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

Line 679: pay_action_information_api.create_action_information

675: fetch csr_local_unit_details into L_LOCAL_UNIT_NAME;
676: CLOSE csr_local_unit_details;*/
677:
678: -- Insert the report Parameters
679: pay_action_information_api.create_action_information
680: (p_action_information_id => l_action_info_id
681: , p_action_context_id => p_payroll_action_id
682: , p_action_context_type => 'PA'
683: , p_object_version_number => l_ovn

Line 1075: pay_action_information_api.create_action_information

1071: END IF;
1072: END IF;
1073: END IF;
1074: /* fnd_file.put_line(fnd_file.LOG,'Within the ');
1075: pay_action_information_api.create_action_information
1076: (p_action_information_id => l_action_info_id
1077: , p_action_context_id => p_payroll_action_id
1078: , p_action_context_type => 'PA'
1079: , p_object_version_number => l_ovn

Line 1103: pay_action_information_api.create_action_information

1099: l_white_from:=null;
1100: END LOOP;
1101:
1102: FOR csr_record IN emp_record.FIRST .. emp_record.last LOOP
1103: pay_action_information_api.create_action_information
1104: (p_action_information_id => l_action_info_id
1105: , p_action_context_id => p_payroll_action_id
1106: , p_action_context_type => 'PA'
1107: , p_object_version_number => l_ovn

Line 1481: pay_action_information_api.create_action_information

1477: /*FOR csr_record IN emp_record.FIRST .. emp_record.last LOOP
1478: fnd_file.put_line(fnd_file.LOG,'emp_record(csr_record).l_gross_salary '||emp_record(csr_record).l_gross_salary);
1479: END loop;*/
1480: FOR csr_record IN emp_record.FIRST .. emp_record.last LOOP
1481: pay_action_information_api.create_action_information
1482: (p_action_information_id => l_action_info_id
1483: , p_action_context_id => p_payroll_action_id
1484: , p_action_context_type => 'PA'
1485: , p_object_version_number => l_ovn

Line 1898: l_payroll_action_id pay_action_information.action_information1%TYPE;

1894: )
1895: IS
1896: --Variables needed for the report
1897: l_counter NUMBER := 0;
1898: l_payroll_action_id pay_action_information.action_information1%TYPE;
1899:
1900: --Cursors needed for report
1901: CURSOR csr_all_legal_employer (
1902: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 1902: csr_v_pa_id pay_action_information.action_context_id%TYPE

1898: l_payroll_action_id pay_action_information.action_information1%TYPE;
1899:
1900: --Cursors needed for report
1901: CURSOR csr_all_legal_employer (
1902: csr_v_pa_id pay_action_information.action_context_id%TYPE
1903: )
1904: IS
1905: SELECT action_information3, action_information4
1906: , action_information5

Line 1907: FROM pay_action_information

1903: )
1904: IS
1905: SELECT action_information3, action_information4
1906: , action_information5
1907: FROM pay_action_information
1908: WHERE action_context_type = 'PA'
1909: AND action_context_id = csr_v_pa_id
1910: AND action_information_category = 'EMEA REPORT INFORMATION'
1911: AND action_information1 = 'PYSEHPDA'

Line 1915: csr_v_pa_id pay_action_information.action_context_id%TYPE

1911: AND action_information1 = 'PYSEHPDA'
1912: AND action_information2 = 'LE';
1913:
1914: CURSOR csr_report_details (
1915: csr_v_pa_id pay_action_information.action_context_id%TYPE
1916: )
1917: IS
1918: SELECT TO_CHAR
1919: (fnd_date.canonical_to_date (action_information5)

Line 1926: FROM pay_action_information

1922: , TO_CHAR
1923: (fnd_date.canonical_to_date (action_information6)
1924: , 'YYYYMMDD'
1925: ) period_to
1926: FROM pay_action_information
1927: WHERE action_context_type = 'PA'
1928: AND action_context_id = csr_v_pa_id
1929: AND action_information_category = 'EMEA REPORT DETAILS'
1930: AND action_information1 = 'PYSEHPDA';

Line 1935: csr_v_pa_id pay_action_information.action_information3%TYPE

1931:
1932: lr_report_details csr_report_details%ROWTYPE;
1933:
1934: CURSOR csr_all_employees_under_le (
1935: csr_v_pa_id pay_action_information.action_information3%TYPE
1936: , csr_v_le_id pay_action_information.action_information15%TYPE
1937: )
1938: IS
1939: SELECT *

Line 1936: , csr_v_le_id pay_action_information.action_information15%TYPE

1932: lr_report_details csr_report_details%ROWTYPE;
1933:
1934: CURSOR csr_all_employees_under_le (
1935: csr_v_pa_id pay_action_information.action_information3%TYPE
1936: , csr_v_le_id pay_action_information.action_information15%TYPE
1937: )
1938: IS
1939: SELECT *
1940: FROM pay_action_information

Line 1940: FROM pay_action_information

1936: , csr_v_le_id pay_action_information.action_information15%TYPE
1937: )
1938: IS
1939: SELECT *
1940: FROM pay_action_information
1941: WHERE action_context_type = 'AAP'
1942: AND action_information_category = 'EMEA REPORT INFORMATION'
1943: AND action_information1 = 'PYSEHPDA'
1944: AND action_information3 = csr_v_pa_id

Line 2116: pay_action_information pai,

2112: pai1.ACTION_INFORMATION10 Gross_Salary,
2113: pai1.ACTION_INFORMATION11 Terminated,
2114: pai1.ACTION_INFORMATION12 Painter*/
2115: FROM
2116: pay_action_information pai,
2117: pay_payroll_actions ppa,
2118: pay_action_information pai1
2119: WHERE
2120: pai.action_context_id = ppa.payroll_action_id

Line 2118: pay_action_information pai1

2114: pai1.ACTION_INFORMATION12 Painter*/
2115: FROM
2116: pay_action_information pai,
2117: pay_payroll_actions ppa,
2118: pay_action_information pai1
2119: WHERE
2120: pai.action_context_id = ppa.payroll_action_id
2121: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2122: AND pai.action_context_id = pai1.action_context_id

Line 2152: pay_action_information pai,

2148: pai1.ACTION_INFORMATION10 Gross_Salary,
2149: pai1.ACTION_INFORMATION11 Terminated,
2150: pai1.ACTION_INFORMATION12 Painter*/
2151: FROM
2152: pay_action_information pai,
2153: pay_payroll_actions ppa,
2154: pay_action_information pai1
2155: WHERE
2156: pai.action_context_id = ppa.payroll_action_id

Line 2154: pay_action_information pai1

2150: pai1.ACTION_INFORMATION12 Painter*/
2151: FROM
2152: pay_action_information pai,
2153: pay_payroll_actions ppa,
2154: pay_action_information pai1
2155: WHERE
2156: pai.action_context_id = ppa.payroll_action_id
2157: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2158: AND pai.action_context_id = pai1.action_context_id

Line 2184: --pay_action_information pai,

2180: nvl(pai1.ACTION_INFORMATION11,0) Gross_Salary,
2181: pai1.ACTION_INFORMATION12 Terminated,
2182: pai1.ACTION_INFORMATION13 Painter
2183: FROM
2184: --pay_action_information pai,
2185: pay_payroll_actions ppa,
2186: pay_action_information pai1
2187: WHERE
2188: pai1.action_context_id = ppa.payroll_action_id

Line 2186: pay_action_information pai1

2182: pai1.ACTION_INFORMATION13 Painter
2183: FROM
2184: --pay_action_information pai,
2185: pay_payroll_actions ppa,
2186: pay_action_information pai1
2187: WHERE
2188: pai1.action_context_id = ppa.payroll_action_id
2189: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2190: /*AND pai.action_context_id = pai1.action_context_id*/