APPS.QP_PARAM_UTIL dependencies on FND_VSET

Line 6: v_valueset_r fnd_vset.valueset_r;

2: /* $Header: QPXUPRMB.pls 120.2 2005/10/03 02:26:23 prarasto noship $ */
3: PROCEDURE Get_Valueset_Select( p_valueset_id IN VARCHAR2,
4: x_select_stmt OUT NOCOPY VARCHAR2) IS
5: v_select_clause varchar2(4000) := null;
6: v_valueset_r fnd_vset.valueset_r;
7: v_valueset_dr fnd_vset.valueset_dr;
8: v_table_r fnd_vset.table_r;
9: v_cols varchar2(3000);
10: v_value_set_id number := to_number(p_valueset_id);

Line 7: v_valueset_dr fnd_vset.valueset_dr;

3: PROCEDURE Get_Valueset_Select( p_valueset_id IN VARCHAR2,
4: x_select_stmt OUT NOCOPY VARCHAR2) IS
5: v_select_clause varchar2(4000) := null;
6: v_valueset_r fnd_vset.valueset_r;
7: v_valueset_dr fnd_vset.valueset_dr;
8: v_table_r fnd_vset.table_r;
9: v_cols varchar2(3000);
10: v_value_set_id number := to_number(p_valueset_id);
11: BEGIN

Line 8: v_table_r fnd_vset.table_r;

4: x_select_stmt OUT NOCOPY VARCHAR2) IS
5: v_select_clause varchar2(4000) := null;
6: v_valueset_r fnd_vset.valueset_r;
7: v_valueset_dr fnd_vset.valueset_dr;
8: v_table_r fnd_vset.table_r;
9: v_cols varchar2(3000);
10: v_value_set_id number := to_number(p_valueset_id);
11: BEGIN
12: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);

Line 12: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);

8: v_table_r fnd_vset.table_r;
9: v_cols varchar2(3000);
10: v_value_set_id number := to_number(p_valueset_id);
11: BEGIN
12: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);
13:
14: v_table_r := v_valueset_r.table_info;
15: v_cols := nvl(v_table_r.ID_COLUMN_NAME, nvl(v_table_r.VALUE_COLUMN_NAME, 'null')) || ' attribute_id, ';
16: v_cols := v_cols || nvl(v_table_r.VALUE_COLUMN_NAME, 'null') || ' attribute_name, ';