APPS.GMD_SPEC_VRS_GRP dependencies on GMD_QC_STATUS

Line 101: FROM gmd_qc_status

97:
98:
99: CURSOR c_status (p_status_code NUMBER) IS
100: SELECT 1
101: FROM gmd_qc_status
102: WHERE status_code = p_status_code
103: AND delete_mark = 0;
104:
105:

Line 496: -- Check that Spec VR Status exist in GMD_QC_STATUS

492:
493: --=========================================================================
494: -- spec_vr_status :
495: --=========================================================================
496: -- Check that Spec VR Status exist in GMD_QC_STATUS
497: OPEN c_status(l_mon_vr.spec_vr_status);
498: FETCH c_status
499: INTO dummy;
500: IF (c_status%NOTFOUND)

Line 597: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status

593: )
594: AND ( floor(vr.spec_vr_status / 100) = floor(p_mon_vr.spec_vr_status/100) AND
595: /* Bug 3090290; allow duplicate spec vr with "OBSOLUTE" status */
596: p_mon_vr.spec_vr_status <> 1000 )
597: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status
598: WHERE status_type = 800)
599: AND vr.delete_mark = 0
600: AND s.delete_mark = 0
601: AND vr.spec_vr_id <> NVL(p_mon_vr.spec_vr_id, -1)

Line 1119: -- Check that Spec VR Status exist in GMD_QC_STATUS

1115:
1116: --=========================================================================
1117: -- spec_vr_status :
1118: --=========================================================================
1119: -- Check that Spec VR Status exist in GMD_QC_STATUS
1120: OPEN c_status(l_inv_vr.spec_vr_status);
1121: FETCH c_status
1122: INTO dummy;
1123: IF (c_status%NOTFOUND)

Line 1232: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status

1228: )
1229: AND ( floor(vr.spec_vr_status / 100) = floor(p_inv_vr.spec_vr_status/100) AND
1230: /* Bug 3090290; allow duplicate spec vr with "OBSOLUTE" status */
1231: p_inv_vr.spec_vr_status <> 1000 )
1232: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status
1233: WHERE status_type = 800)
1234: AND vr.delete_mark = 0
1235: AND s.delete_mark = 0
1236: AND vr.spec_vr_id <> NVL(p_inv_vr.spec_vr_id, -1)

Line 2456: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status

2452: p_wip_vr.spec_vr_status <> 1000 )
2453:
2454: /* Bug 3090290 - Here's the problem - Both spec vr's have the same status 1000 */
2455: /* obsolete */
2456: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status
2457: WHERE status_type = 800)
2458: AND vr.delete_mark = 0
2459: AND s.delete_mark = 0
2460: AND vr.spec_vr_id <> NVL(p_wip_vr.spec_vr_id, -1)

Line 3103: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status

3099: )
3100: AND ( floor(vr.spec_vr_status/100) = floor(p_cust_vr.spec_vr_status/100) AND
3101: /* Bug 3090290; allow duplicate spec vr with "OBSOLUTE" status */
3102: p_cust_vr.spec_vr_status <> 1000 )
3103: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status
3104: WHERE status_type = 800)
3105: AND vr.delete_mark = 0
3106: AND s.delete_mark = 0
3107: AND vr.spec_vr_id <> NVL(p_cust_vr.spec_vr_id, -1)

Line 3731: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status

3727: )
3728: AND ( floor(vr.spec_vr_status/100) = floor(p_supp_vr.spec_vr_status/100) AND
3729: /* Bug 3090290; allow duplicate spec vr with "OBSOLUTE" status */
3730: p_supp_vr.spec_vr_status <> 1000 )
3731: AND vr.spec_vr_status NOT IN (SELECT status_code FROM gmd_qc_status
3732: WHERE status_type = 800)
3733: AND vr.delete_mark = 0
3734: AND s.delete_mark = 0
3735: AND vr.spec_vr_id <> NVL(p_supp_vr.spec_vr_id, -1)