195: DELETE FROM gmd_msnr_results
196: WHERE concurrent_id IS NULL;
197:
198: l_cursor_id := DBMS_SQL.open_cursor;
199: fnd_dsql.set_cursor (l_cursor_id);
200: l_dsql_text := fnd_dsql.get_text (FALSE);
201: l_debug_text := fnd_dsql.get_text (TRUE);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);
203: --raghav_debug ('l_debug_text ' || l_debug_text);
196: WHERE concurrent_id IS NULL;
197:
198: l_cursor_id := DBMS_SQL.open_cursor;
199: fnd_dsql.set_cursor (l_cursor_id);
200: l_dsql_text := fnd_dsql.get_text (FALSE);
201: l_debug_text := fnd_dsql.get_text (TRUE);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);
203: --raghav_debug ('l_debug_text ' || l_debug_text);
204:
197:
198: l_cursor_id := DBMS_SQL.open_cursor;
199: fnd_dsql.set_cursor (l_cursor_id);
200: l_dsql_text := fnd_dsql.get_text (FALSE);
201: l_debug_text := fnd_dsql.get_text (TRUE);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);
203: --raghav_debug ('l_debug_text ' || l_debug_text);
204:
205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);
202: --raghav_debug ('l_dsql_text ' || l_dsql_text);
203: --raghav_debug ('l_debug_text ' || l_debug_text);
204:
205: DBMS_SQL.parse (l_cursor_id, l_dsql_text, DBMS_SQL.native);
206: fnd_dsql.do_binds;
207:
208: DBMS_SQL.define_column (l_cursor_id, 1, l_object_id);
209: DBMS_SQL.define_column (l_cursor_id, 2, l_object_name, 240);
210: DBMS_SQL.define_column (l_cursor_id, 3, l_object_vers);