APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_MSNR_RESULTS

Line 176: execute immediate 'INSERT INTO gmd_msnr_results

172: END IF;
173: END LOOP;
174: -- oracleabc('The sql is:'||l_dsql_text);
175: --dbms_output.put_line(l_dsql_text);
176: execute immediate 'INSERT INTO gmd_msnr_results
177: ( object_id
178: ,object_name
179: ,object_vers
180: ,object_desc

Line 186: update gmd_msnr_results

182: ,object_select_ind
183: ,object_status_code
184: ) ' || l_dsql_text;
185:
186: update gmd_msnr_results
187: set object_select_ind = 0
188: where object_status_code in ('200', '500', '800', '1000');
189:
190: open c_Search_Result for l_dsql_text;

Line 233: DELETE FROM gmd_msnr_results WHERE concurrent_id IS NULL;

229: l_debug_text VARCHAR2(2000); */
230:
231: BEGIN
232: -- Delete rows from previous searches
233: DELETE FROM gmd_msnr_results WHERE concurrent_id IS NULL;
234: /*
235: l_cursor_id := dbms_sql.open_cursor;
236: fnd_dsql.set_cursor(l_cursor_id);
237: l_dsql_text := fnd_dsql.get_text(FALSE);

Line 282: INSERT INTO gmd_msnr_results

278: X_search_tbl(l_row_cnt).object_select_ind := l_object_select_ind ;
279: X_search_tbl(l_row_cnt).object_status_code := l_object_status_code ;
280:
281: -- Save the set of details in work table
282: INSERT INTO gmd_msnr_results
283: ( concurrent_id
284: ,object_id
285: ,object_name
286: ,object_vers

Line 453: FROM gmd_msnr_results

449: ,object_vers -- e.g formula_vers = 2
450: ,object_desc
451: ,object_status_code -- e.g formula_status = '100'
452: ,concurrent_id
453: FROM gmd_msnr_results
454: WHERE object_select_ind = 1 AND
455: concurrent_id = pConcurrent_id;
456:
457: CURSOR Check_version_enabled(vStatus VARCHAR2) IS

Line 2032: FROM gmd_msnr_results

2028: -- If MSNR was successful until here then
2029: -- Delete rows specific to this concurrent id
2030: IF (pConcurrent_id IS NOT NULL) THEN
2031: DELETE
2032: FROM gmd_msnr_results
2033: WHERE concurrent_id = pconcurrent_id;
2034: COMMIT;
2035: END IF;
2036:

Line 2127: From Gmd_MSNR_Results

2123: l_primary_key VARCHAR2(100);
2124:
2125: CURSOR get_select_id IS
2126: Select object_id
2127: From Gmd_MSNR_Results
2128: Where concurrent_id IS NULL
2129: And object_select_ind = 1;
2130:
2131: VALIDATION_FAILED_EXCEPTION EXCEPTION;

Line 2139: FROM Gmd_MSNR_Results

2135: x_return_status := 'S';
2136:
2137: SELECT count(*)
2138: INTO l_row_count
2139: FROM Gmd_MSNR_Results
2140: WHERE object_select_ind = 1
2141: AND Concurrent_id IS NULL;
2142:
2143: SELECT DECODE(pObject_type,

Line 2213: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||

2209:
2210: END IF;
2211:
2212: fnd_dsql.init;
2213: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2214: ' Set Object_select_ind = 0 '||
2215: ' Where concurrent_id IS NULL '||
2216: ' And Object_select_ind = 1 '||
2217: ' And object_id NOT IN ( Select object_id '||

Line 2218: ' From Gmd_MSNR_Results, '||l_table_name||

2214: ' Set Object_select_ind = 0 '||
2215: ' Where concurrent_id IS NULL '||
2216: ' And Object_select_ind = 1 '||
2217: ' And object_id NOT IN ( Select object_id '||
2218: ' From Gmd_MSNR_Results, '||l_table_name||
2219: ' Where '||l_primary_key||' = object_id'||
2220: ' And concurrent_id IS NULL '||
2221: ' And Object_select_ind = 1' );
2222: IF (pOld_Name = ' ' or pOld_name IS NULL) THEN