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.PER_PERUSEOC_XMLP_PKG dependencies on HR_REPORTS

Line 946: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');

942:
943: FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2 IS
944: X0 VARCHAR2(2000);
945: BEGIN
946: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
947: STPROC.BIND_O(X0);
948: STPROC.BIND_I(P_BUDGET_ID);
949: STPROC.EXECUTE;
950: STPROC.RETRIEVE(1

Line 959: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');

955: FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
956: ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2 IS
957: X0 VARCHAR2(2000);
958: BEGIN
959: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
960: STPROC.BIND_O(X0);
961: STPROC.BIND_I(P_BUDGET_ID);
962: STPROC.BIND_I(P_BUDGET_VERSION_ID);
963: STPROC.EXECUTE;

Line 973: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');

969: PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
970: ,P_ORG_NAME OUT NOCOPY VARCHAR2
971: ,P_ORG_TYPE OUT NOCOPY VARCHAR2) IS
972: BEGIN
973: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');
974: STPROC.BIND_I(P_ORGANIZATION_ID);
975: STPROC.BIND_O(P_ORG_NAME);
976: STPROC.BIND_O(P_ORG_TYPE);
977: STPROC.EXECUTE;

Line 987: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');

983:
984: FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2 IS
985: X0 VARCHAR2(2000);
986: BEGIN
987: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
988: STPROC.BIND_O(X0);
989: STPROC.BIND_I(P_JOB_ID);
990: STPROC.EXECUTE;
991: STPROC.RETRIEVE(1

Line 999: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');

995:
996: FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2 IS
997: X0 VARCHAR2(2000);
998: BEGIN
999: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
1000: STPROC.BIND_O(X0);
1001: STPROC.BIND_I(P_POSITION_ID);
1002: STPROC.EXECUTE;
1003: STPROC.RETRIEVE(1

Line 1011: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');

1007:
1008: FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2 IS
1009: X0 VARCHAR2(2000);
1010: BEGIN
1011: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
1012: STPROC.BIND_O(X0);
1013: STPROC.BIND_I(P_GRADE_ID);
1014: STPROC.EXECUTE;
1015: STPROC.RETRIEVE(1

Line 1025: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');

1021: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
1022: ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1023: X0 VARCHAR2(2000);
1024: BEGIN
1025: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');
1026: STPROC.BIND_O(X0);
1027: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1028: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);
1029: STPROC.BIND_I(P_LEGISLATION_CODE);

Line 1039: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');

1035:
1036: FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1037: X0 VARCHAR2(2000);
1038: BEGIN
1039: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
1040: STPROC.BIND_O(X0);
1041: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
1042: STPROC.EXECUTE;
1043: STPROC.RETRIEVE(1

Line 1053: /*STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');

1049: ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
1050: ,P_START_DATE OUT NOCOPY DATE
1051: ,P_END_DATE OUT NOCOPY DATE) IS
1052: BEGIN
1053: /*STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');
1054: STPROC.BIND_I(P_TIME_PERIOD_ID);
1055: STPROC.BIND_O(P_PERIOD_NAME);
1056: STPROC.BIND_O(P_START_DATE);
1057: STPROC.BIND_O(P_END_DATE);

Line 1070: X0:= HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);

1066:
1067: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1068: X0 VARCHAR2(2000);
1069: BEGIN
1070: X0:= HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1071: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1072: STPROC.BIND_O(X0);
1073: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1074: STPROC.EXECUTE;

Line 1071: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');

1067: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1068: X0 VARCHAR2(2000);
1069: BEGIN
1070: X0:= HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1071: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1072: STPROC.BIND_O(X0);
1073: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1074: STPROC.EXECUTE;
1075: STPROC.RETRIEVE(1

Line 1084: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');

1080: FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
1081: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
1082: X0 NUMBER;
1083: BEGIN
1084: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');
1085: STPROC.BIND_O(X0);
1086: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1087: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);
1088: STPROC.EXECUTE;

Line 1098: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');

1094: FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
1095: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
1096: X0 NUMBER;
1097: BEGIN
1098: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');
1099: STPROC.BIND_O(X0);
1100: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1101: STPROC.BIND_I(P_PARENT_POSITION_ID);
1102: STPROC.EXECUTE;

Line 1115: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID,

1111: ,P_ORG_VERSION OUT NOCOPY NUMBER
1112: ,P_VERSION_START_DATE OUT NOCOPY DATE
1113: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1114: BEGIN
1115: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID,
1116: :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE,
1117: :P_VERSION_END_DATE); end;');
1118: STPROC.BIND_I(P_ORGANIZATION_STRUCTURE_ID);
1119: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);

Line 1142: /*STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME,

1138: ,P_POS_VERSION OUT NOCOPY NUMBER
1139: ,P_VERSION_START_DATE OUT NOCOPY DATE
1140: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1141: BEGIN
1142: /*STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME,
1143: :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
1144: STPROC.BIND_I(P_POSITION_STRUCTURE_ID);
1145: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1146: STPROC.BIND_O(P_POS_STRUCTURE_NAME);

Line 1165: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');

1161: FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
1162: ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1163: X0 VARCHAR2(2000);
1164: BEGIN
1165: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
1166: STPROC.BIND_O(X0);
1167: STPROC.BIND_I(P_LOOKUP_TYPE);
1168: STPROC.BIND_I(P_LOOKUP_CODE);
1169: STPROC.EXECUTE;

Line 1183: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID,

1179: ,P_NO_OF_ESSENTIAL IN NUMBER
1180: ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN IS
1181: X0 BOOLEAN;
1182: BEGIN
1183: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID,
1184: :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
1185: STPROC.BIND_I(P_PERSON_ID);
1186: STPROC.BIND_I(P_JOB_POSITION_ID);
1187: STPROC.BIND_I(P_JOB_POSITION_TYPE);

Line 1202: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');

1198: FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
1199: ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2 IS
1200: X0 VARCHAR2(2000);
1201: BEGIN
1202: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');
1203: STPROC.BIND_O(X0);
1204: STPROC.BIND_I(P_SESSION_DATE);
1205: STPROC.BIND_I(P_PAYROLL_ID);
1206: STPROC.EXECUTE;

Line 1216: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');

1212: FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
1213: ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1214: X0 VARCHAR2(2000);
1215: BEGIN
1216: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');
1217: STPROC.BIND_O(X0);
1218: STPROC.BIND_I(P_SESSION_DATE);
1219: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
1220: STPROC.EXECUTE;

Line 1230: /*STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');

1226: PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
1227: ,P_ID_FLEX_NUM IN NUMBER
1228: ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2) IS
1229: BEGIN
1230: /*STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');
1231: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
1232: STPROC.BIND_I(P_ID_FLEX_NUM);
1233: STPROC.BIND_IO(P_MATCHING_LEXICAL);
1234: STPROC.EXECUTE;

Line 1273: /*STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,

1269: ,P_VALUE28 OUT NOCOPY VARCHAR2
1270: ,P_VALUE29 OUT NOCOPY VARCHAR2
1271: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1272: BEGIN
1273: /*STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,
1274: :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13,
1275: :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24,
1276: :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1277: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);

Line 1409: /*STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,

1405: ,P_VALUE28 OUT NOCOPY VARCHAR2
1406: ,P_VALUE29 OUT NOCOPY VARCHAR2
1407: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1408: BEGIN
1409: /*STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,
1410: :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13,
1411: :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24,
1412: :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1413: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);

Line 1518: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR,

1514: ,P_TITLE OUT NOCOPY VARCHAR2
1515: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1516: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1517: BEGIN
1518: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR,
1519: :P_COLUMN_EXPR); end;');
1520: STPROC.BIND_I(P_APPL_SHORT_NAME);
1521: STPROC.BIND_I(P_DESC_FLEX_NAME);
1522: STPROC.BIND_I(P_TABLE_ALIAS);

Line 1542: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR,

1538: ,P_TITLE OUT NOCOPY VARCHAR2
1539: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1540: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1541: BEGIN
1542: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR,
1543: :P_COLUMN_EXPR); end;');
1544: STPROC.BIND_I(P_APPL_SHORT_NAME);
1545: STPROC.BIND_I(P_DESC_FLEX_NAME);
1546: STPROC.BIND_I(P_TABLE_ALIAS);

Line 1567: /*STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS,

1563: ,P_TITLE OUT NOCOPY VARCHAR2
1564: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1565: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1566: BEGIN
1567: /*STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS,
1568: :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1569: STPROC.BIND_I(P_APPL_SHORT_NAME);
1570: STPROC.BIND_I(P_DESC_FLEX_NAME);
1571: STPROC.BIND_I(P_DESC_FLEX_CONTEXT);

Line 1589: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');

1585: FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
1586: ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
1587: X0 VARCHAR2(2000);
1588: BEGIN
1589: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');
1590: STPROC.BIND_O(X0);
1591: STPROC.BIND_I(P_SESSION_DATE);
1592: STPROC.BIND_I(P_PERSON_ID);
1593: STPROC.EXECUTE;