Hi Durden_Tyler

I understand, but i didn't wrote this procedures ,my senior wrote this and he told me to write a script for this.

Yes you are right ,He declared proc_name but never used this in the whole procedure.

and that piecewise is the p_ptfolio_id which is the IN parameter and we are picking this IN parameter from a column of a table named P_ptfolio_id.

He said to me that In script first of all pick the whole rows of that p_ptfolio_id column and then process in the steps of 5 means pick 5 and put those in the background and when those are done pick next 5 and so on.

I appreciate your kind help.

Rspnf

---------- Post updated at 03:13 PM ---------- Previous update was at 03:11 PM ----------

We are calling the 2nd procedure in the package which itself calls the first procedure

and we are just providing one IN parameter that is p_ptfolio_id and other two he makes default p_startdt and p_enddt.