APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

55: -- the archive process knows what code to execute for each step of
56: -- the archive.
57: --------------------------------------------------------------------
58: procedure range_code
59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
60: p_sql out nocopy varchar2 );
61: --
62: procedure assignment_action_code
63: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 63: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

59: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
60: p_sql out nocopy varchar2 );
61: --
62: procedure assignment_action_code
63: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
64: p_start_person_id in per_all_people_f.person_id%type,
65: p_end_person_id in per_all_people_f.person_id%type,
66: p_chunk in number );
67: --

Line 69: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

65: p_end_person_id in per_all_people_f.person_id%type,
66: p_chunk in number );
67: --
68: procedure initialization_code
69: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
70: --
71: procedure archive_code
72: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
73: p_effective_date in date );

Line 76: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

72: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
73: p_effective_date in date );
74: --
75: procedure deinit_code
76: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
77: ----------------------------------------------------------------------------
78: -- These are PRIVATE procedures that required for the Archive
79: -- process.
80: --------------------------------------------------------------------

Line 139: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,

135: -------------------------------------------------------------------------------
136: function employee_if_latest
137: ( p_national_identifier in varchar2,
138: p_person_id in per_all_people_f.person_id%type,
139: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
140: p_report_type in varchar2 ) return boolean ;
141: --
142: ----------------------------------------------------------------------------
143: -- Bug 4688761 - New function to check if the person_id has been archived once

Line 189: from pay_payroll_actions ppa,

185: 'BASIS_YEAR=P',
186: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
187: 'CREATION_DATE=P',
188: to_char(sysdate,'YYYYMMDD') creation_date
189: from pay_payroll_actions ppa,
190: pay_assignment_actions pac,
191: ff_archive_items ffi,
192: ff_database_items fdi
193: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 218: pay_payroll_actions ppa,

214: to_char(paa.person_id) person_id,
215: 'ASSIGNMENT_NUMBER=P',
216: paa.assignment_number assignment_number
217: from per_all_assignments_f paa,
218: pay_payroll_actions ppa,
219: pay_assignment_actions pac,
220: ff_archive_items fai,
221: ff_archive_item_contexts ac2
222: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 241: pay_payroll_actions ppa,

237: to_number(ac2.context) tax_unit_id,
238: 'BASIS_YEAR=P',
239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
240: from per_all_assignments_f paa,
241: pay_payroll_actions ppa,
242: pay_assignment_actions pac,
243: ff_archive_items fai,
244: ff_archive_item_contexts ac2
245: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')