[Home] [Help]
46: l_return_values varchar2(50);
47: l_return_status VARCHAR2(1) ;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec OE_Order_PUB.Header_Rec_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
47: l_return_status VARCHAR2(1) ;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec OE_Order_PUB.Header_Rec_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec OE_Order_PUB.Header_Rec_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
49: l_msg_data VARCHAR2(2000);
50: l_header_rec OE_Order_PUB.Header_Rec_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
50: l_header_rec OE_Order_PUB.Header_Rec_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
51: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
52: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
53: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
54: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
55: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
56: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
57: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
58: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
59: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
60: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
61: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
62: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
63: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
64: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
65: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
66: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
67: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
68: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
69: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
70: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
71: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
72:
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
73: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
74: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
75: OE_Order_PUB.G_MISS_REQUEST_TBL;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
76:
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
77: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
78: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
79: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
80: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
81: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
82: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
83: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
84: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
85: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
86: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
87: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
88: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
96: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
89: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
96: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
97:
90: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
96: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
97:
98: l_message_data varchar2(2000);
91: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
96: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
97:
98: l_message_data varchar2(2000);
99: l_proc varchar2(72) := g_package||'cancel_order';
92: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
93: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
94: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
95: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
96: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
97:
98: l_message_data varchar2(2000);
99: l_proc varchar2(72) := g_package||'cancel_order';
100: l_err_num VARCHAR2(30) := '';
145: -- IF l_ordered_quantity is not null and l_ordered_quantity > 0 THEN
146: IF l_ordered_quantity is not null and l_ordered_quantity > 0 and l_caller_source is null THEN -- Bug 2707198
147: BEGIN
148: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support
149: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
150: --l_header_rec.header_id := l_header_id;
151: l_line_rec.operation := OE_Globals.G_OPR_UPDATE ;
152: --l_line_rec.change_reason := 'NOT PROVIDED';
153: -- Changed the seeded lookup code to mixed case for bug# 3142472
292: l_return_values varchar2(50);
293: l_return_status VARCHAR2(1) ;
294: l_msg_count NUMBER;
295: l_msg_data VARCHAR2(2000);
296: l_header_rec OE_Order_PUB.Header_Rec_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
293: l_return_status VARCHAR2(1) ;
294: l_msg_count NUMBER;
295: l_msg_data VARCHAR2(2000);
296: l_header_rec OE_Order_PUB.Header_Rec_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
294: l_msg_count NUMBER;
295: l_msg_data VARCHAR2(2000);
296: l_header_rec OE_Order_PUB.Header_Rec_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
295: l_msg_data VARCHAR2(2000);
296: l_header_rec OE_Order_PUB.Header_Rec_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
296: l_header_rec OE_Order_PUB.Header_Rec_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
297: x_header_rec OE_Order_PUB.Header_Rec_Type; --added for bug 6347596
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
298: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
299: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
300: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
301: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
303: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
304: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
305: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
306: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
307: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added for bug 6347596
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
308: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
309: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
310: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
311: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
312: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
313: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
314: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
315: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
316: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
317: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
318: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
319:
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
320: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
321: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
322: OE_Order_PUB.G_MISS_REQUEST_TBL;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
323:
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
324: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
325: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
326: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
327: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
328: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
329: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
330: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
331: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
332: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
333: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
334: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
335: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
336: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
344:
337: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
344:
345: l_message_data varchar2(2000);
338: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
344:
345: l_message_data varchar2(2000);
346: l_order_number oe_order_headers.order_number%type;
339: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
340: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
341: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
342: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
343: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
344:
345: l_message_data varchar2(2000);
346: l_order_number oe_order_headers.order_number%type;
347: l_ordered_quantity oe_order_lines.ordered_quantity%type;
488: BEGIN
489:
490: -- Header Level
491: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support
492: l_header_rec := OE_Order_Pub.G_MISS_HEADER_REC;
493: l_header_rec.operation := OE_Globals.G_OPR_CREATE ;
494: l_header_rec.sold_to_org_id := l_sold_to_org_id;
495: l_header_rec.order_type_id := l_order_type_id;
496: l_header_rec.price_list_id := l_price_list_id;
516:
517: /* Bug 2360833 */
518:
519: -- Line Level
520: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
521: l_line_rec.sold_to_org_id := l_sold_to_org_id;
522: l_line_rec.operation := OE_Globals.G_OPR_CREATE ;
523: l_line_rec.line_category_code := 'RETURN';
524: l_line_rec.ordered_quantity := 1;
713: l_return_values varchar2(50);
714: l_return_status VARCHAR2(1) ;
715: l_msg_count NUMBER;
716: l_msg_data VARCHAR2(2000);
717: l_header_rec OE_Order_PUB.Header_Rec_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
714: l_return_status VARCHAR2(1) ;
715: l_msg_count NUMBER;
716: l_msg_data VARCHAR2(2000);
717: l_header_rec OE_Order_PUB.Header_Rec_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
715: l_msg_count NUMBER;
716: l_msg_data VARCHAR2(2000);
717: l_header_rec OE_Order_PUB.Header_Rec_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
716: l_msg_data VARCHAR2(2000);
717: l_header_rec OE_Order_PUB.Header_Rec_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
717: l_header_rec OE_Order_PUB.Header_Rec_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
718: x_header_rec OE_Order_PUB.Header_Rec_Type; --added fro bug 6347596
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
719: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
720: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
721: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
722: l_header_price_att_tbl OE_Order_PUB.header_Price_Att_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
723: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
724: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
725: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
726: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
727: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
728: x_line_tbl OE_Order_PUB.Line_Tbl_Type; --added fro bug 6347596
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
729: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
730: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
731: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
732: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
733: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
734: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
735: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
736: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
737: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
738: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
739: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type ;
740:
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
741: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
742: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
743: OE_Order_PUB.G_MISS_REQUEST_TBL;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
744:
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
745: l_old_header_rec OE_Order_PUB.Header_Rec_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
746: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
747: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
748: l_old_Header_Adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
749: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
750: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
751: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
752: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
753: l_old_Header_Scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
754: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
755: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
756: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
757: l_old_Line_Adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type ;
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
765:
758: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
765:
766: l_message_data varchar2(2000);
759: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
765:
766: l_message_data varchar2(2000);
767: l_order_number oe_order_headers.order_number%type;
760: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
761: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type ;
762: l_old_Line_Scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type ;
763: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type ;
764: l_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type ;
765:
766: l_message_data varchar2(2000);
767: l_order_number oe_order_headers.order_number%type;
768: l_ordered_quantity oe_order_lines.ordered_quantity%type;
799: BEGIN
800: MO_GLOBAL.INIT('ONT');
801: l_org_id := MO_UTILS.Get_Default_Org_Id;
802: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support
803: l_header_rec := OE_Order_Pub.G_MISS_HEADER_REC;
804: l_header_rec.operation := OE_Globals.G_OPR_CREATE ;
805:
806: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
807: l_line_rec.operation := OE_Globals.G_OPR_CREATE ;
802: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support
803: l_header_rec := OE_Order_Pub.G_MISS_HEADER_REC;
804: l_header_rec.operation := OE_Globals.G_OPR_CREATE ;
805:
806: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
807: l_line_rec.operation := OE_Globals.G_OPR_CREATE ;
808: l_line_rec.line_category_code := 'ORDER';
809: l_line_rec.ordered_quantity := 1;
810: l_line_rec.order_quantity_uom := 'ENR';