APPS.OPI_EDW_OPM_PRD_PKG dependencies on QC_SMPL_MST

Line 54: select count(*) into NO_OF_SAMPLES_v from qc_smpl_mst

50: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V1 then
51: return PKG_VAR_NO_OF_SAMPLES_V;
52: end if;
53:
54: select count(*) into NO_OF_SAMPLES_v from qc_smpl_mst
55: where batch_id = BATCH_ID_VI;
56:
57: PKG_VAR_BATCH_ID_V1 := BATCH_ID_vi;
58: PKG_VAR_NO_OF_SAMPLES_V := NO_OF_SAMPLES_v;

Line 72: select count(*) into COMPLET_SAMPLES_v from qc_smpl_mst

68: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V4 then
69: return PKG_VAR_NO_OF_SMPL_CMPLT_V;
70: end if;
71:
72: select count(*) into COMPLET_SAMPLES_v from qc_smpl_mst
73: where batch_id = BATCH_ID_VI
74: and sample_status in ('ACCEPT','REJECT');
75:
76: PKG_VAR_BATCH_ID_V4 := BATCH_ID_vi;

Line 91: select count(*) into PASSED_SAMPLES_V from qc_smpl_mst

87: if BATCH_ID_vi = PKG_VAR_BATCH_ID_V2 then
88: return PKG_VAR_PASSED_SAMPLES_V;
89: end if;
90:
91: select count(*) into PASSED_SAMPLES_V from qc_smpl_mst
92: where batch_id = BATCH_ID_VI
93: and sample_status = 'ACCEPT';
94:
95: PKG_VAR_BATCH_ID_V2 := BATCH_ID_vi;