APPS.GMD_QC_TESTS_PVT dependencies on GMD_QC_TESTS_TL

Line 210: insert into GMD_QC_TESTS_TL (

206: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
207: X_TEST_GROUP_ORDER
208: );
209:
210: insert into GMD_QC_TESTS_TL (
211: TEST_ID,
212: TEST_DESC,
213: CREATION_DATE,
214: CREATED_BY,

Line 234: from GMD_QC_TESTS_TL T

230: from FND_LANGUAGES L
231: where L.INSTALLED_FLAG in ('I', 'B')
232: and not exists
233: (select NULL
234: from GMD_QC_TESTS_TL T
235: where T.TEST_ID = X_TEST_ID
236: and T.LANGUAGE = L.LANGUAGE_CODE);
237:
238: open c;

Line 456: from GMD_QC_TESTS_TL

452:
453: cursor c1 is select
454: TEST_DESC,
455: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
456: from GMD_QC_TESTS_TL
457: where TEST_ID = X_TEST_ID
458: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
459: for update of TEST_ID nowait;
460: BEGIN

Line 732: update GMD_QC_TESTS_TL set

728: if (sql%notfound) then
729: raise no_data_found;
730: end if;
731:
732: update GMD_QC_TESTS_TL set
733: TEST_DESC = X_TEST_DESC,
734: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
735: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
736: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

Line 749: delete from GMD_QC_TESTS_TL T

745:
746: procedure ADD_LANGUAGE
747: is
748: begin
749: delete from GMD_QC_TESTS_TL T
750: where not exists
751: (select NULL
752: from GMD_QC_TESTS_B B
753: where B.TEST_ID = T.TEST_ID

Line 756: update GMD_QC_TESTS_TL T set (

752: from GMD_QC_TESTS_B B
753: where B.TEST_ID = T.TEST_ID
754: );
755:
756: update GMD_QC_TESTS_TL T set (
757: TEST_DESC
758: ) = (select
759: B.TEST_DESC
760: from GMD_QC_TESTS_TL B

Line 760: from GMD_QC_TESTS_TL B

756: update GMD_QC_TESTS_TL T set (
757: TEST_DESC
758: ) = (select
759: B.TEST_DESC
760: from GMD_QC_TESTS_TL B
761: where B.TEST_ID = T.TEST_ID
762: and B.LANGUAGE = T.SOURCE_LANG)
763: where (
764: T.TEST_ID,

Line 769: from GMD_QC_TESTS_TL SUBB, GMD_QC_TESTS_TL SUBT

765: T.LANGUAGE
766: ) in (select
767: SUBT.TEST_ID,
768: SUBT.LANGUAGE
769: from GMD_QC_TESTS_TL SUBB, GMD_QC_TESTS_TL SUBT
770: where SUBB.TEST_ID = SUBT.TEST_ID
771: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
772: and (SUBB.TEST_DESC <> SUBT.TEST_DESC
773: ));

Line 775: insert into GMD_QC_TESTS_TL (

771: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
772: and (SUBB.TEST_DESC <> SUBT.TEST_DESC
773: ));
774:
775: insert into GMD_QC_TESTS_TL (
776: TEST_ID,
777: TEST_DESC,
778: CREATION_DATE,
779: CREATED_BY,

Line 795: from GMD_QC_TESTS_TL B, FND_LANGUAGES L

791: B.LAST_UPDATE_DATE,
792: B.LAST_UPDATE_LOGIN,
793: L.LANGUAGE_CODE,
794: B.SOURCE_LANG
795: from GMD_QC_TESTS_TL B, FND_LANGUAGES L
796: where L.INSTALLED_FLAG in ('I', 'B')
797: and B.LANGUAGE = userenv('LANG')
798: and not exists
799: (select NULL

Line 800: from GMD_QC_TESTS_TL T

796: where L.INSTALLED_FLAG in ('I', 'B')
797: and B.LANGUAGE = userenv('LANG')
798: and not exists
799: (select NULL
800: from GMD_QC_TESTS_TL T
801: where T.TEST_ID = B.TEST_ID
802: and T.LANGUAGE = L.LANGUAGE_CODE);
803: end ADD_LANGUAGE;
804: