DBA Data[Home] [Help]

APPS.OE_INV_IFACE_PVT dependencies on OE_ORDER_PUB

Line 34: l_line_rec OE_Order_Pub.Line_Rec_Type;

30:
31: )
32: IS
33: l_return_status VARCHAR2(30);
34: l_line_rec OE_Order_Pub.Line_Rec_Type;
35: l_sales_order_id NUMBER;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(4000);
38: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

Line 77: l_line_tbl OE_ORDER_PUB.line_tbl_type;

73: l_ordered_date DATE;
74: -- Process Order arguments
75:
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;

Line 78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;

74: -- Process Order arguments
75:
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 80: l_header_rec OE_Order_PUB.Header_Rec_Type;

76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;

77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;

78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

80: l_header_rec OE_Order_PUB.Header_Rec_Type;
81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

81: l_new_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC;
82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

Line 86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

82: l_new_line_tbl OE_Order_PUB.Line_Tbl_Type;
83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

83: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

Line 88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

84: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

85: l_line_adj_out_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

86: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

87: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */

Line 92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

88: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:

Line 93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

89: l_Header_Adj_Att_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:
97: /* -- HW OPM BUG#:2536589 added variable to hold item_rec information

Line 94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

90: l_Header_Adj_Assoc_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
91: l_Header_price_Att_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
92: l_Line_Price_Att_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
93: l_Line_Adj_Att_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
94: l_Line_Adj_Assoc_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
95: */
96:
97: /* -- HW OPM BUG#:2536589 added variable to hold item_rec information
98: l_item_rec OE_ORDER_CACHE.item_rec_type;