[Home] [Help]
PACKAGE: APPS.ASO_VALIDATE_PVT
Source
1 PACKAGE ASO_VALIDATE_PVT AUTHID CURRENT_USER as
2 /* $Header: asovvlds.pls 120.8 2006/05/11 11:56:15 skulkarn ship $ */
3 -- Start of Comments
4 -- Package name : ASO_VALIDATE_PVT
5 -- Purpose :
6 --
7 -- History :
8 -- NOTE :
9 -- End of Comments
10
11
12 PROCEDURE Validate_NotNULL_Number (
13 p_init_msg_list IN VARCHAR2,
14 p_column_name IN VARCHAR2,
15 p_notnull_column IN NUMBER,
16 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
17 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
18 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
19
20 PROCEDURE Validate_NotNULL_VARCHAR2 (
21 p_init_msg_list IN VARCHAR2,
22 p_column_name IN VARCHAR2,
23 p_notnull_column IN VARCHAR2,
24 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
25 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
26 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27
28 PROCEDURE Validate_NotNULL_DATE (
29 p_init_msg_list IN VARCHAR2,
30 p_column_name IN VARCHAR2,
31 p_notnull_column IN DATE,
32 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
33 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
34 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
35
36 PROCEDURE Validate_For_GreaterEndDate (
37 p_init_msg_list IN VARCHAR2,
38 p_start_date IN DATE,
39 p_end_date IN DATE,
40 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
42 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
43
44 PROCEDURE Validate_For_Positive(
45 p_init_msg_list IN VARCHAR2,
46 p_column_name IN VARCHAR2,
47 p_value IN NUMBER,
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 PROCEDURE Validate_Party(
53 p_init_msg_list IN VARCHAR2,
54 p_party_id IN NUMBER,
55 p_party_usage IN VARCHAR2,
56 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
57 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
58 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
59
60 PROCEDURE Validate_Contact(
61 p_init_msg_list IN VARCHAR2,
62 p_contact_id IN NUMBER,
63 p_contact_usage IN VARCHAR2,
64 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
65 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
66 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
67
68 PROCEDURE Validate_PartySite(
69 p_init_msg_list IN VARCHAR2,
70 p_party_id IN NUMBER,
71 p_party_site_id IN NUMBER,
72 p_site_usage IN VARCHAR2,
73 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
75 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
76
77 PROCEDURE Validate_OrderType(
78 p_init_msg_list IN VARCHAR2,
79 p_order_type_id IN NUMBER,
80 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
81 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
82 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
83
84 PROCEDURE Validate_LineType(
85 p_init_msg_list IN VARCHAR2,
86 p_order_line_type_id IN NUMBER,
87 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
89 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
90
91 PROCEDURE Validate_PriceList(
92 p_init_msg_list IN VARCHAR2,
93 p_price_list_id IN NUMBER,
94 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
96 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
97
98 PROCEDURE Validate_Quote_Status(
99 p_init_msg_list IN VARCHAR2,
100 p_quote_status_id IN NUMBER,
101 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
102 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
103 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
104
105 PROCEDURE Validate_Inventory_Item(
106 p_init_msg_list IN VARCHAR2,
107 p_inventory_item_id IN NUMBER,
108 p_organization_id IN NUMBER,
109 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
110 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
111 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
112
113 PROCEDURE Validate_Item_Type_Code(
114 p_init_msg_list IN VARCHAR2,
115 p_item_type_code IN VARCHAR2,
116 -- p_organization_id IN NUMBER,
117 -- p_inventory_item_id IN NUMBER,
118 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
120 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
121
122 PROCEDURE Validate_Marketing_Source_Code(
123 p_init_msg_list IN VARCHAR2,
124 p_mkting_source_code_id IN NUMBER,
125 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
126 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
127 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
128
129 PROCEDURE Validate_Tax_Exemption(
130 p_init_msg_list IN VARCHAR2,
131 p_tax_exempt_flag IN VARCHAR2,
132 p_tax_exempt_reason_code IN VARCHAR2,
133 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
134 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
135 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
136
137 PROCEDURE Validate_UOM_code(
138 p_init_msg_list IN VARCHAR2,
139 p_uom_code IN VARCHAR2,
140 p_organization_id IN NUMBER,
141 p_inventory_item_id IN NUMBER,
142 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
143 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
144 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
145
146 PROCEDURE Validate_Configuration(
147 p_init_msg_list IN VARCHAR2,
148 p_config_header_id IN NUMBER,
149 p_config_revision_num IN NUMBER,
150 p_config_item_id IN NUMBER,
151 --p_component_code IN VARCHAR2,
152 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
153 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
154 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
155
156 PROCEDURE Validate_Delayed_Service(
157 p_init_msg_list IN VARCHAR2,
158 p_service_ref_type_code IN VARCHAR2,
159 p_service_ref_line_id IN NUMBER,
160 p_service_ref_system_id IN NUMBER,
161 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
162 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
163 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
164
165 PROCEDURE Validate_Service(
166 p_init_msg_list IN VARCHAR2,
167 p_inventory_item_id IN NUMBER,
168 p_start_date_active IN DATE,
169 p_end_date_active IN DATE,
170 p_service_duration IN NUMBER,
171 p_service_period IN VARCHAR2,
172 p_service_coterminate_flag IN VARCHAR2,
173 p_organization_id IN NUMBER,
174 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
175 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
176 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
177
178 PROCEDURE Validate_Service_Period(
179 p_init_msg_list IN VARCHAR2,
180 p_service_period IN VARCHAR2,
181 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
182 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
183 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
184
185 PROCEDURE Validate_Service_Duration(
186 p_init_msg_list IN VARCHAR2,
187 p_service_duration IN NUMBER,
188 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
189 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
190 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
191
192 PROCEDURE Validate_Returns(
193 p_init_msg_list IN VARCHAR2,
194 p_return_ref_type_code IN VARCHAR2,
195 p_return_ref_header_id IN NUMBER,
196 p_return_ref_line_id IN NUMBER,
197 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
198 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
199 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
200
201 PROCEDURE Validate_EmployPerson(
202 p_init_msg_list IN VARCHAR2,
203 p_employee_id IN NUMBER,
204 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
205 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
206 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
207
208 PROCEDURE Validate_CategoryCode(
209 p_init_msg_list IN VARCHAR2,
210 p_category_code IN VARCHAR2,
211 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
212 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
213 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
214
215 -- 06/27/00
216
217 PROCEDURE Validate_Salescredit_Type(
218 p_init_msg_list IN VARCHAR2,
219 p_salescredit_type_id IN NUMBER,
220 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
221 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
222 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
223
224 PROCEDURE Validate_Party_Type(
225 p_init_msg_list IN VARCHAR2,
226 p_party_type IN VARCHAR2,
227 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
228 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
229 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
230
231 PROCEDURE Validate_Party_Object_Type(
232 p_init_msg_list IN VARCHAR2,
233 p_party_object_type IN VARCHAR2,
234 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
235 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
236 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
237
238 PROCEDURE Validate_Party_Object_Id(
239 p_init_msg_list IN VARCHAR2,
240 p_party_id IN NUMBER,
241 p_party_object_type IN VARCHAR2,
242 p_party_object_id IN NUMBER,
243 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
244 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
245 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
246
247 PROCEDURE Validate_Resource_id(
248 p_init_msg_list IN VARCHAR2,
249 p_resource_id IN NUMBER,
250 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
252 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
253
254 PROCEDURE Validate_Resource_group_id(
255 p_init_msg_list IN VARCHAR2,
256 p_resource_group_id IN NUMBER,
257 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
258 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
259 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
260
261 PROCEDURE Validate_Quote_Price_Exp(
262 p_init_msg_list IN VARCHAR2,
263 p_price_list_id IN NUMBER,
264 p_quote_expiration_date IN DATE,
265 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
266 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
267 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
268 PROCEDURE Validate_Quote_Exp_date(
269 p_init_msg_list IN VARCHAR2,
270 p_quote_expiration_date IN DATE,
271 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
272 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
273 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
274
275
276 --07/06/00
277 -- this procedure calls fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name). If you want to pass segment values instead of segment ids then the call
278 -- should be modified to fnd_flex_descval.validate_desccols('ASO', p_desc_flex_name, 'V')
279
280 PROCEDURE Validate_Desc_Flexfield(
281 p_desc_flex_rec IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.attribute_rec_type,
282 p_desc_flex_name IN VARCHAR2 ,
283 p_value_or_id IN VARCHAR2 := 'I',
284 x_return_status OUT NOCOPY /* file.sql.39 change */ varchar2);
285 PROCEDURE Validate_item_tca_bsc(
286 p_init_msg_list IN VARCHAR2,
287 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
288 p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
289 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
290 p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
291 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
292 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
293 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
294
295 PROCEDURE Validate_record_tca_crs(
296 p_init_msg_list IN VARCHAR2,
297 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
298 p_shipment_rec IN ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
299 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
300 p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
302 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
303 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
304
305 PROCEDURE Validate_QTE_OBJ_TYPE_CODE (
306 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
307 P_QUOTE_OBJECT_TYPE_CODE IN VARCHAR2,
308 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
309 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
310 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
311 );
312
313 PROCEDURE Validate_RLTSHIP_TYPE_CODE (
314 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315 P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
316 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
317 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
318 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
319 );
320 PROCEDURE Validate_OBJECT_TYPE_CODE (
321 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322 P_OBJECT_TYPE_CODE IN VARCHAR2,
323 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
324 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
325 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
326 );
327 PROCEDURE Validate_Emp_Res_id(
328 p_init_msg_list IN VARCHAR2,
329 p_resource_id IN NUMBER,
330 p_employee_person_id IN NUMBER,
331 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
332 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
333 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
334
335 PROCEDURE Validate_Minisite(
336 p_init_msg_list IN VARCHAR2,
337 p_minisite_id IN NUMBER,
338 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
339 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
340 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
341
342 PROCEDURE Validate_Section(
343 p_init_msg_list IN VARCHAR2,
344 p_section_id IN NUMBER,
345 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
346 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
347 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
348
349 Procedure Validate_Quote_Percent(
350 p_init_msg_list IN VARCHAR2,
351 p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
352 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
353 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
354 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
355
356 Procedure Validate_Sales_Credit_Return(
357 p_init_msg_list IN VARCHAR2,
358 p_sales_credit_tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
359 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
360 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
361 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
362 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
363
364
365 PROCEDURE validate_ship_from_org_ID (
366 P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
367 P_Shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
368 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369 );
370
371
372 PROCEDURE Validate_Commitment(
373 P_Init_Msg_List IN VARCHAR2,
374 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
375 P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
376 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
377 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
378 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
379
380
381 PROCEDURE Validate_Agreement(
382 P_Init_Msg_List IN VARCHAR2,
383 P_Agreement_Id IN NUMBER,
384 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
385 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
386 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
387
388 -- hyang quote_status
389 PROCEDURE Validate_Status_Transition(
390 p_init_msg_list IN VARCHAR2,
391 p_source_status_id IN NUMBER,
392 p_dest_status_id IN NUMBER,
393 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
394 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
395 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
396 -- end of hyang quote_status
397
398 -- hyang okc
399 PROCEDURE Validate_Contract_Template(
400 p_init_msg_list IN VARCHAR2,
401 p_template_id IN NUMBER,
402 p_template_major_version IN NUMBER,
403 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
404 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
405 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
406 -- end of hyang okc
407
408 PROCEDURE Validate_Promotion (
409 P_Api_Version_Number IN NUMBER,
410 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
411 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
412 p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
413 x_price_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
414 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
415 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
416 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
417
418
419 PROCEDURE VALIDATE_DEFAULTING_DATA(
420 P_quote_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
421 P_quote_line_rec IN ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
422 P_Shipment_header_rec IN ASO_QUOTE_PUB.shipment_rec_type,
423 P_shipment_line_rec IN ASO_QUOTE_PUB.shipment_rec_type,
424 P_Payment_header_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
425 P_Payment_line_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
426 P_tax_header_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
427 P_tax_line_rec IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
428 p_def_object_name IN VARCHAR,
429 X_quote_header_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
430 X_quote_line_rec OUT NOCOPY ASO_QUOTE_PUB.QTE_LINE_Rec_Type,
431 X_Shipment_header_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
432 X_Shipment_line_rec OUT NOCOPY ASO_QUOTE_PUB.shipment_rec_type,
433 X_Payment_header_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
434 X_Payment_line_rec OUT NOCOPY ASO_QUOTE_PUB.Payment_Rec_Type,
435 X_tax_header_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
436 X_tax_line_rec OUT NOCOPY ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
437 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
438 X_MSG_DATA OUT NOCOPY VARCHAR2,
439 X_MSG_COUNT OUT NOCOPY VARCHAR2 );
440 Function Validate_PaymentTerms(
441 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
442 p_payment_term_id IN NUMBER)
443 RETURN VARCHAR2;
444
445 FUNCTION Validate_FreightTerms(
446 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
447 p_freight_terms_code IN VARCHAR2)
448 RETURN VARCHAR2;
449
450 FUNCTION Validate_ShipMethods(
451 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
452 p_ship_method_code IN VARCHAR2,
453 p_ship_from_org_id IN NUMBER := FND_API.G_MISS_NUM,
454 p_qte_header_id IN NUMBER,
455 p_qte_line_id IN NUMBER := FND_API.G_MISS_NUM)
456 RETURN VARCHAR2;
457
458 PROCEDURE Validate_ln_type_for_ord_type
459 (
460 p_init_msg_list IN VARCHAR2,
461 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
462 P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
463 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
464 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
465 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
466
467 PROCEDURE Validate_ln_category_code
468 (
469 p_init_msg_list IN VARCHAR2,
470 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
471 P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
472 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
473 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
474 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
475
476 Procedure Validate_po_line_number
477 (
478 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
479 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
480 P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
481 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
482 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
483 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
484
485
486 PROCEDURE validate_service_ref_line_id
487 (
488 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
489 p_service_ref_type_code IN VARCHAR2,
490 p_service_ref_line_id IN NUMBER,
491 p_qte_header_id IN NUMBER := fnd_api.g_miss_num,
492 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
493 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
494 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
495
496
497 Procedure Validate_cc_info
498 (
499 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
500 p_payment_rec IN aso_quote_pub.payment_rec_type,
501 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
502 P_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
503 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
504 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
505 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
506
507 PROCEDURE VALIDATE_OU(p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type) ;
508
509 PROCEDURE validate_ship_method_code
510 (
511 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
512 p_qte_header_id IN NUMBER := fnd_api.g_miss_num,
513 p_qte_line_id IN NUMBER := fnd_api.g_miss_num,
514 p_organization_id IN NUMBER := fnd_api.g_miss_num,
515 p_ship_method_code IN VARCHAR2 := fnd_api.g_miss_char,
516 p_operation_code IN VARCHAR2 := fnd_api.g_miss_char,
517 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
518 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
519 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
520
521
522 END ASO_VALIDATE_PVT;
523