APPS.AHL_VISIT_TASKS_PKG dependencies on AHL_VISIT_TASKS_TL

Line 365: insert into AHL_VISIT_TASKS_TL (

361: X_LAST_UPDATE_LOGIN,
362: X_REPAIR_BATCH_NAME --PRAKKUM :: 11/06/2012 :: Bug 14068468
363: );
364:
365: insert into AHL_VISIT_TASKS_TL (
366: VISIT_TASK_ID,
367: LAST_UPDATE_DATE,
368: LAST_UPDATED_BY,
369: CREATION_DATE,

Line 391: from AHL_VISIT_TASKS_TL T

387: from FND_LANGUAGES L
388: where L.INSTALLED_FLAG in ('I', 'B')
389: and not exists
390: (select NULL
391: from AHL_VISIT_TASKS_TL T
392: where T.VISIT_TASK_ID = X_VISIT_TASK_ID
393: and T.LANGUAGE = L.LANGUAGE_CODE);
394:
395: open c;

Line 521: from AHL_VISIT_TASKS_TL

517: cursor c1 is select
518: VISIT_TASK_NAME,
519: DESCRIPTION,
520: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
521: from AHL_VISIT_TASKS_TL
522: where VISIT_TASK_ID = X_VISIT_TASK_ID
523: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
524: for update of VISIT_TASK_ID nowait;
525: begin

Line 770: update AHL_VISIT_TASKS_TL set

766: if (sql%notfound) then
767: raise no_data_found;
768: end if;
769:
770: update AHL_VISIT_TASKS_TL set
771: VISIT_TASK_NAME = X_VISIT_TASK_NAME,
772: DESCRIPTION = X_DESCRIPTION,
773: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
774: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 789: delete from AHL_VISIT_TASKS_TL

785: procedure DELETE_ROW (
786: X_VISIT_TASK_ID in NUMBER
787: ) is
788: begin
789: delete from AHL_VISIT_TASKS_TL
790: where VISIT_TASK_ID = X_VISIT_TASK_ID;
791:
792: if (sql%notfound) then
793: raise no_data_found;

Line 807: delete from AHL_VISIT_TASKS_TL T

803:
804: procedure ADD_LANGUAGE
805: is
806: begin
807: delete from AHL_VISIT_TASKS_TL T
808: where not exists
809: (select NULL
810: from AHL_VISIT_TASKS_B B
811: where B.VISIT_TASK_ID = T.VISIT_TASK_ID

Line 814: update AHL_VISIT_TASKS_TL T set (

810: from AHL_VISIT_TASKS_B B
811: where B.VISIT_TASK_ID = T.VISIT_TASK_ID
812: );
813:
814: update AHL_VISIT_TASKS_TL T set (
815: VISIT_TASK_NAME,
816: DESCRIPTION
817: ) = (select
818: B.VISIT_TASK_NAME,

Line 820: from AHL_VISIT_TASKS_TL B

816: DESCRIPTION
817: ) = (select
818: B.VISIT_TASK_NAME,
819: B.DESCRIPTION
820: from AHL_VISIT_TASKS_TL B
821: where B.VISIT_TASK_ID = T.VISIT_TASK_ID
822: and B.LANGUAGE = T.SOURCE_LANG)
823: where (
824: T.VISIT_TASK_ID,

Line 829: from AHL_VISIT_TASKS_TL SUBB, AHL_VISIT_TASKS_TL SUBT

825: T.LANGUAGE
826: ) in (select
827: SUBT.VISIT_TASK_ID,
828: SUBT.LANGUAGE
829: from AHL_VISIT_TASKS_TL SUBB, AHL_VISIT_TASKS_TL SUBT
830: where SUBB.VISIT_TASK_ID = SUBT.VISIT_TASK_ID
831: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
832: and (SUBB.VISIT_TASK_NAME <> SUBT.VISIT_TASK_NAME
833: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 838: insert into AHL_VISIT_TASKS_TL (

834: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
835: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
836: ));
837:
838: insert into AHL_VISIT_TASKS_TL (
839: VISIT_TASK_ID,
840: LAST_UPDATE_DATE,
841: LAST_UPDATED_BY,
842: CREATION_DATE,

Line 860: from AHL_VISIT_TASKS_TL B, FND_LANGUAGES L

856: B.DESCRIPTION,
857: B.VISIT_TASK_NAME,
858: L.LANGUAGE_CODE,
859: B.SOURCE_LANG
860: from AHL_VISIT_TASKS_TL B, FND_LANGUAGES L
861: where L.INSTALLED_FLAG in ('I', 'B')
862: and B.LANGUAGE = userenv('LANG')
863: and not exists
864: (select NULL

Line 865: from AHL_VISIT_TASKS_TL T

861: where L.INSTALLED_FLAG in ('I', 'B')
862: and B.LANGUAGE = userenv('LANG')
863: and not exists
864: (select NULL
865: from AHL_VISIT_TASKS_TL T
866: where T.VISIT_TASK_ID = B.VISIT_TASK_ID
867: and T.LANGUAGE = L.LANGUAGE_CODE);
868: end ADD_LANGUAGE;
869: