DBA Data[Home] [Help]

APPS.PER_PERUSEOC_XMLP_PKG dependencies on HR_REPORTS

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

991:
992: FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2 IS
993: X0 VARCHAR2(2000);
994: BEGIN
995: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
996: STPROC.BIND_O(X0);
997: STPROC.BIND_I(P_BUDGET_ID);
998: STPROC.EXECUTE;
999: STPROC.RETRIEVE(1

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

1004: FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
1005: ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2 IS
1006: X0 VARCHAR2(2000);
1007: BEGIN
1008: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
1009: STPROC.BIND_O(X0);
1010: STPROC.BIND_I(P_BUDGET_ID);
1011: STPROC.BIND_I(P_BUDGET_VERSION_ID);
1012: STPROC.EXECUTE;

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

1018: PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
1019: ,P_ORG_NAME OUT NOCOPY VARCHAR2
1020: ,P_ORG_TYPE OUT NOCOPY VARCHAR2) IS
1021: BEGIN
1022: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');
1023: STPROC.BIND_I(P_ORGANIZATION_ID);
1024: STPROC.BIND_O(P_ORG_NAME);
1025: STPROC.BIND_O(P_ORG_TYPE);
1026: STPROC.EXECUTE;

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

1032:
1033: FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2 IS
1034: X0 VARCHAR2(2000);
1035: BEGIN
1036: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
1037: STPROC.BIND_O(X0);
1038: STPROC.BIND_I(P_JOB_ID);
1039: STPROC.EXECUTE;
1040: STPROC.RETRIEVE(1

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

1044:
1045: FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2 IS
1046: X0 VARCHAR2(2000);
1047: BEGIN
1048: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
1049: STPROC.BIND_O(X0);
1050: STPROC.BIND_I(P_POSITION_ID);
1051: STPROC.EXECUTE;
1052: STPROC.RETRIEVE(1

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

1056:
1057: FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2 IS
1058: X0 VARCHAR2(2000);
1059: BEGIN
1060: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
1061: STPROC.BIND_O(X0);
1062: STPROC.BIND_I(P_GRADE_ID);
1063: STPROC.EXECUTE;
1064: STPROC.RETRIEVE(1

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

1070: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
1071: ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1072: X0 VARCHAR2(2000);
1073: BEGIN
1074: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');
1075: STPROC.BIND_O(X0);
1076: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1077: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);
1078: STPROC.BIND_I(P_LEGISLATION_CODE);

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

1084:
1085: FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1086: X0 VARCHAR2(2000);
1087: BEGIN
1088: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
1089: STPROC.BIND_O(X0);
1090: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
1091: STPROC.EXECUTE;
1092: STPROC.RETRIEVE(1

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

1098: ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
1099: ,P_START_DATE OUT NOCOPY DATE
1100: ,P_END_DATE OUT NOCOPY DATE) IS
1101: BEGIN
1102: /*STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');
1103: STPROC.BIND_I(P_TIME_PERIOD_ID);
1104: STPROC.BIND_O(P_PERIOD_NAME);
1105: STPROC.BIND_O(P_START_DATE);
1106: STPROC.BIND_O(P_END_DATE);

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

1115:
1116: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1117: X0 VARCHAR2(2000);
1118: BEGIN
1119: X0:= HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1120: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1121: STPROC.BIND_O(X0);
1122: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1123: STPROC.EXECUTE;

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

1116: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
1117: X0 VARCHAR2(2000);
1118: BEGIN
1119: X0:= HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1120: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1121: STPROC.BIND_O(X0);
1122: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1123: STPROC.EXECUTE;
1124: STPROC.RETRIEVE(1

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

1129: FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
1130: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
1131: X0 NUMBER;
1132: BEGIN
1133: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');
1134: STPROC.BIND_O(X0);
1135: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1136: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);
1137: STPROC.EXECUTE;

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

1143: FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
1144: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
1145: X0 NUMBER;
1146: BEGIN
1147: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');
1148: STPROC.BIND_O(X0);
1149: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1150: STPROC.BIND_I(P_PARENT_POSITION_ID);
1151: STPROC.EXECUTE;

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

1160: ,P_ORG_VERSION OUT NOCOPY NUMBER
1161: ,P_VERSION_START_DATE OUT NOCOPY DATE
1162: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1163: BEGIN
1164: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID,
1165: :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE,
1166: :P_VERSION_END_DATE); end;');
1167: STPROC.BIND_I(P_ORGANIZATION_STRUCTURE_ID);
1168: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);

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

1187: ,P_POS_VERSION OUT NOCOPY NUMBER
1188: ,P_VERSION_START_DATE OUT NOCOPY DATE
1189: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1190: BEGIN
1191: /*STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME,
1192: :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
1193: STPROC.BIND_I(P_POSITION_STRUCTURE_ID);
1194: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1195: STPROC.BIND_O(P_POS_STRUCTURE_NAME);

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

1210: FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
1211: ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1212: X0 VARCHAR2(2000);
1213: BEGIN
1214: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
1215: STPROC.BIND_O(X0);
1216: STPROC.BIND_I(P_LOOKUP_TYPE);
1217: STPROC.BIND_I(P_LOOKUP_CODE);
1218: STPROC.EXECUTE;

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

1228: ,P_NO_OF_ESSENTIAL IN NUMBER
1229: ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN IS
1230: X0 BOOLEAN;
1231: BEGIN
1232: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID,
1233: :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
1234: STPROC.BIND_I(P_PERSON_ID);
1235: STPROC.BIND_I(P_JOB_POSITION_ID);
1236: STPROC.BIND_I(P_JOB_POSITION_TYPE);

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

1247: FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
1248: ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2 IS
1249: X0 VARCHAR2(2000);
1250: BEGIN
1251: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');
1252: STPROC.BIND_O(X0);
1253: STPROC.BIND_I(P_SESSION_DATE);
1254: STPROC.BIND_I(P_PAYROLL_ID);
1255: STPROC.EXECUTE;

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

1261: FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
1262: ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
1263: X0 VARCHAR2(2000);
1264: BEGIN
1265: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');
1266: STPROC.BIND_O(X0);
1267: STPROC.BIND_I(P_SESSION_DATE);
1268: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
1269: STPROC.EXECUTE;

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

1275: PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
1276: ,P_ID_FLEX_NUM IN NUMBER
1277: ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2) IS
1278: BEGIN
1279: /*STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');
1280: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
1281: STPROC.BIND_I(P_ID_FLEX_NUM);
1282: STPROC.BIND_IO(P_MATCHING_LEXICAL);
1283: STPROC.EXECUTE;

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

1318: ,P_VALUE28 OUT NOCOPY VARCHAR2
1319: ,P_VALUE29 OUT NOCOPY VARCHAR2
1320: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1321: BEGIN
1322: /*STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,
1323: :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13,
1324: :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24,
1325: :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1326: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);

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

1454: ,P_VALUE28 OUT NOCOPY VARCHAR2
1455: ,P_VALUE29 OUT NOCOPY VARCHAR2
1456: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1457: BEGIN
1458: /*STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2,
1459: :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13,
1460: :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24,
1461: :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1462: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);

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

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_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR,
1568: :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_TABLE_ALIAS);

Line 1591: /*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,

1587: ,P_TITLE OUT NOCOPY VARCHAR2
1588: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1589: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1590: BEGIN
1591: /*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,
1592: :P_COLUMN_EXPR); end;');
1593: STPROC.BIND_I(P_APPL_SHORT_NAME);
1594: STPROC.BIND_I(P_DESC_FLEX_NAME);
1595: STPROC.BIND_I(P_TABLE_ALIAS);

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

1612: ,P_TITLE OUT NOCOPY VARCHAR2
1613: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1614: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1615: BEGIN
1616: /*STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS,
1617: :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1618: STPROC.BIND_I(P_APPL_SHORT_NAME);
1619: STPROC.BIND_I(P_DESC_FLEX_NAME);
1620: STPROC.BIND_I(P_DESC_FLEX_CONTEXT);

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

1634: FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
1635: ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
1636: X0 VARCHAR2(2000);
1637: BEGIN
1638: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');
1639: STPROC.BIND_O(X0);
1640: STPROC.BIND_I(P_SESSION_DATE);
1641: STPROC.BIND_I(P_PERSON_ID);
1642: STPROC.EXECUTE;