DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on FND_FLEX_EXT

Line 1108: /* STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_DELIMITER(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER); end;');

1104: ,KEY_FLEX_CODE IN VARCHAR2
1105: ,STRUCTURE_NUMBER IN NUMBER) RETURN VARCHAR2 IS
1106: X0 VARCHAR2(2000);
1107: BEGIN
1108: /* STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_DELIMITER(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER); end;');
1109: STPROC.BIND_O(X0);
1110: STPROC.BIND_I(APPLICATION_SHORT_NAME);
1111: STPROC.BIND_I(KEY_FLEX_CODE);
1112: STPROC.BIND_I(STRUCTURE_NUMBER);

Line 1116: X0 := FND_FLEX_EXT.GET_DELIMITER(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER);

1112: STPROC.BIND_I(STRUCTURE_NUMBER);
1113: STPROC.EXECUTE;
1114: STPROC.RETRIEVE(1
1115: ,X0);*/
1116: X0 := FND_FLEX_EXT.GET_DELIMITER(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER);
1117: RETURN X0;
1118: END GET_DELIMITER;
1119:
1120: FUNCTION GET_CCID(APPLICATION_SHORT_NAME IN VARCHAR2

Line 1127: /*STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_CCID(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER, :VALIDATION_DATE, :CONCATENATED_SEGMENTS); end;');

1123: ,VALIDATION_DATE IN VARCHAR2
1124: ,CONCATENATED_SEGMENTS IN VARCHAR2) RETURN NUMBER IS
1125: X0 NUMBER;
1126: BEGIN
1127: /*STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_CCID(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER, :VALIDATION_DATE, :CONCATENATED_SEGMENTS); end;');
1128: STPROC.BIND_O(X0);
1129: STPROC.BIND_I(APPLICATION_SHORT_NAME);
1130: STPROC.BIND_I(KEY_FLEX_CODE);
1131: STPROC.BIND_I(STRUCTURE_NUMBER);

Line 1137: X0 := FND_FLEX_EXT.GET_CCID(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER, VALIDATION_DATE, CONCATENATED_SEGMENTS);

1133: STPROC.BIND_I(CONCATENATED_SEGMENTS);
1134: STPROC.EXECUTE;
1135: STPROC.RETRIEVE(1
1136: ,X0);*/
1137: X0 := FND_FLEX_EXT.GET_CCID(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER, VALIDATION_DATE, CONCATENATED_SEGMENTS);
1138: RETURN X0;
1139: END GET_CCID;
1140:
1141: FUNCTION GET_SEGS(APPLICATION_SHORT_NAME IN VARCHAR2

Line 1147: /* STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_SEGS(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER, :COMBINATION_ID); end;');

1143: ,STRUCTURE_NUMBER IN NUMBER
1144: ,COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
1145: X0 VARCHAR2(2000);
1146: BEGIN
1147: /* STPROC.INIT('begin :X0 := FND_FLEX_EXT.GET_SEGS(:APPLICATION_SHORT_NAME, :KEY_FLEX_CODE, :STRUCTURE_NUMBER, :COMBINATION_ID); end;');
1148: STPROC.BIND_O(X0);
1149: STPROC.BIND_I(APPLICATION_SHORT_NAME);
1150: STPROC.BIND_I(KEY_FLEX_CODE);
1151: STPROC.BIND_I(STRUCTURE_NUMBER);

Line 1156: X0 := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER, COMBINATION_ID);

1152: STPROC.BIND_I(COMBINATION_ID);
1153: STPROC.EXECUTE;
1154: STPROC.RETRIEVE(1
1155: ,X0);*/
1156: X0 := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME, KEY_FLEX_CODE, STRUCTURE_NUMBER, COMBINATION_ID);
1157: RETURN X0;
1158: END GET_SEGS;
1159: function B_task_idFt(organization_id varchar2) return varchar2 is
1160: begin