eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 20: type t_person_id_tab is table of per_all_people_f.person_id%type index by binary_integer;

16: --
17: ---------------------------------------------------------------------
18: -- 3435334 Record of person_ids with same national identifier
19: ---------------------------------------------------------------------
20: type t_person_id_tab is table of per_all_people_f.person_id%type index by binary_integer;
21: g_person_id_tab t_person_id_tab;
22: --
23: type t_rehire_same_person_record is record
24: (

Line 25: person_id per_all_people_f.person_id%type

21: g_person_id_tab t_person_id_tab;
22: --
23: type t_rehire_same_person_record is record
24: (
25: person_id per_all_people_f.person_id%type
26: );
27: --------------------------------------------------------------------
28: -- Bug 4688761 Record of person_ids with archived person_id
29: --------------------------------------------------------------------

Line 32: person_id per_all_people_f.person_id%type

28: -- Bug 4688761 Record of person_ids with archived person_id
29: --------------------------------------------------------------------
30: type t_archived_person_rec is record
31: (
32: person_id per_all_people_f.person_id%type
33: );
34: type t_archived_person_tab is table of t_archived_person_rec index by binary_integer;
35: t_archived_person t_archived_person_tab;
36:

Line 61: p_start_person_id in per_all_people_f.person_id%type,

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

Line 62: p_end_person_id in per_all_people_f.person_id%type,

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

Line 76: p_start_person_id in per_all_people_f.person_id%type,

72: -- Bug: 3118540 Procedures called from SRS 'IR8S Ad Hoc Printed Archive'
73: ----------------------------------------------------------------------------
74: procedure assignment_action_code_adhoc
75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number );
79: --
80: procedure initialization_code_adhoc

Line 77: p_end_person_id in per_all_people_f.person_id%type,

73: ----------------------------------------------------------------------------
74: procedure assignment_action_code_adhoc
75: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
76: p_start_person_id in per_all_people_f.person_id%type,
77: p_end_person_id in per_all_people_f.person_id%type,
78: p_chunk in number );
79: --
80: procedure initialization_code_adhoc
81: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

Line 95: p_person_id in per_all_people_f.person_id%type,

91: -- process.
92: --------------------------------------------------------------------
93: procedure archive_balances
94: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
95: p_person_id in per_all_people_f.person_id%type,
96: p_business_group_id in hr_organization_units.business_group_id%type,
97: p_tax_unit_id in ff_archive_item_contexts.context%type,
98: p_basis_year in varchar2 );
99: --

Line 101: ( p_person_id in per_all_people_f.person_id%TYPE,

97: p_tax_unit_id in ff_archive_item_contexts.context%type,
98: p_basis_year in varchar2 );
99: --
100: procedure archive_balance_dates
101: ( p_person_id in per_all_people_f.person_id%TYPE,
102: p_basis_year in varchar2,
103: p_business_group_id in hr_organization_units.business_group_id%type,
104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
105: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,

Line 112: p_person_id in per_all_people_f.person_id%type,

108: procedure archive_org_info
109: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
110: p_business_group_id in hr_organization_units.business_group_id%type,
111: p_legal_entity_id in hr_organization_units.organization_id%type,
112: p_person_id in per_all_people_f.person_id%type,
113: p_basis_start in date,
114: p_basis_end in date );
115: --
116: procedure archive_person_details

Line 118: p_person_id in per_all_people_f.person_id%type,

114: p_basis_end in date );
115: --
116: procedure archive_person_details
117: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
118: p_person_id in per_all_people_f.person_id%type,
119: p_basis_start in date,
120: p_basis_end in date );
121: --
122: procedure archive_person_addresses

Line 124: p_person_id in per_all_people_f.person_id%type,

120: p_basis_end in date );
121: --
122: procedure archive_person_addresses
123: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
124: p_person_id in per_all_people_f.person_id%type,
125: p_basis_start in date,
126: p_basis_end in date );
127: --
128: procedure archive_person_cq_addresses

Line 130: p_person_id in per_all_people_f.person_id%type,

126: p_basis_end in date );
127: --
128: procedure archive_person_cq_addresses
129: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
130: p_person_id in per_all_people_f.person_id%type,
131: p_basis_start in date,
132: p_basis_end in date );
133: --
134: procedure archive_emp_details

Line 136: p_person_id in per_all_people_f.person_id%type,

132: p_basis_end in date );
133: --
134: procedure archive_emp_details
135: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
136: p_person_id in per_all_people_f.person_id%type,
137: -- p_assignment_id in per_all_assignments_f.assignment_id%type,
138: p_legal_entity_id in hr_organization_units.organization_id%type, /* Bug 13786754*/
139: p_basis_start in date,
140: p_basis_end in date );

Line 144: p_person_id in per_all_people_f.person_id%type,

140: p_basis_end in date );
141: --
142: procedure archive_people_flex
143: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
144: p_person_id in per_all_people_f.person_id%type,
145: p_basis_start in date,
146: p_basis_end in date );
147: --
148: procedure archive_person_eits

Line 150: p_person_id in per_all_people_f.person_id%type,

146: p_basis_end in date );
147: --
148: procedure archive_person_eits
149: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
150: p_person_id in per_all_people_f.person_id%type,
151: p_basis_start in date,
152: p_basis_end in date );
153:
154: --------------------------------------------------------------------------

Line 161: p_person_id in per_all_people_f.person_id%type,

157: procedure archive_payroll_date
158: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
159: p_business_group_id in hr_organization_units.business_group_id%type,
160: p_legal_entity_id in hr_organization_units.organization_id%type,
161: p_person_id in per_all_people_f.person_id%type,
162: p_basis_year in varchar2);
163: --
164: --
165: --------------------------------------------------------------------------

Line 171: p_person_id in per_all_people_f.person_id%type,

167: -- Bug 4890964, added assignment_id
168: --------------------------------------------------------------------------
169: procedure archive_assignment_eits
170: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
171: p_person_id in per_all_people_f.person_id%type,
172: p_assignment_id in per_all_assignments_f.assignment_id%type,
173: p_legal_entity_id in hr_organization_units.organization_id%type,
174: p_basis_start in date,
175: p_basis_end in date );

Line 182: p_person_id in per_all_people_f.person_id%type,

178: -- Bug #5078454
179: --------------------------------------------------------------------------
180: procedure archive_ass_bonus_date_eits
181: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
182: p_person_id in per_all_people_f.person_id%type,
183: p_assignment_id in per_all_assignments_f.assignment_id%type,
184: p_legal_entity_id in hr_organization_units.organization_id%type,
185: p_basis_start in date,
186: p_basis_end in date );

Line 193: p_person_id in per_all_people_f.person_id%type,

189: -- Bug 5435088
190: --------------------------------------------------------------------------
191: procedure archive_ass_payment_method
192: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
193: p_person_id in per_all_people_f.person_id%type,
194: p_assignment_id in per_all_assignments_f.assignment_id%type,
195: p_legal_entity_id in hr_organization_units.organization_id%type,
196: p_basis_start in date,
197: p_basis_end in date);

Line 204: p_person_id in per_all_people_f.person_id%type,

200: -- Bug #4688761, added legal_entity_id
201: -------------------------------------------------------------------------
202: procedure archive_os_assignment
203: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
204: p_person_id in per_all_people_f.person_id%type,
205: p_legal_entity_id in hr_organization_units.organization_id%type,
206: p_basis_start in date,
207: p_basis_end in date );
208: --

Line 214: p_person_id in per_all_people_f.person_id%type,

210: -- Bug 4890964, added assignment_id
211: --------------------------------------------------------------------------
212: procedure archive_job_designation
213: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
214: p_person_id in per_all_people_f.person_id%type,
215: p_assignment_id in per_all_assignments_f.assignment_id%type,
216: p_legal_entity_id in hr_organization_units.organization_id%type,
217: p_basis_start in date,
218: p_basis_end in date,

Line 227: p_person_id in per_all_people_f.person_id%type,

223: -- Bug #4314453, added legal_entity_id
224: ---------------------------------------------------------------------------
225: procedure archive_shares_details
226: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
227: p_person_id in per_all_people_f.person_id%type,
228: p_tax_unit_id in ff_archive_item_contexts.context%type,
229: p_basis_start in date,
230: p_basis_end in date );
231: --

Line 234: p_person_id in per_all_people_f.person_id%type,

230: p_basis_end in date );
231: --
232: procedure archive_ir8s_c_details
233: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
234: p_person_id in per_all_people_f.person_id%type,
235: p_tax_unit_id in ff_archive_item_contexts.context%type,
236: p_business_group_id in per_assignments_f.business_group_id%type,
237: p_basis_start in date,
238: p_basis_end in date );

Line 242: p_1_person_id in per_all_people_f.person_id%type,

238: p_basis_end in date );
239: --
240: procedure archive_ir8s_c_detail_moas
241: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
242: p_1_person_id in per_all_people_f.person_id%type,
243: p_person_id in per_all_people_f.person_id%type,
244: p_tax_unit_id in ff_archive_item_contexts.context%type,
245: p_business_group_id in per_assignments_f.business_group_id%type,
246: p_basis_start in date,

Line 243: p_person_id in per_all_people_f.person_id%type,

239: --
240: procedure archive_ir8s_c_detail_moas
241: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
242: p_1_person_id in per_all_people_f.person_id%type,
243: p_person_id in per_all_people_f.person_id%type,
244: p_tax_unit_id in ff_archive_item_contexts.context%type,
245: p_business_group_id in per_assignments_f.business_group_id%type,
246: p_basis_start in date,
247: p_basis_end in date );

Line 272: p_person_id in per_all_people_f.person_id%type,

268: -- with pre-processor
269: -------------------------------------------------------------------------------
270: function employee_if_latest
271: ( p_national_identifier in varchar2,
272: p_person_id in per_all_people_f.person_id%type,
273: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
274: p_report_type in varchar2 ) return boolean ;
275: --
276: ----------------------------------------------------------------------------

Line 279: function person_if_archived (p_person_id in per_all_people_f.person_id%type) return boolean;

275: --
276: ----------------------------------------------------------------------------
277: -- Bug 4688761 - New function to check if the person_id has been archived once
278: ----------------------------------------------------------------------------
279: function person_if_archived (p_person_id in per_all_people_f.person_id%type) return boolean;
280: --
281: ----------------------------------------------------------------------------
282: -- Bug 4890964 - The function to get the LE if it is with the latest primary
283: -- assignment for multi-LEs.

Line 286: ( p_person_id in per_all_people_f.person_id%type

282: -- Bug 4890964 - The function to get the LE if it is with the latest primary
283: -- assignment for multi-LEs.
284: ----------------------------------------------------------------------------
285: function pri_if_latest
286: ( p_person_id in per_all_people_f.person_id%type
287: , p_tax_unit_id in ff_archive_item_contexts.context%type
288: , p_basis_start in date
289: , p_basis_end in date) return boolean;
290: --

Line 296: ( p_person_id in per_all_people_f.person_id%type

292: -- Bug 4890964 - The function to get the assignment with LE if its the
293: -- latest primary assignment
294: ----------------------------------------------------------------------------
295: function pri_LE_if_latest
296: ( p_person_id in per_all_people_f.person_id%type
297: , p_tax_unit_id in ff_archive_item_contexts.context%type
298: , p_basis_start in date
299: , p_basis_end in date) return number;
300: --

Line 306: ( p_person_id in per_all_people_f.person_id%type

302: -- Bug 4890964 - The function to get the assignment with LE if its the
303: -- latest assignment without primay flag defined.
304: ----------------------------------------------------------------------------
305: function id_LE_if_latest
306: ( p_person_id in per_all_people_f.person_id%type
307: , p_tax_unit_id in ff_archive_item_contexts.context%type
308: , p_basis_start in date
309: , p_basis_end in date) return number;
310: --