APPS.GMD_SPECIFICATIONS_PVT dependencies on GMD_SPECIFICATIONS_TL

Line 173: INSERT INTO GMD_SPECIFICATIONS_TL (

169: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
170: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
171: );
172:
173: INSERT INTO GMD_SPECIFICATIONS_TL (
174: SPEC_ID,
175: SPEC_DESC,
176: CREATION_DATE,
177: CREATED_BY,

Line 197: FROM GMD_SPECIFICATIONS_TL T

193: FROM FND_LANGUAGES L
194: WHERE L.INSTALLED_FLAG IN ('I', 'B')
195: AND NOT EXISTS
196: (SELECT NULL
197: FROM GMD_SPECIFICATIONS_TL T
198: WHERE T.SPEC_ID = X_SPEC_ID
199: AND T.LANGUAGE = L.LANGUAGE_CODE);
200:
201: OPEN c;

Line 314: FROM GMD_SPECIFICATIONS_TL

310:
311: CURSOR c1 IS SELECT
312: SPEC_DESC,
313: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
314: FROM GMD_SPECIFICATIONS_TL
315: WHERE SPEC_ID = X_SPEC_ID
316: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
317: FOR UPDATE OF SPEC_ID NOWAIT;
318: BEGIN

Line 539: UPDATE GMD_SPECIFICATIONS_TL SET

535: IF (SQL%NOTFOUND) THEN
536: RAISE NO_DATA_FOUND;
537: END IF;
538:
539: UPDATE GMD_SPECIFICATIONS_TL SET
540: SPEC_DESC = X_SPEC_DESC,
541: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
542: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
543: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

Line 556: DELETE FROM GMD_SPECIFICATIONS_TL T

552:
553: PROCEDURE ADD_LANGUAGE
554: IS
555: BEGIN
556: DELETE FROM GMD_SPECIFICATIONS_TL T
557: WHERE NOT EXISTS
558: (SELECT NULL
559: FROM GMD_SPECIFICATIONS_B B
560: WHERE B.SPEC_ID = T.SPEC_ID

Line 563: UPDATE GMD_SPECIFICATIONS_TL T SET (

559: FROM GMD_SPECIFICATIONS_B B
560: WHERE B.SPEC_ID = T.SPEC_ID
561: );
562:
563: UPDATE GMD_SPECIFICATIONS_TL T SET (
564: SPEC_DESC
565: ) = (SELECT
566: B.SPEC_DESC
567: FROM GMD_SPECIFICATIONS_TL B

Line 567: FROM GMD_SPECIFICATIONS_TL B

563: UPDATE GMD_SPECIFICATIONS_TL T SET (
564: SPEC_DESC
565: ) = (SELECT
566: B.SPEC_DESC
567: FROM GMD_SPECIFICATIONS_TL B
568: WHERE B.SPEC_ID = T.SPEC_ID
569: AND B.LANGUAGE = T.SOURCE_LANG)
570: WHERE (
571: T.SPEC_ID,

Line 576: FROM GMD_SPECIFICATIONS_TL SUBB, GMD_SPECIFICATIONS_TL SUBT

572: T.LANGUAGE
573: ) IN (SELECT
574: SUBT.SPEC_ID,
575: SUBT.LANGUAGE
576: FROM GMD_SPECIFICATIONS_TL SUBB, GMD_SPECIFICATIONS_TL SUBT
577: WHERE SUBB.SPEC_ID = SUBT.SPEC_ID
578: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
579: AND (SUBB.SPEC_DESC <> SUBT.SPEC_DESC
580: ));

Line 582: INSERT INTO GMD_SPECIFICATIONS_TL (

578: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
579: AND (SUBB.SPEC_DESC <> SUBT.SPEC_DESC
580: ));
581:
582: INSERT INTO GMD_SPECIFICATIONS_TL (
583: SPEC_ID,
584: SPEC_DESC,
585: CREATION_DATE,
586: CREATED_BY,

Line 602: FROM GMD_SPECIFICATIONS_TL B, FND_LANGUAGES L

598: B.LAST_UPDATE_DATE,
599: B.LAST_UPDATE_LOGIN,
600: L.LANGUAGE_CODE,
601: B.SOURCE_LANG
602: FROM GMD_SPECIFICATIONS_TL B, FND_LANGUAGES L
603: WHERE L.INSTALLED_FLAG IN ('I', 'B')
604: AND B.LANGUAGE = USERENV('LANG')
605: AND NOT EXISTS
606: (SELECT NULL

Line 607: FROM GMD_SPECIFICATIONS_TL T

603: WHERE L.INSTALLED_FLAG IN ('I', 'B')
604: AND B.LANGUAGE = USERENV('LANG')
605: AND NOT EXISTS
606: (SELECT NULL
607: FROM GMD_SPECIFICATIONS_TL T
608: WHERE T.SPEC_ID = B.SPEC_ID
609: AND T.LANGUAGE = L.LANGUAGE_CODE);
610: END ADD_LANGUAGE;
611: