APPS.GMD_TEST_CLASSES_PVT dependencies on GMD_TEST_CLASSES_TL

Line 135: insert into GMD_TEST_CLASSES_TL (

131: X_LAST_UPDATE_LOGIN,
132: X_TEST_GROUP_ENABLED
133: );
134:
135: insert into GMD_TEST_CLASSES_TL (
136: TEST_CLASS,
137: TEST_CLASS_DESC,
138: CREATION_DATE,
139: CREATED_BY,

Line 159: from GMD_TEST_CLASSES_TL T

155: from FND_LANGUAGES L
156: where L.INSTALLED_FLAG in ('I', 'B')
157: and not exists
158: (select NULL
159: from GMD_TEST_CLASSES_TL T
160: where T.TEST_CLASS = X_TEST_CLASS
161: and T.LANGUAGE = L.LANGUAGE_CODE);
162:
163: open c;

Line 254: from GMD_TEST_CLASSES_TL

250:
251: cursor c1 is select
252: TEST_CLASS_DESC,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from GMD_TEST_CLASSES_TL
255: where TEST_CLASS = X_TEST_CLASS
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of TEST_CLASS nowait;
258: begin

Line 441: update GMD_TEST_CLASSES_TL set

437: if (sql%notfound) then
438: raise no_data_found;
439: end if;
440:
441: update GMD_TEST_CLASSES_TL set
442: TEST_CLASS_DESC = X_TEST_CLASS_DESC,
443: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
444: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
445: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 459: delete from GMD_TEST_CLASSES_TL

455: procedure DELETE_ROW (
456: X_TEST_CLASS in VARCHAR2
457: ) is
458: begin
459: delete from GMD_TEST_CLASSES_TL
460: where TEST_CLASS = X_TEST_CLASS;
461:
462: if (sql%notfound) then
463: raise no_data_found;

Line 477: delete from GMD_TEST_CLASSES_TL T

473:
474: procedure ADD_LANGUAGE
475: is
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

Line 484: update GMD_TEST_CLASSES_TL T set (

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 (
485: TEST_CLASS_DESC
486: ) = (select
487: B.TEST_CLASS_DESC
488: from GMD_TEST_CLASSES_TL B

Line 488: from GMD_TEST_CLASSES_TL B

484: update GMD_TEST_CLASSES_TL T set (
485: TEST_CLASS_DESC
486: ) = (select
487: B.TEST_CLASS_DESC
488: from GMD_TEST_CLASSES_TL B
489: where B.TEST_CLASS = T.TEST_CLASS
490: and B.LANGUAGE = T.SOURCE_LANG)
491: where (
492: T.TEST_CLASS,

Line 497: from GMD_TEST_CLASSES_TL SUBB, GMD_TEST_CLASSES_TL SUBT

493: T.LANGUAGE
494: ) in (select
495: SUBT.TEST_CLASS,
496: SUBT.LANGUAGE
497: from GMD_TEST_CLASSES_TL SUBB, GMD_TEST_CLASSES_TL SUBT
498: where SUBB.TEST_CLASS = SUBT.TEST_CLASS
499: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
500: and (SUBB.TEST_CLASS_DESC <> SUBT.TEST_CLASS_DESC
501: ));

Line 503: insert into GMD_TEST_CLASSES_TL (

499: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
500: and (SUBB.TEST_CLASS_DESC <> SUBT.TEST_CLASS_DESC
501: ));
502:
503: insert into GMD_TEST_CLASSES_TL (
504: TEST_CLASS,
505: TEST_CLASS_DESC,
506: CREATION_DATE,
507: CREATED_BY,

Line 523: from GMD_TEST_CLASSES_TL B, FND_LANGUAGES L

519: B.LAST_UPDATED_BY,
520: B.LAST_UPDATE_LOGIN,
521: L.LANGUAGE_CODE,
522: B.SOURCE_LANG
523: from GMD_TEST_CLASSES_TL B, FND_LANGUAGES L
524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL

Line 528: from GMD_TEST_CLASSES_TL T

524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL
528: from GMD_TEST_CLASSES_TL T
529: where T.TEST_CLASS = B.TEST_CLASS
530: and T.LANGUAGE = L.LANGUAGE_CODE);
531: end ADD_LANGUAGE;
532: end GMD_TEST_CLASSES_PVT;