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_basis_start in date,
138: p_basis_end in date );
139: --
140: procedure archive_people_flex

Line 142: p_person_id in per_all_people_f.person_id%type,

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

Line 148: p_person_id in per_all_people_f.person_id%type,

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

Line 159: p_person_id in per_all_people_f.person_id%type,

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

Line 169: p_person_id in per_all_people_f.person_id%type,

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

Line 180: p_person_id in per_all_people_f.person_id%type,

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

Line 191: p_person_id in per_all_people_f.person_id%type,

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

Line 202: p_person_id in per_all_people_f.person_id%type,

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

Line 212: p_person_id in per_all_people_f.person_id%type,

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

Line 225: p_person_id in per_all_people_f.person_id%type,

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

Line 232: p_person_id in per_all_people_f.person_id%type,

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

Line 240: p_1_person_id in per_all_people_f.person_id%type,

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

Line 241: p_person_id in per_all_people_f.person_id%type,

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

Line 270: p_person_id in per_all_people_f.person_id%type,

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

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

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

Line 284: ( p_person_id in per_all_people_f.person_id%type

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

Line 294: ( p_person_id in per_all_people_f.person_id%type

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

Line 304: ( p_person_id in per_all_people_f.person_id%type

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