APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_LTP_MATRL_AVAL_PUB

Line 164: P_X_MATERIAL_AVL_TBL AHL_LTP_MATRL_AVAL_PUB.MATERIAL_AVAILABILITY_TBL;

160: GROUP BY DEMAND_SOURCE_LINE_DETAIL;
161:
162: P_RESERVED_QUANTITY NUMBER;
163:
164: P_X_MATERIAL_AVL_TBL AHL_LTP_MATRL_AVAL_PUB.MATERIAL_AVAILABILITY_TBL;
165:
166: L_API_VERSION CONSTANT NUMBER := 1.0;
167: L_API_NAME CONSTANT VARCHAR2(30) := 'CHECK_AVAILABILITY';
168: L_DEBUG CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;

Line 291: P_X_MATERIAL_AVL_TBL AHL_LTP_MATRL_AVAL_PUB.PLANNED_MATRL_TBL;

287: NVL(COMPLETED_QUANTITY,0) COMPLETED_QUANTITY
288: FROM AHL_SCHEDULE_MATERIALS
289: WHERE SCHEDULED_MATERIAL_ID = P_SCHEDULE_MATERIAL_ID;
290:
291: P_X_MATERIAL_AVL_TBL AHL_LTP_MATRL_AVAL_PUB.PLANNED_MATRL_TBL;
292:
293: CURSOR ERROR_MESSAGE_CUR(C_ERROR_CODE IN NUMBER)
294: IS
295: SELECT meaning