APPS.GMD_TEST_METHODS_PVT dependencies on GMD_TEST_METHODS_B

Line 74: cursor c1 is select * from GMD_TEST_METHODS_B where (TEST_METHOD_ID=X_TEST_METHOD_ID);

70: X_ATTRIBUTE29 IN VARCHAR2,
71: X_ATTRIBUTE30 IN VARCHAR2,
72: X_OWNER IN VARCHAR2
73: )IS
74: cursor c1 is select * from GMD_TEST_METHODS_B where (TEST_METHOD_ID=X_TEST_METHOD_ID);
75: l_pkpresent c1%rowtype;
76: l_user_id NUMBER := 0;
77: l_sysdate DATE;
78: l_test_method_id NUMBER;

Line 90: UPDATE GMD_TEST_METHODS_B SET

86: OPEN c1;
87: fetch c1 into l_pkpresent;
88: IF (c1%found) THEN
89:
90: UPDATE GMD_TEST_METHODS_B SET
91: TEST_METHOD_CODE = X_TEST_METHOD_CODE,
92: TEST_QTY = X_TEST_QTY,
93: TEST_QTY_UOM = X_TEST_QTY_UOM,
94: DELETE_MARK = X_DELETE_MARK ,

Line 153: INSERT INTO GMD_TEST_METHODS_B(

149: userenv('LANG') in (LANGUAGE,SOURCE_LANG);
150:
151: ELSIF (c1%notfound) then
152:
153: INSERT INTO GMD_TEST_METHODS_B(
154: TEST_METHOD_ID,
155: TEST_METHOD_CODE,
156: TEST_QTY,
157: TEST_QTY_UOM,

Line 349: cursor C is select ROWID from GMD_TEST_METHODS_B

345: X_LAST_UPDATE_DATE in DATE,
346: X_LAST_UPDATED_BY in NUMBER,
347: X_LAST_UPDATE_LOGIN in NUMBER
348: ) is
349: cursor C is select ROWID from GMD_TEST_METHODS_B
350: where TEST_METHOD_ID = X_TEST_METHOD_ID
351: ;
352: begin
353: insert into GMD_TEST_METHODS_B (

Line 353: insert into GMD_TEST_METHODS_B (

349: cursor C is select ROWID from GMD_TEST_METHODS_B
350: where TEST_METHOD_ID = X_TEST_METHOD_ID
351: ;
352: begin
353: insert into GMD_TEST_METHODS_B (
354: TEST_METHOD_ID,
355: TEST_METHOD_CODE,
356: TEST_QTY,
357: TEST_QTY_UOM,

Line 596: from GMD_TEST_METHODS_B

592: ATTRIBUTE27,
593: ATTRIBUTE28,
594: ATTRIBUTE29,
595: ATTRIBUTE30
596: from GMD_TEST_METHODS_B
597: where TEST_METHOD_ID = X_TEST_METHOD_ID
598: for update of TEST_METHOD_ID nowait;
599: recinfo c%rowtype;
600:

Line 781: update GMD_TEST_METHODS_B set

777: X_LAST_UPDATED_BY in NUMBER,
778: X_LAST_UPDATE_LOGIN in NUMBER
779: ) is
780: begin
781: update GMD_TEST_METHODS_B set
782: TEST_METHOD_CODE = X_TEST_METHOD_CODE,
783: TEST_QTY = X_TEST_QTY,
784: TEST_QTY_UOM = X_TEST_QTY_UOM,
785: DISPLAY_PRECISION = X_DISPLAY_PRECISION,

Line 862: delete from GMD_TEST_METHODS_B

858: if (sql%notfound) then
859: raise no_data_found;
860: end if;
861:
862: delete from GMD_TEST_METHODS_B
863: where TEST_METHOD_ID = X_TEST_METHOD_ID;
864:
865: if (sql%notfound) then
866: raise no_data_found;

Line 876: from GMD_TEST_METHODS_B B

872: begin
873: delete from GMD_TEST_METHODS_TL T
874: where not exists
875: (select NULL
876: from GMD_TEST_METHODS_B B
877: where B.TEST_METHOD_ID = T.TEST_METHOD_ID
878: );
879:
880: update GMD_TEST_METHODS_TL T set (