51:
52: -- Header Adj Query_Rows
53: PROCEDURE Query_Rows
54: ( p_price_adjustment_id IN NUMBER :=
55: FND_API.G_MISS_NUM
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
53: PROCEDURE Query_Rows
54: ( p_price_adjustment_id IN NUMBER :=
55: FND_API.G_MISS_NUM
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: );
70:
71: -- Header SCredit Query_Rows
72: PROCEDURE Query_Rows
73: ( p_sales_credit_id IN NUMBER :=
74: FND_API.G_MISS_NUM
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
72: PROCEDURE Query_Rows
73: ( p_sales_credit_id IN NUMBER :=
74: FND_API.G_MISS_NUM
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:
90:
91: -- Line Query_Rows
92: PROCEDURE Query_Rows
93: ( p_line_id IN NUMBER :=
94: FND_API.G_MISS_NUM
95: , p_header_id IN NUMBER :=
96: FND_API.G_MISS_NUM
97: , p_line_set_id IN NUMBER :=
98: FND_API.G_MISS_NUM
92: PROCEDURE Query_Rows
93: ( p_line_id IN NUMBER :=
94: FND_API.G_MISS_NUM
95: , p_header_id IN NUMBER :=
96: FND_API.G_MISS_NUM
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
94: FND_API.G_MISS_NUM
95: , p_header_id IN NUMBER :=
96: FND_API.G_MISS_NUM
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: );
111:
112: -- Line Adj Query_Rows
113: PROCEDURE Query_Rows
114: ( p_price_adjustment_id IN NUMBER :=
115: FND_API.G_MISS_NUM
116: , p_line_id IN NUMBER :=
117: FND_API.G_MISS_NUM
118: , p_Header_id IN NUMBER :=
119: FND_API.G_MISS_NUM
113: PROCEDURE Query_Rows
114: ( p_price_adjustment_id IN NUMBER :=
115: FND_API.G_MISS_NUM
116: , p_line_id IN NUMBER :=
117: FND_API.G_MISS_NUM
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
115: FND_API.G_MISS_NUM
116: , p_line_id IN NUMBER :=
117: FND_API.G_MISS_NUM
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: );
132:
133: -- Line Scredit Query_Rows
134: PROCEDURE Query_Rows
135: ( p_sales_credit_id IN NUMBER :=
136: FND_API.G_MISS_NUM
137: , p_line_id IN NUMBER :=
138: FND_API.G_MISS_NUM
139: , p_Header_id IN NUMBER :=
140: FND_API.G_MISS_NUM
134: PROCEDURE Query_Rows
135: ( p_sales_credit_id IN NUMBER :=
136: FND_API.G_MISS_NUM
137: , p_line_id IN NUMBER :=
138: FND_API.G_MISS_NUM
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
136: FND_API.G_MISS_NUM
137: , p_line_id IN NUMBER :=
138: FND_API.G_MISS_NUM
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: );