DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_PUB

Line 22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

18: Procedure Get_Transaction_Version(
19: p_header_id IN NUMBER,
20: p_version_number IN NUMBER := NULL,
21: p_phase_change_flag IN VARCHAR2 := NULL,
22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

Line 23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,

19: p_header_id IN NUMBER,
20: p_version_number IN NUMBER := NULL,
21: p_phase_change_flag IN VARCHAR2 := NULL,
22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

Line 24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,

20: p_version_number IN NUMBER := NULL,
21: p_phase_change_flag IN VARCHAR2 := NULL,
22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
28: x_return_status OUT NOCOPY VARCHAR2);

Line 25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

21: p_phase_change_flag IN VARCHAR2 := NULL,
22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
28: x_return_status OUT NOCOPY VARCHAR2);
29:

Line 26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

22: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
28: x_return_status OUT NOCOPY VARCHAR2);
29:
30:

Line 27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

23: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
28: x_return_status OUT NOCOPY VARCHAR2);
29:
30:
31: -- Query_Rows with version_number to query from history tables

Line 38: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

34: PROCEDURE Query_Row
35: ( p_header_id IN NUMBER,
36: p_version_number IN NUMBER := NULL,
37: p_phase_change_flag IN VARCHAR2 := NULL,
38: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
39: ) ;
40:
41: -- Header Adj Query_Row
42: PROCEDURE Query_Row

Line 46: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

42: PROCEDURE Query_Row
43: ( p_price_adjustment_id IN NUMBER
44: , p_version_number IN NUMBER := NULL
45: , p_phase_change_flag IN VARCHAR2 := NULL
46: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
47: );
48:
49: -- Header Adj Query_Rows
50: PROCEDURE Query_Rows

Line 57: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

53: , p_header_id IN NUMBER :=
54: FND_API.G_MISS_NUM
55: , p_version_number IN NUMBER := NULL
56: , p_phase_change_flag IN VARCHAR2 := NULL
57: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
58: );
59:
60: -- Header SCredit Query_Row
61: PROCEDURE Query_Row

Line 65: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

61: PROCEDURE Query_Row
62: ( p_sales_credit_id IN NUMBER,
63: p_version_number IN NUMBER := NULL,
64: p_phase_change_flag IN VARCHAR2 := NULL,
65: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
66: ) ;
67:
68: -- Header SCredit Query_Rows
69: PROCEDURE Query_Rows

Line 76: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type

72: , p_header_id IN NUMBER :=
73: FND_API.G_MISS_NUM
74: , p_version_number IN NUMBER := NULL
75: , p_phase_change_flag IN VARCHAR2 := NULL
76: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
77:
78: );
79:
80: -- Line Query_Row

Line 85: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

81: PROCEDURE Query_Row
82: ( p_line_id IN NUMBER
83: , p_version_number IN NUMBER := NULL
84: , p_phase_change_flag IN VARCHAR2 := NULL
85: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
86: );
87:
88: -- Line Query_Rows
89: PROCEDURE Query_Rows

Line 98: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

94: , p_line_set_id IN NUMBER :=
95: FND_API.G_MISS_NUM
96: , p_version_number IN NUMBER := NULL
97: , p_phase_change_flag IN VARCHAR2 := NULL
98: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
99: );
100:
101: -- Line Adj Query_Row
102: PROCEDURE Query_Row

Line 106: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

102: PROCEDURE Query_Row
103: ( p_price_adjustment_id IN NUMBER
104: , p_version_number IN NUMBER := NULL
105: , p_phase_change_flag IN VARCHAR2 := NULL
106: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
107: );
108:
109: -- Line Adj Query_Rows
110: PROCEDURE Query_Rows

Line 119: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

115: , p_Header_id IN NUMBER :=
116: FND_API.G_MISS_NUM
117: , p_version_number IN NUMBER := NULL
118: , p_phase_change_flag IN VARCHAR2 := NULL
119: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
120: );
121:
122: -- Line Scredit Query_Row
123: PROCEDURE Query_Row

Line 127: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

123: PROCEDURE Query_Row
124: ( p_sales_credit_id IN NUMBER
125: , p_version_number IN NUMBER := NULL
126: , p_phase_change_flag IN VARCHAR2 := NULL
127: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
128: );
129:
130: -- Line Scredit Query_Rows
131: PROCEDURE Query_Rows

Line 140: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

136: , p_Header_id IN NUMBER :=
137: FND_API.G_MISS_NUM
138: , p_version_number IN NUMBER := NULL
139: , p_phase_change_flag IN VARCHAR2 := NULL
140: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
141: );
142:
143:
144: END OE_VERSION_HISTORY_UTIL;