DBA Data[Home] [Help]

APPS.IBE_CANCEL_ORDER_PVT dependencies on OE_ORDER_PUB

Line 26: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=

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

Line 27: OE_Order_PUB.G_MISS_REQUEST_TBL;

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;

Line 30: l_header_rec OE_Order_PUB.Header_Rec_Type

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;

Line 31: := OE_ORDER_PUB.G_MISS_HEADER_REC;

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 ;

Line 32: x_header_rec OE_Order_PUB.Header_Rec_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 ;

Line 33: := OE_ORDER_PUB.G_MISS_HEADER_REC;

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 ;

Line 34: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_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;

Line 35: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_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;

Line 36: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_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;

Line 37: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;

Line 38: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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 ;

Line 39: l_line_tbl OE_Order_PUB.Line_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 ;

Line 40: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_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;

Line 41: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_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;
45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 42: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;

Line 43: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 44: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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 ;

Line 45: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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 ;

Line 46: l_old_header_rec OE_Order_PUB.Header_Rec_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 ;

Line 47: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_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;

Line 48: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_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;

Line 49: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_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;

Line 50: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;

Line 51: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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 ;

Line 52: l_old_line_tbl OE_Order_PUB.Line_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 ;

Line 53: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_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;

Line 54: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_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;
58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 55: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;

Line 56: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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);

Line 57: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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);
61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 58: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;
62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

Line 59: l_action_request_tbl OE_Order_PUB.Request_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;
63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

Line 61: l_header_val_rec OE_Order_PUB.Header_Val_Rec_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;

Line 62: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_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;

Line 63: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_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;

Line 64: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_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;

Line 65: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_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;

Line 66: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_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;

Line 67: l_line_val_tbl OE_Order_PUB.Line_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;

Line 68: l_old_line_val_tbl OE_Order_PUB.Line_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;

Line 69: l_line_adj_val_tbl OE_Order_PUB.Line_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;
73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

Line 70: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_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;

Line 71: l_line_scredit_val_tbl OE_Order_PUB.Line_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;
75: l_commit VARCHAR2(10) := FND_API.G_FALSE;

Line 72: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_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;
76: l_msg_count NUMBER;

Line 73: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_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;
77: l_msg_data VARCHAR2(2000);

Line 74: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_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);
78: l_userid VARCHAR2(30);