DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

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

68: procedure initialization_code
69: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );
70: --
71: procedure archive_code
72: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
73: p_effective_date in date );
74: --
75: procedure deinit_code
76: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

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

78: -- These are PRIVATE procedures that required for the Archive
79: -- process.
80: --------------------------------------------------------------------
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 );

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

88: ---------------------------------------------------------------------------
89: -- Bug #4314453, added legal_entity_id
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 );

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

95: p_basis_start in date,
96: p_basis_end in date );
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,

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

103: p_basis_start in date,
104: p_basis_end in date );
105: --
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,

Line 117: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

113: p_basis_end in date );
114: --
115: procedure archive_item
116: ( p_user_entity_name in ff_user_entities.user_entity_name%type,
117: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
118: p_archive_value in ff_archive_items.value%type );
119: --
120: procedure archive_item_2
121: ( p_user_entity_name in ff_user_entities.user_entity_name%type,

Line 122: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

118: p_archive_value in ff_archive_items.value%type );
119: --
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

Line 128: p_assignment_action_id in pay_assignment_actions.assignment_action_id%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,
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: -------------------------------------------------------------------------------

Line 190: pay_assignment_actions pac,

186: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year,
187: 'CREATION_DATE=P',
188: to_char(sysdate,'YYYYMMDD') creation_date
189: from pay_payroll_actions ppa,
190: pay_assignment_actions pac,
191: ff_archive_items ffi,
192: ff_database_items fdi
193: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
194: and ppa.payroll_action_id = pac.payroll_action_id

Line 219: pay_assignment_actions pac,

215: 'ASSIGNMENT_NUMBER=P',
216: paa.assignment_number assignment_number
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'

Line 242: pay_assignment_actions pac,

238: 'BASIS_YEAR=P',
239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
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'