8: x_msg_data OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: l_return_status OUT NOCOPY VARCHAR2) IS
11:
12: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
9: x_msg_count OUT NOCOPY NUMBER,
10: l_return_status OUT NOCOPY VARCHAR2) IS
11:
12: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
10: l_return_status OUT NOCOPY VARCHAR2) IS
11:
12: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
11:
12: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
12: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
13: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
14: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
15: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
16: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
17: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
18: l_hdr_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
19: l_line_rec OE_Order_PUB.Line_Rec_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
20: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
21: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
22: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
23: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
24: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
25: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
26: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
27: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
28: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
29: l_action_request_tbl OE_Order_PUB.request_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
30: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
38: l_lot_serial_val_tbl OE_Order_PUB.lot_serial_val_tbl_type;
31: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
38: l_lot_serial_val_tbl OE_Order_PUB.lot_serial_val_tbl_type;
39:
32: l_header_val_rec OE_Order_PUB.header_val_rec_type;
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
38: l_lot_serial_val_tbl OE_Order_PUB.lot_serial_val_tbl_type;
39:
40: x_progress varchar2(3);
33: l_line_val_tbl OE_Order_PUB.line_val_tbl_type;
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
38: l_lot_serial_val_tbl OE_Order_PUB.lot_serial_val_tbl_type;
39:
40: x_progress varchar2(3);
41:
34: l_line_adj_val_tbl OE_Order_PUB.line_adj_val_tbl_type;
35: l_line_scredit_val_tbl OE_Order_PUB.line_scredit_val_tbl_type;
36: l_header_scredit_val_tbl OE_Order_PUB.header_scredit_val_tbl_type;
37: l_header_adj_val_tbl OE_Order_PUB.header_adj_val_tbl_type;
38: l_lot_serial_val_tbl OE_Order_PUB.lot_serial_val_tbl_type;
39:
40: x_progress varchar2(3);
41:
42: BEGIN
45: /* dreddy-iso : set the line_id,cancel reason and quantity .
46: This is for line level cancellation */
47:
48: IF x_oe_line_id is not null THEN
49: l_line_rec := OE_Order_PUB.G_MISS_LINE_REC;
50:
51: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
52: l_line_rec.line_id := x_oe_line_id;
53: l_line_rec.ordered_quantity := x_oe_line_qty;
59: /* dreddy-iso : set the header id and cancel reason.
60: this is for header level cancellation */
61:
62: IF x_oe_header_id is not null THEN
63: l_hdr_rec := OE_Order_PUB.G_MISS_HEADER_REC;
64:
65: l_hdr_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
66: l_hdr_rec.header_id := x_oe_header_id;
67: l_hdr_rec.change_reason := x_cancel_reason;