APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 842: SELECT * FROM Ahl_Visit_Tasks_VL

838: l_entl_rec_tbl AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Tbl_Type; --salogan added for supplier warranty
839:
840: -- To find task related information
841: CURSOR c_Task (x_id IN NUMBER) IS
842: SELECT * FROM Ahl_Visit_Tasks_VL
843: WHERE VISIT_TASK_ID = x_id;
844: c_Task_rec c_Task%ROWTYPE;
845: c_upd_Task_rec c_Task%ROWTYPE;
846:

Line 1325: SELECT * FROM Ahl_Visit_Tasks_VL

1321: l_msg_count NUMBER;
1322:
1323: -- To find all tasks related information
1324: CURSOR c_Task (x_id IN NUMBER) IS
1325: SELECT * FROM Ahl_Visit_Tasks_VL
1326: WHERE Visit_Task_ID = x_id;
1327: c_task_rec c_Task%ROWTYPE;
1328:
1329: BEGIN

Line 1541: FROM Ahl_Visit_Tasks_vl

1537: )
1538: IS
1539: CURSOR c_Visit_Task IS
1540: SELECT *
1541: FROM Ahl_Visit_Tasks_vl
1542: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
1543: --
1544: -- This is the only exception for using %ROWTYPE.
1545: -- We are selecting from the VL view, which may

Line 1633: 'Ahl_Visit_Tasks_vl',

1629: 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');
1630: END IF;
1631: -- FOR CREATION
1632: IF Ahl_Utility_Pvt.check_uniqueness(
1633: 'Ahl_Visit_Tasks_vl',
1634: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
1635: ) = Fnd_Api.g_false
1636: THEN
1637: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');