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 PAY_ASSIGNMENT_ACTIONS

Line 69: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

65: procedure initialization_code
66: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
67: --
68: procedure archive_code
69: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
70: p_effective_date in date );
71: ----------------------------------------------------------------------------
72: -- Bug: 3118540 Procedures called from SRS 'IR8S Ad Hoc Printed Archive'
73: ----------------------------------------------------------------------------

Line 85: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type ) return varchar2;

81: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
82: --
83: Function get_archive_value
84: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
85: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type ) return varchar2;
86: --
87: procedure deinit_code
88: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
89: ----------------------------------------------------------------------------

Line 94: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

90: -- These are PRIVATE procedures that required for the Archive
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 );

Line 104: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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,
106: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type );
107: --
108: procedure archive_org_info

Line 105: p_run_ass_action_id in pay_assignment_actions.assignment_action_id%type,

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,
106: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type );
107: --
108: procedure archive_org_info
109: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 106: p_tax_unit_id in pay_assignment_actions.tax_unit_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,
106: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type );
107: --
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,

Line 109: ( 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,
106: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type );
107: --
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,

Line 117: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

113: p_basis_start in date,
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: --

Line 123: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

119: p_basis_start in date,
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: --

Line 129: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

125: p_basis_start in date,
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: --

Line 135: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

131: p_basis_start in date,
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,

Line 143: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

139: p_basis_start in date,
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: --

Line 149: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

145: p_basis_start in date,
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:

Line 158: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

154: --------------------------------------------------------------------------
155: -- Bug 5435088, Added for payroll date
156: --------------------------------------------------------------------------
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);

Line 170: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

166: -- Bug #4688761, added legal_entity_id
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,

Line 181: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

177: --------------------------------------------------------------------------
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,

Line 192: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

188: --------------------------------------------------------------------------
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,

Line 203: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

199: -------------------------------------------------------------------------
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 );

Line 213: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

209: --------------------------------------------------------------------------
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,

Line 226: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

222: ---------------------------------------------------------------------------
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 );

Line 233: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

229: p_basis_start in date,
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,

Line 241: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

237: p_basis_start in date,
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,

Line 251: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

247: p_basis_end in date );
248: --
249: procedure archive_item
250: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
251: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
252: p_archive_value in ff_archive_items.value%type );
253: --
254: procedure archive_item_2
255: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

Line 256: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

252: p_archive_value in ff_archive_items.value%type );
253: --
254: procedure archive_item_2
255: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
256: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
257: p_archive_value in ff_archive_items.value%type,
258: p_context_value2 in ff_archive_item_contexts.context%type );
259: --
260: procedure archive_item_3

Line 262: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

258: p_context_value2 in ff_archive_item_contexts.context%type );
259: --
260: procedure archive_item_3
261: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
262: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
263: p_archive_value in ff_archive_items.value%type,
264: p_context_value2 in ff_archive_item_contexts.context%type,
265: p_context_value3 in ff_archive_item_contexts.context%type );
266: -------------------------------------------------------------------------------

Line 348: pay_assignment_actions pac,

344: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
345: 'CREATION_DATE=P',
346: to_char(sysdate,'YYYYMMDD') creation_date
347: from pay_payroll_actions ppa,
348: pay_assignment_actions pac,
349: ff_archive_items ffi,
350: ff_database_items fdi
351: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
352: and ppa.payroll_action_id = pac.payroll_action_id

Line 377: pay_assignment_actions pac,

373: 'ASSIGNMENT_NUMBER=P',
374: paa.assignment_number assignment_number
375: from per_all_assignments_f paa,
376: pay_payroll_actions ppa,
377: pay_assignment_actions pac,
378: ff_archive_items fai,
379: ff_archive_item_contexts ac2
380: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
381: and pac.action_status = 'C'

Line 400: pay_assignment_actions pac,

396: 'BASIS_YEAR=P',
397: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
398: from per_all_assignments_f paa,
399: pay_payroll_actions ppa,
400: pay_assignment_actions pac,
401: ff_archive_items fai,
402: ff_archive_item_contexts ac2
403: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
404: and pac.action_status = 'C'