APPS.GMD_QM_CONC_REPLACE_PKG dependencies on GMD_MSNR_RESULTS

Line 195: DELETE FROM gmd_msnr_results

191: l_object_status_code VARCHAR2 (240);
192: l_debug_text VARCHAR2 (2000);
193: BEGIN
194: -- Delete rows from previous searches
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);

Line 243: INSERT INTO gmd_msnr_results

239: x_search_tbl (l_row_cnt).object_select_ind := l_object_select_ind;
240: x_search_tbl (l_row_cnt).object_status_code := l_object_status_code;
241:
242: -- Save the set of details in work table
243: INSERT INTO gmd_msnr_results
244: (concurrent_id
245: , object_id
246: , object_name
247: , object_vers

Line 406: FROM gmd_msnr_results

402: , object_vers -- e.g formula_vers = 2
403: , object_desc
404: , object_status_code -- e.g formula_status = '100'
405: , concurrent_id
406: FROM gmd_msnr_results
407: WHERE object_select_ind = 1
408: AND concurrent_id = TO_NUMBER (pconcurrent_id);
409:
410: CURSOR get_gmd_test1 (p_test_name IN VARCHAR2) IS

Line 1543: DELETE FROM gmd_msnr_results

1539:
1540: -- If MSNR was successful until here then
1541: -- Delete rows specific to this concurrent id
1542: IF (pconcurrent_id IS NOT NULL) THEN
1543: DELETE FROM gmd_msnr_results
1544: WHERE concurrent_id = TO_NUMBER (pconcurrent_id);
1545: COMMIT;
1546: END IF;
1547: