APPS.AHL_VWP_TASKS_PVT dependencies on AHL_VISIT_TASKS_TL

Line 574: AHL_VISIT_TASKS_TL ATSKL,

570: ATSK.Attribute15
571: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
572: FROM AHL_VISITS_B AVTS,
573: AHL_VISIT_TASKS_B ATSK,
574: AHL_VISIT_TASKS_TL ATSKL,
575: AHL_VISIT_TASKS_VL ORIGTSK,
576: AHL_MR_ROUTES AMRR,
577: AHL_MR_HEADERS_VL AMRH,
578: AHL_UNIT_EFFECTIVITIES_B AUEF,

Line 702: AHL_VISIT_TASKS_TL ATSKL,

698: ATSK.Attribute15
699: --manisaga added all the attributes and ROUTE_ID as part of DFF Enablement 0n 18-Feb-2010--End
700: FROM AHL_VISITS_B AVTS,
701: AHL_VISIT_TASKS_B ATSK,
702: AHL_VISIT_TASKS_TL ATSKL,
703: AHL_VISIT_TASKS_VL ORIGTSK,
704: AHL_MR_HEADERS_VL AMRH,
705: AHL_UNIT_EFFECTIVITIES_B AUEF,
706: CSI_ITEM_INSTANCES CSIS,

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

6685: END IF;
6686:
6687: IF l_workorder_present = 'N' THEN
6688:
6689: -- Delete task translation (AHL_VISIT_TASKS_TL) table data
6690: DELETE FROM Ahl_Visit_Tasks_TL
6691: WHERE Visit_Task_ID = l_task_id;
6692:
6693: IF (SQL%NOTFOUND) THEN

Line 6690: DELETE FROM Ahl_Visit_Tasks_TL

6686:
6687: IF l_workorder_present = 'N' THEN
6688:
6689: -- Delete task translation (AHL_VISIT_TASKS_TL) table data
6690: DELETE FROM Ahl_Visit_Tasks_TL
6691: WHERE Visit_Task_ID = l_task_id;
6692:
6693: IF (SQL%NOTFOUND) THEN
6694: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 7220: DELETE FROM Ahl_Visit_Tasks_TL

7216: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
7217: END IF;
7218: -- salogan added for supplier warranty ends
7219: ELSE
7220: DELETE FROM Ahl_Visit_Tasks_TL
7221: WHERE Visit_Task_ID = l_task_id;
7222:
7223: IF (SQL%NOTFOUND) THEN
7224: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 7871: DELETE FROM Ahl_Visit_Tasks_TL WHERE Visit_Task_ID = l_task_id;

7867: fnd_log.string(l_log_statement,
7868: L_DEBUG_KEY,
7869: 'Before DELETE');
7870: END IF;
7871: DELETE FROM Ahl_Visit_Tasks_TL WHERE Visit_Task_ID = l_task_id;
7872: IF (SQL%NOTFOUND) THEN
7873: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
7874: THEN
7875: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 8121: DELETE FROM Ahl_Visit_Tasks_TL

8117: END IF;
8118: -- salogan added for supplier warranty ends
8119: ELSE
8120:
8121: DELETE FROM Ahl_Visit_Tasks_TL
8122: WHERE Visit_Task_ID = l_task_id;
8123:
8124: IF (SQL%NOTFOUND) THEN
8125: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');