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

Line 106: l_cursor_id := dbms_sql.open_cursor;

102: -- Delete rows from previous searches
103: DELETE FROM gmd_msnr_results
104: WHERE concurrent_id IS NULL;
105:
106: l_cursor_id := dbms_sql.open_cursor;
107: fnd_dsql.set_cursor(l_cursor_id);
108: l_dsql_text := fnd_dsql.get_text(FALSE);
109:
110: l_debug_text := fnd_dsql.get_text(TRUE);

Line 113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);

109:
110: l_debug_text := fnd_dsql.get_text(TRUE);
111: --insert into shy_text values (l_debug_text); commit;
112:
113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
114: fnd_dsql.do_binds;
115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );

Line 116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );

112:
113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
114: fnd_dsql.do_binds;
115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );

Line 117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );

113: dbms_sql.parse(l_cursor_id, l_dsql_text, dbms_sql.native);
114: fnd_dsql.do_binds;
115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );

Line 118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );

114: fnd_dsql.do_binds;
115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );

Line 119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );

115:
116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
123:

Line 120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );

116: dbms_sql.define_column(l_cursor_id, 1, l_Object_id );
117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
123:
124: l_num_of_rows := dbms_sql.execute(l_cursor_id);

Line 121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );

117: dbms_sql.define_column(l_cursor_id, 2, l_object_name, 240 );
118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
123:
124: l_num_of_rows := dbms_sql.execute(l_cursor_id);
125:

Line 122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );

118: dbms_sql.define_column(l_cursor_id, 3, l_object_vers );
119: dbms_sql.define_column(l_cursor_id, 4, l_object_desc, 240 );
120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
123:
124: l_num_of_rows := dbms_sql.execute(l_cursor_id);
125:
126: LOOP

Line 124: l_num_of_rows := dbms_sql.execute(l_cursor_id);

120: dbms_sql.define_column(l_cursor_id, 5, l_object_status_desc, 240 );
121: dbms_sql.define_column(l_cursor_id, 6, l_object_select_ind );
122: dbms_sql.define_column(l_cursor_id, 7, l_object_status_code, 240 );
123:
124: l_num_of_rows := dbms_sql.execute(l_cursor_id);
125:
126: LOOP
127: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
128: l_row_cnt := l_row_cnt + 1;

Line 127: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then

123:
124: l_num_of_rows := dbms_sql.execute(l_cursor_id);
125:
126: LOOP
127: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
128: l_row_cnt := l_row_cnt + 1;
129:
130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );

Line 130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );

126: LOOP
127: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
128: l_row_cnt := l_row_cnt + 1;
129:
130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );

Line 131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );

127: IF dbms_sql.fetch_rows(l_cursor_id) > 0 then
128: l_row_cnt := l_row_cnt + 1;
129:
130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );

Line 132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );

128: l_row_cnt := l_row_cnt + 1;
129:
130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );

Line 133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );

129:
130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
137:

Line 134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );

130: dbms_sql.column_value(l_cursor_id, 1, l_Object_id );
131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
137:
138: IF (l_object_status_code IN ('200','500','800','1000')) THEN

Line 135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );

131: dbms_sql.column_value(l_cursor_id, 2, l_object_name );
132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
137:
138: IF (l_object_status_code IN ('200','500','800','1000')) THEN
139: l_object_select_ind := 0;

Line 136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );

132: dbms_sql.column_value(l_cursor_id, 3, l_object_vers );
133: dbms_sql.column_value(l_cursor_id, 4, l_object_desc );
134: dbms_sql.column_value(l_cursor_id, 5, l_object_status_desc );
135: dbms_sql.column_value(l_cursor_id, 6, l_object_select_ind );
136: dbms_sql.column_value(l_cursor_id, 7, l_object_status_code );
137:
138: IF (l_object_status_code IN ('200','500','800','1000')) THEN
139: l_object_select_ind := 0;
140: END IF;

Line 178: dbms_sql.close_cursor(l_cursor_id);

174: EXIT;
175: END IF;
176: END LOOP;
177:
178: dbms_sql.close_cursor(l_cursor_id);
179: -- Commit all data populated
180: --Commit; Bug 4479488 Commented the commit
181: EXCEPTION
182: WHEN OTHERS THEN

Line 183: IF (dbms_sql.is_open(l_cursor_id)) THEN

179: -- Commit all data populated
180: --Commit; Bug 4479488 Commented the commit
181: EXCEPTION
182: WHEN OTHERS THEN
183: IF (dbms_sql.is_open(l_cursor_id)) THEN
184: dbms_sql.close_cursor(l_cursor_id);
185: END IF;
186: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
187: END Populate_search_table;

Line 184: dbms_sql.close_cursor(l_cursor_id);

180: --Commit; Bug 4479488 Commented the commit
181: EXCEPTION
182: WHEN OTHERS THEN
183: IF (dbms_sql.is_open(l_cursor_id)) THEN
184: dbms_sql.close_cursor(l_cursor_id);
185: END IF;
186: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);
187: END Populate_search_table;
188:

Line 2102: l_cursor_id := dbms_sql.open_cursor;

2098: END IF;
2099:
2100: END IF;
2101:
2102: l_cursor_id := dbms_sql.open_cursor;
2103: fnd_dsql.set_cursor(l_cursor_id);
2104: l_dynamic_select := fnd_dsql.get_text(FALSE);
2105:
2106: l_dsql_debug := fnd_dsql.get_text(TRUE);

Line 2111: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);

2107: IF (l_debug = 'Y') THEN
2108: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : l_dsql_debug = '||l_dsql_debug);
2109: END IF;
2110:
2111: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2112: fnd_dsql.do_binds;
2113:
2114: pRows_Processed := dbms_sql.execute(l_cursor_id);
2115:

Line 2114: pRows_Processed := dbms_sql.execute(l_cursor_id);

2110:
2111: dbms_sql.parse(l_cursor_id, l_dynamic_select, dbms_sql.native);
2112: fnd_dsql.do_binds;
2113:
2114: pRows_Processed := dbms_sql.execute(l_cursor_id);
2115:
2116: IF (l_debug = 'Y') THEN
2117: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Rows fetched = '||pRows_Processed||
2118: ' and Original select cnt = '||l_row_count);

Line 2121: dbms_sql.close_cursor(l_cursor_id); -- close cursor

2117: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Rows fetched = '||pRows_Processed||
2118: ' and Original select cnt = '||l_row_count);
2119: END IF;
2120:
2121: dbms_sql.close_cursor(l_cursor_id); -- close cursor
2122:
2123: IF (l_debug = 'Y') THEN
2124: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : pRows_Processed = '||pRows_Processed);
2125: END IF;