635: -- Start of Comments --
636: -- Procedure name : Create_Material_Reqst
637: -- Type : Private
638: -- Function : Validates Material Information and inserts records into
639: -- Schedule Material table for non routine jobs Calls AHL_WIP_JOB_PVT.
640: -- update_wip_job api
641: -- Pre-reqs :
642: -- Parameters :
643: --
3015: l_req_material_rec Req_Material_Rec_Type;
3016: l_req_material_tbl Req_Material_Tbl_Type;
3017: l_material_rec Get_Req_Matrl_cur%ROWTYPE;
3018: -- Variables required for wip jobs call
3019: l_ahl_wip_work_rec AHL_WIP_JOB_PVT.ahl_wo_rec_type;
3020: l_ahl_wip_oper_tbl AHL_WIP_JOB_PVT.ahl_wo_op_tbl_type ;
3021: l_ahl_wip_rsrc_tbl AHL_WIP_JOB_PVT.ahl_wo_res_tbl_type;
3022: l_ahl_wip_mtrl_tbl AHL_WIP_JOB_PVT.ahl_wo_mtl_tbl_type;
3023: l_default VARCHAR2(30);
3016: l_req_material_tbl Req_Material_Tbl_Type;
3017: l_material_rec Get_Req_Matrl_cur%ROWTYPE;
3018: -- Variables required for wip jobs call
3019: l_ahl_wip_work_rec AHL_WIP_JOB_PVT.ahl_wo_rec_type;
3020: l_ahl_wip_oper_tbl AHL_WIP_JOB_PVT.ahl_wo_op_tbl_type ;
3021: l_ahl_wip_rsrc_tbl AHL_WIP_JOB_PVT.ahl_wo_res_tbl_type;
3022: l_ahl_wip_mtrl_tbl AHL_WIP_JOB_PVT.ahl_wo_mtl_tbl_type;
3023: l_default VARCHAR2(30);
3024: j NUMBER;
3017: l_material_rec Get_Req_Matrl_cur%ROWTYPE;
3018: -- Variables required for wip jobs call
3019: l_ahl_wip_work_rec AHL_WIP_JOB_PVT.ahl_wo_rec_type;
3020: l_ahl_wip_oper_tbl AHL_WIP_JOB_PVT.ahl_wo_op_tbl_type ;
3021: l_ahl_wip_rsrc_tbl AHL_WIP_JOB_PVT.ahl_wo_res_tbl_type;
3022: l_ahl_wip_mtrl_tbl AHL_WIP_JOB_PVT.ahl_wo_mtl_tbl_type;
3023: l_default VARCHAR2(30);
3024: j NUMBER;
3025:
3018: -- Variables required for wip jobs call
3019: l_ahl_wip_work_rec AHL_WIP_JOB_PVT.ahl_wo_rec_type;
3020: l_ahl_wip_oper_tbl AHL_WIP_JOB_PVT.ahl_wo_op_tbl_type ;
3021: l_ahl_wip_rsrc_tbl AHL_WIP_JOB_PVT.ahl_wo_res_tbl_type;
3022: l_ahl_wip_mtrl_tbl AHL_WIP_JOB_PVT.ahl_wo_mtl_tbl_type;
3023: l_default VARCHAR2(30);
3024: j NUMBER;
3025:
3026: l_reserved_quantity NUMBER;