[Home] [Help]
23: g_pact t_pact;
24: -----------------------------------------------------
25: -- record type to hold archival information
26: -----------------------------------------------------
27: rec_action_info pay_action_information%rowtype ;
28: -----------------------------------------------------
29: -- Table to store Defined Balance details
30: -----------------------------------------------------
31: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type ;
212: g_context_tab pay_balance_pkg.t_context_tab;
213: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
214: --
215: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
216: l_action_info_id pay_action_information.action_information_id%type;
217: l_ovn pay_action_information.object_version_number%type;
218: l_person_id per_all_people_f.person_id%type;
219: l_fwl_amt number;
220: l_spl_amt number; /* Bug: 3595103 */
213: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
214: --
215: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
216: l_action_info_id pay_action_information.action_information_id%type;
217: l_ovn pay_action_information.object_version_number%type;
218: l_person_id per_all_people_f.person_id%type;
219: l_fwl_amt number;
220: l_spl_amt number; /* Bug: 3595103 */
221:
365: l_spl_amt := g_detailed_bal_out_tab(14).balance_value; -- S Pass Liability
366: rec_action_info.action_information16 := l_fwl_amt + l_spl_amt ;
367:
368: ------------------------------------------------
369: -- Insert data into pay_action_information
370: ------------------------------------------------
371: if g_debug then
372: hr_utility.set_location(l_proc_name||' Before Insert into pay_action_information',40);
373: end if;
368: ------------------------------------------------
369: -- Insert data into pay_action_information
370: ------------------------------------------------
371: if g_debug then
372: hr_utility.set_location(l_proc_name||' Before Insert into pay_action_information',40);
373: end if;
374: insert into pay_action_information (
375: action_information_id,
376: action_context_id,
370: ------------------------------------------------
371: if g_debug then
372: hr_utility.set_location(l_proc_name||' Before Insert into pay_action_information',40);
373: end if;
374: insert into pay_action_information (
375: action_information_id,
376: action_context_id,
377: action_context_type,
378: effective_date,
402: action_information21,
403: action_information22,
404: action_information23)
405: values (
406: pay_action_information_s.nextval,
407: p_assignment_action_id,
408: 'AAC',
409: fnd_date.canonical_to_date(rec_action_info.action_information20),
410: l_person_id,
433: rec_action_info.action_information21,
434: rec_action_info.action_information22,
435: rec_action_info.action_information23 ) ;
436: if g_debug then
437: hr_utility.set_location(l_proc_name||' After Insert into pay_action_information',40);
438: end if;
439: --
440: if g_debug then
441: hr_utility.set_location(l_proc_name||' End of archive_code',40);
442: end if;
443: end archive_code ;
444: ---------------------------------
445: -- Deinitialization_code
446: -- Removes data from pay_action_information
447: -- table based on parameter value
448: -- Bug: 3619297 - Added check on action_context_type
449: ---------------------------------
450: procedure deinit_code
458: from pay_payroll_actions ppa
459: where ppa.payroll_action_id = p_payroll_action_id ;
460: --
461: if retain_archive_flag = 'N' then
462: delete from pay_action_information
463: where action_context_id in ( select assignment_action_id
464: from pay_assignment_actions
465: where payroll_action_id = p_payroll_action_id )
466: and action_information_category = 'SG CPF DETAILS'