APPS.GMD_TEST_VALUES_PKG dependencies on GMD_TEST_VALUES_B

Line 21: cursor C is select ROWID from GMD_TEST_VALUES_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from GMD_TEST_VALUES_B
22: where QCASSY_VAL_ID = X_QCASSY_VAL_ID
23: ;
24: begin
25: insert into GMD_TEST_VALUES_B (

Line 25: insert into GMD_TEST_VALUES_B (

21: cursor C is select ROWID from GMD_TEST_VALUES_B
22: where QCASSY_VAL_ID = X_QCASSY_VAL_ID
23: ;
24: begin
25: insert into GMD_TEST_VALUES_B (
26: QCASSY_VAL_ID,
27: QCASSY_TYP_ID,
28: ORGN_CODE,
29: ASSAY_CODE,

Line 118: from GMD_TEST_VALUES_B

114: TEXT_CODE,
115: VALUE_NUM_MIN,
116: VALUE_NUM_MAX,
117: ASSAY_VALUE_RANGE_ORDER
118: from GMD_TEST_VALUES_B
119: where QCASSY_VAL_ID = X_QCASSY_VAL_ID
120: for update of QCASSY_VAL_ID nowait;
121: recinfo c%rowtype;
122:

Line 190: update GMD_TEST_VALUES_B set

186: X_LAST_UPDATED_BY in NUMBER,
187: X_LAST_UPDATE_LOGIN in NUMBER
188: ) is
189: begin
190: update GMD_TEST_VALUES_B set
191: ORGN_CODE = X_ORGN_CODE,
192: ASSAY_CODE = X_ASSAY_CODE,
193: ASSAY_VALUE = X_ASSAY_VALUE,
194: TEXT_CODE = X_TEXT_CODE,

Line 233: delete from GMD_TEST_VALUES_B

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from GMD_TEST_VALUES_B
234: where QCASSY_VAL_ID = X_QCASSY_VAL_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 247: from GMD_TEST_VALUES_B B

243: begin
244: delete from GMD_TEST_VALUES_TL T
245: where not exists
246: (select NULL
247: from GMD_TEST_VALUES_B B
248: where B.QCASSY_VAL_ID = T.QCASSY_VAL_ID
249: );
250:
251: update GMD_TEST_VALUES_TL T set (