APPS.AP_WEB_DB_EXPLINE_PKG dependencies on FND_VSET

Line 5165: l_vset_r fnd_vset.valueset_r;

5161: l_dflex_dr fnd_dflex.dflex_dr;
5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;
5166: l_value_dr fnd_vset.value_dr;
5167: l_vset_dr fnd_vset.valueset_dr;
5168: l_resultval VARCHAR2(2000);
5169: l_found BOOLEAN;

Line 5166: l_value_dr fnd_vset.value_dr;

5162: l_contexts_dr fnd_dflex.contexts_dr;
5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;
5166: l_value_dr fnd_vset.value_dr;
5167: l_vset_dr fnd_vset.valueset_dr;
5168: l_resultval VARCHAR2(2000);
5169: l_found BOOLEAN;
5170: l_rowcount NUMBER;

Line 5167: l_vset_dr fnd_vset.valueset_dr;

5163: l_segments_dr fnd_dflex.segments_dr;
5164: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
5165: l_vset_r fnd_vset.valueset_r;
5166: l_value_dr fnd_vset.value_dr;
5167: l_vset_dr fnd_vset.valueset_dr;
5168: l_resultval VARCHAR2(2000);
5169: l_found BOOLEAN;
5170: l_rowcount NUMBER;
5171: l_region per_addresses.region_1%TYPE;

Line 5192: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);

5188: EXIT;
5189: END IF;
5190: END LOOP;
5191:
5192: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
5193:
5194: fnd_vset.get_value_init(l_vset_r, TRUE);
5195:
5196: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);

Line 5194: fnd_vset.get_value_init(l_vset_r, TRUE);

5190: END LOOP;
5191:
5192: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
5193:
5194: fnd_vset.get_value_init(l_vset_r, TRUE);
5195:
5196: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
5197: WHILE(l_found) LOOP
5198: IF (l_value_dr.id = p_region) THEN

Line 5196: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);

5192: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
5193:
5194: fnd_vset.get_value_init(l_vset_r, TRUE);
5195:
5196: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
5197: WHILE(l_found) LOOP
5198: IF (l_value_dr.id = p_region) THEN
5199: l_resultval := l_value_dr.value;
5200: EXIT;

Line 5202: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);

5198: IF (l_value_dr.id = p_region) THEN
5199: l_resultval := l_value_dr.value;
5200: EXIT;
5201: END IF;
5202: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
5203: END LOOP;
5204:
5205: fnd_vset.get_value_end(l_vset_r);
5206: RETURN l_resultval;

Line 5205: fnd_vset.get_value_end(l_vset_r);

5201: END IF;
5202: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
5203: END LOOP;
5204:
5205: fnd_vset.get_value_end(l_vset_r);
5206: RETURN l_resultval;
5207:
5208: EXCEPTION
5209: WHEN NO_DATA_FOUND THEN