APPS.GMD_ROUTINGS_PKG dependencies on GMD_ROUTINGS_TL

Line 187: INSERT INTO GMD_ROUTINGS_TL (

183: X_FIXED_PROCESS_LOSS, /* B6811759 */
184: X_FIXED_PROCESS_LOSS_UOM
185: );
186:
187: INSERT INTO GMD_ROUTINGS_TL (
188: LAST_UPDATE_LOGIN,
189: LAST_UPDATE_DATE,
190: LAST_UPDATED_BY,
191: ROUTING_ID,

Line 211: FROM GMD_ROUTINGS_TL T

207: FROM FND_LANGUAGES L
208: WHERE L.INSTALLED_FLAG IN ('I', 'B')
209: AND NOT EXISTS
210: (SELECT NULL
211: FROM GMD_ROUTINGS_TL T
212: WHERE T.ROUTING_ID = X_ROUTING_ID
213: AND T.LANGUAGE = L.LANGUAGE_CODE);
214:
215: OPEN C;

Line 340: FROM GMD_ROUTINGS_TL

336:
337: CURSOR C1 IS SELECT
338: ROUTING_DESC,
339: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
340: FROM GMD_ROUTINGS_TL
341: WHERE ROUTING_ID = X_ROUTING_ID
342: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
343: FOR UPDATE OF ROUTING_ID NOWAIT;
344: BEGIN

Line 587: UPDATE GMD_ROUTINGS_TL SET

583: IF (SQL%NOTFOUND) THEN
584: RAISE NO_DATA_FOUND;
585: END IF;
586:
587: UPDATE GMD_ROUTINGS_TL SET
588: ROUTING_DESC = X_ROUTING_DESC,
589: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
590: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
591: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 618: DELETE FROM GMD_ROUTINGS_TL T

614:
615: PROCEDURE ADD_LANGUAGE
616: IS
617: BEGIN
618: DELETE FROM GMD_ROUTINGS_TL T
619: WHERE NOT EXISTS
620: (SELECT NULL
621: FROM GMD_ROUTINGS_B B
622: WHERE B.ROUTING_ID = T.ROUTING_ID

Line 625: UPDATE GMD_ROUTINGS_TL T SET (

621: FROM GMD_ROUTINGS_B B
622: WHERE B.ROUTING_ID = T.ROUTING_ID
623: );
624:
625: UPDATE GMD_ROUTINGS_TL T SET (
626: ROUTING_DESC
627: ) = (SELECT
628: B.ROUTING_DESC
629: FROM GMD_ROUTINGS_TL B

Line 629: FROM GMD_ROUTINGS_TL B

625: UPDATE GMD_ROUTINGS_TL T SET (
626: ROUTING_DESC
627: ) = (SELECT
628: B.ROUTING_DESC
629: FROM GMD_ROUTINGS_TL B
630: WHERE B.ROUTING_ID = T.ROUTING_ID
631: AND B.LANGUAGE = T.SOURCE_LANG)
632: WHERE (
633: T.ROUTING_ID,

Line 638: FROM GMD_ROUTINGS_TL SUBB, GMD_ROUTINGS_TL SUBT

634: T.LANGUAGE
635: ) IN (SELECT
636: SUBT.ROUTING_ID,
637: SUBT.LANGUAGE
638: FROM GMD_ROUTINGS_TL SUBB, GMD_ROUTINGS_TL SUBT
639: WHERE SUBB.ROUTING_ID = SUBT.ROUTING_ID
640: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
641: AND (SUBB.ROUTING_DESC <> SUBT.ROUTING_DESC
642: ));

Line 644: INSERT INTO GMD_ROUTINGS_TL (

640: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
641: AND (SUBB.ROUTING_DESC <> SUBT.ROUTING_DESC
642: ));
643:
644: INSERT INTO GMD_ROUTINGS_TL (
645: LAST_UPDATE_LOGIN,
646: LAST_UPDATE_DATE,
647: LAST_UPDATED_BY,
648: ROUTING_ID,

Line 664: FROM GMD_ROUTINGS_TL B, FND_LANGUAGES L

660: B.CREATION_DATE,
661: B.CREATED_BY,
662: L.LANGUAGE_CODE,
663: B.SOURCE_LANG
664: FROM GMD_ROUTINGS_TL B, FND_LANGUAGES L
665: WHERE L.INSTALLED_FLAG IN ('I', 'B')
666: AND B.LANGUAGE = USERENV('LANG')
667: AND NOT EXISTS
668: (SELECT NULL

Line 669: FROM GMD_ROUTINGS_TL T

665: WHERE L.INSTALLED_FLAG IN ('I', 'B')
666: AND B.LANGUAGE = USERENV('LANG')
667: AND NOT EXISTS
668: (SELECT NULL
669: FROM GMD_ROUTINGS_TL T
670: WHERE T.ROUTING_ID = B.ROUTING_ID
671: AND T.LANGUAGE = L.LANGUAGE_CODE);
672: END ADD_LANGUAGE;
673: