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.FND_VSET dependencies on DBMS_SQL

Line 203: cursor_handle := dbms_sql.open_cursor;

199: sqlstring := 'select ' || cols ||
200: ' from ' || table_info.table_name ||
201: ' ' || table_info.where_clause;
202: dbgprint(' sql stmt = ' || sqlstring);
203: cursor_handle := dbms_sql.open_cursor;
204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);

Line 204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);

200: ' from ' || table_info.table_name ||
201: ' ' || table_info.where_clause;
202: dbgprint(' sql stmt = ' || sqlstring);
203: cursor_handle := dbms_sql.open_cursor;
204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);

Line 205: dbms_sql.define_column(cursor_handle, 1, dummy_date);

201: ' ' || table_info.where_clause;
202: dbgprint(' sql stmt = ' || sqlstring);
203: cursor_handle := dbms_sql.open_cursor;
204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);

Line 206: dbms_sql.define_column(cursor_handle, 2, dummy_date);

202: dbgprint(' sql stmt = ' || sqlstring);
203: cursor_handle := dbms_sql.open_cursor;
204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);
210: dummy_int := dbms_sql.execute(cursor_handle);

Line 207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);

203: cursor_handle := dbms_sql.open_cursor;
204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);
210: dummy_int := dbms_sql.execute(cursor_handle);
211: END;

Line 208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);

204: dbms_sql.parse(cursor_handle, sqlstring, dbms_sql.native);
205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);
210: dummy_int := dbms_sql.execute(cursor_handle);
211: END;
212:

Line 209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);

205: dbms_sql.define_column(cursor_handle, 1, dummy_date);
206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);
210: dummy_int := dbms_sql.execute(cursor_handle);
211: END;
212:
213: PROCEDURE get_value_init(valueset IN valueset_r,

Line 210: dummy_int := dbms_sql.execute(cursor_handle);

206: dbms_sql.define_column(cursor_handle, 2, dummy_date);
207: dbms_sql.define_column(cursor_handle, 3, dummy_vc, max_val_size);
208: dbms_sql.define_column(cursor_handle, 4, dummy_vc, max_meaning_size);
209: dbms_sql.define_column(cursor_handle, 5, dummy_vc, max_id_size);
210: dummy_int := dbms_sql.execute(cursor_handle);
211: END;
212:
213: PROCEDURE get_value_init(valueset IN valueset_r,
214: enabled_only IN BOOLEAN)

Line 257: found := (dbms_sql.fetch_rows(cursor_handle) > 0);

253: value := value_i;
254: found := value_d%found;
255: ELSIF(valueset.validation_type = 'F') THEN
256: dbgprint('get_value: doing fetch (table) ...');
257: found := (dbms_sql.fetch_rows(cursor_handle) > 0);
258: dbgprint('get_value: assigning values (table) ...');
259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);

Line 259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);

255: ELSIF(valueset.validation_type = 'F') THEN
256: dbgprint('get_value: doing fetch (table) ...');
257: found := (dbms_sql.fetch_rows(cursor_handle) > 0);
258: dbgprint('get_value: assigning values (table) ...');
259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);
262: dbms_sql.column_value(cursor_handle, 4, value.meaning);
263: dbms_sql.column_value(cursor_handle, 5, value.id);

Line 260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);

256: dbgprint('get_value: doing fetch (table) ...');
257: found := (dbms_sql.fetch_rows(cursor_handle) > 0);
258: dbgprint('get_value: assigning values (table) ...');
259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);
262: dbms_sql.column_value(cursor_handle, 4, value.meaning);
263: dbms_sql.column_value(cursor_handle, 5, value.id);
264: END IF;

Line 261: dbms_sql.column_value(cursor_handle, 3, value.value);

257: found := (dbms_sql.fetch_rows(cursor_handle) > 0);
258: dbgprint('get_value: assigning values (table) ...');
259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);
262: dbms_sql.column_value(cursor_handle, 4, value.meaning);
263: dbms_sql.column_value(cursor_handle, 5, value.id);
264: END IF;
265: rowcount := NULL;

Line 262: dbms_sql.column_value(cursor_handle, 4, value.meaning);

258: dbgprint('get_value: assigning values (table) ...');
259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);
262: dbms_sql.column_value(cursor_handle, 4, value.meaning);
263: dbms_sql.column_value(cursor_handle, 5, value.id);
264: END IF;
265: rowcount := NULL;
266: dbgprint('get_value: done.');

Line 263: dbms_sql.column_value(cursor_handle, 5, value.id);

259: dbms_sql.column_value(cursor_handle, 1, value.start_date_active);
260: dbms_sql.column_value(cursor_handle, 2, value.end_date_active);
261: dbms_sql.column_value(cursor_handle, 3, value.value);
262: dbms_sql.column_value(cursor_handle, 4, value.meaning);
263: dbms_sql.column_value(cursor_handle, 5, value.id);
264: END IF;
265: rowcount := NULL;
266: dbgprint('get_value: done.');
267: END;

Line 283: IF(dbms_sql.is_open(cursor_handle)) THEN

279: IF value_d%isopen THEN
280: CLOSE value_d;
281: END IF;
282: ELSIF(valueset.validation_type = 'F') THEN
283: IF(dbms_sql.is_open(cursor_handle)) THEN
284: dbms_sql.close_cursor(cursor_handle);
285: END IF;
286: END IF;
287: dbgprint('get_value_end: done.');

Line 284: dbms_sql.close_cursor(cursor_handle);

280: CLOSE value_d;
281: END IF;
282: ELSIF(valueset.validation_type = 'F') THEN
283: IF(dbms_sql.is_open(cursor_handle)) THEN
284: dbms_sql.close_cursor(cursor_handle);
285: END IF;
286: END IF;
287: dbgprint('get_value_end: done.');
288: END;