APPS.GMD_TESTS_PKG dependencies on GMD_TESTS_TL

Line 192: insert into GMD_TESTS_TL (

188: X_LAST_UPDATED_BY,
189: X_LAST_UPDATE_LOGIN
190: );
191:
192: insert into GMD_TESTS_TL (
193: QCASSY_TYP_ID,
194: ASSAY_DESC,
195: CREATION_DATE,
196: LAST_UPDATE_LOGIN,

Line 216: from GMD_TESTS_TL T

212: from FND_LANGUAGES L
213: where L.INSTALLED_FLAG in ('I', 'B')
214: and not exists
215: (select NULL
216: from GMD_TESTS_TL T
217: where T.QCASSY_TYP_ID = X_QCASSY_TYP_ID
218: and T.LANGUAGE = L.LANGUAGE_CODE);
219:
220: open c;

Line 349: from GMD_TESTS_TL

345:
346: cursor c1 is select
347: ASSAY_DESC,
348: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
349: from GMD_TESTS_TL
350: where QCASSY_TYP_ID = X_QCASSY_TYP_ID
351: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
352: for update of QCASSY_TYP_ID nowait;
353: begin

Line 609: update GMD_TESTS_TL set

605: if (sql%notfound) then
606: raise no_data_found;
607: end if;
608:
609: update GMD_TESTS_TL set
610: ASSAY_DESC = X_ASSAY_DESC,
611: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
612: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
613: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 627: delete from GMD_TESTS_TL

623: procedure DELETE_ROW (
624: X_QCASSY_TYP_ID in NUMBER
625: ) is
626: begin
627: delete from GMD_TESTS_TL
628: where QCASSY_TYP_ID = X_QCASSY_TYP_ID;
629:
630: if (sql%notfound) then
631: raise no_data_found;

Line 645: delete from GMD_TESTS_TL T

641:
642: procedure ADD_LANGUAGE
643: is
644: begin
645: delete from GMD_TESTS_TL T
646: where not exists
647: (select NULL
648: from GMD_TESTS_B B
649: where B.QCASSY_TYP_ID = T.QCASSY_TYP_ID

Line 652: update GMD_TESTS_TL T set (

648: from GMD_TESTS_B B
649: where B.QCASSY_TYP_ID = T.QCASSY_TYP_ID
650: );
651:
652: update GMD_TESTS_TL T set (
653: ASSAY_DESC
654: ) = (select
655: B.ASSAY_DESC
656: from GMD_TESTS_TL B

Line 656: from GMD_TESTS_TL B

652: update GMD_TESTS_TL T set (
653: ASSAY_DESC
654: ) = (select
655: B.ASSAY_DESC
656: from GMD_TESTS_TL B
657: where B.QCASSY_TYP_ID = T.QCASSY_TYP_ID
658: and B.LANGUAGE = T.SOURCE_LANG)
659: where (
660: T.QCASSY_TYP_ID,

Line 665: from GMD_TESTS_TL SUBB, GMD_TESTS_TL SUBT

661: T.LANGUAGE
662: ) in (select
663: SUBT.QCASSY_TYP_ID,
664: SUBT.LANGUAGE
665: from GMD_TESTS_TL SUBB, GMD_TESTS_TL SUBT
666: where SUBB.QCASSY_TYP_ID = SUBT.QCASSY_TYP_ID
667: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
668: and (SUBB.ASSAY_DESC <> SUBT.ASSAY_DESC
669: ));

Line 671: insert into GMD_TESTS_TL (

667: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
668: and (SUBB.ASSAY_DESC <> SUBT.ASSAY_DESC
669: ));
670:
671: insert into GMD_TESTS_TL (
672: QCASSY_TYP_ID,
673: ASSAY_DESC,
674: CREATION_DATE,
675: LAST_UPDATE_LOGIN,

Line 691: from GMD_TESTS_TL B, FND_LANGUAGES L

687: B.LAST_UPDATE_DATE,
688: B.LAST_UPDATED_BY,
689: L.LANGUAGE_CODE,
690: B.SOURCE_LANG
691: from GMD_TESTS_TL B, FND_LANGUAGES L
692: where L.INSTALLED_FLAG in ('I', 'B')
693: and B.LANGUAGE = userenv('LANG')
694: and not exists
695: (select NULL

Line 696: from GMD_TESTS_TL T

692: where L.INSTALLED_FLAG in ('I', 'B')
693: and B.LANGUAGE = userenv('LANG')
694: and not exists
695: (select NULL
696: from GMD_TESTS_TL T
697: where T.QCASSY_TYP_ID = B.QCASSY_TYP_ID
698: and T.LANGUAGE = L.LANGUAGE_CODE);
699: end ADD_LANGUAGE;
700: