APPS.PAY_JP_PRE_TAX_PKG dependencies on PAY_ACTION_INFORMATION

Line 125: l_action_info_id1 pay_action_information.action_information_id%TYPE;

121: l_leaving_reason per_periods_of_service.leaving_reason%TYPE;
122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;
126: l_action_info_id2 pay_action_information.action_information_id%TYPE;
127: l_ovn pay_action_information.object_version_number%TYPE;
128:
129: BEGIN

Line 126: l_action_info_id2 pay_action_information.action_information_id%TYPE;

122: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;
126: l_action_info_id2 pay_action_information.action_information_id%TYPE;
127: l_ovn pay_action_information.object_version_number%TYPE;
128:
129: BEGIN
130:

Line 127: l_ovn pay_action_information.object_version_number%TYPE;

123: l_employment_category per_all_assignments_f.employment_category%TYPE;
124:
125: l_action_info_id1 pay_action_information.action_information_id%TYPE;
126: l_action_info_id2 pay_action_information.action_information_id%TYPE;
127: l_ovn pay_action_information.object_version_number%TYPE;
128:
129: BEGIN
130:
131: hr_utility.set_location('pay_jp_pre_tax_pkg.insert_row',10);

Line 164: pay_action_information_api.create_action_information

160: );
161:
162: if (l_person_id is not null) then
163:
164: pay_action_information_api.create_action_information
165: (
166: p_action_information_id => l_action_info_id1
167: ,p_action_context_id => p_locking_assignment_action_id
168: ,p_action_context_type => 'AAP'

Line 202: pay_action_information_api.create_action_information

198: ,p_action_information29 => fnd_number.number_to_canonical(p_value.disaster_tax_reduction)
199: ,p_action_information30 => l_employment_category
200: );
201:
202: pay_action_information_api.create_action_information
203: (
204: p_action_information_id => l_action_info_id2
205: ,p_action_context_id => p_locking_assignment_action_id
206: ,p_action_context_type => 'AAP'

Line 297: delete pay_action_information pai

293: retcode OUT NOCOPY VARCHAR2)
294: IS
295: BEGIN
296: -- Delete rollbacked assignment_action_id.
297: delete pay_action_information pai
298: where (action_information_category='JP_PRE_TAX_1'
299: or action_information_category='JP_PRE_TAX_2')
300: and action_context_type='AAP'
301: and not exists(

Line 330: pay_action_information pai

326: CURSOR csr_assact IS
327: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
329: pay_payroll_actions ppa1, pay_assignment_actions paa1,
330: pay_action_information pai
331: WHERE ppa.business_group_id = p_business_group_id
332: AND ppa.payroll_id = p_payroll_id
333: AND ppa.date_earned BETWEEN p_from_date AND p_to_date
334: AND ppa.payroll_action_id = paa.payroll_action_id

Line 421: FROM pay_action_information

417: BEGIN
418:
419: SELECT COUNT(1)
420: INTO l_count
421: FROM pay_action_information
422: WHERE action_information_category = 'JP_PRE_TAX_1'
423: AND action_context_type = 'AAP'
424: AND action_information1 = p_assignment_action_id;
425: