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

Line 299: FROM pay_action_information

295:
296: /* Cursor to check if Current Archive exists */
297: CURSOR csr_count is
298: SELECT count(*)
299: FROM pay_action_information
300: WHERE action_information_category = 'EMEA REPORT DETAILS'
301: AND action_information1 = 'PYDKSTATSA'
302: AND action_context_id = pactid;
303:

Line 510: pay_action_information_api.create_action_information

506: --8848543
507:
508: -- Archive the REPORT DETAILS
509:
510: pay_action_information_api.create_action_information
511: (p_action_information_id => l_action_info_id -- out parameter
512: ,p_object_version_number => l_ovn -- out parameter
513: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
514: ,p_action_context_type => 'PA' -- context type

Line 557: pay_action_information_api.create_action_information

553: CLOSE csr_get_le_da_off_codes;
554:
555: l_le_da_scode := rec_get_le_da_off_codes.da_scode;
556:
557: pay_action_information_api.create_action_information
558: (
559: p_action_information_id => l_action_info_id -- out parameter
560: ,p_object_version_number => l_ovn -- out parameter
561: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)

Line 614: FROM pay_action_information pai

610: SELECT effective_date
611: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
612: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
613: ,to_number(action_information2) business_group_id
614: FROM pay_action_information pai
615: WHERE action_context_type = 'PA'
616: AND action_context_id = p_payroll_action_id
617: AND action_information_category = 'EMEA REPORT DETAILS'
618: AND action_information1 = 'PYDKSTATSA'

Line 628: FROM pay_action_information pai

624: SELECT tax_unit_id
625: ,to_number(action_information3) PAYROLL_ID
626: ,action_information8 LE_NAME
627: , action_information11 LE_PUNIT
628: FROM pay_action_information pai
629: WHERE action_context_type = 'PA'
630: AND action_context_id = p_payroll_action_id
631: AND action_information_category = 'EMEA REPORT DETAILS'
632: AND action_information1 = 'PYDKSTATSA'

Line 1903: pay_action_information_api.create_action_information

1899: Else
1900: l_lnr_payroll_period := csr_rec.payroll_period;
1901: End if;
1902:
1903: pay_action_information_api.create_action_information
1904: ( p_action_information_id => l_action_info_id -- OUT parameter
1905: ,p_object_version_number => l_ovn -- OUT parameter
1906: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
1907: ,p_action_context_type => 'AAP' -- Context type

Line 2054: pay_action_information_api.create_action_information

2050: l_asgid_prev := csr_rec_all.asg_id;
2051:
2052: END LOOP;
2053:
2054: pay_action_information_api.create_action_information
2055: ( p_action_information_id => l_action_info_id -- OUT parameter
2056: ,p_object_version_number => l_ovn -- OUT parameter
2057: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
2058: ,p_action_context_type => 'AAP' -- Context type

Line 2099: pay_action_information_api.create_action_information

2095:
2096: --9865127 END
2097:
2098:
2099: pay_action_information_api.create_action_information
2100: ( p_action_information_id => l_action_info_id -- OUT parameter
2101: ,p_object_version_number => l_ovn -- OUT parameter
2102: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
2103: ,p_action_context_type => 'AAP' -- Context type

Line 2137: pay_action_information_api.create_action_information

2133: ,p_action_information24 => to_char(l_bal_todate,'YYYYMMDD') -- For Bug 9266075 to_char(l_date_to,'YYYYMMDD')
2134: --8848543
2135: );
2136:
2137: pay_action_information_api.create_action_information
2138: ( p_action_information_id => l_action_info_id -- OUT parameter
2139: ,p_object_version_number => l_ovn -- OUT parameter
2140: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
2141: ,p_action_context_type => 'AAP' -- Context type

Line 2273: FROM pay_action_information pai

2269: /* Cursor to fetch File Start and End Record Information */
2270: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER)
2271: IS
2272: SELECT *
2273: FROM pay_action_information pai
2274: WHERE action_context_type = 'PA'
2275: AND action_context_id = p_payroll_action_id
2276: AND action_information_category = 'EMEA REPORT DETAILS'
2277: AND action_information1 = 'PYDKSTATSA'

Line 2285: FROM pay_action_information pai

2281: /* Cursor to fetch Company Start and End Record Information */
2282: CURSOR csr_get_chdr_info(p_payroll_action_id NUMBER)
2283: IS
2284: SELECT *
2285: FROM pay_action_information pai
2286: WHERE action_context_type = 'PA'
2287: AND action_context_id = p_payroll_action_id
2288: AND action_information_category = 'EMEA REPORT DETAILS'
2289: AND action_information1 = 'PYDKSTATSA'

Line 2297: FROM pay_action_information pai

2293: /* Cursors to fetch Personal and Salary Record Information */
2294: CURSOR csr_get_body_info1(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER)
2295: IS
2296: SELECT *
2297: FROM pay_action_information pai
2298: WHERE action_context_type = 'AAP'
2299: AND action_information3 = to_char(p_payroll_action_id)
2300: AND action_information_category = 'EMEA REPORT INFORMATION'
2301: AND action_information1 = 'PYDKSTATSA'

Line 2310: FROM pay_action_information pai

2306:
2307: CURSOR csr_get_body_info2(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER,p_action_context_id NUMBER, p_effective_date DATE, p_assignment_id NUMBER)
2308: IS
2309: SELECT *
2310: FROM pay_action_information pai
2311: WHERE action_context_type = 'AAP'
2312: AND action_information3 = p_payroll_action_id
2313: AND action_information_category = 'EMEA REPORT INFORMATION'
2314: AND action_information1 = 'PYDKSTATSA'

Line 2324: FROM pay_action_information pai

2320:
2321: CURSOR csr_get_body_info3(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER,p_action_context_id NUMBER, p_effective_date DATE, p_assignment_id NUMBER)
2322: IS
2323: SELECT *
2324: FROM pay_action_information pai
2325: WHERE action_context_type = 'AAP'
2326: AND action_information3 = p_payroll_action_id
2327: AND action_information_category = 'EMEA REPORT INFORMATION'
2328: AND action_information1 = 'PYDKSTATSA'

Line 2340: FROM pay_action_information pai

2336: --9865127
2337: CURSOR csr_get_date_tracks(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER,p_action_context_id NUMBER, p_effective_date DATE, p_assignment_id NUMBER)
2338: IS
2339: SELECT *
2340: FROM pay_action_information pai
2341: WHERE action_context_type = 'AAP'
2342: AND action_information3 = p_payroll_action_id
2343: AND action_information_category = 'EMEA REPORT INFORMATION'
2344: AND action_information1 = 'PYDKSTATSA'