[Home] [Help]
402: l_task_type_code VARCHAR2(30);
403: l_material_request_type VARCHAR2(30);
404: l_Prior_Item_Rec Get_Prior_Item_Cur%ROWTYPE;
405: l_isInservice AHL_RT_OPER_MATERIALS.IN_SERVICE%TYPE; --Added by sowsubra for Issue 105
406: l_mat_status AHL_SCHEDULE_MATERIALS.STATUS%TYPE; --Added by sowsubra for Issue 105
407: -- SKPATHAK :: Bug 8604722 :: 04-MAR-2010
408: l_default_dff_values dff_default_values_type;
409:
410: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name;
430: 'Request for Create Planned Material for Visit Id: ' || p_visit_id);
431: END IF;
432:
433: --Get the sequence number
434: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id FROM DUAL;
435: --Check for record exists
436: -- Surrkuma on 28-Jul-2011 for handling control position based material requirements
437: OPEN check_matrl_cur(p_visit_id,p_visit_task_id,p_rt_oper_material_id,p_position_key);
438: FETCH check_matrl_cur INTO l_dummy;
916: THEN
917: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
918: INTO l_rsvd_quantity
919: FROM mtl_reservations MR,
920: ahl_schedule_materials SM
921: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
922: AND MR.external_source_code = 'AHL'
923: AND MR.demand_source_line_detail = SM.scheduled_material_id
924: AND MR.organization_id = SM.organization_id
958: THEN
959: SELECT SUM(MR.PRIMARY_RESERVATION_QUANTITY)
960: INTO l_rsvd_quantity
961: FROM mtl_reservations MR,
962: ahl_schedule_materials SM
963: WHERE MR.DEMAND_SOURCE_LINE_DETAIL = l_planned_materials_tbl(i).schedule_material_id
964: AND MR.external_source_code = 'AHL'
965: AND MR.demand_source_line_detail = SM.scheduled_material_id
966: AND MR.organization_id = SM.organization_id