APPS.AHL_LTP_ASCP_ORDERS_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 37: SELECT 1 FROM ahl_schedule_materials

33: IS
34:
35: CURSOR Check_Sched_Mat_Cur(c_sch_mat_id IN NUMBER)
36: IS
37: SELECT 1 FROM ahl_schedule_materials
38: WHERE scheduled_material_id = c_sch_mat_id;
39:
40: --Standard local variables
41: l_api_name CONSTANT VARCHAR2(30) := 'Update_Scheduling_Results';

Line 93: UPDATE AHL_SCHEDULE_MATERIALS

89: IF p_sched_Orders_tbl(i).order_line_id IS NOT NULL THEN
90: OPEN Check_Sched_Mat_Cur(p_sched_Orders_tbl(i).order_line_id);
91: FETCH Check_Sched_Mat_Cur INTO l_dummy;
92: IF Check_Sched_Mat_Cur%FOUND THEN
93: UPDATE AHL_SCHEDULE_MATERIALS
94: SET scheduled_date = p_sched_Orders_tbl(i).schedule_ship_date,
95: scheduled_quantity = p_sched_Orders_tbl(i).Quantity_By_Due_Date,
96: object_version_number = object_version_number + 1
97: WHERE scheduled_material_id = p_sched_Orders_tbl(i).order_line_id;