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

481:
482:
483: -- Archive the REPORT DETAILS
484:
485: pay_action_information_api.create_action_information
486: (p_action_information_id => l_action_info_id -- out parameter
487: ,p_object_version_number => l_ovn -- out parameter
488: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)
489: ,p_action_context_type => 'PA' -- context type

Line 531: pay_action_information_api.create_action_information

527: CLOSE csr_get_le_da_off_codes;
528:
529: l_le_da_scode := rec_get_le_da_off_codes.da_scode;
530:
531: pay_action_information_api.create_action_information
532: (
533: p_action_information_id => l_action_info_id -- out parameter
534: ,p_object_version_number => l_ovn -- out parameter
535: ,p_action_context_id => pactid -- context id = payroll action id (of Archive)

Line 587: FROM pay_action_information pai

583: SELECT effective_date
584: ,fnd_date.CANONICAL_TO_DATE(action_information6) from_date
585: ,fnd_date.CANONICAL_TO_DATE(action_information7) to_date
586: ,to_number(action_information2) business_group_id
587: FROM pay_action_information pai
588: WHERE action_context_type = 'PA'
589: AND action_context_id = p_payroll_action_id
590: AND action_information_category = 'EMEA REPORT DETAILS'
591: AND action_information1 = 'PYDKSTATSA'

Line 600: FROM pay_action_information pai

596: CURSOR csr_get_sub_hdr_info(p_payroll_action_id NUMBER) IS
597: SELECT tax_unit_id
598: ,to_number(action_information3) PAYROLL_ID
599: ,action_information8 LE_NAME
600: FROM pay_action_information pai
601: WHERE action_context_type = 'PA'
602: AND action_context_id = p_payroll_action_id
603: AND action_information_category = 'EMEA REPORT DETAILS'
604: AND action_information1 = 'PYDKSTATSA'

Line 1402: pay_action_information_api.create_action_information

1398: Else
1399: l_lnr_payroll_period := csr_rec.payroll_period;
1400: End if;
1401:
1402: pay_action_information_api.create_action_information
1403: ( p_action_information_id => l_action_info_id -- OUT parameter
1404: ,p_object_version_number => l_ovn -- OUT parameter
1405: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
1406: ,p_action_context_type => 'AAP' -- Context type

Line 1444: pay_action_information_api.create_action_information

1440: ,p_action_information29 => l_iltype_0037_bal -- Balance for ILTYPE 0037
1441: ,p_action_information30 => l_hourly_salaried -- Hourly/Salaried
1442: );
1443:
1444: pay_action_information_api.create_action_information
1445: ( p_action_information_id => l_action_info_id -- OUT parameter
1446: ,p_object_version_number => l_ovn -- OUT parameter
1447: ,p_action_context_id => l_actid -- Context id = assignment action id (of Archive)
1448: ,p_action_context_type => 'AAP' -- Context type

Line 1567: FROM pay_action_information pai

1563: /* Cursor to fetch File Start and End Record Information */
1564: CURSOR csr_get_hdr_info(p_payroll_action_id NUMBER)
1565: IS
1566: SELECT *
1567: FROM pay_action_information pai
1568: WHERE action_context_type = 'PA'
1569: AND action_context_id = p_payroll_action_id
1570: AND action_information_category = 'EMEA REPORT DETAILS'
1571: AND action_information1 = 'PYDKSTATSA'

Line 1579: FROM pay_action_information pai

1575: /* Cursor to fetch Company Start and End Record Information */
1576: CURSOR csr_get_chdr_info(p_payroll_action_id NUMBER)
1577: IS
1578: SELECT *
1579: FROM pay_action_information pai
1580: WHERE action_context_type = 'PA'
1581: AND action_context_id = p_payroll_action_id
1582: AND action_information_category = 'EMEA REPORT DETAILS'
1583: AND action_information1 = 'PYDKSTATSA'

Line 1591: FROM pay_action_information pai

1587: /* Cursors to fetch Personal and Salary Record Information */
1588: CURSOR csr_get_body_info1(p_payroll_action_id NUMBER, p_tax_unit_id NUMBER)
1589: IS
1590: SELECT *
1591: FROM pay_action_information pai
1592: WHERE action_context_type = 'AAP'
1593: AND action_information3 = to_char(p_payroll_action_id)
1594: AND action_information_category = 'EMEA REPORT INFORMATION'
1595: AND action_information1 = 'PYDKSTATSA'

Line 1604: FROM pay_action_information pai

1600:
1601: 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)
1602: IS
1603: SELECT *
1604: FROM pay_action_information pai
1605: WHERE action_context_type = 'AAP'
1606: AND action_information3 = p_payroll_action_id
1607: AND action_information_category = 'EMEA REPORT INFORMATION'
1608: AND action_information1 = 'PYDKSTATSA'