DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 97: p_tax_unit_id in ff_archive_item_contexts.context%type,

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: --
100: procedure archive_balance_dates
101: ( p_person_id in per_all_people_f.person_id%TYPE,

Line 226: p_tax_unit_id in ff_archive_item_contexts.context%type,

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: --
230: procedure archive_ir8s_c_details

Line 233: p_tax_unit_id in ff_archive_item_contexts.context%type,

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

Line 242: p_tax_unit_id in ff_archive_item_contexts.context%type,

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

Line 256: p_context_value2 in ff_archive_item_contexts.context%type );

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

Line 262: p_context_value2 in ff_archive_item_contexts.context%type,

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: -------------------------------------------------------------------------------
265: -- Bug 3435334 - New function introduced for implementing duplicate person logic
266: -- with pre-processor

Line 263: p_context_value3 in ff_archive_item_contexts.context%type );

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: -------------------------------------------------------------------------------
265: -- Bug 3435334 - New function introduced for implementing duplicate person logic
266: -- with pre-processor
267: -------------------------------------------------------------------------------

Line 285: , p_tax_unit_id in ff_archive_item_contexts.context%type

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: --
289: ----------------------------------------------------------------------------

Line 295: , p_tax_unit_id in ff_archive_item_contexts.context%type

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: --
299: ----------------------------------------------------------------------------

Line 305: , p_tax_unit_id in ff_archive_item_contexts.context%type

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: --
309: ---------------------------------------------------------------------------

Line 377: ff_archive_item_contexts ac2

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'
380: and ppa.payroll_action_id = pac.payroll_action_id
381: and paa.assignment_id = pac.assignment_id

Line 400: ff_archive_item_contexts ac2

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'
403: and ppa.payroll_action_id = pac.payroll_action_id
404: and paa.assignment_id = pac.assignment_id