APPS.AHL_ROUTES_PKG dependencies on AHL_ROUTES_TL

Line 246: insert into AHL_ROUTES_TL (

242: X_LAST_UPDATED_BY,
243: X_LAST_UPDATE_LOGIN
244: );
245:
246: insert into AHL_ROUTES_TL (
247: REMARKS,
248: REVISION_NOTES,
249: ROUTE_ID,
250: LAST_UPDATE_DATE,

Line 274: from AHL_ROUTES_TL T

270: from FND_LANGUAGES L
271: where L.INSTALLED_FLAG in ('I', 'B')
272: and not exists
273: (select NULL
274: from AHL_ROUTES_TL T
275: where T.ROUTE_ID = X_ROUTE_ID
276: and T.LANGUAGE = L.LANGUAGE_CODE);
277:
278: open c;

Line 440: from AHL_ROUTES_TL

436: TITLE,
437: REMARKS,
438: REVISION_NOTES,
439: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
440: from AHL_ROUTES_TL
441: where ROUTE_ID = X_ROUTE_ID
442: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
443: for update of ROUTE_ID nowait;
444: begin

Line 753: update AHL_ROUTES_TL set

749: if (sql%notfound) then
750: raise no_data_found;
751: end if;
752:
753: update AHL_ROUTES_TL set
754: TITLE = X_TITLE,
755: REMARKS = X_REMARKS,
756: REVISION_NOTES = X_REVISION_NOTES,
757: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 773: delete from AHL_ROUTES_TL

769: procedure DELETE_ROW (
770: X_ROUTE_ID in NUMBER
771: ) is
772: begin
773: delete from AHL_ROUTES_TL
774: where ROUTE_ID = X_ROUTE_ID;
775:
776: if (sql%notfound) then
777: raise no_data_found;

Line 791: delete from AHL_ROUTES_TL T

787:
788: procedure ADD_LANGUAGE
789: is
790: begin
791: delete from AHL_ROUTES_TL T
792: where not exists
793: (select NULL
794: from AHL_ROUTES_B B
795: where B.ROUTE_ID = T.ROUTE_ID

Line 798: update AHL_ROUTES_TL T set (

794: from AHL_ROUTES_B B
795: where B.ROUTE_ID = T.ROUTE_ID
796: );
797:
798: update AHL_ROUTES_TL T set (
799: TITLE,
800: REMARKS,
801: REVISION_NOTES
802: ) = (select

Line 806: from AHL_ROUTES_TL B

802: ) = (select
803: B.TITLE,
804: B.REMARKS,
805: B.REVISION_NOTES
806: from AHL_ROUTES_TL B
807: where B.ROUTE_ID = T.ROUTE_ID
808: and B.LANGUAGE = T.SOURCE_LANG)
809: where (
810: T.ROUTE_ID,

Line 815: from AHL_ROUTES_TL SUBB, AHL_ROUTES_TL SUBT

811: T.LANGUAGE
812: ) in (select
813: SUBT.ROUTE_ID,
814: SUBT.LANGUAGE
815: from AHL_ROUTES_TL SUBB, AHL_ROUTES_TL SUBT
816: where SUBB.ROUTE_ID = SUBT.ROUTE_ID
817: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
818: and (SUBB.TITLE <> SUBT.TITLE
819: or SUBB.REMARKS <> SUBT.REMARKS

Line 827: insert into AHL_ROUTES_TL (

823: or (SUBB.REVISION_NOTES is null and SUBT.REVISION_NOTES is not null)
824: or (SUBB.REVISION_NOTES is not null and SUBT.REVISION_NOTES is null)
825: ));
826:
827: insert into AHL_ROUTES_TL (
828: REMARKS,
829: REVISION_NOTES,
830: ROUTE_ID,
831: LAST_UPDATE_DATE,

Line 851: from AHL_ROUTES_TL B, FND_LANGUAGES L

847: B.LAST_UPDATE_LOGIN,
848: B.TITLE,
849: L.LANGUAGE_CODE,
850: B.SOURCE_LANG
851: from AHL_ROUTES_TL B, FND_LANGUAGES L
852: where L.INSTALLED_FLAG in ('I', 'B')
853: and B.LANGUAGE = userenv('LANG')
854: and not exists
855: (select NULL

Line 856: from AHL_ROUTES_TL T

852: where L.INSTALLED_FLAG in ('I', 'B')
853: and B.LANGUAGE = userenv('LANG')
854: and not exists
855: (select NULL
856: from AHL_ROUTES_TL T
857: where T.ROUTE_ID = B.ROUTE_ID
858: and T.LANGUAGE = L.LANGUAGE_CODE);
859: end ADD_LANGUAGE;
860: