APPS.AHL_VISITS_PKG dependencies on AHL_VISITS_TL

Line 172: insert into AHL_VISITS_TL (

168: X_LAST_UPDATED_BY,
169: X_LAST_UPDATE_LOGIN
170: );
171:
172: insert into AHL_VISITS_TL (
173: VISIT_ID,
174: LAST_UPDATE_DATE,
175: LAST_UPDATED_BY,
176: CREATION_DATE,

Line 198: from AHL_VISITS_TL T

194: from FND_LANGUAGES L
195: where L.INSTALLED_FLAG in ('I', 'B')
196: and not exists
197: (select NULL
198: from AHL_VISITS_TL T
199: where T.VISIT_ID = X_VISIT_ID
200: and T.LANGUAGE = L.LANGUAGE_CODE);
201:
202: open c;

Line 319: from AHL_VISITS_TL

315: cursor c1 is select
316: VISIT_NAME,
317: DESCRIPTION,
318: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
319: from AHL_VISITS_TL
320: where VISIT_ID = X_VISIT_ID
321: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
322: for update of VISIT_ID nowait;
323: begin

Line 556: update AHL_VISITS_TL set

552: if (sql%notfound) then
553: raise no_data_found;
554: end if;
555:
556: update AHL_VISITS_TL set
557: VISIT_NAME = X_VISIT_NAME,
558: DESCRIPTION = X_DESCRIPTION,
559: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
560: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 575: delete from AHL_VISITS_TL

571: procedure DELETE_ROW (
572: X_VISIT_ID in NUMBER
573: ) is
574: begin
575: delete from AHL_VISITS_TL
576: where VISIT_ID = X_VISIT_ID;
577:
578: if (sql%notfound) then
579: raise no_data_found;

Line 593: delete from AHL_VISITS_TL T

589:
590: procedure ADD_LANGUAGE
591: is
592: begin
593: delete from AHL_VISITS_TL T
594: where not exists
595: (select NULL
596: from AHL_VISITS_B B
597: where B.VISIT_ID = T.VISIT_ID

Line 600: update AHL_VISITS_TL T set (

596: from AHL_VISITS_B B
597: where B.VISIT_ID = T.VISIT_ID
598: );
599:
600: update AHL_VISITS_TL T set (
601: VISIT_NAME,
602: DESCRIPTION
603: ) = (select
604: B.VISIT_NAME,

Line 606: from AHL_VISITS_TL B

602: DESCRIPTION
603: ) = (select
604: B.VISIT_NAME,
605: B.DESCRIPTION
606: from AHL_VISITS_TL B
607: where B.VISIT_ID = T.VISIT_ID
608: and B.LANGUAGE = T.SOURCE_LANG)
609: where (
610: T.VISIT_ID,

Line 615: from AHL_VISITS_TL SUBB, AHL_VISITS_TL SUBT

611: T.LANGUAGE
612: ) in (select
613: SUBT.VISIT_ID,
614: SUBT.LANGUAGE
615: from AHL_VISITS_TL SUBB, AHL_VISITS_TL SUBT
616: where SUBB.VISIT_ID = SUBT.VISIT_ID
617: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
618: and (SUBB.VISIT_NAME <> SUBT.VISIT_NAME
619: or (SUBB.VISIT_NAME is null and SUBT.VISIT_NAME is not null)

Line 626: insert into AHL_VISITS_TL (

622: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
623: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
624: ));
625:
626: insert into AHL_VISITS_TL (
627: VISIT_ID,
628: LAST_UPDATE_DATE,
629: LAST_UPDATED_BY,
630: CREATION_DATE,

Line 648: from AHL_VISITS_TL B, FND_LANGUAGES L

644: B.DESCRIPTION,
645: B.VISIT_NAME,
646: L.LANGUAGE_CODE,
647: B.SOURCE_LANG
648: from AHL_VISITS_TL B, FND_LANGUAGES L
649: where L.INSTALLED_FLAG in ('I', 'B')
650: and B.LANGUAGE = userenv('LANG')
651: and not exists
652: (select NULL

Line 653: from AHL_VISITS_TL T

649: where L.INSTALLED_FLAG in ('I', 'B')
650: and B.LANGUAGE = userenv('LANG')
651: and not exists
652: (select NULL
653: from AHL_VISITS_TL T
654: where T.VISIT_ID = B.VISIT_ID
655: and T.LANGUAGE = L.LANGUAGE_CODE);
656: end ADD_LANGUAGE;
657: