APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_SCHEDULE_MATERIALS_PKG

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

196:
197: -- perform orphan forcast delete. Which ones? refer to comments for cursor.
198: -- delete operation transferred to due date calculation API
199: /*FOR delete_mtl_forecast_rec IN delete_schedule_mtl_csr LOOP
200: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);
201: END LOOP;*/
202:
203: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
204: fnd_log.string

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

247: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
248: );
249: END IF;
250: 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
251: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
252: END LOOP;
253: ELSE
254: -- route is valid and proceed to forecast
255: IF(TRUNC(ue_mr_routes_rec.due_date) < TRUNC(SYSDATE))THEN

Line 353: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

349: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
350: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
351: );
352: END IF;
353: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
354: (
355: X_SCHEDULED_MATERIAL_ID => NULL,
356: X_OBJECT_VERSION_NUMBER => 1,
357: X_LAST_UPDATE_DATE => SYSDATE,

Line 453: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

449: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
450: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
451: );
452: END IF;
453: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
454: (
455: X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
456: X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
457: X_LAST_UPDATE_DATE => SYSDATE,

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

1067: 'p_route_id :p_mr_route_id : ' || p_route_id || ':' || p_mr_route_id);
1068: END IF;
1069:
1070: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(p_unit_effectivity_id,p_mr_route_id) LOOP
1071: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
1072: END LOOP;
1073:
1074: ELSE
1075: -- route is valid and proceed to forecast

Line 1144: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

1140: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1141: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1142: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1143: END IF;
1144: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
1145: (
1146: X_SCHEDULED_MATERIAL_ID => NULL,
1147: X_OBJECT_VERSION_NUMBER => 1,
1148: X_LAST_UPDATE_DATE => SYSDATE,

Line 1218: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

1214: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1215: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1216: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1217: END IF;
1218: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
1219: (
1220: X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
1221: X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
1222: X_LAST_UPDATE_DATE => SYSDATE,