APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_MSNR_RESULTS

Line 103: DELETE FROM gmd_msnr_results

99: l_debug_text VARCHAR2(2000);
100:
101: BEGIN
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);

Line 153: INSERT INTO gmd_msnr_results

149: X_search_tbl(l_row_cnt).object_select_ind := l_object_select_ind ;
150: X_search_tbl(l_row_cnt).object_status_code := l_object_status_code ;
151:
152: -- Save the set of details in work table
153: INSERT INTO gmd_msnr_results
154: ( concurrent_id
155: ,object_id
156: ,object_name
157: ,object_vers

Line 300: FROM gmd_msnr_results

296: ,object_vers -- e.g formula_vers = 2
297: ,object_desc
298: ,object_status_code -- e.g formula_status = '100'
299: ,concurrent_id
300: FROM gmd_msnr_results
301: WHERE object_select_ind = 1 AND
302: concurrent_id = pConcurrent_id;
303:
304: CURSOR Check_version_enabled(vStatus VARCHAR2) IS

Line 1846: FROM gmd_msnr_results

1842: -- If MSNR was successful until here then
1843: -- Delete rows specific to this concurrent id
1844: IF (pConcurrent_id IS NOT NULL) THEN
1845: DELETE
1846: FROM gmd_msnr_results
1847: WHERE concurrent_id = pconcurrent_id;
1848: COMMIT;
1849: END IF;
1850:

Line 1941: From Gmd_MSNR_Results

1937: l_primary_key VARCHAR2(100);
1938:
1939: CURSOR get_select_id IS
1940: Select object_id
1941: From Gmd_MSNR_Results
1942: Where concurrent_id IS NULL
1943: And object_select_ind = 1;
1944:
1945: VALIDATION_FAILED_EXCEPTION EXCEPTION;

Line 1953: FROM Gmd_MSNR_Results

1949: x_return_status := 'S';
1950:
1951: SELECT count(*)
1952: INTO l_row_count
1953: FROM Gmd_MSNR_Results
1954: WHERE object_select_ind = 1
1955: AND Concurrent_id IS NULL;
1956:
1957: SELECT DECODE(pObject_type,

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

2023:
2024: END IF;
2025:
2026: fnd_dsql.init;
2027: fnd_dsql.add_text( ' Update Gmd_MSNR_Results '||
2028: ' Set Object_select_ind = 0 '||
2029: ' Where concurrent_id IS NULL '||
2030: ' And Object_select_ind = 1 '||
2031: ' And object_id NOT IN ( Select object_id '||

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

2028: ' Set Object_select_ind = 0 '||
2029: ' Where concurrent_id IS NULL '||
2030: ' And Object_select_ind = 1 '||
2031: ' And object_id NOT IN ( Select object_id '||
2032: ' From Gmd_MSNR_Results, '||l_table_name||
2033: ' Where '||l_primary_key||' = object_id'||
2034: ' And concurrent_id IS NULL '||
2035: ' And Object_select_ind = 1' );
2036: IF (pOld_Name = ' ' or pOld_name IS NULL) THEN