APPS.HXC_LOAD_PKG dependencies on FND_VSET

Line 219: l_valueset_r fnd_vset.valueset_r;

215: -- Declare local variables
216: --
217: l_sql_text LONG;
218: l_sql_text_id LONG;
219: l_valueset_r fnd_vset.valueset_r;
220: l_valueset_dr fnd_vset.valueset_dr;
221: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
222: l_order_by_start NUMBER;
223: l_from_start NUMBER;

Line 220: l_valueset_dr fnd_vset.valueset_dr;

216: --
217: l_sql_text LONG;
218: l_sql_text_id LONG;
219: l_valueset_r fnd_vset.valueset_r;
220: l_valueset_dr fnd_vset.valueset_dr;
221: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
222: l_order_by_start NUMBER;
223: l_from_start NUMBER;
224: l_additional_and_clause VARCHAR2(2000);

Line 233: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);

229: begin -- get_value_set_sql
230:
231: l_value_set_id := p_flex_value_set_id;
232:
233: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);
234:
235: --
236: -- Initailize the SQL text columns.
237: --

Line 774: l_valueset_r fnd_vset.valueset_r;

770: -- Declare local variables
771: --
772: l_sql_text LONG;
773: l_sql_text_id LONG;
774: l_valueset_r fnd_vset.valueset_r;
775: l_valueset_dr fnd_vset.valueset_dr;
776: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
777: l_order_by_start NUMBER;
778: l_from_start NUMBER;

Line 775: l_valueset_dr fnd_vset.valueset_dr;

771: --
772: l_sql_text LONG;
773: l_sql_text_id LONG;
774: l_valueset_r fnd_vset.valueset_r;
775: l_valueset_dr fnd_vset.valueset_dr;
776: l_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
777: l_order_by_start NUMBER;
778: l_from_start NUMBER;
779: l_additional_and_clause VARCHAR2(2000);

Line 788: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);

784: begin -- get_value_set_sql
785:
786: l_value_set_id := p_flex_value_set_id;
787:
788: fnd_vset.get_valueset(l_value_set_id,l_valueset_r,l_valueset_dr);
789:
790: --
791: -- Initailize the SQL text columns.
792: --