APPS.AHL_ROUTES_PKG dependencies on AHL_ROUTES_TL

Line 218: insert into AHL_ROUTES_TL (

214: X_LAST_UPDATED_BY,
215: X_LAST_UPDATE_LOGIN
216: );
217:
218: insert into AHL_ROUTES_TL (
219: REMARKS,
220: REVISION_NOTES,
221: ROUTE_ID,
222: LAST_UPDATE_DATE,

Line 246: from AHL_ROUTES_TL T

242: from FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and not exists
245: (select NULL
246: from AHL_ROUTES_TL T
247: where T.ROUTE_ID = X_ROUTE_ID
248: and T.LANGUAGE = L.LANGUAGE_CODE);
249:
250: open c;

Line 391: from AHL_ROUTES_TL

387: TITLE,
388: REMARKS,
389: REVISION_NOTES,
390: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
391: from AHL_ROUTES_TL
392: where ROUTE_ID = X_ROUTE_ID
393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
394: for update of ROUTE_ID nowait;
395: begin

Line 667: update AHL_ROUTES_TL set

663: if (sql%notfound) then
664: raise no_data_found;
665: end if;
666:
667: update AHL_ROUTES_TL set
668: TITLE = X_TITLE,
669: REMARKS = X_REMARKS,
670: REVISION_NOTES = X_REVISION_NOTES,
671: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 687: delete from AHL_ROUTES_TL

683: procedure DELETE_ROW (
684: X_ROUTE_ID in NUMBER
685: ) is
686: begin
687: delete from AHL_ROUTES_TL
688: where ROUTE_ID = X_ROUTE_ID;
689:
690: if (sql%notfound) then
691: raise no_data_found;

Line 705: delete from AHL_ROUTES_TL T

701:
702: procedure ADD_LANGUAGE
703: is
704: begin
705: delete from AHL_ROUTES_TL T
706: where not exists
707: (select NULL
708: from AHL_ROUTES_B B
709: where B.ROUTE_ID = T.ROUTE_ID

Line 712: update AHL_ROUTES_TL T set (

708: from AHL_ROUTES_B B
709: where B.ROUTE_ID = T.ROUTE_ID
710: );
711:
712: update AHL_ROUTES_TL T set (
713: TITLE,
714: REMARKS,
715: REVISION_NOTES
716: ) = (select

Line 720: from AHL_ROUTES_TL B

716: ) = (select
717: B.TITLE,
718: B.REMARKS,
719: B.REVISION_NOTES
720: from AHL_ROUTES_TL B
721: where B.ROUTE_ID = T.ROUTE_ID
722: and B.LANGUAGE = T.SOURCE_LANG)
723: where (
724: T.ROUTE_ID,

Line 729: from AHL_ROUTES_TL SUBB, AHL_ROUTES_TL SUBT

725: T.LANGUAGE
726: ) in (select
727: SUBT.ROUTE_ID,
728: SUBT.LANGUAGE
729: from AHL_ROUTES_TL SUBB, AHL_ROUTES_TL SUBT
730: where SUBB.ROUTE_ID = SUBT.ROUTE_ID
731: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
732: and (SUBB.TITLE <> SUBT.TITLE
733: or SUBB.REMARKS <> SUBT.REMARKS

Line 741: insert into AHL_ROUTES_TL (

737: or (SUBB.REVISION_NOTES is null and SUBT.REVISION_NOTES is not null)
738: or (SUBB.REVISION_NOTES is not null and SUBT.REVISION_NOTES is null)
739: ));
740:
741: insert into AHL_ROUTES_TL (
742: REMARKS,
743: REVISION_NOTES,
744: ROUTE_ID,
745: LAST_UPDATE_DATE,

Line 765: from AHL_ROUTES_TL B, FND_LANGUAGES L

761: B.LAST_UPDATE_LOGIN,
762: B.TITLE,
763: L.LANGUAGE_CODE,
764: B.SOURCE_LANG
765: from AHL_ROUTES_TL B, FND_LANGUAGES L
766: where L.INSTALLED_FLAG in ('I', 'B')
767: and B.LANGUAGE = userenv('LANG')
768: and not exists
769: (select NULL

Line 770: from AHL_ROUTES_TL T

766: where L.INSTALLED_FLAG in ('I', 'B')
767: and B.LANGUAGE = userenv('LANG')
768: and not exists
769: (select NULL
770: from AHL_ROUTES_TL T
771: where T.ROUTE_ID = B.ROUTE_ID
772: and T.LANGUAGE = L.LANGUAGE_CODE);
773: end ADD_LANGUAGE;
774: