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

Line 372: pay_action_information_api.create_action_information

368: -- *****************************************************************************
369:
370: -- *****************************************************************************
371: -- Insert the report Parameters
372: pay_action_information_api.create_action_information
373: (p_action_information_id => l_action_info_id
374: ,p_action_context_id => p_payroll_action_id
375: ,p_action_context_type => 'PA'
376: ,p_object_version_number => l_ovn

Line 412: pay_action_information_api.create_action_information

408: INTO l_legal_employer_details;
409:
410: CLOSE csr_legal_employer_details;
411:
412: pay_action_information_api.create_action_information
413: (p_action_information_id => l_action_info_id,
414: p_action_context_id => p_payroll_action_id,
415: p_action_context_type => 'PA',
416: p_object_version_number => l_ovn,

Line 449: pay_action_information_api.create_action_information

445: CLOSE csr_check_empty_le;
446:
447: IF l_le_has_employee = '1'
448: THEN
449: pay_action_information_api.create_action_information
450: (p_action_information_id => l_action_info_id,
451: p_action_context_id => p_payroll_action_id,
452: p_action_context_type => 'PA',
453: p_object_version_number => l_ovn,

Line 996: l_action_info_id pay_action_information.action_information_id%TYPE;

992: l_end_date per_time_periods.end_date%TYPE;
993: l_date_earned pay_payroll_actions.date_earned%TYPE;
994: l_effective_date pay_payroll_actions.effective_date%TYPE;
995: l_start_date per_time_periods.start_date%TYPE;
996: l_action_info_id pay_action_information.action_information_id%TYPE;
997: l_ovn pay_action_information.object_version_number%TYPE;
998: l_flag NUMBER := 0;
999: -- The place for Variables which fetches the values to be archived
1000: l_employee_number VARCHAR2 (240);

Line 997: l_ovn pay_action_information.object_version_number%TYPE;

993: l_date_earned pay_payroll_actions.date_earned%TYPE;
994: l_effective_date pay_payroll_actions.effective_date%TYPE;
995: l_start_date per_time_periods.start_date%TYPE;
996: l_action_info_id pay_action_information.action_information_id%TYPE;
997: l_ovn pay_action_information.object_version_number%TYPE;
998: l_flag NUMBER := 0;
999: -- The place for Variables which fetches the values to be archived
1000: l_employee_number VARCHAR2 (240);
1001: l_employee_code VARCHAR2 (240);

Line 1346: pay_action_information_api.create_action_information

1342:
1343: /* **********************************************************************************/
1344: IF l_new_entry IS NOT NULL
1345: THEN
1346: pay_action_information_api.create_action_information
1347: (p_action_information_id => l_action_info_id
1348: ,p_action_context_id => p_assignment_action_id
1349: ,p_action_context_type => 'AAP'
1350: ,p_object_version_number => l_ovn

Line 1461: pay_action_information_api.create_action_information

1457: ,l_fully_capable_of_work
1458: ,l_inability_to_work
1459: );
1460: /* **********************************************************************************/
1461: pay_action_information_api.create_action_information
1462: (p_action_information_id => l_action_info_id
1463: ,p_action_context_id => p_assignment_action_id
1464: ,p_action_context_type => 'AAP'
1465: ,p_object_version_number => l_ovn

Line 1567: pay_action_information_api.create_action_information

1563:
1564:
1565: IF l_new_salary IS NOT NULL
1566: THEN
1567: pay_action_information_api.create_action_information
1568: (p_action_information_id => l_action_info_id
1569: ,p_action_context_id => p_assignment_action_id
1570: ,p_action_context_type => 'AAP'
1571: ,p_object_version_number => l_ovn

Line 1687: pay_action_information_api.create_action_information

1683:
1684: /* **********************************************************************************/
1685: IF l_new_salary IS NOT NULL
1686: THEN
1687: pay_action_information_api.create_action_information
1688: (p_action_information_id => l_action_info_id
1689: ,p_action_context_id => p_assignment_action_id
1690: ,p_action_context_type => 'AAP'
1691: ,p_object_version_number => l_ovn

Line 1811: pay_action_information_api.create_action_information

1807: ,l_first_name
1808: ,l_last_name
1809: ,l_before_after
1810: );
1811: pay_action_information_api.create_action_information
1812: (p_action_information_id => l_action_info_id
1813: ,p_action_context_id => p_assignment_action_id
1814: ,p_action_context_type => 'AAP'
1815: ,p_object_version_number => l_ovn

Line 2097: l_payroll_action_id pay_action_information.action_information1%TYPE;

2093: )
2094: IS
2095: --Variables needed for the report
2096: l_counter NUMBER := 0;
2097: l_payroll_action_id pay_action_information.action_information1%TYPE;
2098:
2099: --Cursors needed for report
2100: CURSOR csr_report_details (
2101: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 2101: csr_v_pa_id pay_action_information.action_context_id%TYPE

2097: l_payroll_action_id pay_action_information.action_information1%TYPE;
2098:
2099: --Cursors needed for report
2100: CURSOR csr_report_details (
2101: csr_v_pa_id pay_action_information.action_context_id%TYPE
2102: )
2103: IS
2104: SELECT *
2105: FROM pay_action_information

Line 2105: FROM pay_action_information

2101: csr_v_pa_id pay_action_information.action_context_id%TYPE
2102: )
2103: IS
2104: SELECT *
2105: FROM pay_action_information
2106: WHERE action_context_type = 'PA'
2107: AND action_context_id = csr_v_pa_id
2108: AND action_information_category = 'EMEA REPORT DETAILS'
2109: AND action_information1 = 'PYSEALEA';

Line 2114: csr_v_pa_id pay_action_information.action_information3%TYPE

2110:
2111: lr_report_details csr_report_details%ROWTYPE;
2112:
2113: CURSOR csr_all_employees_for_event (
2114: csr_v_pa_id pay_action_information.action_information3%TYPE
2115: ,csr_v_event pay_action_information.action_information4%TYPE
2116: )
2117: IS
2118: SELECT *

Line 2115: ,csr_v_event pay_action_information.action_information4%TYPE

2111: lr_report_details csr_report_details%ROWTYPE;
2112:
2113: CURSOR csr_all_employees_for_event (
2114: csr_v_pa_id pay_action_information.action_information3%TYPE
2115: ,csr_v_event pay_action_information.action_information4%TYPE
2116: )
2117: IS
2118: SELECT *
2119: FROM pay_action_information

Line 2119: FROM pay_action_information

2115: ,csr_v_event pay_action_information.action_information4%TYPE
2116: )
2117: IS
2118: SELECT *
2119: FROM pay_action_information
2120: WHERE action_context_type = 'AAP'
2121: AND action_information_category = 'EMEA REPORT INFORMATION'
2122: AND action_information1 = 'PYSEALEA'
2123: AND action_information3 = csr_v_pa_id

Line 2129: csr_v_pa_id pay_action_information.action_information3%TYPE

2125: AND action_information4 = csr_v_event
2126: ORDER BY action_information30;
2127:
2128: CURSOR csr_count_employees_for_event (
2129: csr_v_pa_id pay_action_information.action_information3%TYPE
2130: ,csr_v_event pay_action_information.action_information4%TYPE
2131: )
2132: IS
2133: SELECT COUNT ('1')

Line 2130: ,csr_v_event pay_action_information.action_information4%TYPE

2126: ORDER BY action_information30;
2127:
2128: CURSOR csr_count_employees_for_event (
2129: csr_v_pa_id pay_action_information.action_information3%TYPE
2130: ,csr_v_event pay_action_information.action_information4%TYPE
2131: )
2132: IS
2133: SELECT COUNT ('1')
2134: FROM pay_action_information

Line 2134: FROM pay_action_information

2130: ,csr_v_event pay_action_information.action_information4%TYPE
2131: )
2132: IS
2133: SELECT COUNT ('1')
2134: FROM pay_action_information
2135: WHERE action_context_type = 'AAP'
2136: AND action_information_category = 'EMEA REPORT INFORMATION'
2137: AND action_information1 = 'PYSEALEA'
2138: AND action_information3 = csr_v_pa_id

Line 2145: csr_v_pa_id pay_action_information.action_information3%TYPE

2141:
2142: l_count_employees_for_event NUMBER;
2143:
2144: CURSOR csr_all_employees_under_le (
2145: csr_v_pa_id pay_action_information.action_information3%TYPE
2146: ,csr_v_le_id pay_action_information.action_information15%TYPE
2147: )
2148: IS
2149: SELECT *

Line 2146: ,csr_v_le_id pay_action_information.action_information15%TYPE

2142: l_count_employees_for_event NUMBER;
2143:
2144: CURSOR csr_all_employees_under_le (
2145: csr_v_pa_id pay_action_information.action_information3%TYPE
2146: ,csr_v_le_id pay_action_information.action_information15%TYPE
2147: )
2148: IS
2149: SELECT *
2150: FROM pay_action_information

Line 2150: FROM pay_action_information

2146: ,csr_v_le_id pay_action_information.action_information15%TYPE
2147: )
2148: IS
2149: SELECT *
2150: FROM pay_action_information
2151: WHERE action_context_type = 'AAP'
2152: AND action_information_category = 'EMEA REPORT INFORMATION'
2153: AND action_information1 = 'PYSEALEA'
2154: AND action_information3 = csr_v_pa_id