APPS.AHL_UNIT_EFFECTIVITIES_PKG dependencies on AHL_UNIT_EFFECTIVITIES_TL

Line 195: insert into AHL_UNIT_EFFECTIVITIES_TL (

191: X_LAST_UPDATED_BY,
192: X_LAST_UPDATE_LOGIN
193: ) RETURNING UNIT_EFFECTIVITY_ID INTO X_UNIT_EFFECTIVITY_ID;
194:
195: insert into AHL_UNIT_EFFECTIVITIES_TL (
196: UNIT_EFFECTIVITY_ID,
197: LAST_UPDATE_DATE,
198: LAST_UPDATED_BY,
199: CREATION_DATE,

Line 219: from AHL_UNIT_EFFECTIVITIES_TL T

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

Line 354: from AHL_UNIT_EFFECTIVITIES_TL

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

Line 621: update AHL_UNIT_EFFECTIVITIES_TL set

617: if (sql%notfound) then
618: raise no_data_found;
619: end if;
620:
621: update AHL_UNIT_EFFECTIVITIES_TL set
622: REMARKS = X_REMARKS,
623: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
624: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
625: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 639: delete from AHL_UNIT_EFFECTIVITIES_TL

635: procedure DELETE_ROW (
636: X_UNIT_EFFECTIVITY_ID in NUMBER
637: ) is
638: begin
639: delete from AHL_UNIT_EFFECTIVITIES_TL
640: where UNIT_EFFECTIVITY_ID = X_UNIT_EFFECTIVITY_ID;
641:
642: if (sql%notfound) then
643: raise no_data_found;

Line 657: delete from AHL_UNIT_EFFECTIVITIES_TL T

653:
654: procedure ADD_LANGUAGE
655: is
656: begin
657: delete from AHL_UNIT_EFFECTIVITIES_TL T
658: where not exists
659: (select NULL
660: from AHL_UNIT_EFFECTIVITIES_B B
661: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID

Line 664: update AHL_UNIT_EFFECTIVITIES_TL T set (

660: from AHL_UNIT_EFFECTIVITIES_B B
661: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
662: );
663:
664: update AHL_UNIT_EFFECTIVITIES_TL T set (
665: REMARKS
666: ) = (select
667: B.REMARKS
668: from AHL_UNIT_EFFECTIVITIES_TL B

Line 668: from AHL_UNIT_EFFECTIVITIES_TL B

664: update AHL_UNIT_EFFECTIVITIES_TL T set (
665: REMARKS
666: ) = (select
667: B.REMARKS
668: from AHL_UNIT_EFFECTIVITIES_TL B
669: where B.UNIT_EFFECTIVITY_ID = T.UNIT_EFFECTIVITY_ID
670: and B.LANGUAGE = T.SOURCE_LANG)
671: where (
672: T.UNIT_EFFECTIVITY_ID,

Line 677: from AHL_UNIT_EFFECTIVITIES_TL SUBB, AHL_UNIT_EFFECTIVITIES_TL SUBT

673: T.LANGUAGE
674: ) in (select
675: SUBT.UNIT_EFFECTIVITY_ID,
676: SUBT.LANGUAGE
677: from AHL_UNIT_EFFECTIVITIES_TL SUBB, AHL_UNIT_EFFECTIVITIES_TL SUBT
678: where SUBB.UNIT_EFFECTIVITY_ID = SUBT.UNIT_EFFECTIVITY_ID
679: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
680: and (SUBB.REMARKS <> SUBT.REMARKS
681: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)

Line 685: insert into AHL_UNIT_EFFECTIVITIES_TL (

681: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)
682: or (SUBB.REMARKS is not null and SUBT.REMARKS is null)
683: ));
684:
685: insert into AHL_UNIT_EFFECTIVITIES_TL (
686: UNIT_EFFECTIVITY_ID,
687: LAST_UPDATE_DATE,
688: LAST_UPDATED_BY,
689: CREATION_DATE,

Line 705: from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L

701: B.LAST_UPDATE_LOGIN,
702: B.REMARKS,
703: L.LANGUAGE_CODE,
704: B.SOURCE_LANG
705: from AHL_UNIT_EFFECTIVITIES_TL B, FND_LANGUAGES L
706: where L.INSTALLED_FLAG in ('I', 'B')
707: and B.LANGUAGE = userenv('LANG')
708: and not exists
709: (select NULL

Line 710: from AHL_UNIT_EFFECTIVITIES_TL T

706: where L.INSTALLED_FLAG in ('I', 'B')
707: and B.LANGUAGE = userenv('LANG')
708: and not exists
709: (select NULL
710: from AHL_UNIT_EFFECTIVITIES_TL T
711: where T.UNIT_EFFECTIVITY_ID = B.UNIT_EFFECTIVITY_ID
712: and T.LANGUAGE = L.LANGUAGE_CODE);
713: end ADD_LANGUAGE;
714: