DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on FND_DSQL

Line 199: fnd_dsql.set_cursor (l_cursor_id);

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);

Line 200: l_dsql_text := fnd_dsql.get_text (FALSE);

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:

Line 201: l_debug_text := fnd_dsql.get_text (TRUE);

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);

Line 206: fnd_dsql.do_binds;

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);