APPS.GMD_TEST_CLASSES_PVT dependencies on GMD_TEST_CLASSES_B

Line 47: cursor C is select ROWID from GMD_TEST_CLASSES_B

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from GMD_TEST_CLASSES_B
48: where TEST_CLASS = X_TEST_CLASS
49: ;
50: begin
51: insert into GMD_TEST_CLASSES_B (

Line 51: insert into GMD_TEST_CLASSES_B (

47: cursor C is select ROWID from GMD_TEST_CLASSES_B
48: where TEST_CLASS = X_TEST_CLASS
49: ;
50: begin
51: insert into GMD_TEST_CLASSES_B (
52: TEST_CLASS,
53: DELETE_MARK,
54: TEXT_CODE,
55: ATTRIBUTE1,

Line 246: from GMD_TEST_CLASSES_B

242: ATTRIBUTE28,
243: ATTRIBUTE29,
244: ATTRIBUTE30,
245: ATTRIBUTE_CATEGORY
246: from GMD_TEST_CLASSES_B
247: where TEST_CLASS = X_TEST_CLASS
248: for update of TEST_CLASS nowait;
249: recinfo c%rowtype;
250:

Line 397: update GMD_TEST_CLASSES_B set

393: X_LAST_UPDATED_BY in NUMBER,
394: X_LAST_UPDATE_LOGIN in NUMBER
395: ) is
396: begin
397: update GMD_TEST_CLASSES_B set
398: DELETE_MARK = X_DELETE_MARK,
399: TEXT_CODE = X_TEXT_CODE,
400: TEST_GROUP_ENABLED = X_TEST_GROUP_ENABLED,
401: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 466: delete from GMD_TEST_CLASSES_B

462: if (sql%notfound) then
463: raise no_data_found;
464: end if;
465:
466: delete from GMD_TEST_CLASSES_B
467: where TEST_CLASS = X_TEST_CLASS;
468:
469: if (sql%notfound) then
470: raise no_data_found;

Line 480: from GMD_TEST_CLASSES_B B

476: begin
477: delete from GMD_TEST_CLASSES_TL T
478: where not exists
479: (select NULL
480: from GMD_TEST_CLASSES_B B
481: where B.TEST_CLASS = T.TEST_CLASS
482: );
483:
484: update GMD_TEST_CLASSES_TL T set (