DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 85: p_tax_unit_id in ff_archive_item_contexts.context%type,

81: procedure archive_balances
82: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
83: p_person_id in per_all_people_f.person_id%type,
84: p_business_group_id in hr_organization_units.business_group_id%type,
85: p_tax_unit_id in ff_archive_item_contexts.context%type,
86: p_basis_year in varchar2 );
87: --
88: ---------------------------------------------------------------------------
89: -- Bug #4314453, added legal_entity_id

Line 94: p_tax_unit_id in ff_archive_item_contexts.context%type,

90: ---------------------------------------------------------------------------
91: procedure archive_shares_details
92: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
93: p_person_id in per_all_people_f.person_id%type,
94: p_tax_unit_id in ff_archive_item_contexts.context%type,
95: p_basis_start in date,
96: p_basis_end in date );
97: --
98: procedure archive_ir8s_c_details

Line 101: p_tax_unit_id in ff_archive_item_contexts.context%type,

97: --
98: procedure archive_ir8s_c_details
99: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
100: p_person_id in per_all_people_f.person_id%type,
101: p_tax_unit_id in ff_archive_item_contexts.context%type,
102: p_business_group_id in per_assignments_f.business_group_id%type,
103: p_basis_start in date,
104: p_basis_end in date );
105: --

Line 110: p_tax_unit_id in ff_archive_item_contexts.context%type,

106: procedure archive_ir8s_c_detail_moas
107: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
108: p_1_person_id in per_all_people_f.person_id%type,
109: p_person_id in per_all_people_f.person_id%type,
110: p_tax_unit_id in ff_archive_item_contexts.context%type,
111: p_business_group_id in per_assignments_f.business_group_id%type,
112: p_basis_start in date,
113: p_basis_end in date );
114: --

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

120: procedure archive_item_2
121: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
122: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
123: p_archive_value in ff_archive_items.value%type,
124: p_context_value2 in ff_archive_item_contexts.context%type );
125: --
126: procedure archive_item_3
127: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
128: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

Line 130: p_context_value2 in ff_archive_item_contexts.context%type,

126: procedure archive_item_3
127: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
128: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
129: p_archive_value in ff_archive_items.value%type,
130: p_context_value2 in ff_archive_item_contexts.context%type,
131: p_context_value3 in ff_archive_item_contexts.context%type );
132: -------------------------------------------------------------------------------
133: -- Bug 3435334 - New function introduced for implementing duplicate person logic
134: -- with pre-processor

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

127: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
128: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
129: p_archive_value in ff_archive_items.value%type,
130: p_context_value2 in ff_archive_item_contexts.context%type,
131: p_context_value3 in ff_archive_item_contexts.context%type );
132: -------------------------------------------------------------------------------
133: -- Bug 3435334 - New function introduced for implementing duplicate person logic
134: -- with pre-processor
135: -------------------------------------------------------------------------------

Line 153: , p_tax_unit_id in ff_archive_item_contexts.context%type

149: -- assignment for multi-LEs.
150: ----------------------------------------------------------------------------
151: function pri_if_latest
152: ( p_person_id in per_all_people_f.person_id%type
153: , p_tax_unit_id in ff_archive_item_contexts.context%type
154: , p_basis_start in date
155: , p_basis_end in date) return boolean;
156: --
157: ----------------------------------------------------------------------------

Line 163: , p_tax_unit_id in ff_archive_item_contexts.context%type

159: -- latest primary assignment
160: ----------------------------------------------------------------------------
161: function pri_LE_if_latest
162: ( p_person_id in per_all_people_f.person_id%type
163: , p_tax_unit_id in ff_archive_item_contexts.context%type
164: , p_basis_start in date
165: , p_basis_end in date) return number;
166: --
167: ----------------------------------------------------------------------------

Line 173: , p_tax_unit_id in ff_archive_item_contexts.context%type

169: -- latest assignment without primay flag defined.
170: ----------------------------------------------------------------------------
171: function id_LE_if_latest
172: ( p_person_id in per_all_people_f.person_id%type
173: , p_tax_unit_id in ff_archive_item_contexts.context%type
174: , p_basis_start in date
175: , p_basis_end in date) return number;
176: --
177: ---------------------------------------------------------------------

Line 221: ff_archive_item_contexts ac2

217: from per_all_assignments_f paa,
218: pay_payroll_actions ppa,
219: pay_assignment_actions pac,
220: ff_archive_items fai,
221: ff_archive_item_contexts ac2
222: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
223: and pac.action_status = 'C'
224: and ppa.payroll_action_id = pac.payroll_action_id
225: and paa.assignment_id = pac.assignment_id

Line 244: ff_archive_item_contexts ac2

240: from per_all_assignments_f paa,
241: pay_payroll_actions ppa,
242: pay_assignment_actions pac,
243: ff_archive_items fai,
244: ff_archive_item_contexts ac2
245: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
246: and pac.action_status = 'C'
247: and ppa.payroll_action_id = pac.payroll_action_id
248: and paa.assignment_id = pac.assignment_id