631: x_msg_count IN OUT NoCopy NUMBER ,
632: x_msg_data IN OUT NoCopy VARCHAR2 ,
633: x_return_status IN OUT NoCopy VARCHAR2 ) IS
634:
635: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
636: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
637: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
638: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
639: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
632: x_msg_data IN OUT NoCopy VARCHAR2 ,
633: x_return_status IN OUT NoCopy VARCHAR2 ) IS
634:
635: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
636: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
637: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
638: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
639: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
640: char_1_null VARCHAR2(2000) := NULL;
633: x_return_status IN OUT NoCopy VARCHAR2 ) IS
634:
635: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
636: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
637: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
638: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
639: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
640: char_1_null VARCHAR2(2000) := NULL;
641: char_30_null VARCHAR2(30) := NULL;
634:
635: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
636: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
637: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
638: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
639: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
640: char_1_null VARCHAR2(2000) := NULL;
641: char_30_null VARCHAR2(30) := NULL;
642: number_null NUMBER := null;
635: x_atp_rec MRP_ATP_PUB.atp_rec_typ;
636: x_atp_rec_out MRP_ATP_PUB.atp_rec_typ;
637: x_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
638: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
639: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
640: char_1_null VARCHAR2(2000) := NULL;
641: char_30_null VARCHAR2(30) := NULL;
642: number_null NUMBER := null;
643: date_null DATE := null;
833: END IF;
834:
835: IF x_return_status <> 'E' THEN
836:
837: MRP_ATP_PUB.call_atp_no_commit
838: (l_session_id,
839: x_atp_rec,
840: x_atp_rec_out,
841: x_atp_supply_demand,
1584: msc_sch_wb.atp_debug(' excp in call_oe_api '||Substr(Sqlerrm,1,100));
1585: END IF;
1586: END call_oe_api;
1587:
1588: PROCEDURE call_oe_api (p_atp_rec MRP_ATP_PUB.atp_rec_typ,
1589: x_msg_count OUT NoCopy NUMBER,
1590: x_msg_data OUT NoCopy VARCHAR2,
1591: x_return_status OUT NoCopy VARCHAR2)
1592: IS