eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SYS_PARAMETERS_UTIL dependencies on FND_VSET

Line 9: -- IN : p_table_r IN fnd_vset.table_r required

5: -- API name : Get_Value_from_Table
6: -- Type : Public
7: -- Description : This api will get the value from the table based on table information and the code
8: -- Parameters :
9: -- IN : p_table_r IN fnd_vset.table_r required
10: -- Table information
11: -- p_code IN VARCHAR2 required
12: -- Code/id for which value to be retrived
13: -- OUT x_value OUT VARCHAR2

Line 16: PROCEDURE Get_Value_from_Table(p_table_r IN fnd_vset.table_r,

12: -- Code/id for which value to be retrived
13: -- OUT x_value OUT VARCHAR2
14: -- value for the code
15: -- End of Comments
16: PROCEDURE Get_Value_from_Table(p_table_r IN fnd_vset.table_r,
17: p_code IN VARCHAR2,
18: x_value OUT NOCOPY VARCHAR2)
19: IS
20: l_selectstmt VARCHAR2(3000) ;

Line 133: -- IN : p_format_type IN fnd_vset.table_r required

129: -- API name : Get_num_date_from_canonical
130: -- Type : Public
131: -- Description : This api will convert the value based on format type
132: -- Parameters :
133: -- IN : p_format_type IN fnd_vset.table_r required
134: -- Format type information
135: -- p_value_code IN VARCHAR2 required
136: -- End of Comments
137: FUNCTION Get_num_date_from_canonical(p_format_type IN VARCHAR2,

Line 183: l_vset_rec fnd_vset.valueset_r;

179: FUNCTION Get_Value(p_value_set_id IN NUMBER,
180: p_value_code IN VARCHAR2)
181: RETURN VARCHAR2
182: IS
183: l_vset_rec fnd_vset.valueset_r;
184: l_format_rec fnd_vset.valueset_dr;
185: l_found BOOLEAN;
186: l_row NUMBER;
187: l_value_rec fnd_vset.value_dr;

Line 184: l_format_rec fnd_vset.valueset_dr;

180: p_value_code IN VARCHAR2)
181: RETURN VARCHAR2
182: IS
183: l_vset_rec fnd_vset.valueset_r;
184: l_format_rec fnd_vset.valueset_dr;
185: l_found BOOLEAN;
186: l_row NUMBER;
187: l_value_rec fnd_vset.value_dr;
188: l_attr_code VARCHAR2(240);

Line 187: l_value_rec fnd_vset.value_dr;

183: l_vset_rec fnd_vset.valueset_r;
184: l_format_rec fnd_vset.valueset_dr;
185: l_found BOOLEAN;
186: l_row NUMBER;
187: l_value_rec fnd_vset.value_dr;
188: l_attr_code VARCHAR2(240);
189: l_attr_value VARCHAR2(240);
190: l_value VARCHAR2(240);
191: --

Line 196: fnd_vset.get_valueset(p_value_set_id,l_vset_rec, l_format_rec);

192: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
193: --
194:
195: BEGIN
196: fnd_vset.get_valueset(p_value_set_id,l_vset_rec, l_format_rec);
197: l_attr_code := get_num_date_from_canonical
198: (l_format_rec.format_type,p_value_code);
199: IF l_vset_rec.validation_type = 'I' THEN
200: fnd_vset.get_value_init(l_vset_rec, TRUE);

Line 200: fnd_vset.get_value_init(l_vset_rec, TRUE);

196: fnd_vset.get_valueset(p_value_set_id,l_vset_rec, l_format_rec);
197: l_attr_code := get_num_date_from_canonical
198: (l_format_rec.format_type,p_value_code);
199: IF l_vset_rec.validation_type = 'I' THEN
200: fnd_vset.get_value_init(l_vset_rec, TRUE);
201: fnd_vset.get_value(l_vset_rec, l_row, l_found, l_value_rec);
202:
203: IF l_format_rec.Has_Id THEN --id is defined.Hence compare for id
204: WHILE(l_Found) LOOP

Line 201: fnd_vset.get_value(l_vset_rec, l_row, l_found, l_value_rec);

197: l_attr_code := get_num_date_from_canonical
198: (l_format_rec.format_type,p_value_code);
199: IF l_vset_rec.validation_type = 'I' THEN
200: fnd_vset.get_value_init(l_vset_rec, TRUE);
201: fnd_vset.get_value(l_vset_rec, l_row, l_found, l_value_rec);
202:
203: IF l_format_rec.Has_Id THEN --id is defined.Hence compare for id
204: WHILE(l_Found) LOOP
205: -- 4284156

Line 212: FND_VSET.get_value(l_Vset_rec,l_Row,l_Found,l_Value_rec);

208: IF l_attr_code = l_value_rec.id THEN
209: l_attr_value := l_value_rec.value;
210: EXIT;
211: END IF;
212: FND_VSET.get_value(l_Vset_rec,l_Row,l_Found,l_Value_rec);
213: END LOOP;
214: ELSE -- id not defined.Hence compare for value
215: WHILE(l_Found) LOOP
216: -- bug 4284156

Line 224: FND_VSET.get_value(l_Vset_rec,l_Row,l_Found,l_Value_rec);

220: --5048979
221: l_attr_value := l_value_rec.value; -- l_attr_code;
222: EXIT;
223: END IF;
224: FND_VSET.get_value(l_Vset_rec,l_Row,l_Found,l_Value_rec);
225: END LOOP;
226: END IF;
227: fnd_vset.get_value_end(l_vset_rec);
228:

Line 227: fnd_vset.get_value_end(l_vset_rec);

223: END IF;
224: FND_VSET.get_value(l_Vset_rec,l_Row,l_Found,l_Value_rec);
225: END LOOP;
226: END IF;
227: fnd_vset.get_value_end(l_vset_rec);
228:
229: ELSIF l_vset_rec.validation_type = 'F' THEN
230: Get_value_from_table(l_vset_rec.table_info,
231: l_attr_code,