DBA Data[Home] [Help]

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 471: FND_VSET.get_valueset(x_vsid, vset, fmt);

467: rec.product_attribute_context,
468: l_segment_name,
469: x_vsid, x_format_type, x_validation_type);
470: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
471: FND_VSET.get_valueset(x_vsid, vset, fmt);
472: FND_VSET.get_value_init(vset, TRUE);
473: FND_VSET.get_value(vset, row, found, value);
474:
475: WHILE (found) LOOP

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

468: l_segment_name,
469: x_vsid, x_format_type, x_validation_type);
470: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
471: FND_VSET.get_valueset(x_vsid, vset, fmt);
472: FND_VSET.get_value_init(vset, TRUE);
473: FND_VSET.get_value(vset, row, found, value);
474:
475: WHILE (found) LOOP
476: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);

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

469: x_vsid, x_format_type, x_validation_type);
470: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
471: FND_VSET.get_valueset(x_vsid, vset, fmt);
472: FND_VSET.get_value_init(vset, TRUE);
473: FND_VSET.get_value(vset, row, found, value);
474:
475: WHILE (found) LOOP
476: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);
477: IF (fmt.has_meaning AND

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

492: EXIT;
493:
494: END IF; -- If value.meaning or value.value matches with p_meaning
495:
496: FND_VSET.get_value(vset, row, found, value);
497: END LOOP;
498:
499: FND_VSET.get_value_end(vset);
500:

Line 499: FND_VSET.get_value_end(vset);

495:
496: FND_VSET.get_value(vset, row, found, value);
497: END LOOP;
498:
499: FND_VSET.get_value_end(vset);
500:
501: qp_bulk_loader_pub.write_log('x_value/x_id: ' || x_value || '/' || x_id);
502: if x_value is NULL then
503: x_value := rec.product_attr_val_disp;