13: , x_msg_count OUT NOCOPY NUMBER
14: , x_msg_data OUT NOCOPY VARCHAR2
15: )
16: IS
17: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
18:
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
15: )
16: IS
17: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
18:
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
16: IS
17: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
18:
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
17: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
18:
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
18:
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
19: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
20: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
21: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
22: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
23: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
24: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
25: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
26: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
34: --myerrams, start
27: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
28: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
29: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
30: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
31: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
32: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
33:
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
33:
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
41: l_lot_serial_val_out_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
34: --myerrams, start
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
41: l_lot_serial_val_out_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
42: --myerrams, end
35: l_header_val_out_rec OE_Order_PUB.Header_Val_Rec_Type;
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
41: l_lot_serial_val_out_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
42: --myerrams, end
43:
36: l_header_adj_val_out_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
41: l_lot_serial_val_out_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
42: --myerrams, end
43:
44: l_action VARCHAR2(30);
37: l_header_scredit_val_out_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
38: l_line_val_out_tbl OE_Order_PUB.Line_Val_Tbl_Type;
39: l_line_adj_val_out_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
40: l_line_scredit_val_out_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
41: l_lot_serial_val_out_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
42: --myerrams, end
43:
44: l_action VARCHAR2(30);
45: l_return_status VARCHAR2(1);
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Before Call to Process Order API.') ;
118: END IF;
119:
120: OE_Order_PUB.Process_Order
121: ( p_api_version_number => 1.0
122: , p_org_id => l_org_id
123: , x_return_status => l_return_status
124: , x_msg_count => l_msg_count