APPS.GMD_SPEC_TESTS_PVT dependencies on GMD_SPEC_TESTS_B

Line 87: cursor C is select ROWID from GMD_SPEC_TESTS_B

83: X_TEST_EXPIRATION_SECONDS in number,
84: X_CALC_UOM_CONV_IND in VARCHAR2,
85: X_TO_QTY_UOM in VARCHAR2
86: ) is
87: cursor C is select ROWID from GMD_SPEC_TESTS_B
88: where SPEC_ID = X_SPEC_ID
89: and TEST_ID = X_TEST_ID
90: ;
91: begin

Line 92: insert into GMD_SPEC_TESTS_B (

88: where SPEC_ID = X_SPEC_ID
89: and TEST_ID = X_TEST_ID
90: ;
91: begin
92: insert into GMD_SPEC_TESTS_B (
93: ATTRIBUTE1,
94: ATTRIBUTE2,
95: MIN_VALUE_CHAR,
96: SPEC_ID,

Line 449: from GMD_SPEC_TESTS_B

445: MINUTES,
446: SECONDS,
447: CALC_UOM_CONV_IND,
448: TO_QTY_UOM
449: from GMD_SPEC_TESTS_B
450: where SPEC_ID = X_SPEC_ID
451: and TEST_ID = X_TEST_ID
452: for update of SPEC_ID nowait;
453: recinfo c%rowtype;

Line 720: update GMD_SPEC_TESTS_B set

716: X_CALC_UOM_CONV_IND in VARCHAR2,
717: X_TO_QTY_UOM in VARCHAR2
718: ) is
719: begin
720: update GMD_SPEC_TESTS_B set
721: ATTRIBUTE1 = X_ATTRIBUTE1,
722: ATTRIBUTE2 = X_ATTRIBUTE2,
723: MIN_VALUE_CHAR = X_MIN_VALUE_CHAR,
724: TEST_METHOD_ID = X_TEST_METHOD_ID,

Line 833: delete from GMD_SPEC_TESTS_B

829: if (sql%notfound) then
830: raise no_data_found;
831: end if;
832:
833: delete from GMD_SPEC_TESTS_B
834: where SPEC_ID = P_SPEC_ID
835: and TEST_ID = P_TEST_ID;
836:
837: if (sql%notfound) then

Line 865: from GMD_SPEC_TESTS_B B

861: begin
862: delete from GMD_SPEC_TESTS_TL T
863: where not exists
864: (select NULL
865: from GMD_SPEC_TESTS_B B
866: where B.SPEC_ID = T.SPEC_ID
867: and B.TEST_ID = T.TEST_ID
868: );
869:

Line 970: FROM gmd_spec_tests_b

966:
967: IF (p_spec_id IS NOT NULL) and (p_test_id is NOT NULL) THEN
968: SELECT spec_id
969: INTO dummy
970: FROM gmd_spec_tests_b
971: WHERE spec_id = p_spec_id
972: AND test_id = p_test_id
973: FOR UPDATE OF spec_id NOWAIT ;
974: ELSE