[Home] [Help]
200: END LOOP;
201: END LOOP;
202:
203:
204: AHL_LTP_MATRL_AVAL_PVT.CHECK_MATERIAL_AVAL ( P_API_VERSION => P_API_VERSION ,P_INIT_MSG_LIST => P_INIT_MSG_LIST,P_COMMIT=>P_COMMIT,P_VALIDATION_LEVEL => P_VALIDATION_LEVEL,
205: P_X_MATERIAL_AVL_TBL => P_X_MATERIAL_AVL_TBL, X_RETURN_STATUS => X_RETURN_STATUS, X_MSG_COUNT => X_MSG_COUNT, X_MSG_DATA => X_MSG_DATA);
206:
207: FOR I IN 1 .. P_X_MATERIAL_AVL_TBL.COUNT
208: LOOP
345: P_X_MATERIAL_AVL_TBL(I).SCHEDULE_MATERIAL_ID := SCHEDULE_MATERIALS.SCHEDULED_MATERIAL_ID;
346: P_X_MATERIAL_AVL_TBL(I).REQUIRED_QUANTITY := SCHEDULE_MATERIALS.REQUESTED_QUANTITY - (SCHEDULE_MATERIALS.COMPLETED_QUANTITY + P_RESERVED_QUANTITY);
347: END LOOP;
348: END LOOP;
349: AHL_LTP_MATRL_AVAL_PVT.SCHEDULE_PLANNED_MATRLS( P_API_VERSION => P_API_VERSION , P_X_PLANNED_MATRL_TBL => P_X_MATERIAL_AVL_TBL, X_RETURN_STATUS => X_RETURN_STATUS, X_MSG_COUNT => X_MSG_COUNT, X_MSG_DATA => X_MSG_DATA);
350:
351: FOR I IN 1 .. P_X_MATERIAL_AVL_TBL.COUNT
352: LOOP
353: X_MTL_AVL_SCHLD_TBL(I).SCHEDULE_MATERIAL_ID := P_X_MATERIAL_AVL_TBL(I).SCHEDULE_MATERIAL_ID;