APPS.QP_MASS_MAINTAIN_UTIL dependencies on FND_VSET

Line 135: v_valueset_r fnd_vset.valueset_r;

131: p_pte IN VARCHAR2 DEFAULT NULL, -- Hierarchical Categories
132: p_ss IN VARCHAR2 DEFAULT NULL) -- Hierarchical Categories
133: is
134: v_value_set_id NUMBER;
135: v_valueset_r fnd_vset.valueset_r;
136: v_valueset_dr fnd_vset.valueset_dr;
137: v_table_r fnd_vset.table_r;
138: v_select_clause varchar2(4000);
139: v_cols varchar2(3000);

Line 136: v_valueset_dr fnd_vset.valueset_dr;

132: p_ss IN VARCHAR2 DEFAULT NULL) -- Hierarchical Categories
133: is
134: v_value_set_id NUMBER;
135: v_valueset_r fnd_vset.valueset_r;
136: v_valueset_dr fnd_vset.valueset_dr;
137: v_table_r fnd_vset.table_r;
138: v_select_clause varchar2(4000);
139: v_cols varchar2(3000);
140: v_fnarea_where_clause VARCHAR2(500);

Line 137: v_table_r fnd_vset.table_r;

133: is
134: v_value_set_id NUMBER;
135: v_valueset_r fnd_vset.valueset_r;
136: v_valueset_dr fnd_vset.valueset_dr;
137: v_table_r fnd_vset.table_r;
138: v_select_clause varchar2(4000);
139: v_cols varchar2(3000);
140: v_fnarea_where_clause VARCHAR2(500);
141: l_appl_id NUMBER;

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

176: and cont.PRC_CONTEXT_ID = seg.PRC_CONTEXT_ID
177: and seg.SEGMENT_MAPPING_COLUMN = nvl(p_segment_map_col, seg.SEGMENT_MAPPING_COLUMN) -- sfiresto fix
178: and vs.validation_type <> 'N'; -- sfiresto for bug 5136873, all value set types but 'NONE'
179:
180: fnd_vset.get_valueset(v_value_set_id,v_valueset_r,v_valueset_dr);
181:
182: v_table_r := v_valueset_r.table_info;
183:
184: v_cols := nvl(v_table_r.ID_COLUMN_NAME, nvl(v_table_r.VALUE_COLUMN_NAME, 'null')) || ' attribute_id, '; -- sfiresto fix