APPS.GMD_QMSMC dependencies on GMD_WIP_SPEC_VRS

Line 2020: gmd_wip_spec_vrs sv

2016: nvl(RESERVE_QTY, 0) reserve_qty,
2017: nvl(ARCHIVE_CNT_REQ,0) archive_cnt_req,
2018: nvl(ARCHIVE_QTY,0) archive_qty
2019: FROM gmd_sampling_plans_b sm,
2020: gmd_wip_spec_vrs sv
2021: WHERE sv.sampling_plan_id = sm.sampling_plan_id
2022: AND sv.spec_vr_id = X_SPEC_VR_ID;
2023:
2024: CURSOR wip_sample_plan_freq_per (x_frequency_per varchar2 ) IS

Line 2146: from GMD_WIP_SPEC_VRS

2142:
2143: /* Cursors to check if Spec VR has auto enable flag enabled */
2144: CURSOR wip_auto_sample ( X_SPEC_VR_ID number) is
2145: select nvl(auto_sample_ind,'N')
2146: from GMD_WIP_SPEC_VRS
2147: where spec_vr_id = X_SPEC_VR_ID ;
2148:
2149:
2150: /* Given a sampling event and a retain as, gets the sample numbers */

Line 2419: UPDATE GMD_WIP_SPEC_VRS

2415: FND_MESSAGE.SET_TOKEN('RGULAR_SAMPLES', fsample_name);
2416:
2417: --RLNAGARA Bug 5910300 start
2418: IF (l_frequency_type = 'F') THEN
2419: UPDATE GMD_WIP_SPEC_VRS
2420: SET BATCH_FREQUENCY = NVL(BATCH_FREQUENCY,0) + 1 --RLNAGARA Bug 5910300 Rework Added NVL
2421: WHERE SPEC_VR_ID = l_spec_vr_id;
2422: select batch_frequency into b from gmd_wip_spec_vrs
2423: where spec_vr_id = l_spec_vr_id;

Line 2422: select batch_frequency into b from gmd_wip_spec_vrs

2418: IF (l_frequency_type = 'F') THEN
2419: UPDATE GMD_WIP_SPEC_VRS
2420: SET BATCH_FREQUENCY = NVL(BATCH_FREQUENCY,0) + 1 --RLNAGARA Bug 5910300 Rework Added NVL
2421: WHERE SPEC_VR_ID = l_spec_vr_id;
2422: select batch_frequency into b from gmd_wip_spec_vrs
2423: where spec_vr_id = l_spec_vr_id;
2424:
2425: IF b <> l_frequency_count THEN
2426: p_resultout := 'COMPLETE:';

Line 2429: UPDATE GMD_WIP_SPEC_VRS

2425: IF b <> l_frequency_count THEN
2426: p_resultout := 'COMPLETE:';
2427: RETURN;
2428: ELSE
2429: UPDATE GMD_WIP_SPEC_VRS
2430: SET BATCH_FREQUENCY = 0
2431: WHERE SPEC_VR_ID = l_spec_vr_id;
2432: l_sampling_events.sample_req_cnt := l_sample_count;
2433: END IF;