APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 882: SELECT * FROM Ahl_Visit_Tasks_VL

878: l_planned_order_flag VARCHAR2(1);
879:
880: -- To find task related information
881: CURSOR c_Task (x_id IN NUMBER) IS
882: SELECT * FROM Ahl_Visit_Tasks_VL
883: WHERE VISIT_TASK_ID = x_id;
884: c_Task_rec c_Task%ROWTYPE;
885: c_upd_Task_rec c_Task%ROWTYPE;
886:

Line 1295: SELECT * FROM Ahl_Visit_Tasks_VL

1291: l_msg_count NUMBER;
1292:
1293: -- To find all tasks related information
1294: CURSOR c_Task (x_id IN NUMBER) IS
1295: SELECT * FROM Ahl_Visit_Tasks_VL
1296: WHERE Visit_Task_ID = x_id;
1297: c_task_rec c_Task%ROWTYPE;
1298:
1299: BEGIN

Line 1511: FROM Ahl_Visit_Tasks_vl

1507: )
1508: IS
1509: CURSOR c_Visit_Task IS
1510: SELECT *
1511: FROM Ahl_Visit_Tasks_vl
1512: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
1513: --
1514: -- This is the only exception for using %ROWTYPE.
1515: -- We are selecting from the VL view, which may

Line 1603: 'Ahl_Visit_Tasks_vl',

1599: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.'||G_PKG_NAME,'Check_Visit_Task_UK_Items : = Check_Visit_Task_UK_Items Uniqueness Of ID');
1600: END IF;
1601: -- FOR CREATION
1602: IF Ahl_Utility_Pvt.check_uniqueness(
1603: 'Ahl_Visit_Tasks_vl',
1604: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
1605: ) = Fnd_Api.g_false
1606: THEN
1607: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');