APPS.GMD_QMSMC dependencies on GMD_SUPPLIER_SPEC_VRS

Line 491: from GMD_SUPPLIER_SPEC_VRS

487: where spec_vr_id = X_SPEC_VR_ID;
488:
489: CURSOR supplier_auto_sample(X_SPEC_VR_ID number) is
490: Select nvl(auto_sample_ind, 'N')
491: from GMD_SUPPLIER_SPEC_VRS
492: where spec_vr_id = X_SPEC_VR_ID;
493:
494: CURSOR specvr_auto_sample(X_SPEC_VR_ID number) is
495: Select nvl(auto_sample_ind, 'N')

Line 1153: UPDATE GMD_SUPPLIER_SPEC_VRS

1149: ELSIF (l_frequency_type = 'F') THEN
1150: -- Bug 3617267
1151: r := 0; --Added in Bug No.8222504
1152: --RLNAGARA Bug 5910300 start
1153: UPDATE GMD_SUPPLIER_SPEC_VRS
1154: SET RECEIPT_FREQUENCY = NVL(RECEIPT_FREQUENCY, 0) + 1 --RLNAGARA Bug 5910300 Rework Added NVL
1155: WHERE SPEC_VR_ID = l_spec_vr_id;
1156:
1157: IF (SQL%ROWCOUNT <> 0) THEN

Line 1161: from GMD_SUPPLIER_SPEC_VRS

1157: IF (SQL%ROWCOUNT <> 0) THEN
1158: --Added IF in Bug No.8222504
1159: select RECEIPT_FREQUENCY
1160: into r
1161: from GMD_SUPPLIER_SPEC_VRS
1162: where spec_vr_id = l_spec_vr_id;
1163: END IF;
1164:
1165: IF r <> l_frequency_count THEN

Line 1169: UPDATE GMD_SUPPLIER_SPEC_VRS

1165: IF r <> l_frequency_count THEN
1166: p_resultout := 'COMPLETE:';
1167: -- RETURN; --Commented in Bug No.8222504
1168: ELSE
1169: UPDATE GMD_SUPPLIER_SPEC_VRS
1170: SET RECEIPT_FREQUENCY = 0
1171: WHERE SPEC_VR_ID = l_spec_vr_id;
1172: l_sampling_events.sample_req_cnt := l_sample_count;
1173: END IF;