DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_PUB

Line 25: x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

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

Line 26: x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,

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

Line 27: x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,

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

Line 28: x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

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

Line 29: x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,

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

Line 30: x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,

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

Line 41: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type

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

Line 49: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

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

Line 60: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

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

Line 68: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

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

Line 79: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type

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

Line 88: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 101: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

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

Line 109: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

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

Line 122: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

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

Line 130: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type

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

Line 143: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

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