APPS.AHL_VISIT_TASKS_PKG dependencies on AHL_VISIT_TASKS_TL

Line 166: insert into AHL_VISIT_TASKS_TL (

162: X_LAST_UPDATED_BY,
163: X_LAST_UPDATE_LOGIN
164: );
165:
166: insert into AHL_VISIT_TASKS_TL (
167: VISIT_TASK_ID,
168: LAST_UPDATE_DATE,
169: LAST_UPDATED_BY,
170: CREATION_DATE,

Line 192: from AHL_VISIT_TASKS_TL T

188: from FND_LANGUAGES L
189: where L.INSTALLED_FLAG in ('I', 'B')
190: and not exists
191: (select NULL
192: from AHL_VISIT_TASKS_TL T
193: where T.VISIT_TASK_ID = X_VISIT_TASK_ID
194: and T.LANGUAGE = L.LANGUAGE_CODE);
195:
196: open c;

Line 307: from AHL_VISIT_TASKS_TL

303: cursor c1 is select
304: VISIT_TASK_NAME,
305: DESCRIPTION,
306: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
307: from AHL_VISIT_TASKS_TL
308: where VISIT_TASK_ID = X_VISIT_TASK_ID
309: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
310: for update of VISIT_TASK_ID nowait;
311: begin

Line 531: update AHL_VISIT_TASKS_TL set

527: if (sql%notfound) then
528: raise no_data_found;
529: end if;
530:
531: update AHL_VISIT_TASKS_TL set
532: VISIT_TASK_NAME = X_VISIT_TASK_NAME,
533: DESCRIPTION = X_DESCRIPTION,
534: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
535: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 550: delete from AHL_VISIT_TASKS_TL

546: procedure DELETE_ROW (
547: X_VISIT_TASK_ID in NUMBER
548: ) is
549: begin
550: delete from AHL_VISIT_TASKS_TL
551: where VISIT_TASK_ID = X_VISIT_TASK_ID;
552:
553: if (sql%notfound) then
554: raise no_data_found;

Line 568: delete from AHL_VISIT_TASKS_TL T

564:
565: procedure ADD_LANGUAGE
566: is
567: begin
568: delete from AHL_VISIT_TASKS_TL T
569: where not exists
570: (select NULL
571: from AHL_VISIT_TASKS_B B
572: where B.VISIT_TASK_ID = T.VISIT_TASK_ID

Line 575: update AHL_VISIT_TASKS_TL T set (

571: from AHL_VISIT_TASKS_B B
572: where B.VISIT_TASK_ID = T.VISIT_TASK_ID
573: );
574:
575: update AHL_VISIT_TASKS_TL T set (
576: VISIT_TASK_NAME,
577: DESCRIPTION
578: ) = (select
579: B.VISIT_TASK_NAME,

Line 581: from AHL_VISIT_TASKS_TL B

577: DESCRIPTION
578: ) = (select
579: B.VISIT_TASK_NAME,
580: B.DESCRIPTION
581: from AHL_VISIT_TASKS_TL B
582: where B.VISIT_TASK_ID = T.VISIT_TASK_ID
583: and B.LANGUAGE = T.SOURCE_LANG)
584: where (
585: T.VISIT_TASK_ID,

Line 590: from AHL_VISIT_TASKS_TL SUBB, AHL_VISIT_TASKS_TL SUBT

586: T.LANGUAGE
587: ) in (select
588: SUBT.VISIT_TASK_ID,
589: SUBT.LANGUAGE
590: from AHL_VISIT_TASKS_TL SUBB, AHL_VISIT_TASKS_TL SUBT
591: where SUBB.VISIT_TASK_ID = SUBT.VISIT_TASK_ID
592: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
593: and (SUBB.VISIT_TASK_NAME <> SUBT.VISIT_TASK_NAME
594: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 599: insert into AHL_VISIT_TASKS_TL (

595: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
596: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
597: ));
598:
599: insert into AHL_VISIT_TASKS_TL (
600: VISIT_TASK_ID,
601: LAST_UPDATE_DATE,
602: LAST_UPDATED_BY,
603: CREATION_DATE,

Line 621: from AHL_VISIT_TASKS_TL B, FND_LANGUAGES L

617: B.DESCRIPTION,
618: B.VISIT_TASK_NAME,
619: L.LANGUAGE_CODE,
620: B.SOURCE_LANG
621: from AHL_VISIT_TASKS_TL B, FND_LANGUAGES L
622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL

Line 626: from AHL_VISIT_TASKS_TL T

622: where L.INSTALLED_FLAG in ('I', 'B')
623: and B.LANGUAGE = userenv('LANG')
624: and not exists
625: (select NULL
626: from AHL_VISIT_TASKS_TL T
627: where T.VISIT_TASK_ID = B.VISIT_TASK_ID
628: and T.LANGUAGE = L.LANGUAGE_CODE);
629: end ADD_LANGUAGE;
630: