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

328: -- *****************************************************************************
329:
330: -- *****************************************************************************
331: -- Insert the report Parameters
332: pay_action_information_api.create_action_information
333: (p_action_information_id => l_action_info_id
334: ,p_action_context_id => p_payroll_action_id
335: ,p_action_context_type => 'PA'
336: ,p_object_version_number => l_ovn

Line 372: pay_action_information_api.create_action_information

368: INTO l_legal_employer_details;
369:
370: CLOSE csr_legal_employer_details;
371:
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 409: pay_action_information_api.create_action_information

405: CLOSE csr_check_empty_le;
406:
407: IF l_le_has_employee = '1'
408: THEN
409: pay_action_information_api.create_action_information
410: (p_action_information_id => l_action_info_id,
411: p_action_context_id => p_payroll_action_id,
412: p_action_context_type => 'PA',
413: p_object_version_number => l_ovn,

Line 956: l_action_info_id pay_action_information.action_information_id%TYPE;

952: l_end_date per_time_periods.end_date%TYPE;
953: l_date_earned pay_payroll_actions.date_earned%TYPE;
954: l_effective_date pay_payroll_actions.effective_date%TYPE;
955: l_start_date per_time_periods.start_date%TYPE;
956: l_action_info_id pay_action_information.action_information_id%TYPE;
957: l_ovn pay_action_information.object_version_number%TYPE;
958: l_flag NUMBER := 0;
959: -- The place for Variables which fetches the values to be archived
960: l_employee_number VARCHAR2 (240);

Line 957: l_ovn pay_action_information.object_version_number%TYPE;

953: l_date_earned pay_payroll_actions.date_earned%TYPE;
954: l_effective_date pay_payroll_actions.effective_date%TYPE;
955: l_start_date per_time_periods.start_date%TYPE;
956: l_action_info_id pay_action_information.action_information_id%TYPE;
957: l_ovn pay_action_information.object_version_number%TYPE;
958: l_flag NUMBER := 0;
959: -- The place for Variables which fetches the values to be archived
960: l_employee_number VARCHAR2 (240);
961: l_employee_code VARCHAR2 (240);

Line 1270: pay_action_information_api.create_action_information

1266:
1267: /* **********************************************************************************/
1268: IF l_new_entry IS NOT NULL
1269: THEN
1270: pay_action_information_api.create_action_information
1271: (p_action_information_id => l_action_info_id
1272: ,p_action_context_id => p_assignment_action_id
1273: ,p_action_context_type => 'AAP'
1274: ,p_object_version_number => l_ovn

Line 1372: pay_action_information_api.create_action_information

1368:
1369: /* **********************************************************************************/
1370: IF l_new_salary IS NOT NULL
1371: THEN
1372: pay_action_information_api.create_action_information
1373: (p_action_information_id => l_action_info_id
1374: ,p_action_context_id => p_assignment_action_id
1375: ,p_action_context_type => 'AAP'
1376: ,p_object_version_number => l_ovn

Line 1484: pay_action_information_api.create_action_information

1480: ,l_fully_capable_of_work
1481: ,l_inability_to_work
1482: );
1483: /* **********************************************************************************/
1484: pay_action_information_api.create_action_information
1485: (p_action_information_id => l_action_info_id
1486: ,p_action_context_id => p_assignment_action_id
1487: ,p_action_context_type => 'AAP'
1488: ,p_object_version_number => l_ovn

Line 1600: pay_action_information_api.create_action_information

1596: ,l_first_name
1597: ,l_last_name
1598: ,l_before_after
1599: );
1600: pay_action_information_api.create_action_information
1601: (p_action_information_id => l_action_info_id
1602: ,p_action_context_id => p_assignment_action_id
1603: ,p_action_context_type => 'AAP'
1604: ,p_object_version_number => l_ovn

Line 1875: l_payroll_action_id pay_action_information.action_information1%TYPE;

1871: )
1872: IS
1873: --Variables needed for the report
1874: l_counter NUMBER := 0;
1875: l_payroll_action_id pay_action_information.action_information1%TYPE;
1876:
1877: --Cursors needed for report
1878: CURSOR csr_report_details (
1879: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 1879: csr_v_pa_id pay_action_information.action_context_id%TYPE

1875: l_payroll_action_id pay_action_information.action_information1%TYPE;
1876:
1877: --Cursors needed for report
1878: CURSOR csr_report_details (
1879: csr_v_pa_id pay_action_information.action_context_id%TYPE
1880: )
1881: IS
1882: SELECT *
1883: FROM pay_action_information

Line 1883: FROM pay_action_information

1879: csr_v_pa_id pay_action_information.action_context_id%TYPE
1880: )
1881: IS
1882: SELECT *
1883: FROM pay_action_information
1884: WHERE action_context_type = 'PA'
1885: AND action_context_id = csr_v_pa_id
1886: AND action_information_category = 'EMEA REPORT DETAILS'
1887: AND action_information1 = 'PYSEALEA';

Line 1892: csr_v_pa_id pay_action_information.action_information3%TYPE

1888:
1889: lr_report_details csr_report_details%ROWTYPE;
1890:
1891: CURSOR csr_all_employees_for_event (
1892: csr_v_pa_id pay_action_information.action_information3%TYPE
1893: ,csr_v_event pay_action_information.action_information4%TYPE
1894: )
1895: IS
1896: SELECT *

Line 1893: ,csr_v_event pay_action_information.action_information4%TYPE

1889: lr_report_details csr_report_details%ROWTYPE;
1890:
1891: CURSOR csr_all_employees_for_event (
1892: csr_v_pa_id pay_action_information.action_information3%TYPE
1893: ,csr_v_event pay_action_information.action_information4%TYPE
1894: )
1895: IS
1896: SELECT *
1897: FROM pay_action_information

Line 1897: FROM pay_action_information

1893: ,csr_v_event pay_action_information.action_information4%TYPE
1894: )
1895: IS
1896: SELECT *
1897: FROM pay_action_information
1898: WHERE action_context_type = 'AAP'
1899: AND action_information_category = 'EMEA REPORT INFORMATION'
1900: AND action_information1 = 'PYSEALEA'
1901: AND action_information3 = csr_v_pa_id

Line 1907: csr_v_pa_id pay_action_information.action_information3%TYPE

1903: AND action_information4 = csr_v_event
1904: ORDER BY action_information30;
1905:
1906: CURSOR csr_count_employees_for_event (
1907: csr_v_pa_id pay_action_information.action_information3%TYPE
1908: ,csr_v_event pay_action_information.action_information4%TYPE
1909: )
1910: IS
1911: SELECT COUNT ('1')

Line 1908: ,csr_v_event pay_action_information.action_information4%TYPE

1904: ORDER BY action_information30;
1905:
1906: CURSOR csr_count_employees_for_event (
1907: csr_v_pa_id pay_action_information.action_information3%TYPE
1908: ,csr_v_event pay_action_information.action_information4%TYPE
1909: )
1910: IS
1911: SELECT COUNT ('1')
1912: FROM pay_action_information

Line 1912: FROM pay_action_information

1908: ,csr_v_event pay_action_information.action_information4%TYPE
1909: )
1910: IS
1911: SELECT COUNT ('1')
1912: FROM pay_action_information
1913: WHERE action_context_type = 'AAP'
1914: AND action_information_category = 'EMEA REPORT INFORMATION'
1915: AND action_information1 = 'PYSEALEA'
1916: AND action_information3 = csr_v_pa_id

Line 1923: csr_v_pa_id pay_action_information.action_information3%TYPE

1919:
1920: l_count_employees_for_event NUMBER;
1921:
1922: CURSOR csr_all_employees_under_le (
1923: csr_v_pa_id pay_action_information.action_information3%TYPE
1924: ,csr_v_le_id pay_action_information.action_information15%TYPE
1925: )
1926: IS
1927: SELECT *

Line 1924: ,csr_v_le_id pay_action_information.action_information15%TYPE

1920: l_count_employees_for_event NUMBER;
1921:
1922: CURSOR csr_all_employees_under_le (
1923: csr_v_pa_id pay_action_information.action_information3%TYPE
1924: ,csr_v_le_id pay_action_information.action_information15%TYPE
1925: )
1926: IS
1927: SELECT *
1928: FROM pay_action_information

Line 1928: FROM pay_action_information

1924: ,csr_v_le_id pay_action_information.action_information15%TYPE
1925: )
1926: IS
1927: SELECT *
1928: FROM pay_action_information
1929: WHERE action_context_type = 'AAP'
1930: AND action_information_category = 'EMEA REPORT INFORMATION'
1931: AND action_information1 = 'PYSEALEA'
1932: AND action_information3 = csr_v_pa_id