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_GRP_SCH_UTIL dependencies on OE_ORDER_PUB

Line 8: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);

4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_GRP_SCH_UTIL';
5:
6: PROCEDURE Query_Lines
7: ( p_header_id IN NUMBER,
8: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);
9:
10: Procedure Validate_Group_Request
11: (p_group_req_rec IN OE_GRP_SCH_UTIL.Sch_Group_Rec_Type
12: ,x_return_status OUT NOCOPY VARCHAR2);

Line 16: (p_line_tbl IN OE_ORDER_PUB.line_tbl_type

12: ,x_return_status OUT NOCOPY VARCHAR2);
13:
14:
15: Procedure Validate_Warehouse
16: (p_line_tbl IN OE_ORDER_PUB.line_tbl_type
17: ,p_ship_from_org_id IN NUMBER
18: ,x_return_status OUT NOCOPY VARCHAR2);
19:
20:

Line 25: FUNCTION Delink_Required(p_line_rec IN OE_ORDER_PUB.line_rec_type)

21: /*--------------------------------------------------------------------
22: Procedure Name : Delink_Required
23: Description : ** Currently not used **
24: ---------------------------------------------------------------------*/
25: FUNCTION Delink_Required(p_line_rec IN OE_ORDER_PUB.line_rec_type)
26: RETURN BOOLEAN
27: IS
28: --
29: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 37: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

33: END Delink_Required;
34: /*--------------------------------------------------------------------
35: Procedure Name : Validate_Line
36: ---------------------------------------------------------------------*/
37: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
38: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
39: x_return_status OUT NOCOPY VARCHAR2)
40:
41: IS

Line 38: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,

34: /*--------------------------------------------------------------------
35: Procedure Name : Validate_Line
36: ---------------------------------------------------------------------*/
37: Procedure Validate_Line(p_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
38: p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type,
39: x_return_status OUT NOCOPY VARCHAR2)
40:
41: IS
42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 595: l_old_line_rec OE_ORDER_PUB.line_rec_type;

591:
592: x_msg_data OUT NOCOPY VARCHAR2)
593:
594: IS
595: l_old_line_rec OE_ORDER_PUB.line_rec_type;
596: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
597: l_out_atp_rec OE_ATP.atp_rec_type;
598: l_out_atp_tbl OE_ATP.atp_tbl_type;
599: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 596: --l_out_line_rec OE_ORDER_PUB.line_rec_type;

592: x_msg_data OUT NOCOPY VARCHAR2)
593:
594: IS
595: l_old_line_rec OE_ORDER_PUB.line_rec_type;
596: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
597: l_out_atp_rec OE_ATP.atp_rec_type;
598: l_out_atp_tbl OE_ATP.atp_tbl_type;
599: l_line_rec OE_ORDER_PUB.line_rec_type;
600: l_return_status VARCHAR2(1);

Line 599: l_line_rec OE_ORDER_PUB.line_rec_type;

595: l_old_line_rec OE_ORDER_PUB.line_rec_type;
596: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
597: l_out_atp_rec OE_ATP.atp_rec_type;
598: l_out_atp_tbl OE_ATP.atp_tbl_type;
599: l_line_rec OE_ORDER_PUB.line_rec_type;
600: l_return_status VARCHAR2(1);
601: l_msg_count NUMBER;
602: l_msg_data VARCHAR2(2000);
603:

Line 605: l_line_tbl OE_ORDER_PUB.line_tbl_type;

601: l_msg_count NUMBER;
602: l_msg_data VARCHAR2(2000);
603:
604: l_control_rec OE_GLOBALS.control_rec_type;
605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

602: l_msg_data VARCHAR2(2000);
603:
604: l_control_rec OE_GLOBALS.control_rec_type;
605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 607: l_header_rec OE_Order_PUB.Header_Rec_Type;

603:
604: l_control_rec OE_GLOBALS.control_rec_type;
605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

604: l_control_rec OE_GLOBALS.control_rec_type;
605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

605: l_line_tbl OE_ORDER_PUB.line_tbl_type;
606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

606: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

607: l_header_rec OE_Order_PUB.Header_Rec_Type;
608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

608: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

609: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

610: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

611: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
619:

Line 616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

612: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
619:
620: l_arrival_set_id NUMBER;

Line 617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

613: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
614: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
615: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
616: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
617: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
618: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
619:
620: l_arrival_set_id NUMBER;
621: l_ato_line_id NUMBER;

Line 1118: l_line_rec OE_ORDER_PUB.line_rec_type;

1114:
1115: IS
1116: l_line_id NUMBER;
1117: l_atp_tbl OE_ATP.atp_tbl_type;
1118: l_line_rec OE_ORDER_PUB.line_rec_type;
1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;

Line 1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;

1115: IS
1116: l_line_id NUMBER;
1117: l_atp_tbl OE_ATP.atp_tbl_type;
1118: l_line_rec OE_ORDER_PUB.line_rec_type;
1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;

Line 1120: l_option_rec OE_ORDER_PUB.line_rec_type;

1116: l_line_id NUMBER;
1117: l_atp_tbl OE_ATP.atp_tbl_type;
1118: l_line_rec OE_ORDER_PUB.line_rec_type;
1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;

Line 1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;

1117: l_atp_tbl OE_ATP.atp_tbl_type;
1118: l_line_rec OE_ORDER_PUB.line_rec_type;
1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;

Line 1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;

1118: l_line_rec OE_ORDER_PUB.line_rec_type;
1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1126: l_out_atp_rec OE_ATP.atp_rec_type;

Line 1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;

1119: l_config_line_rec OE_ORDER_PUB.line_rec_type;
1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1126: l_out_atp_rec OE_ATP.atp_rec_type;
1127: l_return_status VARCHAR2(1);

Line 1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;

1120: l_option_rec OE_ORDER_PUB.line_rec_type;
1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1126: l_out_atp_rec OE_ATP.atp_rec_type;
1127: l_return_status VARCHAR2(1);
1128: l_msg_count NUMBER;

Line 1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;

1121: l_option_tbl OE_ORDER_PUB.line_tbl_type;
1122: l_old_option_tbl OE_ORDER_PUB.line_tbl_type;
1123: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1124: l_out_line_rec OE_ORDER_PUB.line_rec_type;
1125: l_model_line_rec OE_ORDER_PUB.line_rec_type;
1126: l_out_atp_rec OE_ATP.atp_rec_type;
1127: l_return_status VARCHAR2(1);
1128: l_msg_count NUMBER;
1129: l_msg_data VARCHAR2(2000);

Line 1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;

1129: l_msg_data VARCHAR2(2000);
1130: l_action VARCHAR2(30) := NULL;
1131: -- For calling process order.
1132: l_control_rec OE_GLOBALS.control_rec_type;
1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

1130: l_action VARCHAR2(30) := NULL;
1131: -- For calling process order.
1132: l_control_rec OE_GLOBALS.control_rec_type;
1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;

1131: -- For calling process order.
1132: l_control_rec OE_GLOBALS.control_rec_type;
1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1136: l_header_rec OE_Order_PUB.Header_Rec_Type;

1132: l_control_rec OE_GLOBALS.control_rec_type;
1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;

1133: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1134: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1135: l_header_out_rec OE_Order_PUB.Header_Rec_Type;
1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1136: l_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1137: l_line_out_tbl OE_Order_PUB.Line_Tbl_Type;
1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1138: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

1139: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

1140: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

1141: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

1142: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1150:

Line 1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

1143: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1150:
1151: l_component_ratio NUMBER;

Line 1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

1144: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1150:
1151: l_component_ratio NUMBER;
1152: l_model_quantity_chg NUMBER;

Line 1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

1145: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
1146: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
1147: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
1148: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
1149: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
1150:
1151: l_component_ratio NUMBER;
1152: l_model_quantity_chg NUMBER;
1153: l_ato_model_quantity NUMBER;

Line 1440: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;

1436: END IF;
1437:
1438: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1439: l_line_tbl(I) := l_line_rec;
1440: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
1441:
1442: END LOOP;
1443:
1444: -- Added a code to fix bug 2275374.

Line 1557: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type)

1553: p_entity_type VARCHAR2,
1554: p_ship_set_id NUMBER,
1555: p_arrival_set_id NUMBER,
1556: p_line_id NUMBER,
1557: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type)
1558: IS
1559: l_line_rec OE_Order_PUB.Line_Rec_Type;
1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1559: l_line_rec OE_Order_PUB.Line_Rec_Type;

1555: p_arrival_set_id NUMBER,
1556: p_line_id NUMBER,
1557: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type)
1558: IS
1559: l_line_rec OE_Order_PUB.Line_Rec_Type;
1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;
1562: l_ii_line_tbl OE_Order_PUB.Line_Tbl_Type;
1563: K NUMBER := 0;

Line 1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

1556: p_line_id NUMBER,
1557: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type)
1558: IS
1559: l_line_rec OE_Order_PUB.Line_Rec_Type;
1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;
1562: l_ii_line_tbl OE_Order_PUB.Line_Tbl_Type;
1563: K NUMBER := 0;
1564: J NUMBER := 0;

Line 1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;

1557: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type)
1558: IS
1559: l_line_rec OE_Order_PUB.Line_Rec_Type;
1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;
1562: l_ii_line_tbl OE_Order_PUB.Line_Tbl_Type;
1563: K NUMBER := 0;
1564: J NUMBER := 0;
1565: orig_count NUMBER;

Line 1562: l_ii_line_tbl OE_Order_PUB.Line_Tbl_Type;

1558: IS
1559: l_line_rec OE_Order_PUB.Line_Rec_Type;
1560: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1561: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;
1562: l_ii_line_tbl OE_Order_PUB.Line_Tbl_Type;
1563: K NUMBER := 0;
1564: J NUMBER := 0;
1565: orig_count NUMBER;
1566: l_sales_order_id NUMBER;

Line 1744: p_line_tbl IN OE_ORDER_PUB.line_tbl_type,

1740: Description: ** Currently not used **
1741: ---------------------------------------------------------------*/
1742: Procedure Validate_Set_Attributes
1743: (p_entity_type IN VARCHAR2,
1744: p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
1745: x_return_status OUT NOCOPY VARCHAR2) IS
1746:
1747: --
1748: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;

1760:
1761: x_return_status OUT NOCOPY VARCHAR2)
1762:
1763: IS
1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

1761: x_return_status OUT NOCOPY VARCHAR2)
1762:
1763: IS
1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;

Line 1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

1762:
1763: IS
1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;

Line 1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;

1763: IS
1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;
1771: l_atp_tbl OE_ATP.atp_tbl_type;

Line 1768: l_line_rec OE_ORDER_PUB.line_rec_type;

1764: l_line_tbl OE_ORDER_PUB.line_tbl_type;
1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;
1771: l_atp_tbl OE_ATP.atp_tbl_type;
1772: l_Ship_From_Org_Id NUMBER := null;

Line 1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;

1765: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;
1771: l_atp_tbl OE_ATP.atp_tbl_type;
1772: l_Ship_From_Org_Id NUMBER := null;
1773: l_Ship_To_Org_Id NUMBER := null;

Line 1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;

1766: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
1767: l_included_items_tbl OE_ORDER_PUB.line_tbl_type;
1768: l_line_rec OE_ORDER_PUB.line_rec_type;
1769: l_old_line_rec OE_ORDER_PUB.line_rec_type;
1770: l_new_line_rec OE_ORDER_PUB.line_rec_type;
1771: l_atp_tbl OE_ATP.atp_tbl_type;
1772: l_Ship_From_Org_Id NUMBER := null;
1773: l_Ship_To_Org_Id NUMBER := null;
1774: l_Schedule_Ship_Date DATE := null;

Line 2224: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,

2220: part of a set.
2221: ---------------------------------------------------------------*/
2222:
2223: Procedure Schedule_set_of_lines
2224: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
2225: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
2226: x_return_status OUT NOCOPY VARCHAR2)
2227:
2228: IS

Line 2225: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

2221: ---------------------------------------------------------------*/
2222:
2223: Procedure Schedule_set_of_lines
2224: (p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type,
2225: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
2226: x_return_status OUT NOCOPY VARCHAR2)
2227:
2228: IS
2229: l_atp_tbl OE_ATP.ATP_Tbl_Type;

Line 2230: l_line_rec OE_ORDER_PUB.line_rec_type;

2226: x_return_status OUT NOCOPY VARCHAR2)
2227:
2228: IS
2229: l_atp_tbl OE_ATP.ATP_Tbl_Type;
2230: l_line_rec OE_ORDER_PUB.line_rec_type;
2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;
2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2227:
2228: IS
2229: l_atp_tbl OE_ATP.ATP_Tbl_Type;
2230: l_line_rec OE_ORDER_PUB.line_rec_type;
2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;
2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;
2235: l_return_status VARCHAR2(1);

Line 2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;

2228: IS
2229: l_atp_tbl OE_ATP.ATP_Tbl_Type;
2230: l_line_rec OE_ORDER_PUB.line_rec_type;
2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;
2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;
2235: l_return_status VARCHAR2(1);
2236: K NUMBER := 0;

Line 2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2229: l_atp_tbl OE_ATP.ATP_Tbl_Type;
2230: l_line_rec OE_ORDER_PUB.line_rec_type;
2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;
2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;
2235: l_return_status VARCHAR2(1);
2236: K NUMBER := 0;
2237: J NUMBER := 0;

Line 2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;

2230: l_line_rec OE_ORDER_PUB.line_rec_type;
2231: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2232: l_grp_line_tbl OE_ORDER_PUB.line_tbl_type;
2233: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2234: l_ii_line_tbl OE_ORDER_PUB.line_tbl_type;
2235: l_return_status VARCHAR2(1);
2236: K NUMBER := 0;
2237: J NUMBER := 0;
2238: l_old_recursion_mode VARCHAR2(1);

Line 2759: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type

2755: Description:
2756: ---------------------------------------------------------------*/
2757:
2758: Procedure Process_set_of_lines
2759: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
2760: := OE_ORDER_PUB.G_MISS_LINE_TBL,
2761: p_write_to_db IN VARCHAR2 := FND_API.G_TRUE,
2762: x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
2763:

Line 2760: := OE_ORDER_PUB.G_MISS_LINE_TBL,

2756: ---------------------------------------------------------------*/
2757:
2758: Procedure Process_set_of_lines
2759: ( p_old_line_tbl IN OE_ORDER_PUB.line_tbl_type
2760: := OE_ORDER_PUB.G_MISS_LINE_TBL,
2761: p_write_to_db IN VARCHAR2 := FND_API.G_TRUE,
2762: x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
2763:
2764: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

Line 2764: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

2760: := OE_ORDER_PUB.G_MISS_LINE_TBL,
2761: p_write_to_db IN VARCHAR2 := FND_API.G_TRUE,
2762: x_atp_tbl OUT NOCOPY OE_ATP.Atp_Tbl_Type,
2763:
2764: p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
2765: p_log_msg IN VARCHAR2 := 'Y',
2766: x_return_status OUT NOCOPY VARCHAR2)
2767:
2768: IS

Line 2769: l_line_tbl OE_ORDER_PUB.line_tbl_type;

2765: p_log_msg IN VARCHAR2 := 'Y',
2766: x_return_status OUT NOCOPY VARCHAR2)
2767:
2768: IS
2769: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2770: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
2771: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2772: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
2773: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 2770: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;

2766: x_return_status OUT NOCOPY VARCHAR2)
2767:
2768: IS
2769: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2770: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
2771: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2772: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
2773: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
2774: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;

Line 2771: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

2767:
2768: IS
2769: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2770: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
2771: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2772: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
2773: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
2774: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
2775: l_out_atp_table OE_ATP.ATP_Tbl_Type;

Line 2772: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;

2768: IS
2769: l_line_tbl OE_ORDER_PUB.line_tbl_type;
2770: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
2771: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
2772: l_out_line_tbl OE_ORDER_PUB.line_tbl_type;
2773: l_mrp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
2774: l_out_mtp_atp_rec MRP_ATP_PUB.ATP_Rec_Typ;
2775: l_out_atp_table OE_ATP.ATP_Tbl_Type;
2776: l_atp_supply_demand MRP_ATP_PUB.ATP_Supply_Demand_Typ;

Line 2800: l_old_line_tbl1 OE_ORDER_PUB.line_tbl_type;

2796: l_qty_to_reserve NUMBER;
2797: l_rsv_id NUMBER;
2798: l_buffer VARCHAR2(2000);
2799:
2800: l_old_line_tbl1 OE_ORDER_PUB.line_tbl_type;
2801: l_out_line_tbl1 OE_ORDER_PUB.line_tbl_type;
2802: K NUMBER := 0;
2803: M NUMBER := 0;
2804: N NUMBER := 0;

Line 2801: l_out_line_tbl1 OE_ORDER_PUB.line_tbl_type;

2797: l_rsv_id NUMBER;
2798: l_buffer VARCHAR2(2000);
2799:
2800: l_old_line_tbl1 OE_ORDER_PUB.line_tbl_type;
2801: l_out_line_tbl1 OE_ORDER_PUB.line_tbl_type;
2802: K NUMBER := 0;
2803: M NUMBER := 0;
2804: N NUMBER := 0;
2805: l_process_requests BOOLEAN;

Line 3742: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

3738: because we want to sort the table in a particular format.
3739: ------------------------------------------------------------------- */
3740: PROCEDURE Query_Lines
3741: ( p_header_id IN NUMBER,
3742: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3743: )
3744: IS
3745: l_line_rec OE_Order_PUB.Line_Rec_Type;
3746: --l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 3745: l_line_rec OE_Order_PUB.Line_Rec_Type;

3741: ( p_header_id IN NUMBER,
3742: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3743: )
3744: IS
3745: l_line_rec OE_Order_PUB.Line_Rec_Type;
3746: --l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3747: l_org_id NUMBER;
3748:
3749: CURSOR l_line_csr IS

Line 3746: --l_line_tbl OE_Order_PUB.Line_Tbl_Type;

3742: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
3743: )
3744: IS
3745: l_line_rec OE_Order_PUB.Line_Rec_Type;
3746: --l_line_tbl OE_Order_PUB.Line_Tbl_Type;
3747: l_org_id NUMBER;
3748:
3749: CURSOR l_line_csr IS
3750: SELECT LINE_ID

Line 3869: (p_line_tbl IN OE_ORDER_PUB.line_tbl_type

3865: that is passed in.
3866:
3867: ---------------------------------------------------------------*/
3868: Procedure Validate_Warehouse
3869: (p_line_tbl IN OE_ORDER_PUB.line_tbl_type
3870: ,p_ship_from_org_id IN NUMBER
3871: ,x_return_status OUT NOCOPY VARCHAR2)
3872:
3873: IS

Line 3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;

3930: initial Integer;
3931: nextpos Integer;
3932: l_record_ids VARCHAR2(2000) := p_line_list || ',';
3933: l_line_id NUMBER;
3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;

3931: nextpos Integer;
3932: l_record_ids VARCHAR2(2000) := p_line_list || ',';
3933: l_line_id NUMBER;
3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;

Line 3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

3932: l_record_ids VARCHAR2(2000) := p_line_list || ',';
3933: l_line_id NUMBER;
3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;

Line 3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;

3933: l_line_id NUMBER;
3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;
3941: l_return_status VARCHAR2(1);

Line 3938: l_line_rec OE_ORDER_PUB.line_rec_type;

3934: l_line_tbl OE_ORDER_PUB.line_tbl_type;
3935: l_option_tbl OE_ORDER_PUB.line_tbl_type;
3936: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
3937: l_new_line_tbl OE_ORDER_PUB.line_tbl_type;
3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;
3941: l_return_status VARCHAR2(1);
3942: --l_out_line_rec OE_ORDER_PUB.line_rec_type;

Line 3942: --l_out_line_rec OE_ORDER_PUB.line_rec_type;

3938: l_line_rec OE_ORDER_PUB.line_rec_type;
3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;
3941: l_return_status VARCHAR2(1);
3942: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
3943: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3944: atp_count NUMBER;
3945: line_count NUMBER := 0;
3946: option_count NUMBER;

Line 3943: l_old_line_rec OE_ORDER_PUB.line_rec_type;

3939: l_group_req_rec OE_GRP_SCH_UTIL.Sch_Group_Rec_Type;
3940: l_out_atp_tbl OE_ATP.atp_tbl_type;
3941: l_return_status VARCHAR2(1);
3942: --l_out_line_rec OE_ORDER_PUB.line_rec_type;
3943: l_old_line_rec OE_ORDER_PUB.line_rec_type;
3944: atp_count NUMBER;
3945: line_count NUMBER := 0;
3946: option_count NUMBER;
3947: l_option_exists NUMBER; -- Bug-2287767