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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 249: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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

Line 254: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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

Line 260: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

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

Line 346: pay_assignment_actions pac,

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

Line 375: pay_assignment_actions pac,

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

Line 398: pay_assignment_actions pac,

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