DBA Data[Home] [Help]

APPS.OE_AR_ACCEPTANCE_GRP dependencies on OE_ORDER_PUB

Line 22: p_Action_Request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,

18: --| MAY-05-2005 Initial creation |
19: --+=======================================================================+
20:
21: PROCEDURE Process_Acceptance_in_OM(
22: p_Action_Request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:

Line 27: x_header_rec OE_Order_PUB.Header_Rec_Type;

23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
27: x_header_rec OE_Order_PUB.Header_Rec_Type;
28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
27: x_header_rec OE_Order_PUB.Header_Rec_Type;
28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
27: x_header_rec OE_Order_PUB.Header_Rec_Type;
28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

26:
27: x_header_rec OE_Order_PUB.Header_Rec_Type;
28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

27: x_header_rec OE_Order_PUB.Header_Rec_Type;
28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

28: x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

29: x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;

30: x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

31: x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

32: x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

33: x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

34: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
42:

Line 39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

35: x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
42:
43: BEGIN

Line 40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

36: x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
42:
43: BEGIN
44:

Line 41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

37: x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
38: x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
39: x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
40: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
41: x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
42:
43: BEGIN
44:
45: -- call to process order

Line 80: l_line_rec OE_Order_Pub.Line_Rec_Type;

76: , x_msg_count OUT NOCOPY NUMBER
77: , x_msg_data OUT NOCOPY VARCHAR2
78: )IS
79: l_delivery_line_id NUMBER := NULL;
80: l_line_rec OE_Order_Pub.Line_Rec_Type;
81: --
82: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
83: --
84: BEGIN