APPS.GMD_TECH_PARAMETERS_PKG dependencies on GMD_TECH_PARAMETERS_TL

Line 197: INSERT INTO GMD_TECH_PARAMETERS_TL (

193: X_LAST_UPDATED_BY,
194: X_LAST_UPDATE_LOGIN
195: );
196:
197: INSERT INTO GMD_TECH_PARAMETERS_TL (
198: TECH_PARM_ID,
199: TECH_PARM_NAME,
200: PARM_DESCRIPTION,
201: CREATION_DATE,

Line 223: FROM GMD_TECH_PARAMETERS_TL T

219: FROM FND_LANGUAGES L
220: WHERE L.INSTALLED_FLAG IN ('I', 'B')
221: AND NOT EXISTS
222: (SELECT NULL
223: FROM GMD_TECH_PARAMETERS_TL T
224: WHERE T.TECH_PARM_ID = L_TECH_PARM_ID
225: AND T.LANGUAGE = L.LANGUAGE_CODE);
226:
227: OPEN C;

Line 352: FROM GMD_TECH_PARAMETERS_TL

348:
349: CURSOR C1 IS SELECT
350: PARM_DESCRIPTION,
351: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
352: FROM GMD_TECH_PARAMETERS_TL
353: WHERE TECH_PARM_ID = X_TECH_PARM_ID
354: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
355: FOR UPDATE OF TECH_PARM_ID NOWAIT;
356: BEGIN

Line 605: UPDATE GMD_TECH_PARAMETERS_TL SET

601: IF (SQL%NOTFOUND) THEN
602: RAISE NO_DATA_FOUND;
603: END IF;
604:
605: UPDATE GMD_TECH_PARAMETERS_TL SET
606: PARM_DESCRIPTION = X_PARM_DESCRIPTION,
607: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
608: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
609: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 635: DELETE FROM GMD_TECH_PARAMETERS_TL T

631:
632: PROCEDURE ADD_LANGUAGE
633: IS
634: BEGIN
635: DELETE FROM GMD_TECH_PARAMETERS_TL T
636: WHERE NOT EXISTS
637: (SELECT NULL
638: FROM GMD_TECH_PARAMETERS_B B
639: WHERE B.TECH_PARM_ID = T.TECH_PARM_ID

Line 642: UPDATE GMD_TECH_PARAMETERS_TL T SET (

638: FROM GMD_TECH_PARAMETERS_B B
639: WHERE B.TECH_PARM_ID = T.TECH_PARM_ID
640: );
641:
642: UPDATE GMD_TECH_PARAMETERS_TL T SET (
643: PARM_DESCRIPTION
644: ) = (SELECT
645: B.PARM_DESCRIPTION
646: FROM GMD_TECH_PARAMETERS_TL B

Line 646: FROM GMD_TECH_PARAMETERS_TL B

642: UPDATE GMD_TECH_PARAMETERS_TL T SET (
643: PARM_DESCRIPTION
644: ) = (SELECT
645: B.PARM_DESCRIPTION
646: FROM GMD_TECH_PARAMETERS_TL B
647: WHERE B.TECH_PARM_ID = T.TECH_PARM_ID
648: AND B.LANGUAGE = T.SOURCE_LANG)
649: WHERE (
650: T.TECH_PARM_ID,

Line 655: FROM GMD_TECH_PARAMETERS_TL SUBB, GMD_TECH_PARAMETERS_TL SUBT

651: T.LANGUAGE
652: ) IN (SELECT
653: SUBT.TECH_PARM_ID,
654: SUBT.LANGUAGE
655: FROM GMD_TECH_PARAMETERS_TL SUBB, GMD_TECH_PARAMETERS_TL SUBT
656: WHERE SUBB.TECH_PARM_ID = SUBT.TECH_PARM_ID
657: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
658: AND (SUBB.PARM_DESCRIPTION <> SUBT.PARM_DESCRIPTION
659: ));

Line 661: INSERT INTO GMD_TECH_PARAMETERS_TL (

657: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
658: AND (SUBB.PARM_DESCRIPTION <> SUBT.PARM_DESCRIPTION
659: ));
660:
661: INSERT INTO GMD_TECH_PARAMETERS_TL (
662: TECH_PARM_ID,
663: TECH_PARM_NAME,
664: PARM_DESCRIPTION,
665: CREATION_DATE,

Line 683: FROM GMD_TECH_PARAMETERS_TL B, FND_LANGUAGES L

679: B.LAST_UPDATED_BY,
680: B.LAST_UPDATE_LOGIN,
681: L.LANGUAGE_CODE,
682: B.SOURCE_LANG
683: FROM GMD_TECH_PARAMETERS_TL B, FND_LANGUAGES L
684: WHERE L.INSTALLED_FLAG IN ('I', 'B')
685: AND B.LANGUAGE = USERENV('LANG')
686: AND NOT EXISTS
687: (SELECT NULL

Line 688: FROM GMD_TECH_PARAMETERS_TL T

684: WHERE L.INSTALLED_FLAG IN ('I', 'B')
685: AND B.LANGUAGE = USERENV('LANG')
686: AND NOT EXISTS
687: (SELECT NULL
688: FROM GMD_TECH_PARAMETERS_TL T
689: WHERE T.TECH_PARM_ID = B.TECH_PARM_ID
690: AND T.LANGUAGE = L.LANGUAGE_CODE);
691: END ADD_LANGUAGE;
692: