[Home] [Help]
35: -- of assignments eligible for archival.
36: --------------------------------------------------------------------
37: --
38: procedure range_code
39: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
40: p_sql out nocopy varchar2);
41: --
42: --------------------------------------------------------------------
43: -- This procedure is used to set global contexts
46: -- no archival is required.
47: --------------------------------------------------------------------
48: --
49: procedure initialization_code
50: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
51: --
52: --------------------------------------------------------------------
53: -- This procedure further restricts the assignment_id's
54: -- returned by range_code
54: -- returned by range_code
55: --------------------------------------------------------------------
56: --
57: procedure assignment_action_code
58: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
59: p_start_person_id in per_all_people_f.person_id%type,
60: p_end_person_id in per_all_people_f.person_id%type,
61: p_chunk in number);
62:
87: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
88: return varchar2;
89:
90: procedure spawn_data_file -- (Bug 3132178) Created to call magtape process
91: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
92:
93: /*bug8711855 - this function returns sum of other lump sum e balances
94: The function is called in pay_au_payment_summary, pay_au_recon_summary, pay_au_rec_det_paysum_mode package*/
95: /*Bug 9190980 - Added argument p_adj_lump_sum_pre_tax to get_lumpsumE_value function */