[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_LINES_PVT
Source
1 PACKAGE ASO_QUOTE_LINES_PVT AUTHID CURRENT_USER as
2 /* $Header: asovqlns.pls 120.1 2005/06/29 12:43:58 appldev ship $ */
3 -- Start of Comments
4 -- Start of Comments
5 -- Package name : ASO_QUOTE_LINES_PVT
6 -- Purpose :
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13 --Fix performance bug for literals
14 G_PROMO_GOODS_DISCOUNT CONSTANT VARCHAR2(30) := 'PRG';
15 G_DISCOUNT CONSTANT VARCHAR2(30) := 'DIS';
16
17 -- this procedure calls the table handlers to insert the rows.
18
19 PROCEDURE Insert_Quote_Line_Rows(
20 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
21 P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
22 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
23 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
24 P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
25 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
26 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_tax_detail_TBL,
27 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.G_MISS_freight_charge_TBL,
28 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
29 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
30 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type
31 := ASO_QUOTE_PUB.G_Miss_Line_Attribs_Ext_Tbl,
32 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
33 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
34 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
35 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
36 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
37 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
38 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
39 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
40 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
41 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
42 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
43 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
44 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
45 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
46 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
47 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
48 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
49 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
50 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 );
52
53
54
55 -- *******************************************************
56 -- Start of Comments
57 -- *******************************************************
58 -- API Name: Create_Quote_Lines
59 -- Type : Private
60 -- Pre-Req :
61 -- Parameters:
62 -- IN
63 -- p_api_version_number IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66 -- P_qte_lines_Rec IN qte_line_Rec_Type Required
67 -- P_quote_header_id IN NUMBER Required
68 -- P_header_last_update_date IN DATE Required
69 -- P_Payment_Tbl IN Payment_Tbl_Type
70 -- P_Price_Adj_Tbl IN Price_Adj_Tbl_Type
71 -- P_Qte_Line_Dtl_Rec IN Qte_Line_Dtl_Rec_Type
72 -- P_Shipment_Tbl IN Shipment_Tbl_Type
73 -- P_Tax_Details_Tbl IN Tax_Details_Tbl_Type
74 -- P_Freight_Charges_Tbl IN Freight_Charges_Tbl_Type
75 -- P_Line_Relationship_Tbl IN Line_Relationship_Tbl_Type
76 -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
77 -- P_Price_Adj_Relationship_Tbl IN Price_Adj_Relationship_Tbl_Type
78 -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
79
80 -- OUT:
81 -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
82 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
84 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 -- Version : Current version 2.0
86 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
87 -- and basic operation, developer must manually add parameters and business logic as necessary.
88 --
89 -- End of Comments
90 --
91 PROCEDURE Create_Quote_Lines(
92 P_Api_Version_Number IN NUMBER,
93 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
97 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
98 P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
99 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
100 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
101 P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
102 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
103 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_tax_detail_TBL,
104 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.G_MISS_freight_charge_TBL,
105 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
106 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
107 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type
108 := ASO_QUOTE_PUB.G_Miss_Line_Attribs_Ext_Tbl,
109 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
110 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
111 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
112 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
113 P_Update_Header_Flag IN VARCHAR2 := 'Y',
114 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
115 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
116 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
117 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
118 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
119 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
120 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
121 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
122 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
123 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
124 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
125 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
126 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
128 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 );
130
131
132 -- *******************************************************
133 -- Start of Comments
134 -- *******************************************************
135 -- API Name: Update_Quote_Lines
136 -- Type : Public
137 -- Pre-Req :
138 -- Parameters:
139 -- IN
140 -- p_api_version_number IN NUMBER Required
141 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
144 -- P_qte_lines_Rec IN qte_line_Rec_Type Required
145 -- P_quote_header_id IN NUMBER Required
146 -- P_header_last_update_date IN DATE Required
147 -- P_Payment_Tbl IN Payment_Tbl_Type
148 -- P_Price_Adj_Tbl IN Price_Adj_Tbl_Type
149 -- P_Qte_Line_Dtl_Rec IN Qte_Line_Dtl_Rec_Type
150 -- P_Shipment_Tbl IN Shipment_Tbl_Type
151 -- P_Tax_Details_Tbl IN Tax_Details_Tbl_Type
152 -- P_Freight_Charges_Tbl IN Freight_Charges_Tbl_Type
153 -- P_Line_Relationship_Tbl IN Line_Relationship_Tbl_Type
154 -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
155 -- P_Price_Adj_Relationship_Tbl IN Price_Adj_Relationship_Tbl_Type
156 -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
157 -- OUT:
158 -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
159 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
161 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 -- Version : Current version 2.0
163 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
164 -- and basic operation, developer must manually add parameters and business logic as necessary.
165 --
166 -- End of Comments
167 --
168 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
169
170 PROCEDURE Update_Quote_Line(
171 P_Api_Version_Number IN NUMBER,
172 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174 P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
176 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
177 P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
178 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
179 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
180 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
181 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
182 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_tax_detail_TBL,
183 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.G_MISS_freight_charge_TBL,
184 P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
185 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
186 P_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type
187 := ASO_QUOTE_PUB.G_Miss_Line_Attribs_Ext_Tbl,
188 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
189 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
190 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
191 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
192 P_Update_Header_Flag IN VARCHAR2 := 'Y',
193 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
194 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
195 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
196 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
197 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
198 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
199 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
200 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
204 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
201 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
202 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
203 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
205 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
206 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
207 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
208 );
209
210
211 -- *******************************************************
212 -- Start of Comments
213 -- *******************************************************
214 -- API Name: Delete_Quote_Line
215 -- Type : Public
216 -- Pre-Req :
217 -- Parameters:
218 -- IN
219 -- p_api_version_number IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
223 -- P_qte_line_Rec IN qte_line_Rec_Type Required
224 -- P_quote_header_id IN NUMBER Required
225 -- P_header_last_update_date IN DATE Required
226 --
227 -- OUT:
228 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
229 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
230 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 -- Version : Current version 2.0
232 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
233 -- and basic operation, developer must manually add parameters and business logic as necessary.
234 --
235 -- End of Comments
236 --
237 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
238 -- The Master delete procedure may not be needed depends on different business requirements.
239
240 PROCEDURE Delete_Quote_Line(
241 P_Api_Version_Number IN NUMBER,
242 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244 P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
245 P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
246 P_Update_Header_Flag IN VARCHAR2 := 'Y',
247 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
248 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
249 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
250 );
251
252
253
254
255 -- *******************************************************
256 -- Start of Comments
257 -- *******************************************************
258 -- API Name: Get_Quote_Lines
259 -- Type : Public
260 -- Pre-Req :
261 -- Parameters:
262 -- IN
263 -- p_api_version_number IN NUMBER Required
264 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
266 -- P_quote_id IN NUMBER Required
267 -- p_rec_requested IN NUMBER Optional Default = 30
268 -- p_start_rec_ptr IN NUMBER Optional Default = 1
269 --
270 -- Return Total Records Count Flag. This flag controls whether the total record count
271 -- and total record amount is returned.
272 --
273 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
274 -- Hint: User defined record type
275 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
276 --
277 -- OUT NOCOPY /* file.sql.39 change */ :
278 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
279 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
280 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281 -- X_qte_line_Tbl OUT NOCOPY /* file.sql.39 change */ qte_line_Tbl_Type
282 -- X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ Payment_Tbl_Type
283 -- X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_Tbl_Type
284 -- X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ Qte_Line_Dtl_Tbl_Type
285 -- X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ Shipment_Tbl_Type
286 -- X_Tax_Details_Tbl OUT NOCOPY /* file.sql.39 change */ Tax_Details_Tbl_Type
287 -- X_Freight_Charges_Tbl OUT NOCOPY /* file.sql.39 change */ Freight_Charges_Tbl_Type
288 -- X_Line_Relationship_Tbl OUT NOCOPY /* file.sql.39 change */ Line_Relationship_Tbl_Type
289 -- X_Related_Object_Tbl OUT NOCOPY /* file.sql.39 change */ Related_Object_Tbl_Type
290 -- X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Attributes_Tbl_Type
291 -- X_Price_Adj_Relationship_Tbl OUT NOCOPY /* file.sql.39 change */ Price_Adj_relationship_Tbl_Type
292 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
293 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
294 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
295 -- other optional OUT NOCOPY /* file.sql.39 change */ parameters
296 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
297 -- Version : Current version 2.0
298 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
299 -- and basic operation, developer must manually add parameters and business logic as necessary.
300 --
301 -- End of Comments
302 --
303 PROCEDURE Get_Quote_Line(
304 P_Api_Version_Number IN NUMBER,
305 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
307 p_start_rec_prt IN NUMBER := 1,
308 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
309 -- Hint: user defined record type
310 p_order_by_rec IN ASO_QUOTE_PUB.qte_line_sort_rec_type,
311 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
312 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
313 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
314 x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
315 x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER,
316 x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
317 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
318 P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
319 X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
320 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
321 X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
322 X_Qte_Line_Dtl_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
323 X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
324 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
325 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
326 X_Line_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
327 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
328 X_Price_Adj_rltship_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
329 X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type
330 );
331
332 Procedure SERVICE_ITEM_QTY_UPDATE
333 (p_qte_line_rec IN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE,
334 p_service_item_flag IN VARCHAR2,
335 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
336 );
337
338
339 End ASO_QUOTE_LINES_PVT;