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.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ACTION_INFORMATION

Line 297: l_action_info_id pay_action_information.action_information_id%TYPE;

293: AND asg_run.business_group_id = g_business_group_id
294: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date);
295: --
296: l_unused_number NUMBER;
297: l_action_info_id pay_action_information.action_information_id%TYPE;
298: l_ovn pay_action_information.object_version_number%TYPE;
299: l_test_flag NUMBER;
300: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
301: --

Line 298: l_ovn pay_action_information.object_version_number%TYPE;

294: AND fnd_date.canonical_to_date(asg_extra.aei_information7) <= c_effective_end_date);
295: --
296: l_unused_number NUMBER;
297: l_action_info_id pay_action_information.action_information_id%TYPE;
298: l_ovn pay_action_information.object_version_number%TYPE;
299: l_test_flag NUMBER;
300: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
301: --
302: BEGIN

Line 322: pay_action_information_api.create_action_information(

318: ,g_effective_end_date
319: ,g_organization_id) LOOP
320: --
321: l_test_flag := 1;
322: pay_action_information_api.create_action_information(
323: p_action_information_id => l_action_info_id
324: ,p_action_context_id => pactid
325: ,p_action_context_type => 'PA'
326: ,p_object_version_number => l_ovn

Line 339: pay_action_information_api.create_action_information(

335: ,p_action_information8 => g_test_flag
336: ,p_action_information9 => header_details.Current_password
337: ,p_action_information10 => ' ');
338: --
339: pay_action_information_api.create_action_information(
340: p_action_information_id => l_action_info_id
341: ,p_action_context_id => pactid
342: ,p_action_context_type => 'PA'
343: ,p_object_version_number => l_ovn

Line 540: FROM pay_action_information

536:
537: -- Checking whether the employee is already archived or not
538: CURSOR check_employee_exists (c_assignment_id NUMBER, c_actid NUMBER) IS
539: SELECT count(1)
540: FROM pay_action_information
541: WHERE action_information_category = 'ES_SS_REPORT_TRA'
542: AND action_context_type = 'AAP'
543: AND action_context_id = c_actid
544: AND assignment_id = c_assignment_id;

Line 586: l_action_info_id pay_action_information.action_information_id%TYPE;

582: --
583: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
584: l_actid pay_assignment_actions.assignment_action_id%TYPE;
585: l_unused_number NUMBER;
586: l_action_info_id pay_action_information.action_information_id%TYPE;
587: l_ovn pay_action_information.object_version_number%TYPE;
588: l_contract_start_date DATE;
589: l_replace_person_id per_all_people_f.person_id%TYPE;
590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;

Line 587: l_ovn pay_action_information.object_version_number%TYPE;

583: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
584: l_actid pay_assignment_actions.assignment_action_id%TYPE;
585: l_unused_number NUMBER;
586: l_action_info_id pay_action_information.action_information_id%TYPE;
587: l_ovn pay_action_information.object_version_number%TYPE;
588: l_contract_start_date DATE;
589: l_replace_person_id per_all_people_f.person_id%TYPE;
590: l_replacement_reason_code per_contracts_f.ctr_information7%TYPE;
591: l_ss_identifier pay_element_entry_values_f.screen_entry_value%TYPE;

Line 686: pay_action_information_api.create_action_information(

682: FETCH csr_get_ss_identifier_asg INTO l_ss_number;
683: CLOSE csr_get_ss_identifier_asg;
684: --
685:
686: pay_action_information_api.create_action_information(
687: p_action_information_id => l_action_info_id
688: ,p_action_context_id => l_actid
689: ,p_action_context_type => 'AAP'
690: ,p_object_version_number => l_ovn

Line 811: l_action_info_id pay_action_information.action_information_id%TYPE;

807: l_first_changed_date first_changed_date_list;
808: l_asg_status_type_id NUMBER;
809: l_contribution_group VARCHAR2(30);
810: l_employment_category VARCHAR2(30);
811: l_action_info_id pay_action_information.action_information_id%TYPE;
812: l_ovn pay_action_information.object_version_number%TYPE;
813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;
814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;
815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;

Line 812: l_ovn pay_action_information.object_version_number%TYPE;

808: l_asg_status_type_id NUMBER;
809: l_contribution_group VARCHAR2(30);
810: l_employment_category VARCHAR2(30);
811: l_action_info_id pay_action_information.action_information_id%TYPE;
812: l_ovn pay_action_information.object_version_number%TYPE;
813: l_screen_entry_value_1 pay_element_entry_values_f.screen_entry_value%TYPE;
814: l_screen_entry_value_2 pay_element_entry_values_f.screen_entry_value%TYPE;
815: l_epi_value pay_element_entry_values_f.screen_entry_value%TYPE;
816: l_unused_number NUMBER;

Line 938: pay_action_information_api.create_action_information(

934: l_epi_value := NULL;
935: END IF;
936:
937: IF l_value.EXISTS(1) AND l_event(1) = 'AS' AND l_system_status = 'ACTIVE_ASSIGN' THEN
938: pay_action_information_api.create_action_information(
939: p_action_information_id => l_action_info_id
940: ,p_action_context_id => p_assignment_action_id
941: ,p_action_context_type => 'AAP'
942: ,p_object_version_number => l_ovn

Line 1198: l_action_info_id pay_action_information.action_information_id%TYPE;

1194: AND system_type_cd = c_leaving_reason
1195: AND business_group_id IS NULL;
1196: --
1197:
1198: l_action_info_id pay_action_information.action_information_id%TYPE;
1199: l_ovn pay_action_information.object_version_number%TYPE;
1200: l_unused_value pay_action_information.action_information4%TYPE;
1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;

Line 1199: l_ovn pay_action_information.object_version_number%TYPE;

1195: AND business_group_id IS NULL;
1196: --
1197:
1198: l_action_info_id pay_action_information.action_information_id%TYPE;
1199: l_ovn pay_action_information.object_version_number%TYPE;
1200: l_unused_value pay_action_information.action_information4%TYPE;
1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;
1203: l_actual_date DATE;

Line 1200: l_unused_value pay_action_information.action_information4%TYPE;

1196: --
1197:
1198: l_action_info_id pay_action_information.action_information_id%TYPE;
1199: l_ovn pay_action_information.object_version_number%TYPE;
1200: l_unused_value pay_action_information.action_information4%TYPE;
1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;
1203: l_actual_date DATE;
1204: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 1202: l_value pay_action_information.action_information4%TYPE;

1198: l_action_info_id pay_action_information.action_information_id%TYPE;
1199: l_ovn pay_action_information.object_version_number%TYPE;
1200: l_unused_value pay_action_information.action_information4%TYPE;
1201: l_unused_number NUMBER;
1202: l_value pay_action_information.action_information4%TYPE;
1203: l_actual_date DATE;
1204: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
1205: l_sex per_all_people_f.sex%TYPE;
1206: --

Line 1255: pay_action_information_api.create_action_information(

1251: FETCH get_csr_event_values into l_value, l_actual_date, l_date_of_birth, l_sex;
1252: EXIT WHEN get_csr_event_values%NOTFOUND;
1253: IF p_event = 'AS' AND l_value <> p_value THEN
1254: p_value := l_value;
1255: pay_action_information_api.create_action_information(
1256: p_action_information_id => l_action_info_id
1257: ,p_action_context_id => p_assignment_action_id
1258: ,p_action_context_type => 'AAP'
1259: ,p_object_version_number => l_ovn

Line 1316: pay_action_information_api.create_action_information(

1312: ,l_first_contractor_ter
1313: ,l_after_two_years_ter
1314: ,l_minority_group_flag_ter
1315: ,l_active_rent_flag_ter);
1316: pay_action_information_api.create_action_information(
1317: p_action_information_id => l_action_info_id
1318: ,p_action_context_id => p_assignment_action_id
1319: ,p_action_context_type => 'AAP'
1320: ,p_object_version_number => l_ovn

Line 1348: pay_action_information_api.create_action_information(

1344: l_unused_value := NULL;
1345: ELSE
1346: l_unused_value := p_value;
1347: END IF;
1348: pay_action_information_api.create_action_information(
1349: p_action_information_id => l_action_info_id
1350: ,p_action_context_id => p_assignment_action_id
1351: ,p_action_context_type => 'AAP'
1352: ,p_object_version_number => l_ovn

Line 1380: pay_action_information_api.create_action_information(

1376: l_unused_value := NULL;
1377: ELSE
1378: l_unused_value := p_value;
1379: END IF;
1380: pay_action_information_api.create_action_information(
1381: p_action_information_id => l_action_info_id
1382: ,p_action_context_id => p_assignment_action_id
1383: ,p_action_context_type => 'AAP'
1384: ,p_object_version_number => l_ovn

Line 1412: pay_action_information_api.create_action_information(

1408: l_unused_value := NULL;
1409: ELSE
1410: l_unused_value := p_value;
1411: END IF;
1412: pay_action_information_api.create_action_information(
1413: p_action_information_id => l_action_info_id
1414: ,p_action_context_id => p_assignment_action_id
1415: ,p_action_context_type => 'AAP'
1416: ,p_object_version_number => l_ovn

Line 1491: ,pay_action_information pai

1487: ,max(pai.effective_date) current_reporting_date
1488: FROM pay_payroll_actions ppa
1489: ,pay_assignment_actions paa
1490: ,per_all_assignments_f asg_run
1491: ,pay_action_information pai
1492: WHERE ppa.payroll_action_id = c_payroll_action_id
1493: AND paa.payroll_action_id = ppa.payroll_action_id
1494: AND asg_run.business_group_id = ppa.business_group_id
1495: AND asg_run.assignment_id = paa.assignment_id

Line 1511: FROM pay_action_information pai

1507: SELECT pai.action_information4 assignment_status_type_id
1508: ,pai.action_information5 employment_category
1509: ,pai.action_information6 epigraph_code
1510: ,pai.action_information18 contribution_group
1511: FROM pay_action_information pai
1512: WHERE pai.action_context_id = c_action_context_id
1513: AND pai.action_information1 = c_action_status
1514: AND effective_date = c_current_reporting_date;
1515: --

Line 1521: l_action_info_id pay_action_information.action_information_id%TYPE;

1517: l_employment_category per_assignment_extra_info.aei_information4%TYPE;
1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;
1522: l_ovn pay_action_information.object_version_number%TYPE;
1523: l_unused_number NUMBER;
1524: l_effective_start_date DATE;
1525: --

Line 1522: l_ovn pay_action_information.object_version_number%TYPE;

1518: l_contribution_group per_assignment_extra_info.aei_information4%TYPE;
1519: l_epigraph_code per_assignment_extra_info.aei_information4%TYPE;
1520: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1521: l_action_info_id pay_action_information.action_information_id%TYPE;
1522: l_ovn pay_action_information.object_version_number%TYPE;
1523: l_unused_number NUMBER;
1524: l_effective_start_date DATE;
1525: --
1526: BEGIN