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

Line 360: FROM pay_action_information

356: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
357: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
358: SELECT count(*)
359: INTO l_count
360: FROM pay_action_information
361: WHERE action_information_category = 'EMEA REPORT DETAILS'
362: AND action_information1 = 'PYDKEINA'
363: AND action_context_id = p_payroll_action_id;
364:

Line 418: pay_action_information_api.create_action_information (

414: if(rg_Legal_Emp_Details.ORG_INFORMATION3 = 'Y') then -- if the legal emp has data supplier set to 'Y'
415:
416: -- l_unique_id:=l_cvr_number; /* 9489806 */
417:
418: pay_action_information_api.create_action_information (
419: p_action_information_id => l_action_info_id
420: ,p_action_context_id => p_payroll_action_id
421: ,p_action_context_type => 'PA'
422: ,p_object_version_number => l_ovn

Line 471: pay_action_information_api.create_action_information (

467: g_flag:=1;
468: else
469: -- l_unique_id:=l_sp_cvr_number; /* 9489806 */
470:
471: pay_action_information_api.create_action_information (
472: p_action_information_id => l_action_info_id
473: ,p_action_context_id => p_payroll_action_id
474: ,p_action_context_type => 'PA'
475: ,p_object_version_number => l_ovn

Line 516: /* pay_action_information_api.create_action_information (

512: end if;
513:
514: if(g_flag=0) then
515: -- Record 2001
516: /* pay_action_information_api.create_action_information (
517: p_action_information_id => l_action_info_id
518: ,p_action_context_id => p_payroll_action_id
519: ,p_action_context_type => 'PA'
520: ,p_object_version_number => l_ovn

Line 568: pay_action_information_api.create_action_information (

564: LOOP
565: l_unique_id1:=l_unique_id|| lpad( substr(to_char(csr_rec.TIME_PERIOD_ID),-least(length(csr_rec.TIME_PERIOD_ID),5)),5,0) || '00'||'0'; /* 5 digits of time period id 2 digits of employemtn code, 1 digit for correcctin record , */
566: if(g_company_terminating='N') then
567: -- Record 5000
568: pay_action_information_api.create_action_information (
569: p_action_information_id => l_action_info_id
570: ,p_action_context_id => p_payroll_action_id
571: ,p_action_context_type => 'PA'
572: ,p_object_version_number => l_ovn

Line 619: pay_action_information_api.create_action_information (

615: END IF;
616:
617: -- fnd_file.put_line(fnd_file.log,'Range Code 14');
618: --Report Level Information
619: pay_action_information_api.create_action_information (
620: p_action_information_id => l_action_info_id
621: ,p_action_context_id => p_payroll_action_id
622: ,p_action_context_type => 'PA'
623: ,p_object_version_number => l_ovn

Line 937: FROM pay_action_information pai

933: --bug 10367494
934: CURSOR csr_chk_2001 (p_se_no hr_organization_information.ORG_INFORMATION5%type) IS
935:
936: SELECT 1
937: FROM pay_action_information pai
938: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
939: AND pai.action_information1 = 'PYDKEINA'
940: AND pai.action_information2 = to_char(g_payroll_action_id)
941: AND pai.action_information3 IN ('2001')

Line 1396: pid pay_action_information.action_information1%type

1392: --13463885
1393:
1394:
1395: PROCEDURE rec_6001(
1396: pid pay_action_information.action_information1%type
1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type

Line 1397: ,aid pay_action_information.action_information1%type

1393:
1394:
1395: PROCEDURE rec_6001(
1396: pid pay_action_information.action_information1%type
1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type

Line 1398: ,code pay_action_information.action_information1%type

1394:
1395: PROCEDURE rec_6001(
1396: pid pay_action_information.action_information1%type
1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type

Line 1399: ,amt pay_action_information.action_information1%type

1395: PROCEDURE rec_6001(
1396: pid pay_action_information.action_information1%type
1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type

Line 1400: ,sgn pay_action_information.action_information1%type

1396: pid pay_action_information.action_information1%type
1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type

Line 1401: ,corr pay_action_information.action_information1%type

1397: ,aid pay_action_information.action_information1%type
1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

Line 1402: ,p_payroll_id pay_action_information.action_information1%type

1398: ,code pay_action_information.action_information1%type
1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )

Line 1403: ,p_employment_type pay_action_information.action_information1%type

1399: ,amt pay_action_information.action_information1%type
1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )
1407: IS

Line 1404: ,p_period_id pay_action_information.action_information1%type

1400: ,sgn pay_action_information.action_information1%type
1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )
1407: IS
1408: l_sgn pay_action_information.action_information1%type:=NULL;

Line 1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

1401: ,corr pay_action_information.action_information1%type
1402: ,p_payroll_id pay_action_information.action_information1%type
1403: ,p_employment_type pay_action_information.action_information1%type
1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )
1407: IS
1408: l_sgn pay_action_information.action_information1%type:=NULL;
1409: amt1 pay_action_information.action_information1%type:=NULL;

Line 1408: l_sgn pay_action_information.action_information1%type:=NULL;

1404: ,p_period_id pay_action_information.action_information1%type
1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )
1407: IS
1408: l_sgn pay_action_information.action_information1%type:=NULL;
1409: amt1 pay_action_information.action_information1%type:=NULL;
1410: BEGIN
1411:
1412: if(sgn='-1') then

Line 1409: amt1 pay_action_information.action_information1%type:=NULL;

1405: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1406: ,p_se_no varchar2 )
1407: IS
1408: l_sgn pay_action_information.action_information1%type:=NULL;
1409: amt1 pay_action_information.action_information1%type:=NULL;
1410: BEGIN
1411:
1412: if(sgn='-1') then
1413: l_sgn:='-';

Line 1420: pay_action_information_api.create_action_information (

1416: end if;
1417:
1418: amt1:=lpad(amt,16,'0');
1419: --Record - 6001
1420: pay_action_information_api.create_action_information (
1421: p_action_information_id => l_action_info_id
1422: ,p_action_context_id => p_assignment_action_id
1423: ,p_action_context_type => 'AAP'
1424: ,p_object_version_number => l_ovn

Line 1464: ,p_payroll_id pay_action_information.action_information1%type

1460:
1461: /* 9489806 */
1462: PROCEDURE rec_5000(
1463: p_payroll_action_id NUMBER
1464: ,p_payroll_id pay_action_information.action_information1%type
1465: ,p_employement_type pay_action_information.action_information1%type
1466: ,p_period_id pay_action_information.action_information1%type
1467: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1468: ,p_se_no varchar2 )

Line 1465: ,p_employement_type pay_action_information.action_information1%type

1461: /* 9489806 */
1462: PROCEDURE rec_5000(
1463: p_payroll_action_id NUMBER
1464: ,p_payroll_id pay_action_information.action_information1%type
1465: ,p_employement_type pay_action_information.action_information1%type
1466: ,p_period_id pay_action_information.action_information1%type
1467: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1468: ,p_se_no varchar2 )
1469: IS

Line 1466: ,p_period_id pay_action_information.action_information1%type

1462: PROCEDURE rec_5000(
1463: p_payroll_action_id NUMBER
1464: ,p_payroll_id pay_action_information.action_information1%type
1465: ,p_employement_type pay_action_information.action_information1%type
1466: ,p_period_id pay_action_information.action_information1%type
1467: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1468: ,p_se_no varchar2 )
1469: IS
1470: CURSOR csr_chk_5000 IS

Line 1467: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

1463: p_payroll_action_id NUMBER
1464: ,p_payroll_id pay_action_information.action_information1%type
1465: ,p_employement_type pay_action_information.action_information1%type
1466: ,p_period_id pay_action_information.action_information1%type
1467: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1468: ,p_se_no varchar2 )
1469: IS
1470: CURSOR csr_chk_5000 IS
1471: SELECT *

Line 1472: FROM pay_action_information pai

1468: ,p_se_no varchar2 )
1469: IS
1470: CURSOR csr_chk_5000 IS
1471: SELECT *
1472: FROM pay_action_information pai
1473: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1474: AND pai.action_information1 = 'PYDKEINA'
1475: AND pai.action_information2 = to_char(p_payroll_action_id)
1476: AND pai.action_information3 IN ('5000')

Line 1484: FROM pay_action_information pai

1480: rec_csr_chk_5000 csr_chk_5000%ROWTYPE;
1481:
1482: CURSOR csr_chk_5000_emp IS
1483: SELECT 1
1484: FROM pay_action_information pai
1485: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1486: AND pai.action_information1 = 'PYDKEINA'
1487: AND pai.action_information2 = to_char(p_payroll_action_id)
1488: AND pai.action_information3 IN ('5000')

Line 1522: pay_action_information_api.create_action_information (

1518: l_unique_id:=substr(p_green_land_code,2,2)||substr(rec_csr_chk_5000.action_information10,3,6); /* in case of green land code firts 2 digits green land code..next 6 digits of payroll action id */
1519: END IF;
1520: l_unique_id:=l_unique_id || lpad(substr(p_period_id,-least(length(p_period_id),5)),5,0) || p_employement_type||'0';
1521:
1522: pay_action_information_api.create_action_information (
1523: p_action_information_id => l_action_info_id
1524: ,p_action_context_id => p_payroll_action_id
1525: ,p_action_context_type => 'PA'
1526: ,p_object_version_number => l_ovn

Line 1571: ,p_payroll_id pay_action_information.action_information1%type

1567: END;
1568:
1569: PROCEDURE rec_5000R(
1570: p_payroll_action_id NUMBER
1571: ,p_payroll_id pay_action_information.action_information1%type
1572: ,p_employement_type pay_action_information.action_information1%type
1573: ,p_period_id pay_action_information.action_information1%type
1574: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1575: ,p_se_no varchar2 )

Line 1572: ,p_employement_type pay_action_information.action_information1%type

1568:
1569: PROCEDURE rec_5000R(
1570: p_payroll_action_id NUMBER
1571: ,p_payroll_id pay_action_information.action_information1%type
1572: ,p_employement_type pay_action_information.action_information1%type
1573: ,p_period_id pay_action_information.action_information1%type
1574: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1575: ,p_se_no varchar2 )
1576: IS

Line 1573: ,p_period_id pay_action_information.action_information1%type

1569: PROCEDURE rec_5000R(
1570: p_payroll_action_id NUMBER
1571: ,p_payroll_id pay_action_information.action_information1%type
1572: ,p_employement_type pay_action_information.action_information1%type
1573: ,p_period_id pay_action_information.action_information1%type
1574: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1575: ,p_se_no varchar2 )
1576: IS
1577: CURSOR csr_chk_5000 IS

Line 1574: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

1570: p_payroll_action_id NUMBER
1571: ,p_payroll_id pay_action_information.action_information1%type
1572: ,p_employement_type pay_action_information.action_information1%type
1573: ,p_period_id pay_action_information.action_information1%type
1574: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1575: ,p_se_no varchar2 )
1576: IS
1577: CURSOR csr_chk_5000 IS
1578: SELECT *

Line 1579: FROM pay_action_information pai

1575: ,p_se_no varchar2 )
1576: IS
1577: CURSOR csr_chk_5000 IS
1578: SELECT *
1579: FROM pay_action_information pai
1580: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1581: AND pai.action_information1 = 'PYDKEINA'
1582: AND pai.action_information2 = to_char(p_payroll_action_id)
1583: AND pai.action_information3 IN ('5000')

Line 1591: FROM pay_action_information pai

1587: rec_csr_chk_5000 csr_chk_5000%ROWTYPE;
1588:
1589: CURSOR csr_chk_5000_emp IS
1590: SELECT 1
1591: FROM pay_action_information pai
1592: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1593: AND pai.action_information1 = 'PYDKEINA'
1594: AND pai.action_information2 = to_char(p_payroll_action_id)
1595: AND pai.action_information3 IN ('5000R')

Line 1629: pay_action_information_api.create_action_information (

1625: l_unique_id:=substr(p_green_land_code,2,2)||substr(rec_csr_chk_5000.action_information10,3,6); /* in case of green land code firts 2 digits green land code..next 6 digits of payroll action id */
1626: END IF;
1627:
1628: l_unique_id:=l_unique_id || lpad(substr(p_period_id,-least(length(p_period_id),5)),5,0) || p_employement_type||'1';
1629: pay_action_information_api.create_action_information (
1630: p_action_information_id => l_action_info_id
1631: ,p_action_context_id => p_payroll_action_id
1632: ,p_action_context_type => 'PA'
1633: ,p_object_version_number => l_ovn

Line 1677: ,p_payroll_id pay_action_information.action_information1%type

1673:
1674: END;
1675: PROCEDURE rec_6000R(
1676: p_assignment_action_id NUMBER
1677: ,p_payroll_id pay_action_information.action_information1%type
1678: ,p_employement_type pay_action_information.action_information1%type
1679: ,p_period_id pay_action_information.action_information1%type
1680: ,p_assignment_id pay_action_information.action_information1%type
1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

Line 1678: ,p_employement_type pay_action_information.action_information1%type

1674: END;
1675: PROCEDURE rec_6000R(
1676: p_assignment_action_id NUMBER
1677: ,p_payroll_id pay_action_information.action_information1%type
1678: ,p_employement_type pay_action_information.action_information1%type
1679: ,p_period_id pay_action_information.action_information1%type
1680: ,p_assignment_id pay_action_information.action_information1%type
1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1682: ,p_se_no varchar2 )

Line 1679: ,p_period_id pay_action_information.action_information1%type

1675: PROCEDURE rec_6000R(
1676: p_assignment_action_id NUMBER
1677: ,p_payroll_id pay_action_information.action_information1%type
1678: ,p_employement_type pay_action_information.action_information1%type
1679: ,p_period_id pay_action_information.action_information1%type
1680: ,p_assignment_id pay_action_information.action_information1%type
1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1682: ,p_se_no varchar2 )
1683: IS

Line 1680: ,p_assignment_id pay_action_information.action_information1%type

1676: p_assignment_action_id NUMBER
1677: ,p_payroll_id pay_action_information.action_information1%type
1678: ,p_employement_type pay_action_information.action_information1%type
1679: ,p_period_id pay_action_information.action_information1%type
1680: ,p_assignment_id pay_action_information.action_information1%type
1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1682: ,p_se_no varchar2 )
1683: IS
1684: CURSOR csr_chk_6000 IS

Line 1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

1677: ,p_payroll_id pay_action_information.action_information1%type
1678: ,p_employement_type pay_action_information.action_information1%type
1679: ,p_period_id pay_action_information.action_information1%type
1680: ,p_assignment_id pay_action_information.action_information1%type
1681: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1682: ,p_se_no varchar2 )
1683: IS
1684: CURSOR csr_chk_6000 IS
1685: SELECT *

Line 1686: FROM pay_action_information pai

1682: ,p_se_no varchar2 )
1683: IS
1684: CURSOR csr_chk_6000 IS
1685: SELECT *
1686: FROM pay_action_information pai
1687: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1688: AND pai.action_information1 = 'PYDKEINA'
1689: AND pai.action_context_id = to_char(p_assignment_action_id)
1690: AND pai.action_information3 IN ('6000')

Line 1697: FROM pay_action_information pai

1693: rec_csr_chk_6000 csr_chk_6000%ROWTYPE;
1694:
1695: CURSOR csr_chk_6000_emp IS
1696: SELECT 1
1697: FROM pay_action_information pai
1698: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1699: AND pai.action_information1 = 'PYDKEINA'
1700: AND pai.action_information2 = to_char(p_assignment_action_id)
1701: AND pai.action_information3 IN ('6000R')

Line 1727: pay_action_information_api.create_action_information (

1723: hr_utility.set_location('rec_6000:Entered l_flag IF'|| l_flag ,501);
1724: OPEN csr_chk_6000;
1725: FETCH csr_chk_6000 INTO rec_csr_chk_6000;
1726: CLOSE csr_chk_6000;
1727: pay_action_information_api.create_action_information (
1728: p_action_information_id => l_action_info_id
1729: ,p_action_context_id => p_assignment_action_id
1730: ,p_action_context_type => 'AAP'
1731: ,p_object_version_number => l_ovn

Line 1775: ,p_payroll_id pay_action_information.action_information1%type

1771:
1772: END;
1773: PROCEDURE rec_8001R(
1774: p_assignment_action_id NUMBER
1775: ,p_payroll_id pay_action_information.action_information1%type
1776: ,p_employement_type pay_action_information.action_information1%type
1777: ,p_period_id pay_action_information.action_information1%type
1778: ,p_person_id pay_action_information.action_information1%type
1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

Line 1776: ,p_employement_type pay_action_information.action_information1%type

1772: END;
1773: PROCEDURE rec_8001R(
1774: p_assignment_action_id NUMBER
1775: ,p_payroll_id pay_action_information.action_information1%type
1776: ,p_employement_type pay_action_information.action_information1%type
1777: ,p_period_id pay_action_information.action_information1%type
1778: ,p_person_id pay_action_information.action_information1%type
1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1780: )

Line 1777: ,p_period_id pay_action_information.action_information1%type

1773: PROCEDURE rec_8001R(
1774: p_assignment_action_id NUMBER
1775: ,p_payroll_id pay_action_information.action_information1%type
1776: ,p_employement_type pay_action_information.action_information1%type
1777: ,p_period_id pay_action_information.action_information1%type
1778: ,p_person_id pay_action_information.action_information1%type
1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1780: )
1781: IS

Line 1778: ,p_person_id pay_action_information.action_information1%type

1774: p_assignment_action_id NUMBER
1775: ,p_payroll_id pay_action_information.action_information1%type
1776: ,p_employement_type pay_action_information.action_information1%type
1777: ,p_period_id pay_action_information.action_information1%type
1778: ,p_person_id pay_action_information.action_information1%type
1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1780: )
1781: IS
1782: CURSOR csr_chk_8001 IS

Line 1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */

1775: ,p_payroll_id pay_action_information.action_information1%type
1776: ,p_employement_type pay_action_information.action_information1%type
1777: ,p_period_id pay_action_information.action_information1%type
1778: ,p_person_id pay_action_information.action_information1%type
1779: ,p_green_land_code pay_action_information.action_information1%type /* 8847591 */
1780: )
1781: IS
1782: CURSOR csr_chk_8001 IS
1783: SELECT *

Line 1784: FROM pay_action_information pai

1780: )
1781: IS
1782: CURSOR csr_chk_8001 IS
1783: SELECT *
1784: FROM pay_action_information pai
1785: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1786: AND pai.action_information1 = 'PYDKEINA'
1787: AND pai.action_context_id = to_char(p_assignment_action_id)
1788: AND pai.action_information4=to_char(p_person_id)

Line 1796: FROM pay_action_information pai

1792: rec_csr_chk_8001 csr_chk_8001%ROWTYPE;
1793:
1794: CURSOR csr_chk_8001_emp IS
1795: SELECT 1
1796: FROM pay_action_information pai
1797: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
1798: AND pai.action_information1 = 'PYDKEINA'
1799: AND pai.action_information2 = to_char(p_assignment_action_id)
1800: AND pai.action_information3 IN ('8001R')

Line 1825: pay_action_information_api.create_action_information (

1821: hr_utility.set_location('rec_8001:Entered l_flag IF'|| l_flag ,501);
1822: OPEN csr_chk_8001;
1823: FETCH csr_chk_8001 INTO rec_csr_chk_8001;
1824: CLOSE csr_chk_8001;
1825: pay_action_information_api.create_action_information (
1826: p_action_information_id => l_action_info_id
1827: ,p_action_context_id => p_assignment_action_id
1828: ,p_action_context_type => 'AAP'
1829: ,p_object_version_number => l_ovn

Line 2118: pay_action_information_api.create_action_information (

2114: l_cpr_number:= rg_csr_get_person_details.cpr;
2115: if((rg_csr_latest_hire_date.lhd between l_start_date and l_end_date) and to_char(l_end_date,'mm')<'06' and to_char(l_end_date,'yyyy')<='2008') then
2116: -- fnd_file.put_line(fnd_file.log,'Inserting starters');
2117: --Record - 2101
2118: pay_action_information_api.create_action_information (
2119: p_action_information_id => l_action_info_id
2120: ,p_action_context_id => p_assignment_action_id
2121: ,p_action_context_type => 'AAP'
2122: ,p_object_version_number => l_ovn

Line 2189: pay_action_information_api.create_action_information (

2185: /* bug 10367494 archiving p_action_information11 => l_se_no */
2186: if(rg_csr_asg_terminator.effective_end_date <= l_end_date) then
2187: fnd_file.put_line(fnd_file.log,'Inserting terminators');
2188: --Record - 2101
2189: pay_action_information_api.create_action_information (
2190: p_action_information_id => l_action_info_id
2191: ,p_action_context_id => p_assignment_action_id
2192: ,p_action_context_type => 'AAP'
2193: ,p_object_version_number => l_ovn

Line 2676: pay_action_information_api.create_action_information (

2672: FETCH csr_chk_2001 into l_flag1;
2673: CLOSE csr_chk_2001;
2674:
2675: IF l_flag1<>1 THEN
2676: pay_action_information_api.create_action_information (
2677: p_action_information_id => l_action_info_id
2678: ,p_action_context_id => g_payroll_action_id
2679: ,p_action_context_type => 'PA'
2680: ,p_object_version_number => l_ovn

Line 2721: pay_action_information_api.create_action_information (

2717: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);
2718:
2719: --Record - 6000
2720: /* bug 10367494 archiving p_action_information11 => l_se_no */
2721: pay_action_information_api.create_action_information (
2722: p_action_information_id => l_action_info_id
2723: ,p_action_context_id => p_assignment_action_id
2724: ,p_action_context_type => 'AAP'
2725: ,p_object_version_number => l_ovn

Line 2781: pay_action_information_api.create_action_information (

2777: end if;
2778:
2779: select DECODE(l_sex,'M','1','F','2','3') into l_sex from dual;
2780:
2781: pay_action_information_api.create_action_information (
2782: p_action_information_id => l_action_info_id
2783: ,p_action_context_id => p_assignment_action_id
2784: ,p_action_context_type => 'AAP'
2785: ,p_object_version_number => l_ovn

Line 3435: pay_action_information_api.create_action_information (

3431:
3432: IF (l_yes_no='N' and l_stationed_abroad = 'N') THEN /* Employee is not a foreigner */
3433: --Record - 6002
3434: IF (l_total_atp <> 0) THEN -- 11075581
3435: pay_action_information_api.create_action_information (
3436: p_action_information_id => l_action_info_id
3437: ,p_action_context_id => p_assignment_action_id
3438: ,p_action_context_type => 'AAP'
3439: ,p_object_version_number => l_ovn

Line 3478: pay_action_information_api.create_action_information (

3474: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16: Inserted 6002');
3475: END IF; -- kknadhan end
3476:
3477: IF rg_csr_asg_extra_info.aei_information1='Y' THEN
3478: pay_action_information_api.create_action_information (
3479: p_action_information_id => l_action_info_id
3480: ,p_action_context_id => p_assignment_action_id
3481: ,p_action_context_type => 'AAP'
3482: ,p_object_version_number => l_ovn

Line 3524: pay_action_information_api.create_action_information (

3520:
3521: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
3522: --Record - 6004
3523: IF (l_total_atp <> 0) THEN
3524: pay_action_information_api.create_action_information (
3525: p_action_information_id => l_action_info_id
3526: ,p_action_context_id => p_assignment_action_id
3527: ,p_action_context_type => 'AAP'
3528: ,p_object_version_number => l_ovn

Line 3571: pay_action_information_api.create_action_information (

3567: l_total_atp_hours := ROUND(l_total_atp_hours,2); -- rounding to 2 decimals
3568:
3569: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
3570: --Record - 6005
3571: pay_action_information_api.create_action_information (
3572: p_action_information_id => l_action_info_id
3573: ,p_action_context_id => p_assignment_action_id
3574: ,p_action_context_type => 'AAP'
3575: ,p_object_version_number => l_ovn

Line 3624: pay_action_information_api.create_action_information (

3620:
3621:
3622: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');
3623: --Record - 6005
3624: pay_action_information_api.create_action_information (
3625: p_action_information_id => l_action_info_id
3626: ,p_action_context_id => p_assignment_action_id
3627: ,p_action_context_type => 'AAP'
3628: ,p_object_version_number => l_ovn

Line 3678: pay_action_information_api.create_action_information (

3674: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_1 <> 0 THEN
3675: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');
3676:
3677: --Record - 6102
3678: pay_action_information_api.create_action_information (
3679: p_action_information_id => l_action_info_id
3680: ,p_action_context_id => p_assignment_action_id
3681: ,p_action_context_type => 'AAP'
3682: ,p_object_version_number => l_ovn

Line 3724: pay_action_information_api.create_action_information (

3720: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_2 <> 0 THEN
3721: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-2');
3722:
3723: --Record - 6102
3724: pay_action_information_api.create_action_information (
3725: p_action_information_id => l_action_info_id
3726: ,p_action_context_id => p_assignment_action_id
3727: ,p_action_context_type => 'AAP'
3728: ,p_object_version_number => l_ovn

Line 3770: pay_action_information_api.create_action_information (

3766: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_3 <> 0 THEN
3767: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-3');
3768:
3769: --Record - 6102
3770: pay_action_information_api.create_action_information (
3771: p_action_information_id => l_action_info_id
3772: ,p_action_context_id => p_assignment_action_id
3773: ,p_action_context_type => 'AAP'
3774: ,p_object_version_number => l_ovn

Line 3840: FROM pay_action_information pai

3836: /* Cursors to fetch data for record numbering*/
3837:
3838: CURSOR csr_all_rec_2001 ( p_payroll_action_id NUMBER) IS
3839: SELECT *
3840: FROM pay_action_information pai
3841: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3842: AND pai.action_information1 = 'PYDKEINA'
3843: AND pai.action_information2 = to_char(p_payroll_action_id)
3844: -- AND pai.action_information3 IN ('1000','2001','2101','5000','6000')

Line 3851: FROM pay_action_information pai

3847: FOR UPDATE;
3848:
3849: CURSOR csr_all_rec ( p_payroll_action_id NUMBER,p_se_no varchar2) IS
3850: SELECT *
3851: FROM pay_action_information pai
3852: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3853: AND pai.action_information1 = 'PYDKEINA'
3854: AND pai.action_information2 = to_char(p_payroll_action_id)
3855: -- AND pai.action_information3 IN ('1000','2001','2101','5000','6000')

Line 3864: FROM pay_action_information pai

3860:
3861: --13063867
3862: CURSOR csr_all_rec_2101 ( p_payroll_action_id NUMBER,p_se_no varchar2) IS
3863: SELECT *
3864: FROM pay_action_information pai
3865: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3866: AND pai.ACTION_CONTEXT_TYPE = 'AAP'
3867: AND pai.action_information1 = 'PYDKEINA'
3868: AND pai.action_information2 = to_char(p_payroll_action_id)

Line 3878: FROM pay_action_information pai

3874:
3875: /* 9489806 */
3876: CURSOR csr_all_rec_6000 ( p_payroll_action_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2 ) IS
3877: SELECT *
3878: FROM pay_action_information pai
3879: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3880: AND pai.action_information1 = 'PYDKEINA'
3881: AND pai.action_information2 = to_char(p_payroll_action_id)
3882: AND pai.action_information3 IN ('6000')

Line 3894: FROM pay_action_information pai

3890:
3891: /* 9587046 */
3892: CURSOR csr_all_rec_6000R ( p_payroll_action_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER,p_se_no varchar2 ) IS
3893: SELECT *
3894: FROM pay_action_information pai
3895: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3896: AND pai.action_information1 = 'PYDKEINA'
3897: AND pai.action_information2 = to_char(p_payroll_action_id)
3898: AND pai.action_information3 IN ('6000R')

Line 3909: FROM pay_action_information pai

3905: FOR UPDATE;
3906:
3907: CURSOR csr_asg_all_rec ( p_payroll_action_id NUMBER,p_person_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS
3908: SELECT *
3909: FROM pay_action_information pai
3910: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3911: AND pai.action_information1 = 'PYDKEINA'
3912: AND pai.action_information2 = to_char(p_payroll_action_id)
3913: AND pai.action_information4 = to_char(p_person_id)

Line 3927: FROM pay_action_information pai

3923: /* 8616718 */
3924:
3925: CURSOR csr_asg_all_rec_corr ( p_payroll_action_id NUMBER,p_person_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS
3926: SELECT *
3927: FROM pay_action_information pai
3928: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3929: AND pai.action_information1 = 'PYDKEINA'
3930: AND pai.action_information2 = to_char(p_payroll_action_id)
3931: AND pai.action_information4 = to_char(p_person_id)

Line 3944: FROM pay_action_information pai

3940:
3941: /* bug 7613211*/
3942: CURSOR csr_asg_8001 (p_payroll_action_id NUMBER,p_person_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS
3943: SELECT *
3944: FROM pay_action_information pai
3945: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3946: AND pai.action_information1 = 'PYDKEINA'
3947: AND pai.action_information2 = to_char(p_payroll_action_id)
3948: AND pai.action_information4 = to_char(p_person_id)

Line 3959: FROM pay_action_information pai

3955:
3956: /* 9587046R */
3957: CURSOR csr_asg_8001R (p_payroll_action_id NUMBER,p_person_id NUMBER, p_payroll_id NUMBER,p_employement_type NUMBER,p_time_period_id NUMBER,p_green_land_code NUMBER) IS
3958: SELECT *
3959: FROM pay_action_information pai
3960: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
3961: AND pai.action_information1 = 'PYDKEINA'
3962: AND pai.action_information2 = to_char(p_payroll_action_id)
3963: AND pai.action_information4 = to_char(p_person_id)

Line 3998: UPDATE pay_action_information pai

3994: IF rg_csr_all_rec_2001.action_information3 in ('1000') THEN
3995: l_end_code:=l_end_code + 1 ;
3996: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');
3997:
3998: UPDATE pay_action_information pai
3999: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4000: WHERE CURRENT OF csr_all_rec_2001;
4001:
4002: END IF;

Line 4011: UPDATE pay_action_information pai

4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);
4009: IF rg_csr_all_rec_2001.action_information3='2001' THEN
4010: l_end_code:=l_end_code + 1 ;
4011: UPDATE pay_action_information pai
4012: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4013: WHERE CURRENT OF csr_all_rec_2001;
4014:
4015: --13063867

Line 4019: UPDATE pay_action_information pai

4015: --13063867
4016: FOR rg_csr_all_rec_2101 IN csr_all_rec_2101 ( p_payroll_action_id, rg_csr_all_rec_2001.action_information4 )
4017: LOOP
4018: l_end_code:=l_end_code + 1 ;
4019: UPDATE pay_action_information pai
4020: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4021: WHERE CURRENT OF csr_all_rec_2101;
4022: END LOOP;
4023: --13063867

Line 4033: UPDATE pay_action_information pai

4029: FOR rg_csr_all_rec_6000 IN csr_all_rec_6000(p_payroll_action_id,rg_csr_all_rec.action_information25,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8,rg_csr_all_rec_2001.action_information4)
4030: LOOP
4031: IF l_5000_updated='N' THEN
4032: l_end_code:=l_end_code + 1 ;
4033: UPDATE pay_action_information pai
4034: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4035: WHERE CURRENT OF csr_all_rec;
4036: l_5000_updated:='Y';
4037: END IF;

Line 4040: UPDATE pay_action_information pai

4036: l_5000_updated:='Y';
4037: END IF;
4038:
4039: l_end_code:=l_end_code + 1 ;
4040: UPDATE pay_action_information pai
4041: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4042: WHERE CURRENT OF csr_all_rec_6000;
4043: hr_utility.set_location('DEINIT:entered csr_all_rec_6000: ' || rg_csr_all_rec_6000.action_information4,390);
4044: /* bug 7613211 start*/

Line 4052: UPDATE pay_action_information pai

4048: FOR rg_csr_asg_8001 IN csr_asg_8001( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4049: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8)
4050: LOOP
4051: l_end_code:=l_end_code + 1 ;
4052: UPDATE pay_action_information pai
4053: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4054: WHERE CURRENT OF csr_asg_8001;
4055: fnd_file.put_line(fnd_file.log,'rg_csr_all_rec_6000.action_information7:'|| rg_csr_all_rec_6000.action_information7);
4056:

Line 4071: UPDATE pay_action_information pai

4067: FOR rg_csr_asg_all_rec IN csr_asg_all_rec( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4068: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8) /* 8847591 */
4069: LOOP
4070: l_end_code:=l_end_code + 1 ;
4071: UPDATE pay_action_information pai
4072: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4073: WHERE CURRENT OF csr_asg_all_rec;
4074: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
4075:

Line 4103: UPDATE pay_action_information pai

4099: fnd_file.put_line(fnd_file.log,'before time period id '|| rg_csr_all_rec.action_information24);
4100: IF l_5000R_updated='N' THEN
4101: fnd_file.put_line(fnd_file.log,'entered iff l_5000R_updated');
4102: l_end_code:=l_end_code + 1 ;
4103: UPDATE pay_action_information pai
4104: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4105: WHERE pai.action_information3 = '5000R'
4106: AND pai.action_information2= to_char(p_payroll_action_id)
4107: AND pai.action_information9=rg_csr_all_rec.action_information9

Line 4117: UPDATE pay_action_information pai

4113: l_5000R_updated:='Y';
4114: END IF; /* 9587046R */
4115: IF l_6000R_updated='N' THEN
4116: l_end_code:=l_end_code + 1 ;
4117: UPDATE pay_action_information pai
4118: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4119: WHERE pai.action_information3 = '6000R'
4120: AND pai.action_information2 = to_char(p_payroll_action_id)
4121: AND pai.action_information4 = to_char(rg_csr_all_rec_6000.action_information4)

Line 4133: UPDATE pay_action_information pai

4129: FOR rg_csr_asg_8001 IN csr_asg_8001R( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4130: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8)
4131: LOOP
4132: l_end_code:=l_end_code + 1 ;
4133: UPDATE pay_action_information pai
4134: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4135: WHERE CURRENT OF csr_asg_8001R;
4136: END LOOP;
4137:

Line 4141: UPDATE pay_action_information pai

4137:
4138: END IF;
4139: fnd_file.put_line(fnd_file.log,'l_5000R_updated'|| l_5000R_updated);
4140: l_end_code:=l_end_code + 1 ;
4141: UPDATE pay_action_information pai
4142: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4143: WHERE CURRENT OF csr_asg_all_rec_corr;
4144:
4145: IF (rg_csr_asg_all_rec.action_information6='0038' or rg_csr_asg_all_rec.action_information6='0036') and rg_csr_asg_all_rec.action_information3='6001' THEN /* 8616718 */

Line 4166: UPDATE pay_action_information pai

4162: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');
4163: /* 9001660 */
4164: IF l_foreign_flag='Y' THEN
4165: /*
4166: UPDATE pay_action_information pai
4167: SET pai.action_information9='09'
4168: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
4169: AND pai.action_information1 = 'PYDKEINA'
4170: AND pai.action_information2 = to_char(p_payroll_action_id)

Line 4183: /* UPDATE pay_action_information pai

4179: END IF;
4180: END IF;
4181: /* 8616718 */
4182: IF l_bincome_flag='Y' THEN
4183: /* UPDATE pay_action_information pai
4184: SET pai.action_information9='05'
4185: WHERE pai.action_information_category = 'EMEA REPORT INFORMATION'
4186: AND pai.action_information1 = 'PYDKEINA'
4187: AND pai.action_information2 = to_char(p_payroll_action_id)

Line 4197: pay_action_information_api.create_action_information (

4193: END IF;
4194: END IF;
4195:
4196:
4197: pay_action_information_api.create_action_information (
4198: p_action_information_id=> l_action_info_id,
4199: p_action_context_id=> p_payroll_action_id,
4200: p_action_context_type=> 'PA',
4201: p_object_version_number=> l_ovn,