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);
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);
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:
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
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
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
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,
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,
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(
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(
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)
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:
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: (
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,
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,
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:
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,
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,
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,
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,
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,
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);
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: