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

Line 52: v_cursor_id := dbms_sql.open_cursor;

48: last_update_date, last_updated_by, last_update_login,
49: created_by, creation_date)
50: values (:xflex, :xgen, :xcoll, :xit, :xobj, :xlvl, :xver, sysdate,
51: 0, 1, 1, sysdate) ';
52: v_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));

Line 53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

49: created_by, creation_date)
50: values (:xflex, :xgen, :xcoll, :xit, :xobj, :xlvl, :xver, sysdate,
51: 0, 1, 1, sysdate) ';
52: v_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));

Line 54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));

50: values (:xflex, :xgen, :xcoll, :xit, :xobj, :xlvl, :xver, sysdate,
51: 0, 1, 1, sysdate) ';
52: v_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));

Line 55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));

51: 0, 1, 1, sysdate) ';
52: v_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));

Line 56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));

52: v_cursor_id := dbms_sql.open_cursor;
53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);

Line 57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));

53: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:

Line 58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));

54: dbms_sql.bind_variable(v_cursor_id, ':xflex', upper(p_flex_view_name));
55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:
62: v_ret_code := dbms_sql.execute(v_cursor_id);

Line 59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));

55: dbms_sql.bind_variable(v_cursor_id, ':xgen', upper(p_generated_view_name));
56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:
62: v_ret_code := dbms_sql.execute(v_cursor_id);
63: dbms_sql.close_cursor(v_cursor_id);

Line 60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);

56: dbms_sql.bind_variable(v_cursor_id, ':xcoll', upper(p_collection_view_name));
57: dbms_sql.bind_variable(v_cursor_id, ':xit', upper(p_Interface_table_name));
58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:
62: v_ret_code := dbms_sql.execute(v_cursor_id);
63: dbms_sql.close_cursor(v_cursor_id);
64:

Line 62: v_ret_code := dbms_sql.execute(v_cursor_id);

58: dbms_sql.bind_variable(v_cursor_id, ':xobj', upper(p_object_name));
59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:
62: v_ret_code := dbms_sql.execute(v_cursor_id);
63: dbms_sql.close_cursor(v_cursor_id);
64:
65:
66: EXCEPTION

Line 63: dbms_sql.close_cursor(v_cursor_id);

59: dbms_sql.bind_variable(v_cursor_id, ':xlvl', upper(p_level_name));
60: dbms_sql.bind_variable(v_cursor_id, ':xver', p_version);
61:
62: v_ret_code := dbms_sql.execute(v_cursor_id);
63: dbms_sql.close_cursor(v_cursor_id);
64:
65:
66: EXCEPTION
67: WHEN others THEN

Line 163: v_cursor_id := dbms_sql.open_cursor;

159: last_update_date, last_updated_by, last_update_login, created_by, creation_date)
160: values (:xobject, :xflexview, :xflexcode, :xprefix,
161: :xappid, :xappname, :xflextype, :xflexname, :xversion,
162: sysdate, 1, 1, 1, sysdate) ';
163: v_cursor_id := dbms_sql.open_cursor;
164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);

Line 164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);

160: values (:xobject, :xflexview, :xflexcode, :xprefix,
161: :xappid, :xappname, :xflextype, :xflexname, :xversion,
162: sysdate, 1, 1, 1, sysdate) ';
163: v_cursor_id := dbms_sql.open_cursor;
164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);

Line 165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));

161: :xappid, :xappname, :xflextype, :xflexname, :xversion,
162: sysdate, 1, 1, 1, sysdate) ';
163: v_cursor_id := dbms_sql.open_cursor;
164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);

Line 166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));

162: sysdate, 1, 1, 1, sysdate) ';
163: v_cursor_id := dbms_sql.open_cursor;
164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);

Line 167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);

163: v_cursor_id := dbms_sql.open_cursor;
164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);

Line 168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);

164: dbms_sql.parse(v_cursor_id, v_sql_stmt, DBMS_SQL.V7);
165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);

Line 169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);

165: dbms_sql.bind_variable(v_cursor_id, ':xobject', upper(p_object_name));
166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);

Line 170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);

166: dbms_sql.bind_variable(v_cursor_id, ':xflexview', upper(p_flex_view_name));
167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:

Line 171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);

167: dbms_sql.bind_variable(v_cursor_id, ':xflexcode', p_flex_field_code);
168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:
175:

Line 172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);

168: dbms_sql.bind_variable(v_cursor_id, ':xprefix', p_flex_field_prefix);
169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:
175:
176: v_ret_code := dbms_sql.execute(v_cursor_id);

Line 173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);

169: dbms_sql.bind_variable(v_cursor_id, ':xappid', p_application_id);
170: dbms_sql.bind_variable(v_cursor_id, ':xappname', p_application_short_name);
171: dbms_sql.bind_variable(v_cursor_id, ':xflextype', p_flex_field_type);
172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:
175:
176: v_ret_code := dbms_sql.execute(v_cursor_id);
177: dbms_sql.close_cursor(v_cursor_id);

Line 176: v_ret_code := dbms_sql.execute(v_cursor_id);

172: dbms_sql.bind_variable(v_cursor_id, ':xflexname', p_flex_field_name);
173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:
175:
176: v_ret_code := dbms_sql.execute(v_cursor_id);
177: dbms_sql.close_cursor(v_cursor_id);
178:
179: EXCEPTION
180: WHEN others THEN

Line 177: dbms_sql.close_cursor(v_cursor_id);

173: dbms_sql.bind_variable(v_cursor_id, ':xversion', p_version);
174:
175:
176: v_ret_code := dbms_sql.execute(v_cursor_id);
177: dbms_sql.close_cursor(v_cursor_id);
178:
179: EXCEPTION
180: WHEN others THEN
181: raise;