APPS.PAY_SE_ARCHIVE_TETA dependencies on PAY_ACTION_INFORMATION

Line 175: FROM pay_action_information

171:
172: --fnd_file.put_line(fnd_file.log,'Inside Range Code Archive');
173: SELECT count(*)
174: INTO l_count
175: FROM pay_action_information
176: WHERE action_information_category = 'EMEA REPORT DETAILS'
177: AND action_information1 = 'PYSETETA'
178: AND action_context_id = p_payroll_action_id;
179:

Line 187: pay_action_information_api.create_action_information (

183: FOR person_rec IN csr_person_details( g_person_id , g_date_report )
184: LOOP
185:
186: --fnd_file.put_line(fnd_file.log,'Range Code LOOP');
187: pay_action_information_api.create_action_information (
188: p_action_information_id => l_action_info_id
189: ,p_action_context_id => p_payroll_action_id
190: ,p_action_context_type => 'PA'
191: ,p_object_version_number => l_ovn

Line 497: FROM pay_action_information

493:
494: BEGIN
495: SELECT 1
496: INTO l_flag
497: FROM pay_action_information
498: WHERE action_information_category = 'EMEA REPORT INFORMATION'
499: AND action_information1 = 'PYSETETA'
500: AND action_information2 = 'PER'
501: AND action_context_id = p_assignment_action_id;

Line 525: pay_action_information_api.create_action_information (

521: FETCH csr_emp_name INTO rec_emp_name;
522: CLOSE csr_emp_name;
523:
524:
525: pay_action_information_api.create_action_information (
526: p_action_information_id=> l_action_info_id,
527: p_action_context_id=> p_assignment_action_id,
528: p_action_context_type=> 'AAP',
529: p_object_version_number=> l_ovn,

Line 583: pay_action_information_api.create_action_information (

579: FETCH csr_emp_name INTO rec_emp_name;
580: CLOSE csr_emp_name;
581:
582:
583: pay_action_information_api.create_action_information (
584: p_action_information_id=> l_action_info_id,
585: p_action_context_id=> p_assignment_action_id,
586: p_action_context_type=> 'AAP',
587: p_object_version_number=> l_ovn,

Line 670: FROM pay_action_information

666:
667: /* Cursor to retrieve summary information about the Employee) */
668: CURSOR csr_sum_time IS
669: SELECT sum(action_information10) total_days_worked
670: FROM pay_action_information
671: WHERE action_information_category = 'EMEA REPORT INFORMATION'
672: AND action_information1 = 'PYSETETA'
673: AND action_information2 = to_char(p_payroll_action_id)
674: AND action_information11 IN ('PH','CH');

Line 699: pay_action_information_api.create_action_information (

695:
696:
697: --fnd_file.put_line(fnd_file.log,'Inside Loop Archive Code');
698:
699: pay_action_information_api.create_action_information (
700: p_action_information_id=> l_action_info_id,
701: p_action_context_id=> p_payroll_action_id,
702: p_action_context_type=> 'PA',
703: p_object_version_number=> l_ovn,

Line 757: pay_action_information_api.create_action_information (

753: l_years_worked := 0;
754: l_days_worked := sum_time_rec.total_days_worked;
755: END IF;
756:
757: pay_action_information_api.create_action_information (
758: p_action_information_id=> l_action_info_id,
759: p_action_context_id=> p_payroll_action_id,
760: p_action_context_type=> 'PA',
761: p_object_version_number=> l_ovn,