APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_SCHEDULE_MATERIALS_PKG

Line 208: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);

204:
205: -- perform orphan forcast delete. Which ones? refer to comments for cursor.
206: -- delete operation transferred to due date calculation API
207: /*FOR delete_mtl_forecast_rec IN delete_schedule_mtl_csr LOOP
208: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);
209: END LOOP;*/
210:
211: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
212: fnd_log.string

Line 259: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);

255: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
256: );
257: END IF;
258: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(ue_mr_routes_rec.unit_effectivity_id, ue_mr_routes_rec.mr_route_id) LOOP
259: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
260: END LOOP;
261: ELSE
262: -- route is valid and proceed to forecast
263: IF(TRUNC(ue_mr_routes_rec.due_date) < TRUNC(SYSDATE))THEN

Line 367: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

363: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
364: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
365: );
366: END IF;
367: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
368: (
369: X_SCHEDULED_MATERIAL_ID => NULL,
370: X_OBJECT_VERSION_NUMBER => 1,
371: X_LAST_UPDATE_DATE => SYSDATE,

Line 470: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

466: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
467: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
468: );
469: END IF;
470: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
471: (
472: X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
473: X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
474: X_LAST_UPDATE_DATE => SYSDATE,

Line 1102: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);

1098: 'p_route_id :p_mr_route_id : ' || p_route_id || ':' || p_mr_route_id);
1099: END IF;
1100:
1101: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(p_unit_effectivity_id,p_mr_route_id) LOOP
1102: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
1103: END LOOP;
1104:
1105: ELSE
1106: -- route is valid and proceed to forecast

Line 1181: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

1177: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1178: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1179: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1180: END IF;
1181: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
1182: (
1183: X_SCHEDULED_MATERIAL_ID => NULL,
1184: X_OBJECT_VERSION_NUMBER => 1,
1185: X_LAST_UPDATE_DATE => SYSDATE,

Line 1258: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

1254: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1255: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1256: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1257: END IF;
1258: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
1259: (
1260: X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
1261: X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
1262: X_LAST_UPDATE_DATE => SYSDATE,