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_PAYRP940_XMLP_PKG dependencies on HR_US_REPORTS

Line 10: C_TAX_UNIT := HR_US_REPORTS.GET_ORG_NAME(P_TAX_UNIT_ID

6: C_GAZ_START_DATE := TO_DATE('01-01-' || P_TAX_YEAR
7: ,'DD-MM-YYYY');
8: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
9: IF P_TAX_UNIT_ID IS NOT NULL THEN
10: C_TAX_UNIT := HR_US_REPORTS.GET_ORG_NAME(P_TAX_UNIT_ID
11: ,P_BUSINESS_GROUP_ID);
12: END IF;
13: SELECT
14: DECODE(COUNT(PAA.ASSIGNMENT_ID)

Line 1343: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_SALARY(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_ID, :P_REPORT_DATE); end;');

1339: ,P_ASSIGNMENT_ID IN NUMBER
1340: ,P_REPORT_DATE IN DATE) RETURN NUMBER IS
1341: X0 NUMBER;
1342: BEGIN
1343: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_SALARY(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_ID, :P_REPORT_DATE); end;');
1344: STPROC.BIND_O(X0);
1345: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1346: STPROC.BIND_I(P_ASSIGNMENT_ID);
1347: STPROC.BIND_I(P_REPORT_DATE);

Line 1361: /* STPROC.INIT('begin HR_US_REPORTS.GET_NEW_HIRE_CONTACT(:P_PERSON_ID, :P_BUSINESS_GROUP_ID, :P_REPORT_DATE, :P_CONTACT_NAME, :P_CONTACT_TITLE, :P_CONTACT_PHONE); end;');

1357: ,P_CONTACT_NAME OUT NOCOPY VARCHAR2
1358: ,P_CONTACT_TITLE OUT NOCOPY VARCHAR2
1359: ,P_CONTACT_PHONE OUT NOCOPY VARCHAR2) IS
1360: BEGIN
1361: /* STPROC.INIT('begin HR_US_REPORTS.GET_NEW_HIRE_CONTACT(:P_PERSON_ID, :P_BUSINESS_GROUP_ID, :P_REPORT_DATE, :P_CONTACT_NAME, :P_CONTACT_TITLE, :P_CONTACT_PHONE); end;');
1362: STPROC.BIND_I(P_PERSON_ID);
1363: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1364: STPROC.BIND_I(P_REPORT_DATE);
1365: STPROC.BIND_O(P_CONTACT_NAME);

Line 1381: /*STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS(:P_LOCATION_ID, :P_ADDRESS); end;');

1377:
1378: PROCEDURE GET_ADDRESS(P_LOCATION_ID IN NUMBER
1379: ,P_ADDRESS OUT NOCOPY VARCHAR2) IS
1380: BEGIN
1381: /*STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS(:P_LOCATION_ID, :P_ADDRESS); end;');
1382: STPROC.BIND_I(P_LOCATION_ID);
1383: STPROC.BIND_O(P_ADDRESS);
1384: STPROC.EXECUTE;
1385: STPROC.RETRIEVE(2

Line 1392: /* STPROC.INIT('begin HR_US_REPORTS.GET_EMPLOYEE_ADDRESS(:P_PERSON_ID, :P_ADDRESS); end;');

1388:
1389: PROCEDURE GET_EMPLOYEE_ADDRESS(P_PERSON_ID IN NUMBER
1390: ,P_ADDRESS OUT NOCOPY VARCHAR2) IS
1391: BEGIN
1392: /* STPROC.INIT('begin HR_US_REPORTS.GET_EMPLOYEE_ADDRESS(:P_PERSON_ID, :P_ADDRESS); end;');
1393: STPROC.BIND_I(P_PERSON_ID);
1394: STPROC.BIND_O(P_ADDRESS);
1395: STPROC.EXECUTE;
1396: STPROC.RETRIEVE(2

Line 1403: /* STPROC.INIT('begin HR_US_REPORTS.GET_COUNTY_ADDRESS(:P_LOCATION_ID, :P_ADDRESS); end;');

1399:
1400: PROCEDURE GET_COUNTY_ADDRESS(P_LOCATION_ID IN NUMBER
1401: ,P_ADDRESS OUT NOCOPY VARCHAR2) IS
1402: BEGIN
1403: /* STPROC.INIT('begin HR_US_REPORTS.GET_COUNTY_ADDRESS(:P_LOCATION_ID, :P_ADDRESS); end;');
1404: STPROC.BIND_I(P_LOCATION_ID);
1405: STPROC.BIND_O(P_ADDRESS);
1406: STPROC.EXECUTE;
1407: STPROC.RETRIEVE(2

Line 1414: /* STPROC.INIT('begin HR_US_REPORTS.GET_ACTIVITY(:P_ESTABLISHMENT_ID, :P_ACTIVITY); end;');

1410:
1411: PROCEDURE GET_ACTIVITY(P_ESTABLISHMENT_ID IN NUMBER
1412: ,P_ACTIVITY OUT NOCOPY VARCHAR2) IS
1413: BEGIN
1414: /* STPROC.INIT('begin HR_US_REPORTS.GET_ACTIVITY(:P_ESTABLISHMENT_ID, :P_ACTIVITY); end;');
1415: STPROC.BIND_I(P_ESTABLISHMENT_ID);
1416: STPROC.BIND_O(P_ACTIVITY);
1417: STPROC.EXECUTE;
1418: STPROC.RETRIEVE(2

Line 1425: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_CONSOLIDATION_SET(:P_CONSOLIDATION_SET_ID); end;');

1421:
1422: FUNCTION GET_CONSOLIDATION_SET(P_CONSOLIDATION_SET_ID IN NUMBER) RETURN VARCHAR2 IS
1423: X0 VARCHAR2(2000);
1424: BEGIN
1425: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_CONSOLIDATION_SET(:P_CONSOLIDATION_SET_ID); end;');
1426: STPROC.BIND_O(X0);
1427: STPROC.BIND_I(P_CONSOLIDATION_SET_ID);
1428: STPROC.EXECUTE;
1429: STPROC.RETRIEVE(1

Line 1437: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PAYMENT_TYPE_NAME(:P_PAYMENT_TYPE_ID); end;');

1433:
1434: FUNCTION GET_PAYMENT_TYPE_NAME(P_PAYMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1435: X0 VARCHAR2(2000);
1436: BEGIN
1437: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PAYMENT_TYPE_NAME(:P_PAYMENT_TYPE_ID); end;');
1438: STPROC.BIND_O(X0);
1439: STPROC.BIND_I(P_PAYMENT_TYPE_ID);
1440: STPROC.EXECUTE;
1441: STPROC.RETRIEVE(1

Line 1449: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ELEMENT_TYPE_NAME(:P_ELEMENT_TYPE_ID); end;');

1445:
1446: FUNCTION GET_ELEMENT_TYPE_NAME(P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1447: X0 VARCHAR2(2000);
1448: BEGIN
1449: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ELEMENT_TYPE_NAME(:P_ELEMENT_TYPE_ID); end;');
1450: STPROC.BIND_O(X0);
1451: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
1452: STPROC.EXECUTE;
1453: STPROC.RETRIEVE(1

Line 1461: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_TAX_UNIT(:P_TAX_UNIT_ID); end;');

1457:
1458: FUNCTION GET_TAX_UNIT(P_TAX_UNIT_ID IN NUMBER) RETURN VARCHAR2 IS
1459: X0 VARCHAR2(2000);
1460: BEGIN
1461: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_TAX_UNIT(:P_TAX_UNIT_ID); end;');
1462: STPROC.BIND_O(X0);
1463: STPROC.BIND_I(P_TAX_UNIT_ID);
1464: STPROC.EXECUTE;
1465: STPROC.RETRIEVE(1

Line 1473: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PERSON_NAME(:P_PERSON_ID); end;');

1469:
1470: FUNCTION GET_PERSON_NAME(P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
1471: X0 VARCHAR2(2000);
1472: BEGIN
1473: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PERSON_NAME(:P_PERSON_ID); end;');
1474: STPROC.BIND_O(X0);
1475: STPROC.BIND_I(P_PERSON_ID);
1476: STPROC.EXECUTE;
1477: STPROC.RETRIEVE(1

Line 1485: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PAYROLL_ACTION(:P_PAYROLL_ACTION_ID); end;');

1481:
1482: FUNCTION GET_PAYROLL_ACTION(P_PAYROLL_ACTION_ID IN NUMBER) RETURN VARCHAR2 IS
1483: X0 VARCHAR2(2000);
1484: BEGIN
1485: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_PAYROLL_ACTION(:P_PAYROLL_ACTION_ID); end;');
1486: STPROC.BIND_O(X0);
1487: STPROC.BIND_I(P_PAYROLL_ACTION_ID);
1488: STPROC.EXECUTE;
1489: STPROC.RETRIEVE(1

Line 1497: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_LEGISLATION_CODE(:P_BUSINESS_GROUP_ID); end;');

1493:
1494: FUNCTION GET_LEGISLATION_CODE(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1495: X0 VARCHAR2(2000);
1496: BEGIN
1497: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_LEGISLATION_CODE(:P_BUSINESS_GROUP_ID); end;');
1498: STPROC.BIND_O(X0);
1499: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1500: STPROC.EXECUTE;
1501: STPROC.RETRIEVE(1

Line 1511: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_DEFINED_BALANCE_ID(:P_BALANCE_NAME, :P_DIMENSION_SUFFIX, :P_BUSINESS_GROUP_ID); end;');

1507: ,P_DIMENSION_SUFFIX IN VARCHAR2
1508: ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER IS
1509: X0 NUMBER;
1510: BEGIN
1511: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_DEFINED_BALANCE_ID(:P_BALANCE_NAME, :P_DIMENSION_SUFFIX, :P_BUSINESS_GROUP_ID); end;');
1512: STPROC.BIND_O(X0);
1513: STPROC.BIND_I(P_BALANCE_NAME);
1514: STPROC.BIND_I(P_DIMENSION_SUFFIX);
1515: STPROC.BIND_I(P_BUSINESS_GROUP_ID);

Line 1526: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_STARTUP_DEFINED_BALANCE(:P_REPORTING_NAME, :P_DIMENSION_SUFFIX); end;');

1522: FUNCTION GET_STARTUP_DEFINED_BALANCE(P_REPORTING_NAME IN VARCHAR2
1523: ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER IS
1524: X0 NUMBER;
1525: BEGIN
1526: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_STARTUP_DEFINED_BALANCE(:P_REPORTING_NAME, :P_DIMENSION_SUFFIX); end;');
1527: STPROC.BIND_O(X0);
1528: STPROC.BIND_I(P_REPORTING_NAME);
1529: STPROC.BIND_I(P_DIMENSION_SUFFIX);
1530: STPROC.EXECUTE;

Line 1540: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_DEFINED_BALANCE_BY_TYPE(:P_BOX_NUM, :P_DIMENSION_SUFFIX); end;');

1536: FUNCTION GET_DEFINED_BALANCE_BY_TYPE(P_BOX_NUM IN VARCHAR2
1537: ,P_DIMENSION_SUFFIX IN VARCHAR2) RETURN NUMBER IS
1538: X0 NUMBER;
1539: BEGIN
1540: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_DEFINED_BALANCE_BY_TYPE(:P_BOX_NUM, :P_DIMENSION_SUFFIX); end;');
1541: STPROC.BIND_O(X0);
1542: STPROC.BIND_I(P_BOX_NUM);
1543: STPROC.BIND_I(P_DIMENSION_SUFFIX);
1544: STPROC.EXECUTE;

Line 1555: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_BEN_CLASS_NAME(:P_SESSION_DATE, :P_BENEFIT_CLASSIFICATION_ID); end;');

1551: FUNCTION GET_BEN_CLASS_NAME(P_SESSION_DATE IN DATE
1552: ,P_BENEFIT_CLASSIFICATION_ID IN NUMBER) RETURN VARCHAR2 IS
1553: X0 VARCHAR2(2000);
1554: BEGIN
1555: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_BEN_CLASS_NAME(:P_SESSION_DATE, :P_BENEFIT_CLASSIFICATION_ID); end;');
1556: STPROC.BIND_O(X0);
1557: STPROC.BIND_I(P_SESSION_DATE);
1558: STPROC.BIND_I(P_BENEFIT_CLASSIFICATION_ID);
1559: STPROC.EXECUTE;

Line 1569: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_COBRA_QUALIFYING_EVENT(:P_QUALIFYING_EVENT); end;');

1565:
1566: FUNCTION GET_COBRA_QUALIFYING_EVENT(P_QUALIFYING_EVENT IN VARCHAR2) RETURN VARCHAR2 IS
1567: X0 VARCHAR2(2000);
1568: BEGIN
1569: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_COBRA_QUALIFYING_EVENT(:P_QUALIFYING_EVENT); end;');
1570: STPROC.BIND_O(X0);
1571: STPROC.BIND_I(P_QUALIFYING_EVENT);
1572: STPROC.EXECUTE;
1573: STPROC.RETRIEVE(1

Line 1582: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_COBRA_STATUS(:P_COBRA_STATUS); end;');

1578:
1579: FUNCTION GET_COBRA_STATUS(P_COBRA_STATUS IN VARCHAR2) RETURN VARCHAR2 IS
1580: X0 VARCHAR2(2000);
1581: BEGIN
1582: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_COBRA_STATUS(:P_COBRA_STATUS); end;');
1583: STPROC.BIND_O(X0);
1584: STPROC.BIND_I(P_COBRA_STATUS);
1585: STPROC.EXECUTE;
1586: STPROC.RETRIEVE(1

Line 1596: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_EST_TAX_UNIT(:P_STARTING_ORG_ID, :P_ORG_STRUCTURE_VERSION_ID); end;');

1592: FUNCTION GET_EST_TAX_UNIT(P_STARTING_ORG_ID IN NUMBER
1593: ,P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN NUMBER IS
1594: X0 NUMBER;
1595: BEGIN
1596: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_EST_TAX_UNIT(:P_STARTING_ORG_ID, :P_ORG_STRUCTURE_VERSION_ID); end;');
1597: STPROC.BIND_O(X0);
1598: STPROC.BIND_I(P_STARTING_ORG_ID);
1599: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1600: STPROC.EXECUTE;

Line 1610: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ORG_HIERARCHY_NAME(:P_ORG_STRUCTURE_VERSION_ID); end;');

1606:
1607: FUNCTION GET_ORG_HIERARCHY_NAME(P_ORG_STRUCTURE_VERSION_ID IN NUMBER) RETURN VARCHAR2 IS
1608: X0 VARCHAR2(2000);
1609: BEGIN
1610: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ORG_HIERARCHY_NAME(:P_ORG_STRUCTURE_VERSION_ID); end;');
1611: STPROC.BIND_O(X0);
1612: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1613: STPROC.EXECUTE;
1614: STPROC.RETRIEVE(1

Line 1623: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_STATE_NAME(:P_STATE_CODE); end;');

1619:
1620: FUNCTION GET_STATE_NAME(P_STATE_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1621: X0 VARCHAR2(2000);
1622: BEGIN
1623: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_STATE_NAME(:P_STATE_CODE); end;');
1624: STPROC.BIND_O(X0);
1625: STPROC.BIND_I(P_STATE_CODE);
1626: STPROC.EXECUTE;
1627: STPROC.RETRIEVE(1

Line 1637: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ORG_NAME(:P_ORGANIZATION_ID, :P_BUSINESS_GROUP_ID); end;');

1633: FUNCTION GET_ORG_NAME(P_ORGANIZATION_ID IN NUMBER
1634: ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1635: X0 VARCHAR2(2000);
1636: BEGIN
1637: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_ORG_NAME(:P_ORGANIZATION_ID, :P_BUSINESS_GROUP_ID); end;');
1638: STPROC.BIND_O(X0);
1639: STPROC.BIND_I(P_ORGANIZATION_ID);
1640: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1641: STPROC.EXECUTE;

Line 1651: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_CAREER_PATH_NAME(:P_CAREER_PATH_ID, :P_BUSINESS_GROUP_ID); end;');

1647: FUNCTION GET_CAREER_PATH_NAME(P_CAREER_PATH_ID IN NUMBER
1648: ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1649: X0 VARCHAR2(2000);
1650: BEGIN
1651: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_CAREER_PATH_NAME(:P_CAREER_PATH_ID, :P_BUSINESS_GROUP_ID); end;');
1652: STPROC.BIND_O(X0);
1653: STPROC.BIND_I(P_CAREER_PATH_ID);
1654: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1655: STPROC.EXECUTE;

Line 1665: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_AAP_ORG_ID(:P_AAP_NAME, :P_BUSINESS_GROUP_ID); end;');

1661: FUNCTION GET_AAP_ORG_ID(P_AAP_NAME IN VARCHAR2
1662: ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN NUMBER IS
1663: X0 NUMBER;
1664: BEGIN
1665: /* STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_AAP_ORG_ID(:P_AAP_NAME, :P_BUSINESS_GROUP_ID); end;');
1666: STPROC.BIND_O(X0);
1667: STPROC.BIND_I(P_AAP_NAME);
1668: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1669: STPROC.EXECUTE;

Line 1678: /* STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS_31(:P_LOCATION_ID, :P_ADDRESS); end;');

1674:
1675: PROCEDURE GET_ADDRESS_31(P_LOCATION_ID IN NUMBER
1676: ,P_ADDRESS OUT NOCOPY VARCHAR2) IS
1677: BEGIN
1678: /* STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS_31(:P_LOCATION_ID, :P_ADDRESS); end;');
1679: STPROC.BIND_I(P_LOCATION_ID);
1680: STPROC.BIND_O(P_ADDRESS);
1681: STPROC.EXECUTE;
1682: STPROC.RETRIEVE(2

Line 1689: /*STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_LOCATION_CODE(:P_LOCATION_ID); end;');

1685:
1686: FUNCTION GET_LOCATION_CODE(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2 IS
1687: X0 VARCHAR2(2000);
1688: BEGIN
1689: /*STPROC.INIT('begin :X0 := HR_US_REPORTS.GET_LOCATION_CODE(:P_LOCATION_ID); end;');
1690: STPROC.BIND_O(X0);
1691: STPROC.BIND_I(P_LOCATION_ID);
1692: STPROC.EXECUTE;
1693: STPROC.RETRIEVE(1

Line 1704: /* STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS_3LINES(:P_PERSON_ID, :P_EFFECTIVE_DATE, :P_ADDR_LINE1, :P_ADDR_LINE2, :P_CITY_STATE_ZIP); end;');

1700: ,P_ADDR_LINE1 OUT NOCOPY VARCHAR2
1701: ,P_ADDR_LINE2 OUT NOCOPY VARCHAR2
1702: ,P_CITY_STATE_ZIP OUT NOCOPY VARCHAR2) IS
1703: BEGIN
1704: /* STPROC.INIT('begin HR_US_REPORTS.GET_ADDRESS_3LINES(:P_PERSON_ID, :P_EFFECTIVE_DATE, :P_ADDR_LINE1, :P_ADDR_LINE2, :P_CITY_STATE_ZIP); end;');
1705: STPROC.BIND_I(P_PERSON_ID);
1706: STPROC.BIND_I(P_EFFECTIVE_DATE);
1707: STPROC.BIND_O(P_ADDR_LINE1);
1708: STPROC.BIND_O(P_ADDR_LINE2);