APPS.QP_PRICE_BOOK_UTIL dependencies on FND_VSET

Line 498: v_valueset_r fnd_vset.valueset_r;

494: l_name VARCHAR2(2000);
495: l_desc VARCHAR2(2000);
496: l_count2 NUMBER := 0;
497:
498: v_valueset_r fnd_vset.valueset_r;
499: v_valueset_dr fnd_vset.valueset_dr;
500: l_datatype VARCHAR2(1);
501: l_value VARCHAR2(150);
502: l_id VARCHAR2(150);

Line 499: v_valueset_dr fnd_vset.valueset_dr;

495: l_desc VARCHAR2(2000);
496: l_count2 NUMBER := 0;
497:
498: v_valueset_r fnd_vset.valueset_r;
499: v_valueset_dr fnd_vset.valueset_dr;
500: l_datatype VARCHAR2(1);
501: l_value VARCHAR2(150);
502: l_id VARCHAR2(150);
503: l_valueset_id NUMBER;

Line 2231: fnd_vset.get_valueset(l_valueset_id, v_valueset_r, v_valueset_dr);

2227: ELSE --If l_count <> 0, that is, attribute is valid
2228:
2229: IF l_valueset_id IS NOT NULL THEN
2230:
2231: fnd_vset.get_valueset(l_valueset_id, v_valueset_r, v_valueset_dr);
2232: l_datatype := v_valueset_dr.format_type;
2233:
2234: IF (v_valueset_r.validation_type = 'I') AND
2235: --Validation type is independent

Line 3286: Vset FND_VSET.valueset_r;

3282: x_return_status OUT NOCOPY VARCHAR2,
3283: x_return_text OUT NOCOPY VARCHAR2
3284: )
3285: IS
3286: Vset FND_VSET.valueset_r;
3287: Fmt FND_VSET.valueset_dr;
3288:
3289: Found BOOLEAN;
3290: ROW NUMBER;

Line 3287: Fmt FND_VSET.valueset_dr;

3283: x_return_text OUT NOCOPY VARCHAR2
3284: )
3285: IS
3286: Vset FND_VSET.valueset_r;
3287: Fmt FND_VSET.valueset_dr;
3288:
3289: Found BOOLEAN;
3290: ROW NUMBER;
3291: VALUE FND_VSET.value_dr;

Line 3291: VALUE FND_VSET.value_dr;

3287: Fmt FND_VSET.valueset_dr;
3288:
3289: Found BOOLEAN;
3290: ROW NUMBER;
3291: VALUE FND_VSET.value_dr;
3292:
3293: x_Format_Type VARCHAR2(1);
3294:
3295: x_Validation_Type VARCHAR2(1);

Line 3327: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);

3323: x_Format_Type, x_Validation_Type);
3324:
3325: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3326:
3327: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3328: FND_VSET.get_value_init(Vset, TRUE);
3329: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3330:
3331: IF Fmt.Has_Id THEN -- id defined, get id

Line 3328: FND_VSET.get_value_init(Vset, TRUE);

3324:
3325: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3326:
3327: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3328: FND_VSET.get_value_init(Vset, TRUE);
3329: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3330:
3331: IF Fmt.Has_Id THEN -- id defined, get id
3332: WHILE(Found) LOOP

Line 3329: FND_VSET.get_value(Vset, ROW, Found, VALUE);

3325: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3326:
3327: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3328: FND_VSET.get_value_init(Vset, TRUE);
3329: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3330:
3331: IF Fmt.Has_Id THEN -- id defined, get id
3332: WHILE(Found) LOOP
3333: IF p_attribute_value_name = VALUE.VALUE THEN

Line 3338: FND_VSET.get_value(Vset, ROW, Found, VALUE);

3334: x_attribute_value_code := VALUE.id;
3335: l_count := l_count + 1;
3336: EXIT;
3337: END IF;
3338: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3339: END LOOP;
3340: ELSE -- id not defined, get value
3341: WHILE(Found) LOOP
3342: IF p_attribute_value_name = VALUE.VALUE THEN

Line 3347: FND_VSET.get_value(Vset, ROW, Found, VALUE);

3343: x_attribute_value_code := p_attribute_value_name;
3344: l_count := l_count + 1;
3345: EXIT;
3346: END IF;
3347: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3348: END LOOP;
3349: END IF; -- end of Fmt.Has_Id
3350:
3351: FND_VSET.get_value_end(Vset);

Line 3351: FND_VSET.get_value_end(Vset);

3347: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3348: END LOOP;
3349: END IF; -- end of Fmt.Has_Id
3350:
3351: FND_VSET.get_value_end(Vset);
3352:
3353: IF l_count = 0 THEN
3354: RAISE NO_DATA_FOUND;
3355: ELSIF l_count > 1 THEN