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

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

Line 1081: pay_action_information_api.create_action_information

1077: END IF;
1078: END IF;
1079: END IF;
1080: /* fnd_file.put_line(fnd_file.LOG,'Within the ');
1081: pay_action_information_api.create_action_information
1082: (p_action_information_id => l_action_info_id
1083: , p_action_context_id => p_payroll_action_id
1084: , p_action_context_type => 'PA'
1085: , p_object_version_number => l_ovn

Line 1115: pay_action_information_api.create_action_information

1111: if emp_record(csr_record).l_start_date between l_start_date and l_end_date then
1112: l_rep_start_date := emp_record(csr_record).l_start_date ;
1113: end if;
1114: -- Bug#9440498 fix ends
1115: pay_action_information_api.create_action_information
1116: (p_action_information_id => l_action_info_id
1117: , p_action_context_id => p_payroll_action_id
1118: , p_action_context_type => 'PA'
1119: , p_object_version_number => l_ovn

Line 1505: pay_action_information_api.create_action_information

1501: if emp_record(csr_record).l_start_date between l_start_date and l_end_date then
1502: l_rep_start_date := emp_record(csr_record).l_start_date ;
1503: end if;
1504: -- Bug#9440498 fix ends
1505: pay_action_information_api.create_action_information
1506: (p_action_information_id => l_action_info_id
1507: , p_action_context_id => p_payroll_action_id
1508: , p_action_context_type => 'PA'
1509: , p_object_version_number => l_ovn

Line 1924: l_payroll_action_id pay_action_information.action_information1%TYPE;

1920: )
1921: IS
1922: --Variables needed for the report
1923: l_counter NUMBER := 0;
1924: l_payroll_action_id pay_action_information.action_information1%TYPE;
1925:
1926: --Cursors needed for report
1927: CURSOR csr_all_legal_employer (
1928: csr_v_pa_id pay_action_information.action_context_id%TYPE

Line 1928: csr_v_pa_id pay_action_information.action_context_id%TYPE

1924: l_payroll_action_id pay_action_information.action_information1%TYPE;
1925:
1926: --Cursors needed for report
1927: CURSOR csr_all_legal_employer (
1928: csr_v_pa_id pay_action_information.action_context_id%TYPE
1929: )
1930: IS
1931: SELECT action_information3, action_information4
1932: , action_information5

Line 1933: FROM pay_action_information

1929: )
1930: IS
1931: SELECT action_information3, action_information4
1932: , action_information5
1933: FROM pay_action_information
1934: WHERE action_context_type = 'PA'
1935: AND action_context_id = csr_v_pa_id
1936: AND action_information_category = 'EMEA REPORT INFORMATION'
1937: AND action_information1 = 'PYSEHPDA'

Line 1941: csr_v_pa_id pay_action_information.action_context_id%TYPE

1937: AND action_information1 = 'PYSEHPDA'
1938: AND action_information2 = 'LE';
1939:
1940: CURSOR csr_report_details (
1941: csr_v_pa_id pay_action_information.action_context_id%TYPE
1942: )
1943: IS
1944: SELECT TO_CHAR
1945: (fnd_date.canonical_to_date (action_information5)

Line 1952: FROM pay_action_information

1948: , TO_CHAR
1949: (fnd_date.canonical_to_date (action_information6)
1950: , 'YYYYMMDD'
1951: ) period_to
1952: FROM pay_action_information
1953: WHERE action_context_type = 'PA'
1954: AND action_context_id = csr_v_pa_id
1955: AND action_information_category = 'EMEA REPORT DETAILS'
1956: AND action_information1 = 'PYSEHPDA';

Line 1961: csr_v_pa_id pay_action_information.action_information3%TYPE

1957:
1958: lr_report_details csr_report_details%ROWTYPE;
1959:
1960: CURSOR csr_all_employees_under_le (
1961: csr_v_pa_id pay_action_information.action_information3%TYPE
1962: , csr_v_le_id pay_action_information.action_information15%TYPE
1963: )
1964: IS
1965: SELECT *

Line 1962: , csr_v_le_id pay_action_information.action_information15%TYPE

1958: lr_report_details csr_report_details%ROWTYPE;
1959:
1960: CURSOR csr_all_employees_under_le (
1961: csr_v_pa_id pay_action_information.action_information3%TYPE
1962: , csr_v_le_id pay_action_information.action_information15%TYPE
1963: )
1964: IS
1965: SELECT *
1966: FROM pay_action_information

Line 1966: FROM pay_action_information

1962: , csr_v_le_id pay_action_information.action_information15%TYPE
1963: )
1964: IS
1965: SELECT *
1966: FROM pay_action_information
1967: WHERE action_context_type = 'AAP'
1968: AND action_information_category = 'EMEA REPORT INFORMATION'
1969: AND action_information1 = 'PYSEHPDA'
1970: AND action_information3 = csr_v_pa_id

Line 2142: pay_action_information pai,

2138: pai1.ACTION_INFORMATION10 Gross_Salary,
2139: pai1.ACTION_INFORMATION11 Terminated,
2140: pai1.ACTION_INFORMATION12 Painter*/
2141: FROM
2142: pay_action_information pai,
2143: pay_payroll_actions ppa,
2144: pay_action_information pai1
2145: WHERE
2146: pai.action_context_id = ppa.payroll_action_id

Line 2144: pay_action_information pai1

2140: pai1.ACTION_INFORMATION12 Painter*/
2141: FROM
2142: pay_action_information pai,
2143: pay_payroll_actions ppa,
2144: pay_action_information pai1
2145: WHERE
2146: pai.action_context_id = ppa.payroll_action_id
2147: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2148: AND pai.action_context_id = pai1.action_context_id

Line 2178: pay_action_information pai,

2174: pai1.ACTION_INFORMATION10 Gross_Salary,
2175: pai1.ACTION_INFORMATION11 Terminated,
2176: pai1.ACTION_INFORMATION12 Painter*/
2177: FROM
2178: pay_action_information pai,
2179: pay_payroll_actions ppa,
2180: pay_action_information pai1
2181: WHERE
2182: pai.action_context_id = ppa.payroll_action_id

Line 2180: pay_action_information pai1

2176: pai1.ACTION_INFORMATION12 Painter*/
2177: FROM
2178: pay_action_information pai,
2179: pay_payroll_actions ppa,
2180: pay_action_information pai1
2181: WHERE
2182: pai.action_context_id = ppa.payroll_action_id
2183: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2184: AND pai.action_context_id = pai1.action_context_id

Line 2212: --pay_action_information pai,

2208: pai1.ACTION_INFORMATION13 Coll_Agreement, -- Bug#9440498 fix
2209: pai1.ACTION_INFORMATION14 Termination_Date, -- Bug#9440498 fix
2210: pai1.ACTION_INFORMATION15 Start_Date -- Bug#9440498 fix
2211: FROM
2212: --pay_action_information pai,
2213: pay_payroll_actions ppa,
2214: pay_action_information pai1
2215: WHERE
2216: pai1.action_context_id = ppa.payroll_action_id

Line 2214: pay_action_information pai1

2210: pai1.ACTION_INFORMATION15 Start_Date -- Bug#9440498 fix
2211: FROM
2212: --pay_action_information pai,
2213: pay_payroll_actions ppa,
2214: pay_action_information pai1
2215: WHERE
2216: pai1.action_context_id = ppa.payroll_action_id
2217: AND ppa.payroll_action_id =p_payroll_action_id --27021 --20162 --20264 --20165
2218: /*AND pai.action_context_id = pai1.action_context_id*/