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_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 167: pay_action_information_api.create_action_information

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

Line 205: pay_action_information_api.create_action_information

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

Line 300: delete pay_action_information pai

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

Line 449: pay_action_information pai

445: CURSOR csr_assact IS
446: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
447: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
448: pay_payroll_actions ppa1, pay_assignment_actions paa1,
449: pay_action_information pai
450: WHERE ppa.business_group_id = p_business_group_id
451: AND ppa.payroll_id = p_payroll_id
452: AND ppa.date_earned BETWEEN p_from_date AND p_to_date
453: AND ppa.payroll_action_id = paa.payroll_action_id

Line 519: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.

515:
516: end if;
517:
518: -- Bug 13772840
519: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.
520:
521: DELETE FROM pay_action_information pai
522: WHERE (pai.action_information_category='JP_PRE_TAX_1'
523: OR pai.action_information_category='JP_PRE_TAX_2')

Line 521: DELETE FROM pay_action_information pai

517:
518: -- Bug 13772840
519: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.
520:
521: DELETE FROM pay_action_information pai
522: WHERE (pai.action_information_category='JP_PRE_TAX_1'
523: OR pai.action_information_category='JP_PRE_TAX_2')
524: AND pai.action_context_type='AAP'
525: AND exists ( select null

Line 564: pay_action_information pai

560: IS
561: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
562: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
563: pay_payroll_actions ppa1, pay_assignment_actions paa1,
564: pay_action_information pai
565: WHERE ppa.business_group_id = p_business_group_id
566: AND ppa.payroll_id = p_payroll_id
567: AND ppa.date_earned BETWEEN l_from_date AND l_to_date
568: AND ppa.payroll_action_id = paa.payroll_action_id

Line 727: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.

723:
724: for i IN 1 .. l_temp_table.COUNT
725: loop
726: -- Bug 13772840
727: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.
728:
729: DELETE FROM pay_action_information pai
730: WHERE (pai.action_information_category='JP_PRE_TAX_1'
731: OR pai.action_information_category='JP_PRE_TAX_2')

Line 729: DELETE FROM pay_action_information pai

725: loop
726: -- Bug 13772840
727: -- Delete from pay_action_information when insertion happens via "Run" button in PAYJPPTX form.
728:
729: DELETE FROM pay_action_information pai
730: WHERE (pai.action_information_category='JP_PRE_TAX_1'
731: OR pai.action_information_category='JP_PRE_TAX_2')
732: AND pai.action_context_type='AAP'
733: AND exists ( select null

Line 773: FROM pay_action_information

769: BEGIN
770:
771: SELECT COUNT(1)
772: INTO l_count
773: FROM pay_action_information
774: WHERE action_information_category = 'JP_PRE_TAX_1'
775: AND action_context_type = 'AAP'
776: AND action_information1 = p_assignment_action_id;
777: