DBA Data[Home] [Help]

APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on FND_FLEX_EXT

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

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

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

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

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

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

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

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

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

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

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

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