APPS.QP_QPXPRCST_XMLP_PKG dependencies on FND_VSET

Line 194: VSET FND_VSET.VALUESET_R;

190: ,P_CONTEXT_NAME IN VARCHAR2
191: ,P_SEGMENT_NAME IN VARCHAR2
192: ,P_ATTR_VALUE IN VARCHAR2
193: ,P_COMPARISON_OPERATOR_CODE IN VARCHAR2 := NULL) RETURN VARCHAR2 IS
194: VSET FND_VSET.VALUESET_R;
195: FMT FND_VSET.VALUESET_DR;
196: FOUND BOOLEAN;
197: ROW NUMBER;
198: VALUE FND_VSET.VALUE_DR;

Line 195: FMT FND_VSET.VALUESET_DR;

191: ,P_SEGMENT_NAME IN VARCHAR2
192: ,P_ATTR_VALUE IN VARCHAR2
193: ,P_COMPARISON_OPERATOR_CODE IN VARCHAR2 := NULL) RETURN VARCHAR2 IS
194: VSET FND_VSET.VALUESET_R;
195: FMT FND_VSET.VALUESET_DR;
196: FOUND BOOLEAN;
197: ROW NUMBER;
198: VALUE FND_VSET.VALUE_DR;
199: X_FORMAT_TYPE VARCHAR2(1);

Line 198: VALUE FND_VSET.VALUE_DR;

194: VSET FND_VSET.VALUESET_R;
195: FMT FND_VSET.VALUESET_DR;
196: FOUND BOOLEAN;
197: ROW NUMBER;
198: VALUE FND_VSET.VALUE_DR;
199: X_FORMAT_TYPE VARCHAR2(1);
200: X_VALIDATION_TYPE VARCHAR2(1);
201: X_VSID NUMBER;
202: X_ATTR_VALUE_CODE VARCHAR2(240);

Line 225: FND_VSET.GET_VALUESET(X_VSID

221: ,'attr value ' || L_ATTR_VALUE)*/NULL;
222: IF P_COMPARISON_OPERATOR_CODE <> 'BETWEEN' THEN
223: IF X_VALIDATION_TYPE in ('F','I') AND X_VSID IS NOT NULL THEN
224: IF X_VALIDATION_TYPE = 'I' THEN
225: FND_VSET.GET_VALUESET(X_VSID
226: ,VSET
227: ,FMT);
228: FND_VSET.GET_VALUE_INIT(VSET
229: ,TRUE);

Line 228: FND_VSET.GET_VALUE_INIT(VSET

224: IF X_VALIDATION_TYPE = 'I' THEN
225: FND_VSET.GET_VALUESET(X_VSID
226: ,VSET
227: ,FMT);
228: FND_VSET.GET_VALUE_INIT(VSET
229: ,TRUE);
230: FND_VSET.GET_VALUE(VSET
231: ,ROW
232: ,FOUND

Line 230: FND_VSET.GET_VALUE(VSET

226: ,VSET
227: ,FMT);
228: FND_VSET.GET_VALUE_INIT(VSET
229: ,TRUE);
230: FND_VSET.GET_VALUE(VSET
231: ,ROW
232: ,FOUND
233: ,VALUE);
234: IF FMT.HAS_ID THEN

Line 242: FND_VSET.GET_VALUE(VSET

238: X_ATTR_VALUE_CODE := VALUE.VALUE;
239: VALUE_VALID_IN_VALUESET := TRUE;
240: EXIT;
241: END IF;
242: FND_VSET.GET_VALUE(VSET
243: ,ROW
244: ,FOUND
245: ,VALUE);
246: END LOOP;

Line 255: FND_VSET.GET_VALUE(VSET

251: X_ATTR_VALUE_CODE := L_ATTR_VALUE;
252: VALUE_VALID_IN_VALUESET := TRUE;
253: EXIT;
254: END IF;
255: FND_VSET.GET_VALUE(VSET
256: ,ROW
257: ,FOUND
258: ,VALUE);
259: END LOOP;

Line 261: FND_VSET.GET_VALUE_END(VSET);

257: ,FOUND
258: ,VALUE);
259: END LOOP;
260: END IF;
261: FND_VSET.GET_VALUE_END(VSET);
262: ELSIF X_VALIDATION_TYPE = 'F' THEN
263: FND_VSET.GET_VALUESET(X_VSID
264: ,VSET
265: ,FMT);

Line 263: FND_VSET.GET_VALUESET(X_VSID

259: END LOOP;
260: END IF;
261: FND_VSET.GET_VALUE_END(VSET);
262: ELSIF X_VALIDATION_TYPE = 'F' THEN
263: FND_VSET.GET_VALUESET(X_VSID
264: ,VSET
265: ,FMT);
266: IF (QP_UTIL.VALUE_EXISTS_IN_TABLE(VSET.TABLE_INFO
267: ,L_ATTR_VALUE

Line 322: TEST_REC FND_VSET.VALUESET_R;

318: ,P_SEG IN VARCHAR2
319: ,X_VSID OUT NOCOPY NUMBER
320: ,X_FORMAT_TYPE OUT NOCOPY VARCHAR2
321: ,X_VALIDATION_TYPE OUT NOCOPY VARCHAR2) IS
322: TEST_REC FND_VSET.VALUESET_R;
323: X_VALUESETID NUMBER;
324: TEST_FREC FND_VSET.VALUESET_DR;
325: CURSOR CUR_GET_APPLICATION_ID(APP_SHORT_NAME IN VARCHAR2) IS
326: SELECT

Line 324: TEST_FREC FND_VSET.VALUESET_DR;

320: ,X_FORMAT_TYPE OUT NOCOPY VARCHAR2
321: ,X_VALIDATION_TYPE OUT NOCOPY VARCHAR2) IS
322: TEST_REC FND_VSET.VALUESET_R;
323: X_VALUESETID NUMBER;
324: TEST_FREC FND_VSET.VALUESET_DR;
325: CURSOR CUR_GET_APPLICATION_ID(APP_SHORT_NAME IN VARCHAR2) IS
326: SELECT
327: APPLICATION_ID
328: FROM

Line 358: FND_VSET.GET_VALUESET(X_VALUESETID

354: END LOOP;
355: /*SRW.MESSAGE(1
356: ,'the app ' || X_VALUESETID)*/NULL;
357: IF X_VALUESETID IS NOT NULL THEN
358: FND_VSET.GET_VALUESET(X_VALUESETID
359: ,TEST_REC
360: ,TEST_FREC);
361: /*SRW.MESSAGE(1
362: ,'val type ')*/NULL;