22: IS
23: l_api_version NUMBER := 1.0;
24: l_api_name VARCHAR2(50) := 'CANCEL_ORDER';
25:
26: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
27: OE_Order_PUB.G_MISS_REQUEST_TBL;
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
23: l_api_version NUMBER := 1.0;
24: l_api_name VARCHAR2(50) := 'CANCEL_ORDER';
25:
26: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
27: OE_Order_PUB.G_MISS_REQUEST_TBL;
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
26: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
27: OE_Order_PUB.G_MISS_REQUEST_TBL;
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
27: OE_Order_PUB.G_MISS_REQUEST_TBL;
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
29: l_return_status VARCHAR2(1);
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
30: l_header_rec OE_Order_PUB.Header_Rec_Type
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
31: := OE_ORDER_PUB.G_MISS_HEADER_REC;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
32: x_header_rec OE_Order_PUB.Header_Rec_Type
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
33: := OE_ORDER_PUB.G_MISS_HEADER_REC;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
39: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
46: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
52: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
59: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
60: l_return_values varchar2(50);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
67: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
75: l_commit VARCHAR2(10) := FND_API.G_FALSE;
68: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
75: l_commit VARCHAR2(10) := FND_API.G_FALSE;
76: l_msg_count NUMBER;
69: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
75: l_commit VARCHAR2(10) := FND_API.G_FALSE;
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(2000);
70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
71: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
75: l_commit VARCHAR2(10) := FND_API.G_FALSE;
76: l_msg_count NUMBER;
77: l_msg_data VARCHAR2(2000);
78: l_userid VARCHAR2(30);