DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on MRP_ATP_PUB

Line 6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;

6277: X_MSG_COUNT OUT NOCOPY NUMBER,
6278: x_msg_data OUT NOCOPY VARCHAR2)
6279: IS
6280: L_SESSION_ID NUMBER;
6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;
6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;
6285: x_atp_details mrp_atp_pub.atp_details_typ;

Line 6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;

6278: x_msg_data OUT NOCOPY VARCHAR2)
6279: IS
6280: L_SESSION_ID NUMBER;
6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;
6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;
6285: x_atp_details mrp_atp_pub.atp_details_typ;
6286: l_instance_id INTEGER;

Line 6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;

6279: IS
6280: L_SESSION_ID NUMBER;
6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;
6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;
6285: x_atp_details mrp_atp_pub.atp_details_typ;
6286: l_instance_id INTEGER;
6287: CURSOR Instance_Id_Cur

Line 6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;

6280: L_SESSION_ID NUMBER;
6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;
6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;
6285: x_atp_details mrp_atp_pub.atp_details_typ;
6286: l_instance_id INTEGER;
6287: CURSOR Instance_Id_Cur
6288: IS

Line 6285: x_atp_details mrp_atp_pub.atp_details_typ;

6281: L_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6282: X_ATP_TABLE MRP_ATP_PUB.ATP_REC_TYP;
6283: X_ATP_SUPPLY_DEMAND MRP_ATP_PUB.ATP_SUPPLY_DEMAND_TYP;
6284: X_ATP_PERIOD MRP_ATP_PUB.ATP_PERIOD_TYP;
6285: x_atp_details mrp_atp_pub.atp_details_typ;
6286: l_instance_id INTEGER;
6287: CURSOR Instance_Id_Cur
6288: IS
6289: SELECT instance_id FROM mrp_ap_apps_instances;

Line 6354: MRP_ATP_PUB.CALL_ATP (L_SESSION_ID, L_ATP_TABLE, X_ATP_TABLE, X_ATP_SUPPLY_DEMAND, X_ATP_PERIOD, X_ATP_DETAILS, X_RETURN_STATUS, x_msg_data, X_MSG_COUNT);

6350: l_atp_table.requested_ship_date(1) := sysdate;
6351: l_atp_table.action(1) := 100;
6352: l_atp_table.old_source_organization_id(1) := P_ORG_ID;
6353: l_atp_table.calling_module(1) := 867;
6354: MRP_ATP_PUB.CALL_ATP (L_SESSION_ID, L_ATP_TABLE, X_ATP_TABLE, X_ATP_SUPPLY_DEMAND, X_ATP_PERIOD, X_ATP_DETAILS, X_RETURN_STATUS, x_msg_data, X_MSG_COUNT);
6355: X_Inv_Mtl_Avl_Tbl(1).AVAILABLE_QUANTITY := X_ATP_TABLE.AVAILABLE_QUANTITY(1);
6356: X_Inv_Mtl_Avl_Tbl(1).ERROR_CODE := X_ATP_TABLE.ERROR_CODE(1);
6357: IF(X_ATP_TABLE.ERROR_CODE(1) <> 0) THEN
6358: FND_MESSAGE.SET_NAME('AHL','AHL_MM_CHK_SCH_INFO');