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_SE_HOLIDAY_PAY_DEBT dependencies on PAY_ACTION_INFORMATION

Line 392: pay_action_information_api.create_action_information

388: || g_legal_employer_id
389: );
390: -- *****************************************************************************
391: -- Insert the report Parameters
392: pay_action_information_api.create_action_information
393: (p_action_information_id => l_action_info_id
394: , p_action_context_id => p_payroll_action_id
395: , p_action_context_type => 'PA'
396: , p_object_version_number => l_ovn

Line 445: pay_action_information_api.create_action_information

441: INTO l_legal_employer_details;
442:
443: CLOSE csr_legal_employer_details;
444:
445: pay_action_information_api.create_action_information
446: (p_action_information_id => l_action_info_id
447: , p_action_context_id => p_payroll_action_id
448: , p_action_context_type => 'PA'
449: , p_object_version_number => l_ovn

Line 482: pay_action_information_api.create_action_information

478: CLOSE csr_check_empty_le;
479:
480: IF l_le_has_employee = '1'
481: THEN
482: pay_action_information_api.create_action_information
483: (p_action_information_id => l_action_info_id
484: , p_action_context_id => p_payroll_action_id
485: , p_action_context_type => 'PA'
486: , p_object_version_number => l_ovn

Line 923: l_action_info_id pay_action_information.action_information_id%TYPE;

919: l_end_date per_time_periods.end_date%TYPE;
920: l_date_earned pay_payroll_actions.date_earned%TYPE;
921: l_effective_date pay_payroll_actions.effective_date%TYPE;
922: l_start_date per_time_periods.start_date%TYPE;
923: l_action_info_id pay_action_information.action_information_id%TYPE;
924: l_ovn pay_action_information.object_version_number%TYPE;
925: l_flag NUMBER := 0;
926: -- The place for Variables which fetches the values to be archived
927: l_employee_name VARCHAR2 (240);

Line 924: l_ovn pay_action_information.object_version_number%TYPE;

920: l_date_earned pay_payroll_actions.date_earned%TYPE;
921: l_effective_date pay_payroll_actions.effective_date%TYPE;
922: l_start_date per_time_periods.start_date%TYPE;
923: l_action_info_id pay_action_information.action_information_id%TYPE;
924: l_ovn pay_action_information.object_version_number%TYPE;
925: l_flag NUMBER := 0;
926: -- The place for Variables which fetches the values to be archived
927: l_employee_name VARCHAR2 (240);
928: l_employee_number VARCHAR2 (240);

Line 1320: FROM pay_action_information

1316: -- End of Pickingup the Data
1317: BEGIN
1318: SELECT 1
1319: INTO l_flag
1320: FROM pay_action_information
1321: WHERE action_information_category = 'EMEA REPORT DETAILS'
1322: AND action_information1 = 'PYSEHPDA'
1323: AND action_context_id = p_assignment_action_id;
1324: EXCEPTION

Line 1331: pay_action_information_api.create_action_information

1327: --fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1328: fnd_file.put_line (fnd_file.LOG
1329: , 'g_payroll_action_id ' || g_payroll_action_id
1330: );
1331: pay_action_information_api.create_action_information
1332: (p_action_information_id => l_action_info_id
1333: , p_action_context_id => p_assignment_action_id
1334: , p_action_context_type => 'AAP'
1335: , p_object_version_number => l_ovn

Line 1544: l_payroll_action_id pay_action_information.action_information1%TYPE;

1540: )
1541: IS
1542: --Variables needed for the report
1543: l_counter NUMBER := 0;
1544: l_payroll_action_id pay_action_information.action_information1%TYPE;
1545:
1546: --Cursors needed for report
1547: CURSOR csr_all_legal_employer (
1548: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 1548: csr_v_pa_id pay_action_information.action_context_id%TYPE

1544: l_payroll_action_id pay_action_information.action_information1%TYPE;
1545:
1546: --Cursors needed for report
1547: CURSOR csr_all_legal_employer (
1548: csr_v_pa_id pay_action_information.action_context_id%TYPE
1549: )
1550: IS
1551: SELECT action_information3, action_information4
1552: , action_information5

Line 1553: FROM pay_action_information

1549: )
1550: IS
1551: SELECT action_information3, action_information4
1552: , action_information5
1553: FROM pay_action_information
1554: WHERE action_context_type = 'PA'
1555: AND action_context_id = csr_v_pa_id
1556: AND action_information_category = 'EMEA REPORT INFORMATION'
1557: AND action_information1 = 'PYSEHPDA'

Line 1561: csr_v_pa_id pay_action_information.action_context_id%TYPE

1557: AND action_information1 = 'PYSEHPDA'
1558: AND action_information2 = 'LE';
1559:
1560: CURSOR csr_report_details (
1561: csr_v_pa_id pay_action_information.action_context_id%TYPE
1562: )
1563: IS
1564: SELECT TO_CHAR
1565: (fnd_date.canonical_to_date (action_information5)

Line 1572: FROM pay_action_information

1568: , TO_CHAR
1569: (fnd_date.canonical_to_date (action_information6)
1570: , 'YYYYMMDD'
1571: ) period_to
1572: FROM pay_action_information
1573: WHERE action_context_type = 'PA'
1574: AND action_context_id = csr_v_pa_id
1575: AND action_information_category = 'EMEA REPORT DETAILS'
1576: AND action_information1 = 'PYSEHPDA';

Line 1581: csr_v_pa_id pay_action_information.action_information3%TYPE

1577:
1578: lr_report_details csr_report_details%ROWTYPE;
1579:
1580: CURSOR csr_all_employees_under_le (
1581: csr_v_pa_id pay_action_information.action_information3%TYPE
1582: , csr_v_le_id pay_action_information.action_information15%TYPE
1583: )
1584: IS
1585: SELECT *

Line 1582: , csr_v_le_id pay_action_information.action_information15%TYPE

1578: lr_report_details csr_report_details%ROWTYPE;
1579:
1580: CURSOR csr_all_employees_under_le (
1581: csr_v_pa_id pay_action_information.action_information3%TYPE
1582: , csr_v_le_id pay_action_information.action_information15%TYPE
1583: )
1584: IS
1585: SELECT *
1586: FROM pay_action_information

Line 1586: FROM pay_action_information

1582: , csr_v_le_id pay_action_information.action_information15%TYPE
1583: )
1584: IS
1585: SELECT *
1586: FROM pay_action_information
1587: WHERE action_context_type = 'AAP'
1588: AND action_information_category = 'EMEA REPORT INFORMATION'
1589: AND action_information1 = 'PYSEHPDA'
1590: AND action_information3 = csr_v_pa_id