APPS.AP_WEB_DB_EXPLINE_PKG dependencies on FND_VSET

Line 4850: l_vset_r fnd_vset.valueset_r;

4846: l_dflex_dr fnd_dflex.dflex_dr;
4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4851: l_value_dr fnd_vset.value_dr;
4852: l_vset_dr fnd_vset.valueset_dr;
4853: l_resultval VARCHAR2(2000);
4854: l_found BOOLEAN;

Line 4851: l_value_dr fnd_vset.value_dr;

4847: l_contexts_dr fnd_dflex.contexts_dr;
4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4851: l_value_dr fnd_vset.value_dr;
4852: l_vset_dr fnd_vset.valueset_dr;
4853: l_resultval VARCHAR2(2000);
4854: l_found BOOLEAN;
4855: l_rowcount NUMBER;

Line 4852: l_vset_dr fnd_vset.valueset_dr;

4848: l_segments_dr fnd_dflex.segments_dr;
4849: l_valueset_id fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE;
4850: l_vset_r fnd_vset.valueset_r;
4851: l_value_dr fnd_vset.value_dr;
4852: l_vset_dr fnd_vset.valueset_dr;
4853: l_resultval VARCHAR2(2000);
4854: l_found BOOLEAN;
4855: l_rowcount NUMBER;
4856: l_region per_addresses.region_1%TYPE;

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

4873: EXIT;
4874: END IF;
4875: END LOOP;
4876:
4877: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
4878:
4879: fnd_vset.get_value_init(l_vset_r, TRUE);
4880:
4881: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);

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

4875: END LOOP;
4876:
4877: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
4878:
4879: fnd_vset.get_value_init(l_vset_r, TRUE);
4880:
4881: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
4882: WHILE(l_found) LOOP
4883: IF (l_value_dr.id = p_region) THEN

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

4877: fnd_vset.get_valueset(l_valueset_id, l_vset_r, l_vset_dr);
4878:
4879: fnd_vset.get_value_init(l_vset_r, TRUE);
4880:
4881: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
4882: WHILE(l_found) LOOP
4883: IF (l_value_dr.id = p_region) THEN
4884: l_resultval := l_value_dr.value;
4885: EXIT;

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

4883: IF (l_value_dr.id = p_region) THEN
4884: l_resultval := l_value_dr.value;
4885: EXIT;
4886: END IF;
4887: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
4888: END LOOP;
4889:
4890: fnd_vset.get_value_end(l_vset_r);
4891: RETURN l_resultval;

Line 4890: fnd_vset.get_value_end(l_vset_r);

4886: END IF;
4887: fnd_vset.get_value(l_vset_r, l_rowcount, l_found, l_value_dr);
4888: END LOOP;
4889:
4890: fnd_vset.get_value_end(l_vset_r);
4891: RETURN l_resultval;
4892:
4893: EXCEPTION
4894: WHEN NO_DATA_FOUND THEN