APPS.QP_BULK_VALUE_TO_ID dependencies on FND_VSET

Line 245: vset FND_VSET.valueset_r;

241: l_datatype VARCHAR2(1);
242: l_precedence NUMBER;
243: l_error_code NUMBER;
244:
245: vset FND_VSET.valueset_r;
246: fmt FND_VSET.valueset_dr;
247: found BOOLEAN;
248: row NUMBER;
249: value FND_VSET.value_dr;

Line 246: fmt FND_VSET.valueset_dr;

242: l_precedence NUMBER;
243: l_error_code NUMBER;
244:
245: vset FND_VSET.valueset_r;
246: fmt FND_VSET.valueset_dr;
247: found BOOLEAN;
248: row NUMBER;
249: value FND_VSET.value_dr;
250: x_vsid NUMBER;

Line 249: value FND_VSET.value_dr;

245: vset FND_VSET.valueset_r;
246: fmt FND_VSET.valueset_dr;
247: found BOOLEAN;
248: row NUMBER;
249: value FND_VSET.value_dr;
250: x_vsid NUMBER;
251: x_validation_type VARCHAR2(1);
252:
253: BEGIN

Line 440: FND_VSET.get_valueset(x_vsid, vset, fmt);

436: rec.product_attribute_context,
437: l_segment_name,
438: x_vsid, x_format_type, x_validation_type);
439: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
440: FND_VSET.get_valueset(x_vsid, vset, fmt);
441: FND_VSET.get_value_init(vset, TRUE);
442: FND_VSET.get_value(vset, row, found, value);
443:
444: WHILE (found) LOOP

Line 441: FND_VSET.get_value_init(vset, TRUE);

437: l_segment_name,
438: x_vsid, x_format_type, x_validation_type);
439: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
440: FND_VSET.get_valueset(x_vsid, vset, fmt);
441: FND_VSET.get_value_init(vset, TRUE);
442: FND_VSET.get_value(vset, row, found, value);
443:
444: WHILE (found) LOOP
445: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);

Line 442: FND_VSET.get_value(vset, row, found, value);

438: x_vsid, x_format_type, x_validation_type);
439: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
440: FND_VSET.get_valueset(x_vsid, vset, fmt);
441: FND_VSET.get_value_init(vset, TRUE);
442: FND_VSET.get_value(vset, row, found, value);
443:
444: WHILE (found) LOOP
445: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);
446: IF (fmt.has_meaning AND

Line 465: FND_VSET.get_value(vset, row, found, value);

461: EXIT;
462:
463: END IF; -- If value.meaning or value.value matches with p_meaning
464:
465: FND_VSET.get_value(vset, row, found, value);
466: END LOOP;
467:
468: FND_VSET.get_value_end(vset);
469:

Line 468: FND_VSET.get_value_end(vset);

464:
465: FND_VSET.get_value(vset, row, found, value);
466: END LOOP;
467:
468: FND_VSET.get_value_end(vset);
469:
470: qp_bulk_loader_pub.write_log('x_value/x_id: ' || x_value || '/' || x_id);
471: if x_value is NULL then
472: x_value := rec.product_attr_val_disp;