[Home] [Help]
107: ** Name : action_creation
108: ** Purpose : This procedure fetches archived assignment_action_id's
109: ** from archive table and creates a new temp assignment_action_id
110: ** for each of them. This new temp id along with the archived id
111: ** will be inserted into pay_temp_object_actions.
112: **----------------------------------------------------------**/
113: procedure action_creation(pactid in number,
114: stperson in number,
115: endperson in number,
216:
217: /**------------------------------------------------------------
218: ** Name : archive_historic_data
219: ** Purpose : This procedure gets the archived assignment_action_id from
220: ** pay_temp_object_actions and passes it to the
221: ** get_pay_deduct_element_info procedure to archive payments and
222: ** deductions data.
223: **----------------------------------------------------------**/
224:
226: p_effective_date in date) IS
227:
228: cursor get_archive_asg_id is
229: select ptoa.object_id assignment_action_id
230: from pay_temp_object_actions ptoa
231: where object_action_id = p_assactid;
232:
233: l_assignment_action_id pay_assignment_actions.assignment_Action_id%type;
234: begin