APPS.GMD_QMSMC dependencies on GMD_SUPPLIER_SPEC_VRS

Line 396: from GMD_SUPPLIER_SPEC_VRS

392: where spec_vr_id = X_SPEC_VR_ID ;
393:
394: CURSOR supplier_auto_sample ( X_SPEC_VR_ID number) is
395: Select nvl(auto_sample_ind,'N')
396: from GMD_SUPPLIER_SPEC_VRS
397: where spec_vr_id = X_SPEC_VR_ID ;
398:
399: CURSOR specvr_auto_sample ( X_SPEC_VR_ID number) is
400: Select nvl(auto_sample_ind,'N')

Line 1000: UPDATE GMD_SUPPLIER_SPEC_VRS

996: l_sampling_events.sample_req_cnt := floor(l_qty_conv / l_frequency_count) * l_sample_count;
997:
998: ELSIF (l_frequency_type = 'F') THEN -- Bug 3617267
999: --RLNAGARA Bug 5910300 start
1000: UPDATE GMD_SUPPLIER_SPEC_VRS
1001: SET RECEIPT_FREQUENCY = NVL(RECEIPT_FREQUENCY,0) + 1 --RLNAGARA Bug 5910300 Rework Added NVL
1002: WHERE SPEC_VR_ID = l_spec_vr_id;
1003: select RECEIPT_FREQUENCY into r from GMD_SUPPLIER_SPEC_VRS
1004: where spec_vr_id = l_spec_vr_id;

Line 1003: select RECEIPT_FREQUENCY into r from GMD_SUPPLIER_SPEC_VRS

999: --RLNAGARA Bug 5910300 start
1000: UPDATE GMD_SUPPLIER_SPEC_VRS
1001: SET RECEIPT_FREQUENCY = NVL(RECEIPT_FREQUENCY,0) + 1 --RLNAGARA Bug 5910300 Rework Added NVL
1002: WHERE SPEC_VR_ID = l_spec_vr_id;
1003: select RECEIPT_FREQUENCY into r from GMD_SUPPLIER_SPEC_VRS
1004: where spec_vr_id = l_spec_vr_id;
1005: IF r <> l_frequency_count THEN
1006: p_resultout := 'COMPLETE:';
1007: RETURN;

Line 1009: UPDATE GMD_SUPPLIER_SPEC_VRS

1005: IF r <> l_frequency_count THEN
1006: p_resultout := 'COMPLETE:';
1007: RETURN;
1008: ELSE
1009: UPDATE GMD_SUPPLIER_SPEC_VRS
1010: SET RECEIPT_FREQUENCY = 0
1011: WHERE SPEC_VR_ID = l_spec_vr_id;
1012: l_sampling_events.sample_req_cnt := l_sample_count;
1013: END IF;