APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_SPEC_TESTS_B

Line 2754: p_table_name => 'GMD_SPEC_TESTS_B',

2750: EXCEPTION
2751: WHEN others THEN
2752: GMA_MIGRATION.gma_insert_message (
2753: p_run_id => p_migration_id,
2754: p_table_name => 'GMD_SPEC_TESTS_B',
2755: p_DB_ERROR => '',
2756: p_param1 => l_spec_id,
2757: p_param2 => sd.qcassy_typ_id,
2758: p_param3 => sd.text_code,

Line 2775: INSERT INTO gmd_spec_tests_b

2771: END IF;
2772:
2773: -- END Bug 4898620
2774:
2775: INSERT INTO gmd_spec_tests_b
2776: (
2777: spec_id,
2778: test_id,
2779: test_method_id,

Line 3016: /* UPDATE gmd_spec_tests_b

3012: -- Bug 3097029; expression error type requires at least
3013: -- one action code specified; if none specified,
3014: -- set to NULL
3015: --
3016: /* UPDATE gmd_spec_tests_b
3017: set exp_error_type = NULL
3018: where below_min_action_code is null
3019: and above_max_action_code is null
3020: and above_min_action_code is null

Line 5299: FROM gmd_spec_tests_b

5295:
5296: /* Check that test is in the spec */
5297: CURSOR c_check_spec (pspec_id NUMBER, ptest_id NUMBER) IS
5298: SELECT 1
5299: FROM gmd_spec_tests_b
5300: WHERE spec_id = pspec_id
5301: AND test_id = ptest_id;
5302:
5303: /* Retrieve the next sequence number for use in gmd_spec_tests_b */

Line 5303: /* Retrieve the next sequence number for use in gmd_spec_tests_b */

5299: FROM gmd_spec_tests_b
5300: WHERE spec_id = pspec_id
5301: AND test_id = ptest_id;
5302:
5303: /* Retrieve the next sequence number for use in gmd_spec_tests_b */
5304: CURSOR c_get_spec_seq (pspec_id NUMBER) IS
5305: SELECT NVL(max(seq),0) + 10
5306: FROM gmd_spec_tests_b
5307: WHERE spec_id = pspec_id;

Line 5306: FROM gmd_spec_tests_b

5302:
5303: /* Retrieve the next sequence number for use in gmd_spec_tests_b */
5304: CURSOR c_get_spec_seq (pspec_id NUMBER) IS
5305: SELECT NVL(max(seq),0) + 10
5306: FROM gmd_spec_tests_b
5307: WHERE spec_id = pspec_id;
5308:
5309: /* Retrieve the value of retest_lot_expiry_ind for use in gmd_spec_tests_b */
5310: CURSOR c_get_retest_lot (pspec_id NUMBER) IS

Line 5309: /* Retrieve the value of retest_lot_expiry_ind for use in gmd_spec_tests_b */

5305: SELECT NVL(max(seq),0) + 10
5306: FROM gmd_spec_tests_b
5307: WHERE spec_id = pspec_id;
5308:
5309: /* Retrieve the value of retest_lot_expiry_ind for use in gmd_spec_tests_b */
5310: CURSOR c_get_retest_lot (pspec_id NUMBER) IS
5311: SELECT retest_lot_expiry_ind
5312: FROM gmd_spec_tests_b
5313: WHERE spec_id = pspec_id;

Line 5312: FROM gmd_spec_tests_b

5308:
5309: /* Retrieve the value of retest_lot_expiry_ind for use in gmd_spec_tests_b */
5310: CURSOR c_get_retest_lot (pspec_id NUMBER) IS
5311: SELECT retest_lot_expiry_ind
5312: FROM gmd_spec_tests_b
5313: WHERE spec_id = pspec_id;
5314:
5315: BEGIN
5316: