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 OE_ATP

Line 634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type

630: ( p_old_line_rec IN OE_ORDER_PUB.line_rec_type
631: , p_write_to_db IN VARCHAR2
632: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type
633: , p_recursive_call IN VARCHAR2
634: , x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.Atp_Tbl_Type
635: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
636: IS
637: l_line_rec OE_ORDER_PUB.line_rec_type;
638: l_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 653: l_out_atp_tbl OE_ATP.atp_tbl_type;

649: l_old_ordered_quantity NUMBER;
650: l_out_line_rec OE_ORDER_PUB.line_rec_type;
651: K NUMBER :=0;
652: atp_count NUMBER :=0;
653: l_out_atp_tbl OE_ATP.atp_tbl_type;
654: l_return_status VARCHAR2(1);
655: l_schedule_action_code VARCHAR2(30);
656: l_sales_order_id NUMBER;
657: l_old_recursion_mode VARCHAR2(1);

Line 1027: l_atp_tbl OE_ATP.atp_tbl_type;

1023: IS
1024: l_return_status VARCHAR2(1);
1025: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1026: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1027: l_atp_tbl OE_ATP.atp_tbl_type;
1028: l_count NUMBER;
1029: --
1030: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1031: --

Line 1183: x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,

1179: p_write_to_db IN VARCHAR2,
1180: p_update_flag IN VARCHAR2 := FND_API.G_TRUE,
1181: p_recursive_call IN VARCHAR2 := FND_API.G_TRUE,
1182: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
1183: x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,
1184: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1185: )
1186: IS
1187: l_schedule_line_rec request_rec_type;

Line 1193: l_out_atp_tbl OE_ATP.atp_tbl_type;

1189: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1190: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1191: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1192: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1193: l_out_atp_tbl OE_ATP.atp_tbl_type;
1194: l_request_rec request_rec_type;
1195: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
1196: l_out_request_rec request_rec_type;
1197: l_need_sch BOOLEAN;

Line 3553: l_old_atp_tbl OE_ATP.atp_tbl_type;

3549: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3550: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3551: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3552: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3553: l_old_atp_tbl OE_ATP.atp_tbl_type;
3554: l_return_status VARCHAR2(1);
3555: l_msg_count NUMBER;
3556: l_msg_data VARCHAR2(2000);
3557:

Line 3564: l_out_atp_tbl OE_ATP.atp_tbl_type;

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;
3568: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 3957: l_old_atp_tbl OE_ATP.atp_tbl_type;

3953: l_out_line_rec OE_ORDER_PUB.line_rec_type;
3954: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3955: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3956: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
3957: l_old_atp_tbl OE_ATP.atp_tbl_type;
3958: l_return_status VARCHAR2(1);
3959: l_msg_count NUMBER;
3960: l_msg_data VARCHAR2(2000);
3961: l_out_atp_rec OE_ATP.atp_rec_type;

Line 3961: l_out_atp_rec OE_ATP.atp_rec_type;

3957: l_old_atp_tbl OE_ATP.atp_tbl_type;
3958: l_return_status VARCHAR2(1);
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;

Line 3968: l_out_atp_tbl OE_ATP.atp_tbl_type;

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;
3972: l_qty_to_unreserve NUMBER;

Line 4106: x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,

4102: --------------------------------------------------------------------- */
4103:
4104: Procedure Process_request( p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
4105: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
4106: x_out_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.atp_tbl_type,
4107: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
4108: IS
4109:
4110: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 4115: l_out_atp_rec OE_ATP.atp_rec_type;

4111: l_line_rec OE_ORDER_PUB.line_rec_type;
4112: l_line_tbl OE_ORDER_PUB.line_tbl_type;
4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;
4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4119: l_action VARCHAR2(30);

Line 4117: l_out_atp_tbl OE_ATP.atp_tbl_type;

4113: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
4114: l_out_line_rec OE_ORDER_PUB.line_rec_type;
4115: l_out_atp_rec OE_ATP.atp_rec_type;
4116: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
4117: l_out_atp_tbl OE_ATP.atp_tbl_type;
4118: l_old_line_rec OE_ORDER_PUB.line_rec_type;
4119: l_action VARCHAR2(30);
4120: l_old_status VARCHAR2(30);
4121: l_msg_count NUMBER;

Line 7287: , x_atp_tbl OUT NOCOPY /* file.sql.39 change */ OE_ATP.ATP_Tbl_Type

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
7290: I NUMBER := 0;
7291: J NUMBER := 0;

Line 7294: l_atp_rec OE_ATP.atp_rec_type;

7290: I NUMBER := 0;
7291: J NUMBER := 0;
7292: ATP NUMBER := 0;
7293: l_line_rec OE_ORDER_PUB.line_rec_type;
7294: l_atp_rec OE_ATP.atp_rec_type;
7295: l_msg_count NUMBER;
7296: l_msg_data VARCHAR2(2000);
7297: l_explanation VARCHAR2(80);
7298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 8366: l_out_atp_tbl OE_ATP.atp_tbl_type;

8362: mrp_msg_data VARCHAR2(200);
8363: l_on_hand_qty NUMBER;
8364: l_avail_to_reserve NUMBER;
8365:
8366: l_out_atp_tbl OE_ATP.atp_tbl_type;
8367: l_found BOOLEAN := FALSE;
8368: l_buffer VARCHAR2(2000);
8369: l_msg_count NUMBER;
8370: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 8674: --l_out_atp_tbl OE_ATP.atp_tbl_type;

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;
8675: l_found BOOLEAN := FALSE;
8676: l_buffer VARCHAR2(2000);
8677:
8678: