APPS.PAY_PAYCABPS_XMLP_PKG dependencies on HR_REPORTS

Line 879: X0 := HR_REPORTS.GET_BUDGET(P_BUDGET_ID);

875: /* FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN CHAR IS
876: X0 CHAR(2000);
877: BEGIN
878:
879: X0 := HR_REPORTS.GET_BUDGET(P_BUDGET_ID);
880:
881: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
882: STPROC.BIND_O(X0);
883: STPROC.BIND_I(P_BUDGET_ID);

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

877: BEGIN
878:
879: X0 := HR_REPORTS.GET_BUDGET(P_BUDGET_ID);
880:
881: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
882: STPROC.BIND_O(X0);
883: STPROC.BIND_I(P_BUDGET_ID);
884: STPROC.EXECUTE;
885: STPROC.RETRIEVE(1

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

891: ,P_BUDGET_VERSION_ID IN NUMBER) RETURN CHAR IS
892: X0 CHAR(2000);
893: BEGIN
894:
895: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
896:
897: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
898: STPROC.BIND_O(X0);
899: STPROC.BIND_I(P_BUDGET_ID);

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

893: BEGIN
894:
895: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
896:
897: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
898: STPROC.BIND_O(X0);
899: STPROC.BIND_I(P_BUDGET_ID);
900: STPROC.BIND_I(P_BUDGET_VERSION_ID);
901: STPROC.EXECUTE;

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

909: ,P_ORG_TYPE OUT NOCOPY CHAR) IS
910: BEGIN
911:
912:
913: STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');
914: STPROC.BIND_I(P_ORGANIZATION_ID);
915: STPROC.BIND_O(P_ORG_NAME);
916: STPROC.BIND_O(P_ORG_TYPE);
917: STPROC.EXECUTE;

Line 927: X0 := HR_REPORTS.GET_JOB(P_JOB_ID);

923:
924: /* FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN CHAR IS
925: X0 CHAR(2000);
926: BEGIN
927: X0 := HR_REPORTS.GET_JOB(P_JOB_ID);
928:
929: STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
930: STPROC.BIND_O(X0);
931: STPROC.BIND_I(P_JOB_ID);

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

925: X0 CHAR(2000);
926: BEGIN
927: X0 := HR_REPORTS.GET_JOB(P_JOB_ID);
928:
929: STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
930: STPROC.BIND_O(X0);
931: STPROC.BIND_I(P_JOB_ID);
932: STPROC.EXECUTE;
933: STPROC.RETRIEVE(1

Line 942: X0 := HR_REPORTS.GET_POSITION(P_POSITION_ID);

938: /* FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN CHAR IS
939: X0 CHAR(2000);
940: BEGIN
941:
942: X0 := HR_REPORTS.GET_POSITION(P_POSITION_ID);
943:
944: STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
945: STPROC.BIND_O(X0);
946: STPROC.BIND_I(P_POSITION_ID);

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

940: BEGIN
941:
942: X0 := HR_REPORTS.GET_POSITION(P_POSITION_ID);
943:
944: STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
945: STPROC.BIND_O(X0);
946: STPROC.BIND_I(P_POSITION_ID);
947: STPROC.EXECUTE;
948: STPROC.RETRIEVE(1

Line 956: X0 := HR_REPORTS.GET_GRADE(P_GRADE_ID);

952:
953: /* FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN CHAR IS
954: X0 CHAR(2000);
955: BEGIN
956: X0 := HR_REPORTS.GET_GRADE(P_GRADE_ID);
957:
958: STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
959: STPROC.BIND_O(X0);
960: STPROC.BIND_I(P_GRADE_ID);

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

954: X0 CHAR(2000);
955: BEGIN
956: X0 := HR_REPORTS.GET_GRADE(P_GRADE_ID);
957:
958: STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
959: STPROC.BIND_O(X0);
960: STPROC.BIND_I(P_GRADE_ID);
961: STPROC.EXECUTE;
962: STPROC.RETRIEVE(1

Line 973: X0 := HR_REPORTS.GET_STATUS(P_BUSINESS_GROUP_ID, P_ASSIGNMENT_STATUS_TYPE_ID, P_LEGISLATION_CODE);

969: ,P_LEGISLATION_CODE IN CHAR) RETURN CHAR IS
970: X0 CHAR(2000);
971: BEGIN
972:
973: X0 := HR_REPORTS.GET_STATUS(P_BUSINESS_GROUP_ID, P_ASSIGNMENT_STATUS_TYPE_ID, P_LEGISLATION_CODE);
974:
975: / STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');
976: STPROC.BIND_O(X0);
977: STPROC.BIND_I(P_BUSINESS_GROUP_ID);

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

971: BEGIN
972:
973: X0 := HR_REPORTS.GET_STATUS(P_BUSINESS_GROUP_ID, P_ASSIGNMENT_STATUS_TYPE_ID, P_LEGISLATION_CODE);
974:
975: / STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');
976: STPROC.BIND_O(X0);
977: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
978: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);
979: STPROC.BIND_I(P_LEGISLATION_CODE);

Line 990: X0 := HR_REPORTS.GET_ABS_TYPE(P_ABS_ATT_TYPE_ID);

986: /* FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN CHAR IS
987: X0 CHAR(2000);
988: BEGIN
989:
990: X0 := HR_REPORTS.GET_ABS_TYPE(P_ABS_ATT_TYPE_ID);
991: STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
992: STPROC.BIND_O(X0);
993: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
994: STPROC.EXECUTE;

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

987: X0 CHAR(2000);
988: BEGIN
989:
990: X0 := HR_REPORTS.GET_ABS_TYPE(P_ABS_ATT_TYPE_ID);
991: STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
992: STPROC.BIND_O(X0);
993: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
994: STPROC.EXECUTE;
995: STPROC.RETRIEVE(1

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

1001: ,P_PERIOD_NAME OUT NOCOPY CHAR
1002: ,P_START_DATE OUT NOCOPY DATE
1003: ,P_END_DATE OUT NOCOPY DATE) IS
1004: BEGIN
1005: STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');
1006: STPROC.BIND_I(P_TIME_PERIOD_ID);
1007: STPROC.BIND_O(P_PERIOD_NAME);
1008: STPROC.BIND_O(P_START_DATE);
1009: STPROC.BIND_O(P_END_DATE);

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

1018:
1019: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN CHAR IS
1020: X0 CHAR(2000);
1021: BEGIN
1022: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1023: /*
1024: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1025: STPROC.BIND_O(X0);
1026: STPROC.BIND_I(P_BUSINESS_GROUP_ID);

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

1020: X0 CHAR(2000);
1021: BEGIN
1022: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
1023: /*
1024: STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
1025: STPROC.BIND_O(X0);
1026: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
1027: STPROC.EXECUTE;
1028: STPROC.RETRIEVE(1

Line 1037: X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID, P_PARENT_ORGANIZATION_ID);

1033: /*FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
1034: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
1035: X0 NUMBER;
1036: BEGIN
1037: X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID, P_PARENT_ORGANIZATION_ID);
1038: STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');
1039: STPROC.BIND_O(X0);
1040: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1041: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);

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

1034: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
1035: X0 NUMBER;
1036: BEGIN
1037: X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID, P_PARENT_ORGANIZATION_ID);
1038: STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');
1039: STPROC.BIND_O(X0);
1040: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1041: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);
1042: STPROC.EXECUTE;

Line 1052: X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID, P_PARENT_POSITION_ID);

1048: /* FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
1049: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
1050: X0 NUMBER;
1051: BEGIN
1052: X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID, P_PARENT_POSITION_ID);
1053: STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');
1054: STPROC.BIND_O(X0);
1055: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1056: STPROC.BIND_I(P_PARENT_POSITION_ID);

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

1049: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
1050: X0 NUMBER;
1051: BEGIN
1052: X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID, P_PARENT_POSITION_ID);
1053: STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');
1054: STPROC.BIND_O(X0);
1055: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1056: STPROC.BIND_I(P_PARENT_POSITION_ID);
1057: STPROC.EXECUTE;

Line 1070: STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID, :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');

1066: ,P_ORG_VERSION OUT NOCOPY NUMBER
1067: ,P_VERSION_START_DATE OUT NOCOPY DATE
1068: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1069: BEGIN
1070: STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID, :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
1071: STPROC.BIND_I(P_ORGANIZATION_STRUCTURE_ID);
1072: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
1073: STPROC.BIND_O(P_ORG_STRUCTURE_NAME);
1074: STPROC.BIND_O(P_ORG_VERSION);

Line 1095: STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME, :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');

1091: ,P_POS_VERSION OUT NOCOPY NUMBER
1092: ,P_VERSION_START_DATE OUT NOCOPY DATE
1093: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
1094: BEGIN
1095: STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME, :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
1096: STPROC.BIND_I(P_POSITION_STRUCTURE_ID);
1097: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
1098: STPROC.BIND_O(P_POS_STRUCTURE_NAME);
1099: STPROC.BIND_O(P_POS_VERSION);

Line 1117: X0 := HR_REPORTS.GET_LOOKUP_MEANING(P_LOOKUP_TYPE, P_LOOKUP_CODE);

1113: /* FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN CHAR
1114: ,P_LOOKUP_CODE IN CHAR) RETURN CHAR IS
1115: X0 CHAR(2000);
1116: BEGIN
1117: X0 := HR_REPORTS.GET_LOOKUP_MEANING(P_LOOKUP_TYPE, P_LOOKUP_CODE);
1118:
1119: STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
1120: STPROC.BIND_O(X0);
1121: STPROC.BIND_I(P_LOOKUP_TYPE);

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

1115: X0 CHAR(2000);
1116: BEGIN
1117: X0 := HR_REPORTS.GET_LOOKUP_MEANING(P_LOOKUP_TYPE, P_LOOKUP_CODE);
1118:
1119: STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
1120: STPROC.BIND_O(X0);
1121: STPROC.BIND_I(P_LOOKUP_TYPE);
1122: STPROC.BIND_I(P_LOOKUP_CODE);
1123: STPROC.EXECUTE;

Line 1141: X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(P_PERSON_ID, P_JOB_POSITION_ID, P_JOB_POSITION_TYPE, P_MATCHING_LEVEL, P_NO_OF_ESSENTIAL, P_NO_OF_DESIRABLE);

1137: X0 BOOLEAN;
1138:
1139: BEGIN
1140:
1141: X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(P_PERSON_ID, P_JOB_POSITION_ID, P_JOB_POSITION_TYPE, P_MATCHING_LEVEL, P_NO_OF_ESSENTIAL, P_NO_OF_DESIRABLE);
1142: X0 := sys.diutil.bool_to_int(X0rv);
1143:
1144: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
1145: STPROC.BIND_I(P_PERSON_ID);

Line 1144: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

1140:
1141: X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(P_PERSON_ID, P_JOB_POSITION_ID, P_JOB_POSITION_TYPE, P_MATCHING_LEVEL, P_NO_OF_ESSENTIAL, P_NO_OF_DESIRABLE);
1142: X0 := sys.diutil.bool_to_int(X0rv);
1143:
1144: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
1145: STPROC.BIND_I(P_PERSON_ID);
1146: STPROC.BIND_I(P_JOB_POSITION_ID);
1147: STPROC.BIND_I(P_JOB_POSITION_TYPE);
1148: STPROC.BIND_I(P_MATCHING_LEVEL);

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

1158: /* FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
1159: ,P_PAYROLL_ID IN NUMBER) RETURN CHAR IS
1160: X0 CHAR(2000);
1161: BEGIN
1162: STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');
1163: STPROC.BIND_O(X0);
1164: STPROC.BIND_I(P_SESSION_DATE);
1165: STPROC.BIND_I(P_PAYROLL_ID);
1166: STPROC.EXECUTE;

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

1172: /* FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
1173: ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN CHAR IS
1174: X0 CHAR(2000);
1175: BEGIN
1176: STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');
1177: STPROC.BIND_O(X0);
1178: STPROC.BIND_I(P_SESSION_DATE);
1179: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
1180: STPROC.EXECUTE;

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

1186: PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN CHAR
1187: ,P_ID_FLEX_NUM IN NUMBER
1188: ,P_MATCHING_LEXICAL IN OUT NOCOPY CHAR) IS
1189: BEGIN
1190: STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');
1191: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
1192: STPROC.BIND_I(P_ID_FLEX_NUM);
1193: STPROC.BIND_IO(P_MATCHING_LEXICAL);
1194: STPROC.EXECUTE;

Line 1233: STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED,

1229: ,P_VALUE28 OUT NOCOPY CHAR
1230: ,P_VALUE29 OUT NOCOPY CHAR
1231: ,P_VALUE30 OUT NOCOPY CHAR) IS
1232: BEGIN
1233: STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED,
1234: :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9,
1235: :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13, :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17,
1236: :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25,
1237: :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');

Line 1370: STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED,

1366: ,P_VALUE28 OUT NOCOPY CHAR
1367: ,P_VALUE29 OUT NOCOPY CHAR
1368: ,P_VALUE30 OUT NOCOPY CHAR) IS
1369: BEGIN
1370: STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED,
1371: :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9,
1372: :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13, :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17,
1373: :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25,
1374: :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');

Line 1480: STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');

1476: ,P_TITLE OUT NOCOPY CHAR
1477: ,P_LABEL_EXPR OUT NOCOPY CHAR
1478: ,P_COLUMN_EXPR OUT NOCOPY CHAR) IS
1479: BEGIN
1480: STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1481: STPROC.BIND_I(P_APPL_SHORT_NAME);
1482: STPROC.BIND_I(P_DESC_FLEX_NAME);
1483: STPROC.BIND_I(P_TABLE_ALIAS);
1484: STPROC.BIND_O(P_TITLE);

Line 1503: 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, :P_COLUMN_EXPR); end;');

1499: ,P_TITLE OUT NOCOPY CHAR
1500: ,P_LABEL_EXPR OUT NOCOPY CHAR
1501: ,P_COLUMN_EXPR OUT NOCOPY CHAR) IS
1502: BEGIN
1503: 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, :P_COLUMN_EXPR); end;');
1504: STPROC.BIND_I(P_APPL_SHORT_NAME);
1505: STPROC.BIND_I(P_DESC_FLEX_NAME);
1506: STPROC.BIND_I(P_TABLE_ALIAS);
1507: STPROC.BIND_O(P_TITLE);

Line 1527: STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');

1523: ,P_TITLE OUT NOCOPY CHAR
1524: ,P_LABEL_EXPR OUT NOCOPY CHAR
1525: ,P_COLUMN_EXPR OUT NOCOPY CHAR) IS
1526: BEGIN
1527: STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1528: STPROC.BIND_I(P_APPL_SHORT_NAME);
1529: STPROC.BIND_I(P_DESC_FLEX_NAME);
1530: STPROC.BIND_I(P_DESC_FLEX_CONTEXT);
1531: STPROC.BIND_I(P_TABLE_ALIAS);

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

1544: FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
1545: ,P_PERSON_ID IN NUMBER) RETURN CHAR IS
1546: X0 CHAR(2000);
1547: BEGIN
1548: STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');
1549: STPROC.BIND_O(X0);
1550: STPROC.BIND_I(P_SESSION_DATE);
1551: STPROC.BIND_I(P_PERSON_ID);
1552: STPROC.EXECUTE;