APPS.AHL_VISITS_PKG dependencies on AHL_VISITS_TL

Line 351: insert into AHL_VISITS_TL (

347: X_LOCKED_FLAG, -- PRAKKUM :: VWPE :: ER 12424063 :: 01-FEB-2011
348: X_AUTO_VISIT_TYPE_FLAG -- added by tchimira for ER 14015560
349: );
350:
351: insert into AHL_VISITS_TL (
352: VISIT_ID,
353: LAST_UPDATE_DATE,
354: LAST_UPDATED_BY,
355: CREATION_DATE,

Line 377: from AHL_VISITS_TL T

373: from FND_LANGUAGES L
374: where L.INSTALLED_FLAG in ('I', 'B')
375: and not exists
376: (select NULL
377: from AHL_VISITS_TL T
378: where T.VISIT_ID = X_VISIT_ID
379: and T.LANGUAGE = L.LANGUAGE_CODE);
380:
381: open c;

Line 507: from AHL_VISITS_TL

503: cursor c1 is select
504: VISIT_NAME,
505: DESCRIPTION,
506: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
507: from AHL_VISITS_TL
508: where VISIT_ID = X_VISIT_ID
509: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
510: for update of VISIT_ID nowait;
511: begin

Line 764: update AHL_VISITS_TL set

760: if (sql%notfound) then
761: raise no_data_found;
762: end if;
763:
764: update AHL_VISITS_TL set
765: VISIT_NAME = X_VISIT_NAME,
766: DESCRIPTION = X_DESCRIPTION,
767: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
768: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 783: delete from AHL_VISITS_TL

779: procedure DELETE_ROW (
780: X_VISIT_ID in NUMBER
781: ) is
782: begin
783: delete from AHL_VISITS_TL
784: where VISIT_ID = X_VISIT_ID;
785:
786: if (sql%notfound) then
787: raise no_data_found;

Line 801: delete from AHL_VISITS_TL T

797:
798: procedure ADD_LANGUAGE
799: is
800: begin
801: delete from AHL_VISITS_TL T
802: where not exists
803: (select NULL
804: from AHL_VISITS_B B
805: where B.VISIT_ID = T.VISIT_ID

Line 808: update AHL_VISITS_TL T set (

804: from AHL_VISITS_B B
805: where B.VISIT_ID = T.VISIT_ID
806: );
807:
808: update AHL_VISITS_TL T set (
809: VISIT_NAME,
810: DESCRIPTION
811: ) = (select
812: B.VISIT_NAME,

Line 814: from AHL_VISITS_TL B

810: DESCRIPTION
811: ) = (select
812: B.VISIT_NAME,
813: B.DESCRIPTION
814: from AHL_VISITS_TL B
815: where B.VISIT_ID = T.VISIT_ID
816: and B.LANGUAGE = T.SOURCE_LANG)
817: where (
818: T.VISIT_ID,

Line 823: from AHL_VISITS_TL SUBB, AHL_VISITS_TL SUBT

819: T.LANGUAGE
820: ) in (select
821: SUBT.VISIT_ID,
822: SUBT.LANGUAGE
823: from AHL_VISITS_TL SUBB, AHL_VISITS_TL SUBT
824: where SUBB.VISIT_ID = SUBT.VISIT_ID
825: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
826: and (SUBB.VISIT_NAME <> SUBT.VISIT_NAME
827: or (SUBB.VISIT_NAME is null and SUBT.VISIT_NAME is not null)

Line 834: insert into AHL_VISITS_TL (

830: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
831: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
832: ));
833:
834: insert into AHL_VISITS_TL (
835: VISIT_ID,
836: LAST_UPDATE_DATE,
837: LAST_UPDATED_BY,
838: CREATION_DATE,

Line 856: from AHL_VISITS_TL B, FND_LANGUAGES L

852: B.DESCRIPTION,
853: B.VISIT_NAME,
854: L.LANGUAGE_CODE,
855: B.SOURCE_LANG
856: from AHL_VISITS_TL B, FND_LANGUAGES L
857: where L.INSTALLED_FLAG in ('I', 'B')
858: and B.LANGUAGE = userenv('LANG')
859: and not exists
860: (select NULL

Line 861: from AHL_VISITS_TL T

857: where L.INSTALLED_FLAG in ('I', 'B')
858: and B.LANGUAGE = userenv('LANG')
859: and not exists
860: (select NULL
861: from AHL_VISITS_TL T
862: where T.VISIT_ID = B.VISIT_ID
863: and T.LANGUAGE = L.LANGUAGE_CODE);
864: end ADD_LANGUAGE;
865: