APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SPECIFICATIONS_B

Line 2108: l_spec_status GMD_SPECIFICATIONS_B.spec_status%TYPE;

2104: l_version_end_date_a DATE;
2105: l_version_end_date_b DATE;
2106: l_new_start_date DATE;
2107: l_todays_date DATE := SYSDATE;
2108: l_spec_status GMD_SPECIFICATIONS_B.spec_status%TYPE;
2109: l_rec_count NUMBER := 0;
2110: l_retest_lot_exp_ind VARCHAR2(1);
2111: l_supplier_id NUMBER;
2112: l_supplier_site_id NUMBER;

Line 2418: where table_name='GMD_SPECIFICATIONS_B'

2414: -- Revert back to all_tab_columns since the file is delivered to 11.5.10
2415: CURSOR c_patch_level IS
2416: SELECT 'K+'
2417: from all_tab_columns
2418: where table_name='GMD_SPECIFICATIONS_B'
2419: and column_name='SPEC_TYPE'
2420: and owner = l_gmd;
2421:
2422:

Line 2465: l_sql_stmt := 'INSERT INTO gmd_specifications_b'

2461: -- B3883674 START
2462: -- Performance Improvement
2463: IF l_patch_level IS NULL THEN
2464: -- Customer is on J
2465: l_sql_stmt := 'INSERT INTO gmd_specifications_b'
2466: || '('
2467: || 'spec_id,'
2468: || 'spec_name,'
2469: || 'spec_vers,'

Line 2502: l_sql_stmt := 'INSERT INTO gmd_specifications_b'

2498:
2499: ELSE
2500: -- Customer is on K or onward
2501:
2502: l_sql_stmt := 'INSERT INTO gmd_specifications_b'
2503: || '('
2504: || 'spec_id,'
2505: || 'spec_name,'
2506: || 'spec_vers,'