eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_SCH_UTIL dependencies on MRP_ATP_PUB

Line 1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

1096: l_return_status VARCHAR2(1);
1097: l_msg_count NUMBER;
1098: l_msg_data VARCHAR2(2000);
1099: l_session_id NUMBER := 0;
1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

1097: l_msg_count NUMBER;
1098: l_msg_data VARCHAR2(2000);
1099: l_session_id NUMBER := 0;
1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
1105:

Line 1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

1098: l_msg_data VARCHAR2(2000);
1099: l_session_id NUMBER := 0;
1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
1105:
1106: --

Line 1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

1099: l_session_id NUMBER := 0;
1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
1105:
1106: --
1107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

1100: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1101: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
1102: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
1103: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
1104: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
1105:
1106: --
1107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1108: --

Line 1135: MRP_ATP_PUB.Call_ATP

1131: IF l_debug_level > 0 THEN
1132: oe_debug_pub.add( '4. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
1133: END IF;
1134:
1135: MRP_ATP_PUB.Call_ATP
1136: ( p_session_id => l_session_id
1137: , p_atp_rec => l_mrp_atp_rec
1138: , x_atp_rec => l_out_mtp_atp_rec
1139: , x_atp_supply_demand => l_atp_supply_demand

Line 1147: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

1143: , x_msg_data => l_msg_data
1144: , x_msg_count => l_msg_count);
1145:
1146: IF l_debug_level > 0 THEN
1147: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
1148: END IF;
1149:
1150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

3555: l_msg_count NUMBER;
3556: l_msg_data VARCHAR2(2000);
3557:
3558: l_session_id NUMBER := 0;
3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

3556: l_msg_data VARCHAR2(2000);
3557:
3558: l_session_id NUMBER := 0;
3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3564: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

3557:
3558: l_session_id NUMBER := 0;
3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3564: l_out_atp_tbl OE_ATP.atp_tbl_type;
3565: mrp_msg_data VARCHAR2(200);

Line 3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

3558: l_session_id NUMBER := 0;
3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3564: l_out_atp_tbl OE_ATP.atp_tbl_type;
3565: mrp_msg_data VARCHAR2(200);
3566:

Line 3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

3559: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3560: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3561: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3562: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3564: l_out_atp_tbl OE_ATP.atp_tbl_type;
3565: mrp_msg_data VARCHAR2(200);
3566:
3567: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3641: MRP_ATP_PUB.Call_ATP

3637: IF l_debug_level > 0 THEN
3638: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
3639: END IF;
3640:
3641: MRP_ATP_PUB.Call_ATP
3642: ( p_session_id => l_session_id
3643: , p_atp_rec => l_mrp_atp_rec
3644: , x_atp_rec => l_out_mtp_atp_rec
3645: , x_atp_supply_demand => l_atp_supply_demand

Line 3653: oe_debug_pub.add( '1. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

3649: , x_msg_data => mrp_msg_data
3650: , x_msg_count => l_msg_count);
3651:
3652: IF l_debug_level > 0 THEN
3653: oe_debug_pub.add( '1. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
3654: END IF;
3655: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3656: IF l_debug_level > 0 THEN
3657: oe_debug_pub.add( 'ERROR IS' || MRP_MSG_DATA , 1 ) ;

Line 3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

3959: l_msg_count NUMBER;
3960: l_msg_data VARCHAR2(2000);
3961: l_out_atp_rec OE_ATP.atp_rec_type;
3962: l_session_id NUMBER := 0;
3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

3960: l_msg_data VARCHAR2(2000);
3961: l_out_atp_rec OE_ATP.atp_rec_type;
3962: l_session_id NUMBER := 0;
3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

3961: l_out_atp_rec OE_ATP.atp_rec_type;
3962: l_session_id NUMBER := 0;
3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;
3969: mrp_msg_data VARCHAR2(200);

Line 3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

3962: l_session_id NUMBER := 0;
3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;
3969: mrp_msg_data VARCHAR2(200);
3970: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

Line 3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

3963: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3964: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
3965: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;
3969: mrp_msg_data VARCHAR2(200);
3970: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 4045: MRP_ATP_PUB.Call_ATP

4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
4043: END IF;
4044:
4045: MRP_ATP_PUB.Call_ATP
4046: ( p_session_id => l_session_id
4047: , p_atp_rec => l_mrp_atp_rec
4048: , x_atp_rec => l_out_mtp_atp_rec
4049: , x_atp_supply_demand => l_atp_supply_demand

Line 4057: oe_debug_pub.add( '2. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

4053: , x_msg_data => mrp_msg_data
4054: , x_msg_count => l_msg_count);
4055:
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( '2. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
4058: END IF;
4059:
4060: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

4146: l_quantity2_reserved NUMBER; -- INVCONV
4147:
4148:
4149: l_session_id NUMBER := 0;
4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

4147:
4148:
4149: l_session_id NUMBER := 0;
4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
4155: mrp_msg_data VARCHAR2(200);

Line 4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

4148:
4149: l_session_id NUMBER := 0;
4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
4155: mrp_msg_data VARCHAR2(200);
4156: l_on_hand_qty NUMBER;

Line 4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

4149: l_session_id NUMBER := 0;
4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
4155: mrp_msg_data VARCHAR2(200);
4156: l_on_hand_qty NUMBER;
4157: l_avail_to_reserve NUMBER;

Line 4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

4150: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4151: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
4152: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
4153: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
4154: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
4155: mrp_msg_data VARCHAR2(200);
4156: l_on_hand_qty NUMBER;
4157: l_avail_to_reserve NUMBER;
4158: l_avail_to_reserve2 NUMBER; -- INVCONV

Line 4423: MRP_ATP_PUB.Call_ATP

4419: IF l_debug_level > 0 THEN
4420: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
4421: END IF;
4422:
4423: MRP_ATP_PUB.Call_ATP
4424: ( p_session_id => l_session_id
4425: , p_atp_rec => l_mrp_atp_rec
4426: , x_atp_rec => l_out_mtp_atp_rec
4427: , x_atp_supply_demand => l_atp_supply_demand

Line 4435: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

4431: , x_msg_data => mrp_msg_data
4432: , x_msg_count => l_msg_count);
4433:
4434: IF l_debug_level > 0 THEN
4435: oe_debug_pub.add( '3. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
4436: END IF;
4437:
4438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4980: MRP_ATP_PUB.Call_ATP

4976: IF l_debug_level > 0 THEN
4977: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
4978: END IF;
4979:
4980: MRP_ATP_PUB.Call_ATP
4981: ( p_session_id => l_session_id
4982: , p_atp_rec => l_mrp_atp_rec
4983: , x_atp_rec => l_out_mtp_atp_rec
4984: , x_atp_supply_demand => l_atp_supply_demand

Line 4993: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

4989: , x_msg_count => l_msg_count);
4990:
4991:
4992: IF l_debug_level > 0 THEN
4993: oe_debug_pub.add( '4. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
4994: END IF;
4995:
4996: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5246: MRP_ATP_PUB.Call_ATP

5242: IF l_debug_level > 0 THEN
5243: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
5244: END IF;
5245:
5246: MRP_ATP_PUB.Call_ATP
5247: ( p_session_id => l_session_id
5248: , p_atp_rec => l_mrp_atp_rec
5249: , x_atp_rec => l_out_mtp_atp_rec
5250: , x_atp_supply_demand => l_atp_supply_demand

Line 5259: oe_debug_pub.add( '5. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

5255: , x_msg_count => l_msg_count);
5256:
5257:
5258: IF l_debug_level > 0 THEN
5259: oe_debug_pub.add( '5. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
5260: END IF;
5261: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END IF;

Line 5532: Procedure Initialize_mrp_record(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,

5528: Procedure Name : Initialize_mrp_record
5529: Description : This procedure create l_count records each for each table
5530: in the record of tables of MRP's p_atp_rec.
5531: ----------------------------------------------------------------------------- */
5532: Procedure Initialize_mrp_record(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
5533: l_count IN NUMBER,
5534: x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5535: IS
5536: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 5534: x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)

5530: in the record of tables of MRP's p_atp_rec.
5531: ----------------------------------------------------------------------------- */
5532: Procedure Initialize_mrp_record(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
5533: l_count IN NUMBER,
5534: x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5535: IS
5536: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5537: --
5538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5536: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

5532: Procedure Initialize_mrp_record(p_atp_rec IN MRP_ATP_PUB.ATP_Rec_Typ,
5533: l_count IN NUMBER,
5534: x_atp_rec OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5535: IS
5536: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5537: --
5538: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5539: --
5540: BEGIN

Line 5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)

5757: ----------------------------------------------------------------------------- */
5758: Procedure Load_MRP_Request
5759: ( p_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5760: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5762: IS
5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

5760: , p_old_line_tbl IN Oe_Order_Pub.Line_Tbl_Type
5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5762: IS
5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
5766: l_line_rec Oe_Order_Pub.Line_Rec_Type;
5767: l_old_line_rec Oe_Order_Pub.Line_Rec_Type;
5768:

Line 5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;

5761: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ)
5762: IS
5763: I number := 1;
5764: l_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
5765: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
5766: l_line_rec Oe_Order_Pub.Line_Rec_Type;
5767: l_old_line_rec Oe_Order_Pub.Line_Rec_Type;
5768:
5769: l_type_code VARCHAR2(30);

Line 5776: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;

5772:
5773: l_message_name VARCHAR2(30);
5774: l_error_message VARCHAR2(2000);
5775: l_table_name VARCHAR2(30);
5776: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
5777: l_smc_recs MRP_ATP_PUB.ATP_Rec_Typ;
5778: l_ship_set VARCHAR2(30);
5779: l_arrival_set VARCHAR2(30);
5780:

Line 5777: l_smc_recs MRP_ATP_PUB.ATP_Rec_Typ;

5773: l_message_name VARCHAR2(30);
5774: l_error_message VARCHAR2(2000);
5775: l_table_name VARCHAR2(30);
5776: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
5777: l_smc_recs MRP_ATP_PUB.ATP_Rec_Typ;
5778: l_ship_set VARCHAR2(30);
5779: l_arrival_set VARCHAR2(30);
5780:
5781: l_cto_result NUMBER;

Line 6326: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr

6322:
6323: --Load Model Rec to pass to ATO's API
6324: --Load Model Rec to pass to ATO's API
6325:
6326: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
6327: (l_atp_rec.Inventory_Item_Id(I));
6328:
6329: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
6330: (l_atp_rec.Source_Organization_Id(I));

Line 6329: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr

6325:
6326: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
6327: (l_atp_rec.Inventory_Item_Id(I));
6328:
6329: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
6330: (l_atp_rec.Source_Organization_Id(I));
6331:
6332: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
6333: (l_atp_rec.Identifier(I));

Line 6332: l_model_rec.Identifier := MRP_ATP_PUB.number_arr

6328:
6329: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
6330: (l_atp_rec.Source_Organization_Id(I));
6331:
6332: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
6333: (l_atp_rec.Identifier(I));
6334:
6335: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
6336: (l_atp_rec.Calling_Module(I));

Line 6335: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr

6331:
6332: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
6333: (l_atp_rec.Identifier(I));
6334:
6335: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
6336: (l_atp_rec.Calling_Module(I));
6337:
6338: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
6339: (l_atp_rec.Customer_Id(I));

Line 6338: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr

6334:
6335: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
6336: (l_atp_rec.Calling_Module(I));
6337:
6338: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
6339: (l_atp_rec.Customer_Id(I));
6340:
6341: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
6342: (l_atp_rec.Customer_Site_Id(I));

Line 6341: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr

6337:
6338: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
6339: (l_atp_rec.Customer_Id(I));
6340:
6341: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
6342: (l_atp_rec.Customer_Site_Id(I));
6343:
6344: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
6345: (l_atp_rec.Destination_Time_Zone(I));

Line 6344: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr

6340:
6341: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
6342: (l_atp_rec.Customer_Site_Id(I));
6343:
6344: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
6345: (l_atp_rec.Destination_Time_Zone(I));
6346:
6347: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
6348: (l_atp_rec.Quantity_Ordered(I));

Line 6347: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr

6343:
6344: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
6345: (l_atp_rec.Destination_Time_Zone(I));
6346:
6347: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
6348: (l_atp_rec.Quantity_Ordered(I));
6349:
6350: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
6351: (l_atp_rec.Quantity_UOM(I));

Line 6350: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr

6346:
6347: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
6348: (l_atp_rec.Quantity_Ordered(I));
6349:
6350: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
6351: (l_atp_rec.Quantity_UOM(I));
6352:
6353: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
6354: (l_atp_rec.Earliest_Acceptable_Date(I));

Line 6353: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr

6349:
6350: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
6351: (l_atp_rec.Quantity_UOM(I));
6352:
6353: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
6354: (l_atp_rec.Earliest_Acceptable_Date(I));
6355:
6356: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
6357: (l_atp_rec.Requested_Ship_Date(I));

Line 6356: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr

6352:
6353: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
6354: (l_atp_rec.Earliest_Acceptable_Date(I));
6355:
6356: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
6357: (l_atp_rec.Requested_Ship_Date(I));
6358:
6359: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
6360: (l_atp_rec.Requested_Arrival_Date(I));

Line 6359: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr

6355:
6356: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
6357: (l_atp_rec.Requested_Ship_Date(I));
6358:
6359: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
6360: (l_atp_rec.Requested_Arrival_Date(I));
6361:
6362: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
6363: (l_atp_rec.Latest_Acceptable_Date(I));

Line 6362: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr

6358:
6359: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
6360: (l_atp_rec.Requested_Arrival_Date(I));
6361:
6362: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
6363: (l_atp_rec.Latest_Acceptable_Date(I));
6364:
6365: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
6366: (l_atp_rec.Delivery_Lead_Time(I));

Line 6365: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr

6361:
6362: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
6363: (l_atp_rec.Latest_Acceptable_Date(I));
6364:
6365: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
6366: (l_atp_rec.Delivery_Lead_Time(I));
6367:
6368: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
6369: (l_atp_rec.Atp_lead_Time(I));

Line 6368: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr

6364:
6365: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
6366: (l_atp_rec.Delivery_Lead_Time(I));
6367:
6368: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
6369: (l_atp_rec.Atp_lead_Time(I));
6370:
6371: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
6372: (l_atp_rec.Freight_Carrier(I));

Line 6371: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr

6367:
6368: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
6369: (l_atp_rec.Atp_lead_Time(I));
6370:
6371: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
6372: (l_atp_rec.Freight_Carrier(I));
6373:
6374: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
6375: (l_atp_rec.Ship_Method(I));

Line 6374: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr

6370:
6371: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
6372: (l_atp_rec.Freight_Carrier(I));
6373:
6374: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
6375: (l_atp_rec.Ship_Method(I));
6376:
6377: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
6378: (l_atp_rec.Demand_Class(I));

Line 6377: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr

6373:
6374: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
6375: (l_atp_rec.Ship_Method(I));
6376:
6377: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
6378: (l_atp_rec.Demand_Class(I));
6379:
6380: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
6381: (l_atp_rec.Ship_Set_Name(I));

Line 6380: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr

6376:
6377: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
6378: (l_atp_rec.Demand_Class(I));
6379:
6380: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
6381: (l_atp_rec.Ship_Set_Name(I));
6382:
6383: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
6384: (l_atp_rec.Arrival_Set_Name(I));

Line 6383: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr

6379:
6380: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
6381: (l_atp_rec.Ship_Set_Name(I));
6382:
6383: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
6384: (l_atp_rec.Arrival_Set_Name(I));
6385:
6386: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
6387: (l_atp_rec.Override_Flag(I));

Line 6386: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr

6382:
6383: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
6384: (l_atp_rec.Arrival_Set_Name(I));
6385:
6386: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
6387: (l_atp_rec.Override_Flag(I));
6388:
6389: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
6390: (l_atp_rec.Ship_Date(I));

Line 6389: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr

6385:
6386: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
6387: (l_atp_rec.Override_Flag(I));
6388:
6389: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
6390: (l_atp_rec.Ship_Date(I));
6391:
6392: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
6393: (l_atp_rec.Available_Quantity(I));

Line 6392: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr

6388:
6389: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
6390: (l_atp_rec.Ship_Date(I));
6391:
6392: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
6393: (l_atp_rec.Available_Quantity(I));
6394:
6395: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
6396: (l_atp_rec.Requested_Date_Quantity(I));

Line 6395: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr

6391:
6392: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
6393: (l_atp_rec.Available_Quantity(I));
6394:
6395: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
6396: (l_atp_rec.Requested_Date_Quantity(I));
6397:
6398: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
6399: (l_atp_rec.Group_Ship_Date(I));

Line 6398: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr

6394:
6395: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
6396: (l_atp_rec.Requested_Date_Quantity(I));
6397:
6398: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
6399: (l_atp_rec.Group_Ship_Date(I));
6400:
6401: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
6402: (l_atp_rec.Group_Arrival_Date(I));

Line 6401: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr

6397:
6398: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
6399: (l_atp_rec.Group_Ship_Date(I));
6400:
6401: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
6402: (l_atp_rec.Group_Arrival_Date(I));
6403:
6404: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
6405: (l_atp_rec.Vendor_Id(I));

Line 6404: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr

6400:
6401: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
6402: (l_atp_rec.Group_Arrival_Date(I));
6403:
6404: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
6405: (l_atp_rec.Vendor_Id(I));
6406:
6407: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
6408: (l_atp_rec.Vendor_Site_Id(I));

Line 6407: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr

6403:
6404: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
6405: (l_atp_rec.Vendor_Id(I));
6406:
6407: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
6408: (l_atp_rec.Vendor_Site_Id(I));
6409:
6410: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
6411: (l_atp_rec.Insert_Flag(I));

Line 6410: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr

6406:
6407: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
6408: (l_atp_rec.Vendor_Site_Id(I));
6409:
6410: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
6411: (l_atp_rec.Insert_Flag(I));
6412: --oe_debug_pub.add('Insert flag in model_rec : '||l_model_rec.insert_flag,3);
6413:
6414: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr

Line 6414: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr

6410: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
6411: (l_atp_rec.Insert_Flag(I));
6412: --oe_debug_pub.add('Insert flag in model_rec : '||l_model_rec.insert_flag,3);
6413:
6414: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
6415: (l_atp_rec.Error_Code(I));
6416:
6417: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
6418: (l_atp_rec.Message(I));

Line 6417: l_model_rec.Message := MRP_ATP_PUB.char2000_arr

6413:
6414: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
6415: (l_atp_rec.Error_Code(I));
6416:
6417: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
6418: (l_atp_rec.Message(I));
6419:
6420: l_model_rec.Action := MRP_ATP_PUB.number_arr
6421: (l_atp_rec.action(I));

Line 6420: l_model_rec.Action := MRP_ATP_PUB.number_arr

6416:
6417: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
6418: (l_atp_rec.Message(I));
6419:
6420: l_model_rec.Action := MRP_ATP_PUB.number_arr
6421: (l_atp_rec.action(I));
6422:
6423: l_model_rec.order_number := MRP_ATP_PUB.number_arr
6424: (l_atp_rec.order_number(I));

Line 6423: l_model_rec.order_number := MRP_ATP_PUB.number_arr

6419:
6420: l_model_rec.Action := MRP_ATP_PUB.number_arr
6421: (l_atp_rec.action(I));
6422:
6423: l_model_rec.order_number := MRP_ATP_PUB.number_arr
6424: (l_atp_rec.order_number(I));
6425:
6426: IF l_atp_rec.Old_Source_Organization_Id.Exists(I) THEN
6427: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr

Line 6427: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr

6423: l_model_rec.order_number := MRP_ATP_PUB.number_arr
6424: (l_atp_rec.order_number(I));
6425:
6426: IF l_atp_rec.Old_Source_Organization_Id.Exists(I) THEN
6427: l_model_rec.Old_Source_Organization_Id := MRP_ATP_PUB.number_arr
6428: (l_atp_rec.Old_Source_Organization_Id(I));
6429: END IF;
6430:
6431: IF l_atp_rec.Old_Demand_Class.Exists(I) THEN

Line 6433: MRP_ATP_PUB.char30_arr(l_atp_rec.Old_Demand_Class(I));

6429: END IF;
6430:
6431: IF l_atp_rec.Old_Demand_Class.Exists(I) THEN
6432: l_model_rec.Old_Demand_Class :=
6433: MRP_ATP_PUB.char30_arr(l_atp_rec.Old_Demand_Class(I));
6434: END IF;
6435:
6436: BEGIN
6437: IF l_debug_level > 0 THEN

Line 7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ

7236: Description : ** Not Used **
7237: -------------------------------------------------------------------------- */
7238:
7239: PROCEDURE Call_ATP
7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ
7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ
7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ

Line 7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ

7237: -------------------------------------------------------------------------- */
7238:
7239: PROCEDURE Call_ATP
7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ
7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ
7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ
7245: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ

7238:
7239: PROCEDURE Call_ATP
7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ
7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ
7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ
7245: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7246: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ

7239: PROCEDURE Call_ATP
7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ
7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ
7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ
7245: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7246: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7247: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER)

Line 7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ

7240: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7241: , x_atp_table OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Rec_Typ
7242: , x_atp_supply_demand OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Supply_Demand_Typ
7243: , x_atp_period OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Period_Typ
7244: , x_atp_details OUT NOCOPY /* file.sql.39 change */ MRP_ATP_PUB.ATP_Details_Typ
7245: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7246: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7247: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER)
7248: IS

Line 7262: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr

7258: END IF;
7259:
7260: x_atp_table := p_atp_table;
7261:
7262: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
7263: (p_atp_table.Quantity_Ordered(I));
7264: x_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(204);
7265: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(967900);
7266: x_atp_table.error_code := MRP_ATP_PUB.number_arr(0);

Line 7264: x_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(204);

7260: x_atp_table := p_atp_table;
7261:
7262: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
7263: (p_atp_table.Quantity_Ordered(I));
7264: x_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(204);
7265: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(967900);
7266: x_atp_table.error_code := MRP_ATP_PUB.number_arr(0);
7267: x_return_status := FND_API.G_RET_STS_SUCCESS;
7268: x_msg_count := 0;

Line 7265: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(967900);

7261:
7262: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
7263: (p_atp_table.Quantity_Ordered(I));
7264: x_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(204);
7265: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(967900);
7266: x_atp_table.error_code := MRP_ATP_PUB.number_arr(0);
7267: x_return_status := FND_API.G_RET_STS_SUCCESS;
7268: x_msg_count := 0;
7269: null;

Line 7266: x_atp_table.error_code := MRP_ATP_PUB.number_arr(0);

7262: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
7263: (p_atp_table.Quantity_Ordered(I));
7264: x_atp_table.Source_Organization_Id := MRP_ATP_PUB.number_arr(204);
7265: x_atp_table.Requested_Date_Quantity := MRP_ATP_PUB.number_arr(967900);
7266: x_atp_table.error_code := MRP_ATP_PUB.number_arr(0);
7267: x_return_status := FND_API.G_RET_STS_SUCCESS;
7268: x_msg_count := 0;
7269: null;
7270:

Line 7285: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ

7281: We ignore the mandatory components which we passed to MRP
7282: while loading the results.
7283: -------------------------------------------------------------------------- */
7284: Procedure Load_Results
7285: ( p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ
7286: , p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type
7287: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.ATP_Tbl_Type
7288: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
7289: IS

Line 8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

8353: l_entity VARCHAR2(30);
8354:
8355: -- MRP API variables
8356: l_session_id NUMBER := 0;
8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

8354:
8355: -- MRP API variables
8356: l_session_id NUMBER := 0;
8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8362: mrp_msg_data VARCHAR2(200);

Line 8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

8355: -- MRP API variables
8356: l_session_id NUMBER := 0;
8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8362: mrp_msg_data VARCHAR2(200);
8363: l_on_hand_qty NUMBER;

Line 8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

8356: l_session_id NUMBER := 0;
8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8362: mrp_msg_data VARCHAR2(200);
8363: l_on_hand_qty NUMBER;
8364: l_avail_to_reserve NUMBER;

Line 8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

8357: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8358: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8359: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8360: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8361: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8362: mrp_msg_data VARCHAR2(200);
8363: l_on_hand_qty NUMBER;
8364: l_avail_to_reserve NUMBER;
8365:

Line 8528: MRP_ATP_PUB.Call_ATP

8524: IF l_debug_level > 0 THEN
8525: oe_debug_pub.add( 'SPLIT CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
8526: END IF;
8527:
8528: MRP_ATP_PUB.Call_ATP
8529: ( p_session_id => l_session_id
8530: , p_atp_rec => l_mrp_atp_rec
8531: , x_atp_rec => l_out_mtp_atp_rec
8532: , x_atp_supply_demand => l_atp_supply_demand

Line 8541: oe_debug_pub.add( 'SPLIT. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;

8537: , x_msg_count => l_msg_count);
8538:
8539:
8540: IF l_debug_level > 0 THEN
8541: oe_debug_pub.add( 'SPLIT. AFTER CALLING MRP_ATP_PUB.CALL_ATP' || L_RETURN_STATUS , 1 ) ;
8542: END IF;
8543:
8544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

8662: l_qty2_reserved NUMBER;
8663:
8664: -- MRP API variables
8665: --l_session_id NUMBER := 0;
8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

Line 8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

8663:
8664: -- MRP API variables
8665: --l_session_id NUMBER := 0;
8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8671: --mrp_msg_data VARCHAR2(200);

Line 8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

8664: -- MRP API variables
8665: --l_session_id NUMBER := 0;
8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8671: --mrp_msg_data VARCHAR2(200);
8672: --l_on_hand_qty NUMBER;

Line 8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;

8665: --l_session_id NUMBER := 0;
8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8671: --mrp_msg_data VARCHAR2(200);
8672: --l_on_hand_qty NUMBER;
8673: --l_avail_to_reserve NUMBER;

Line 8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;

8666: --l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8667: --l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
8668: --l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;
8669: --l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
8670: --l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
8671: --mrp_msg_data VARCHAR2(200);
8672: --l_on_hand_qty NUMBER;
8673: --l_avail_to_reserve NUMBER;
8674: --l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 8755: MRP_ATP_PUB.Call_ATP

8751: IF l_mrp_atp_rec.error_code.count > 0 THEN
8752:
8753: oe_debug_pub.add('1. Calling MRP API with session id '||l_session_id,1);
8754:
8755: MRP_ATP_PUB.Call_ATP
8756: ( p_session_id => l_session_id
8757: , p_atp_rec => l_mrp_atp_rec
8758: , x_atp_rec => l_out_mtp_atp_rec
8759: , x_atp_supply_demand => l_atp_supply_demand

Line 8767: oe_debug_pub.add('6. After Calling MRP_ATP_PUB.Call_ATP' ||

8763: , x_msg_data => mrp_msg_data
8764: , x_msg_count => l_msg_count);
8765:
8766:
8767: oe_debug_pub.add('6. After Calling MRP_ATP_PUB.Call_ATP' ||
8768: l_return_status,1);
8769:
8770: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8829: MRP_ATP_PUB.Call_ATP

8825:
8826:
8827: oe_debug_pub.add('2. Calling MRP API with session id '||l_session_id,1);
8828:
8829: MRP_ATP_PUB.Call_ATP
8830: ( p_session_id => l_session_id
8831: , p_atp_rec => l_mrp_atp_rec
8832: , x_atp_rec => l_out_mtp_atp_rec
8833: , x_atp_supply_demand => l_atp_supply_demand

Line 8841: oe_debug_pub.add('2. After Calling MRP_ATP_PUB.Call_ATP' ||

8837: , x_msg_data => mrp_msg_data
8838: , x_msg_count => l_msg_count);
8839:
8840:
8841: oe_debug_pub.add('2. After Calling MRP_ATP_PUB.Call_ATP' ||
8842: l_return_status,1);
8843:
8844: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9719: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;

9715: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9716: )
9717: IS
9718: l_model_line_rec OE_ORDER_PUB.line_rec_type;
9719: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
9720: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
9721: l_ship_set VARCHAR2(30);
9722: lTableName VARCHAR2(30);
9723: lMessageName VARCHAR2(30);

Line 9720: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;

9716: )
9717: IS
9718: l_model_line_rec OE_ORDER_PUB.line_rec_type;
9719: l_model_rec MRP_ATP_PUB.ATP_Rec_Typ;
9720: l_smc_rec MRP_ATP_PUB.ATP_Rec_Typ;
9721: l_ship_set VARCHAR2(30);
9722: lTableName VARCHAR2(30);
9723: lMessageName VARCHAR2(30);
9724: lErrorMessage VARCHAR2(2000);

Line 9771: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr

9767: Get_Lead_Time
9768: (p_ato_line_id => l_model_line_rec.ato_line_id,
9769: p_ship_from_org_id => l_model_line_rec.ship_from_org_id);
9770:
9771: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
9772: (l_model_line_rec.Inventory_Item_Id);
9773:
9774: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
9775: (l_model_line_rec.ship_from_org_id);

Line 9774: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr

9770:
9771: l_model_rec.Inventory_Item_Id := MRP_ATP_PUB.number_arr
9772: (l_model_line_rec.Inventory_Item_Id);
9773:
9774: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
9775: (l_model_line_rec.ship_from_org_id);
9776:
9777: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
9778: (l_model_line_rec.line_id);

Line 9777: l_model_rec.Identifier := MRP_ATP_PUB.number_arr

9773:
9774: l_model_rec.Source_Organization_Id := MRP_ATP_PUB.number_arr
9775: (l_model_line_rec.ship_from_org_id);
9776:
9777: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
9778: (l_model_line_rec.line_id);
9779:
9780: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
9781: (660);

Line 9780: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr

9776:
9777: l_model_rec.Identifier := MRP_ATP_PUB.number_arr
9778: (l_model_line_rec.line_id);
9779:
9780: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
9781: (660);
9782:
9783: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
9784: (l_model_line_rec.sold_to_org_id);

Line 9783: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr

9779:
9780: l_model_rec.Calling_Module := MRP_ATP_PUB.number_arr
9781: (660);
9782:
9783: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
9784: (l_model_line_rec.sold_to_org_id);
9785:
9786: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
9787: (l_model_line_rec.ship_to_org_id);

Line 9786: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr

9782:
9783: l_model_rec.Customer_Id := MRP_ATP_PUB.number_arr
9784: (l_model_line_rec.sold_to_org_id);
9785:
9786: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
9787: (l_model_line_rec.ship_to_org_id);
9788:
9789: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
9790: (null);

Line 9789: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr

9785:
9786: l_model_rec.Customer_Site_Id := MRP_ATP_PUB.number_arr
9787: (l_model_line_rec.ship_to_org_id);
9788:
9789: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
9790: (null);
9791:
9792: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
9793: (l_model_line_rec.ordered_quantity);

Line 9792: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr

9788:
9789: l_model_rec.Destination_Time_Zone := MRP_ATP_PUB.char30_arr
9790: (null);
9791:
9792: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
9793: (l_model_line_rec.ordered_quantity);
9794:
9795: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
9796: (l_model_line_rec.order_quantity_uom);

Line 9795: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr

9791:
9792: l_model_rec.Quantity_Ordered := MRP_ATP_PUB.number_arr
9793: (l_model_line_rec.ordered_quantity);
9794:
9795: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
9796: (l_model_line_rec.order_quantity_uom);
9797:
9798: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
9799: (l_model_line_rec.Earliest_Acceptable_Date);

Line 9798: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr

9794:
9795: l_model_rec.Quantity_UOM := MRP_ATP_PUB.char3_arr
9796: (l_model_line_rec.order_quantity_uom);
9797:
9798: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
9799: (l_model_line_rec.Earliest_Acceptable_Date);
9800:
9801: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
9802: (l_model_line_rec.request_date);

Line 9801: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr

9797:
9798: l_model_rec.Earliest_Acceptable_Date := MRP_ATP_PUB.date_arr
9799: (l_model_line_rec.Earliest_Acceptable_Date);
9800:
9801: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
9802: (l_model_line_rec.request_date);
9803:
9804: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
9805: (l_model_line_rec.request_date);

Line 9804: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr

9800:
9801: l_model_rec.Requested_Ship_Date := MRP_ATP_PUB.date_arr
9802: (l_model_line_rec.request_date);
9803:
9804: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
9805: (l_model_line_rec.request_date);
9806:
9807: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
9808: (l_model_line_rec.Latest_Acceptable_Date);

Line 9807: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr

9803:
9804: l_model_rec.Requested_Arrival_Date := MRP_ATP_PUB.date_arr
9805: (l_model_line_rec.request_date);
9806:
9807: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
9808: (l_model_line_rec.Latest_Acceptable_Date);
9809:
9810: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
9811: (l_model_line_rec.Delivery_Lead_Time);

Line 9810: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr

9806:
9807: l_model_rec.Latest_Acceptable_Date := MRP_ATP_PUB.date_arr
9808: (l_model_line_rec.Latest_Acceptable_Date);
9809:
9810: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
9811: (l_model_line_rec.Delivery_Lead_Time);
9812: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
9813: (l_st_atp_lead_time);
9814:

Line 9812: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr

9808: (l_model_line_rec.Latest_Acceptable_Date);
9809:
9810: l_model_rec.Delivery_Lead_Time := MRP_ATP_PUB.number_arr
9811: (l_model_line_rec.Delivery_Lead_Time);
9812: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
9813: (l_st_atp_lead_time);
9814:
9815: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
9816: (l_model_line_rec.Freight_Carrier_Code);

Line 9815: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr

9811: (l_model_line_rec.Delivery_Lead_Time);
9812: l_model_rec.Atp_lead_Time := MRP_ATP_PUB.number_arr
9813: (l_st_atp_lead_time);
9814:
9815: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
9816: (l_model_line_rec.Freight_Carrier_Code);
9817:
9818: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
9819: (null);

Line 9818: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr

9814:
9815: l_model_rec.Freight_Carrier := MRP_ATP_PUB.char30_arr
9816: (l_model_line_rec.Freight_Carrier_Code);
9817:
9818: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
9819: (null);
9820:
9821: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
9822: (l_model_line_rec.Demand_Class_Code);

Line 9821: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr

9817:
9818: l_model_rec.Ship_Method := MRP_ATP_PUB.char30_arr
9819: (null);
9820:
9821: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
9822: (l_model_line_rec.Demand_Class_Code);
9823:
9824: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
9825: (l_model_line_rec.ship_set_id);

Line 9824: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr

9820:
9821: l_model_rec.Demand_Class := MRP_ATP_PUB.char30_arr
9822: (l_model_line_rec.Demand_Class_Code);
9823:
9824: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
9825: (l_model_line_rec.ship_set_id);
9826:
9827: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
9828: (l_model_line_rec.arrival_set_id);

Line 9827: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr

9823:
9824: l_model_rec.Ship_Set_Name := MRP_ATP_PUB.char30_arr
9825: (l_model_line_rec.ship_set_id);
9826:
9827: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
9828: (l_model_line_rec.arrival_set_id);
9829:
9830: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
9831: (null);

Line 9830: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr

9826:
9827: l_model_rec.Arrival_Set_Name := MRP_ATP_PUB.char30_arr
9828: (l_model_line_rec.arrival_set_id);
9829:
9830: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
9831: (null);
9832:
9833: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
9834: (null);

Line 9833: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr

9829:
9830: l_model_rec.Override_Flag := MRP_ATP_PUB.char1_arr
9831: (null);
9832:
9833: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
9834: (null);
9835:
9836: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
9837: (null);

Line 9836: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr

9832:
9833: l_model_rec.Ship_Date := MRP_ATP_PUB.date_arr
9834: (null);
9835:
9836: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
9837: (null);
9838:
9839: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
9840: (null);

Line 9839: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr

9835:
9836: l_model_rec.Available_Quantity := MRP_ATP_PUB.number_arr
9837: (null);
9838:
9839: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
9840: (null);
9841:
9842: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
9843: (null);

Line 9842: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr

9838:
9839: l_model_rec.Requested_Date_Quantity := MRP_ATP_PUB.number_arr
9840: (null);
9841:
9842: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
9843: (null);
9844:
9845: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
9846: (null);

Line 9845: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr

9841:
9842: l_model_rec.Group_Ship_Date := MRP_ATP_PUB.date_arr
9843: (null);
9844:
9845: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
9846: (null);
9847:
9848: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
9849: (null);

Line 9848: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr

9844:
9845: l_model_rec.Group_Arrival_Date := MRP_ATP_PUB.date_arr
9846: (null);
9847:
9848: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
9849: (null);
9850:
9851: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
9852: (null);

Line 9851: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr

9847:
9848: l_model_rec.Vendor_Id := MRP_ATP_PUB.number_arr
9849: (null);
9850:
9851: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
9852: (null);
9853:
9854: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
9855: (null);

Line 9854: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr

9850:
9851: l_model_rec.Vendor_Site_Id := MRP_ATP_PUB.number_arr
9852: (null);
9853:
9854: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
9855: (null);
9856:
9857: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
9858: (null);

Line 9857: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr

9853:
9854: l_model_rec.Insert_Flag := MRP_ATP_PUB.number_arr
9855: (null);
9856:
9857: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
9858: (null);
9859:
9860: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
9861: (null);

Line 9860: l_model_rec.Message := MRP_ATP_PUB.char2000_arr

9856:
9857: l_model_rec.Error_Code := MRP_ATP_PUB.number_arr
9858: (null);
9859:
9860: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
9861: (null);
9862:
9863: l_model_rec.Action := MRP_ATP_PUB.number_arr
9864: (null);

Line 9863: l_model_rec.Action := MRP_ATP_PUB.number_arr

9859:
9860: l_model_rec.Message := MRP_ATP_PUB.char2000_arr
9861: (null);
9862:
9863: l_model_rec.Action := MRP_ATP_PUB.number_arr
9864: (null);
9865:
9866: l_order_number := Get_order_number(l_model_line_rec.header_id);
9867:

Line 9868: l_model_rec.Order_number := MRP_ATP_PUB.number_arr

9864: (null);
9865:
9866: l_order_number := Get_order_number(l_model_line_rec.header_id);
9867:
9868: l_model_rec.Order_number := MRP_ATP_PUB.number_arr
9869: (l_order_number);
9870:
9871: IF l_debug_level > 0 THEN
9872: oe_debug_pub.add( '1.. CALLING CTO GET_BOM_MANDATORY_COMPS' , 1 ) ;