APPS.AHL_UNIT_EFFECTIVITIES_PKG dependencies on AHL_UNIT_EFFECTIVITIES_TL

Line 198: insert into AHL_UNIT_EFFECTIVITIES_TL (

194: X_LAST_UPDATE_LOGIN,
195: X_FLEET_HEADER_ID
196: ) RETURNING UNIT_EFFECTIVITY_ID INTO X_UNIT_EFFECTIVITY_ID;
197:
198: insert into AHL_UNIT_EFFECTIVITIES_TL (
199: UNIT_EFFECTIVITY_ID,
200: LAST_UPDATE_DATE,
201: LAST_UPDATED_BY,
202: CREATION_DATE,

Line 222: from AHL_UNIT_EFFECTIVITIES_TL T

218: from FND_LANGUAGES L
219: where L.INSTALLED_FLAG in ('I', 'B')
220: and not exists
221: (select NULL
222: from AHL_UNIT_EFFECTIVITIES_TL T
223: where T.UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
224: and T.LANGUAGE = L.LANGUAGE_CODE);
225:
226: open c;

Line 357: from AHL_UNIT_EFFECTIVITIES_TL

353:
354: cursor c1 is select
355: REMARKS,
356: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
357: from AHL_UNIT_EFFECTIVITIES_TL
358: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID
359: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
360: for update of UNIT_EFFECTIVITY_ID nowait;
361: begin

Line 626: update AHL_UNIT_EFFECTIVITIES_TL set

622: if (sql%notfound) then
623: raise no_data_found;
624: end if;
625:
626: update AHL_UNIT_EFFECTIVITIES_TL set
627: REMARKS = X_REMARKS,
628: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
629: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
630: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 644: delete from AHL_UNIT_EFFECTIVITIES_TL

640: procedure DELETE_ROW (
641: X_UNIT_EFFECTIVITY_ID in NUMBER
642: ) is
643: begin
644: delete from AHL_UNIT_EFFECTIVITIES_TL
645: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;
646:
647: if (sql%notfound) then
648: raise no_data_found;

Line 662: delete from AHL_UNIT_EFFECTIVITIES_TL T

658:
659: procedure ADD_LANGUAGE
660: is
661: begin
662: delete from AHL_UNIT_EFFECTIVITIES_TL T
663: where not exists
664: (select NULL
665: from AHL_UNIT_EFFECTIVITIES_B B
666: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID

Line 669: update AHL_UNIT_EFFECTIVITIES_TL T set (

665: from AHL_UNIT_EFFECTIVITIES_B B
666: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
667: );
668:
669: update AHL_UNIT_EFFECTIVITIES_TL T set (
670: REMARKS
671: ) = (select
672: B.REMARKS
673: from AHL_UNIT_EFFECTIVITIES_TL B

Line 673: from AHL_UNIT_EFFECTIVITIES_TL B

669: update AHL_UNIT_EFFECTIVITIES_TL T set (
670: REMARKS
671: ) = (select
672: B.REMARKS
673: from AHL_UNIT_EFFECTIVITIES_TL B
674: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
675: and B.LANGUAGE = T.SOURCE_LANG)
676: where (
677: T.UNIT_EFFECTIVITY_ID,

Line 682: from AHL_UNIT_EFFECTIVITIES_TL SUBB, AHL_UNIT_EFFECTIVITIES_TL SUBT

678: T.LANGUAGE
679: ) in (select
680: SUBT.UNIT_EFFECTIVITY_ID,
681: SUBT.LANGUAGE
682: from AHL_UNIT_EFFECTIVITIES_TL SUBB, AHL_UNIT_EFFECTIVITIES_TL SUBT
683: where SUBB.UNIT_EFFECTIVITY_ID = SUBT.UNIT_EFFECTIVITY_ID
684: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
685: and (SUBB.REMARKS <> SUBT.REMARKS
686: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)

Line 690: insert into AHL_UNIT_EFFECTIVITIES_TL (

686: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)
687: or (SUBB.REMARKS is not null and SUBT.REMARKS is null)
688: ));
689:
690: insert into AHL_UNIT_EFFECTIVITIES_TL (
691: UNIT_EFFECTIVITY_ID,
692: LAST_UPDATE_DATE,
693: LAST_UPDATED_BY,
694: CREATION_DATE,

Line 710: from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L

706: B.LAST_UPDATE_LOGIN,
707: B.REMARKS,
708: L.LANGUAGE_CODE,
709: B.SOURCE_LANG
710: from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L
711: where L.INSTALLED_FLAG in ('I', 'B')
712: and B.LANGUAGE = userenv('LANG')
713: and not exists
714: (select NULL

Line 715: from AHL_UNIT_EFFECTIVITIES_TL T

711: where L.INSTALLED_FLAG in ('I', 'B')
712: and B.LANGUAGE = userenv('LANG')
713: and not exists
714: (select NULL
715: from AHL_UNIT_EFFECTIVITIES_TL T
716: where T.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
717: and T.LANGUAGE = L.LANGUAGE_CODE);
718: end ADD_LANGUAGE;
719: