APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VISIT_TASKS_TL

Line 517: AHL_VISIT_TASKS_TL ATSKL,

513: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
514: AMRH.DESCRIPTION MR_DESCRIPTION
515: FROM AHL_VISITS_B AVTS,
516: AHL_VISIT_TASKS_B ATSK,
517: AHL_VISIT_TASKS_TL ATSKL,
518: AHL_VISIT_TASKS_VL ORIGTSK,
519: AHL_MR_ROUTES AMRR,
520: AHL_MR_HEADERS_VL AMRH,
521: AHL_UNIT_EFFECTIVITIES_B AUEF,

Line 616: AHL_VISIT_TASKS_TL ATSKL,

612: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
613: AMRH.DESCRIPTION MR_DESCRIPTION
614: FROM AHL_VISITS_B AVTS,
615: AHL_VISIT_TASKS_B ATSK,
616: AHL_VISIT_TASKS_TL ATSKL,
617: AHL_VISIT_TASKS_VL ORIGTSK,
618: AHL_MR_HEADERS_VL AMRH,
619: AHL_UNIT_EFFECTIVITIES_B AUEF,
620: CSI_ITEM_INSTANCES CSIS,

Line 5650: -- Delete task translation (AHL_VISIT_TASKS_TL) table data

5646: END IF;
5647:
5648: IF l_workorder_present = 'N' THEN
5649:
5650: -- Delete task translation (AHL_VISIT_TASKS_TL) table data
5651: DELETE FROM Ahl_Visit_Tasks_TL
5652: WHERE Visit_Task_ID = l_task_id;
5653:
5654: IF (SQL%NOTFOUND) THEN

Line 5651: DELETE FROM Ahl_Visit_Tasks_TL

5647:
5648: IF l_workorder_present = 'N' THEN
5649:
5650: -- Delete task translation (AHL_VISIT_TASKS_TL) table data
5651: DELETE FROM Ahl_Visit_Tasks_TL
5652: WHERE Visit_Task_ID = l_task_id;
5653:
5654: IF (SQL%NOTFOUND) THEN
5655: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 6079: DELETE FROM Ahl_Visit_Tasks_TL

6075: SET STATUS_CODE='DELETED',UNIT_EFFECTIVITY_ID=NULL,
6076: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6077: WHERE VISIT_TASK_ID=l_task_id;
6078: ELSE
6079: DELETE FROM Ahl_Visit_Tasks_TL
6080: WHERE Visit_Task_ID = l_task_id;
6081:
6082: IF (SQL%NOTFOUND) THEN
6083: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 6605: DELETE FROM Ahl_Visit_Tasks_TL WHERE Visit_Task_ID = l_task_id;

6601: fnd_log.string(l_log_statement,
6602: L_DEBUG_KEY,
6603: 'Before DELETE');
6604: END IF;
6605: DELETE FROM Ahl_Visit_Tasks_TL WHERE Visit_Task_ID = l_task_id;
6606: IF (SQL%NOTFOUND) THEN
6607: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
6608: THEN
6609: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 6818: DELETE FROM Ahl_Visit_Tasks_TL

6814: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
6815: WHERE VISIT_TASK_ID=l_task_id;
6816: ELSE
6817:
6818: DELETE FROM Ahl_Visit_Tasks_TL
6819: WHERE Visit_Task_ID = l_task_id;
6820:
6821: IF (SQL%NOTFOUND) THEN
6822: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');