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 3253: Vset FND_VSET.valueset_r;

3249: x_return_status OUT NOCOPY VARCHAR2,
3250: x_return_text OUT NOCOPY VARCHAR2
3251: )
3252: IS
3253: Vset FND_VSET.valueset_r;
3254: Fmt FND_VSET.valueset_dr;
3255:
3256: Found BOOLEAN;
3257: ROW NUMBER;

Line 3254: Fmt FND_VSET.valueset_dr;

3250: x_return_text OUT NOCOPY VARCHAR2
3251: )
3252: IS
3253: Vset FND_VSET.valueset_r;
3254: Fmt FND_VSET.valueset_dr;
3255:
3256: Found BOOLEAN;
3257: ROW NUMBER;
3258: VALUE FND_VSET.value_dr;

Line 3258: VALUE FND_VSET.value_dr;

3254: Fmt FND_VSET.valueset_dr;
3255:
3256: Found BOOLEAN;
3257: ROW NUMBER;
3258: VALUE FND_VSET.value_dr;
3259:
3260: x_Format_Type VARCHAR2(1);
3261:
3262: x_Validation_Type VARCHAR2(1);

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

3290: x_Format_Type, x_Validation_Type);
3291:
3292: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3293:
3294: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3295: FND_VSET.get_value_init(Vset, TRUE);
3296: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3297:
3298: IF Fmt.Has_Id THEN -- id defined, get id

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

3291:
3292: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3293:
3294: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3295: FND_VSET.get_value_init(Vset, TRUE);
3296: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3297:
3298: IF Fmt.Has_Id THEN -- id defined, get id
3299: WHILE(Found) LOOP

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

3292: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN
3293:
3294: FND_VSET.get_valueset(x_Vsid, Vset, Fmt);
3295: FND_VSET.get_value_init(Vset, TRUE);
3296: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3297:
3298: IF Fmt.Has_Id THEN -- id defined, get id
3299: WHILE(Found) LOOP
3300: IF p_attribute_value_name = VALUE.VALUE THEN

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

3301: x_attribute_value_code := VALUE.id;
3302: l_count := l_count + 1;
3303: EXIT;
3304: END IF;
3305: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3306: END LOOP;
3307: ELSE -- id not defined, get value
3308: WHILE(Found) LOOP
3309: IF p_attribute_value_name = VALUE.VALUE THEN

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

3310: x_attribute_value_code := p_attribute_value_name;
3311: l_count := l_count + 1;
3312: EXIT;
3313: END IF;
3314: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3315: END LOOP;
3316: END IF; -- end of Fmt.Has_Id
3317:
3318: FND_VSET.get_value_end(Vset);

Line 3318: FND_VSET.get_value_end(Vset);

3314: FND_VSET.get_value(Vset, ROW, Found, VALUE);
3315: END LOOP;
3316: END IF; -- end of Fmt.Has_Id
3317:
3318: FND_VSET.get_value_end(Vset);
3319:
3320: IF l_count = 0 THEN
3321: RAISE NO_DATA_FOUND;
3322: ELSIF l_count > 1 THEN