APPS.GMD_TESTS_PKG dependencies on GMD_TESTS_B

Line 66: cursor C is select ROWID from GMD_TESTS_B

62: X_LAST_UPDATE_DATE in DATE,
63: X_LAST_UPDATED_BY in NUMBER,
64: X_LAST_UPDATE_LOGIN in NUMBER
65: ) is
66: cursor C is select ROWID from GMD_TESTS_B
67: where QCASSY_TYP_ID = X_QCASSY_TYP_ID
68: ;
69: begin
70: insert into GMD_TESTS_B (

Line 70: insert into GMD_TESTS_B (

66: cursor C is select ROWID from GMD_TESTS_B
67: where QCASSY_TYP_ID = X_QCASSY_TYP_ID
68: ;
69: begin
70: insert into GMD_TESTS_B (
71: QCASSY_TYP_ID,
72: ORGN_CODE,
73: ASSAY_CODE,
74: ASSAY_TYPE,

Line 341: from GMD_TESTS_B

337: INSIDE_MAX_ACTION_CODE,
338: OUTSIDE_MIN_ACTION_CODE,
339: OUTSIDE_MAX_ACTION_CODE,
340: INSIDE_MIN_ACTION_CODE
341: from GMD_TESTS_B
342: where QCASSY_TYP_ID = X_QCASSY_TYP_ID
343: for update of QCASSY_TYP_ID nowait;
344: recinfo c%rowtype;
345:

Line 546: update GMD_TESTS_B set

542: X_LAST_UPDATED_BY in NUMBER,
543: X_LAST_UPDATE_LOGIN in NUMBER
544: ) is
545: begin
546: update GMD_TESTS_B set
547: ORGN_CODE = X_ORGN_CODE,
548: ASSAY_CODE = X_ASSAY_CODE,
549: ASSAY_TYPE = X_ASSAY_TYPE,
550: QCUNIT_CODE = X_QCUNIT_CODE,

Line 634: delete from GMD_TESTS_B

630: if (sql%notfound) then
631: raise no_data_found;
632: end if;
633:
634: delete from GMD_TESTS_B
635: where QCASSY_TYP_ID = X_QCASSY_TYP_ID;
636:
637: if (sql%notfound) then
638: raise no_data_found;

Line 648: from GMD_TESTS_B B

644: begin
645: delete from GMD_TESTS_TL T
646: where not exists
647: (select NULL
648: from GMD_TESTS_B B
649: where B.QCASSY_TYP_ID = T.QCASSY_TYP_ID
650: );
651:
652: update GMD_TESTS_TL T set (