7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
13: P_Quote_line_Id IN NUMBER,
14: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
15: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
13: P_Quote_line_Id IN NUMBER,
14: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
15: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
16: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
13: P_Quote_line_Id IN NUMBER,
14: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
15: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
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: )is
63: l_config_hdr_id Number;
64: l_config_rev_nbr Number;
65: l_quote_header_id Number;
66: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
67: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
68: l_model_line_rec aso_quote_pub.qte_line_rec_type;
69: lx_config_tree_rec CZ_API_PUB.config_model_rec_type;
70: l_last_update_date Date;
71: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
64: l_config_rev_nbr Number;
65: l_quote_header_id Number;
66: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
67: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
68: l_model_line_rec aso_quote_pub.qte_line_rec_type;
69: lx_config_tree_rec CZ_API_PUB.config_model_rec_type;
70: l_last_update_date Date;
71: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
72:
67: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
68: l_model_line_rec aso_quote_pub.qte_line_rec_type;
69: lx_config_tree_rec CZ_API_PUB.config_model_rec_type;
70: l_last_update_date Date;
71: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
72:
73: Begin
74:
75: SAVEPOINT Add_to_Container_from_ib_pvt;
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
374: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
375: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
376: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
374: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
375: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
376: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
377: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
374: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
375: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_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: )IS
436: l_config_rev_nbr Number;
437: l_last_update_date Date;
438: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
439:
440: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
441: l_model_line_rec aso_quote_pub.qte_line_rec_type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
437: l_last_update_date Date;
438: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
439:
440: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
441: l_model_line_rec aso_quote_pub.qte_line_rec_type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
438: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
439:
440: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
441: l_model_line_rec aso_quote_pub.qte_line_rec_type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
439:
440: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
441: l_model_line_rec aso_quote_pub.qte_line_rec_type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
441: l_model_line_rec aso_quote_pub.qte_line_rec_type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
444:
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
448: lx_out_config_tree_tbl CZ_API_PUB.config_model_tbl_type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
469:
462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
469:
470:
463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
469:
470:
471: Begin
464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
469:
470:
471: Begin
472:
605: l_qte_header_rec := p_qte_header_rec;
606:
607: l_QTE_HEADER_REC.last_update_date := l_last_update_date;
608:
609: ASO_QUOTE_PUB.Update_Quote(
610: p_api_version_number => 1.0,
611: p_init_msg_list => p_init_msg_list,
612: p_commit => p_commit,
613: p_control_rec => p_control_rec,
811: P_Api_Version_Number IN NUMBER,
812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
820: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
820: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
821: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
820: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
821: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
822: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
823: ) IS
896: l_count Number := 0;
897: i Number;
898: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_from_quote';
899: l_api_version CONSTANT NUMBER := 1.0;
900: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
901: l_macd_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
902: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
903: l_quote_line_id Number;
904: l_quantity Number;
897: i Number;
898: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_from_quote';
899: l_api_version CONSTANT NUMBER := 1.0;
900: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
901: l_macd_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
902: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
903: l_quote_line_id Number;
904: l_quantity Number;
905: l_uom_code VARCHAR2(10);
898: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_from_quote';
899: l_api_version CONSTANT NUMBER := 1.0;
900: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
901: l_macd_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;
902: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
903: l_quote_line_id Number;
904: l_quantity Number;
905: l_uom_code VARCHAR2(10);
906: l_order_line_type_id Number;
909: l_rev_num Number;
910: l_config_item_id Number;
911: l_config_header_id Number;
912: l_config_rev_nbr Number;
913: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
914: l_model_line_rec aso_quote_pub.qte_line_rec_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
915: l_line_count Number :=0;
916: l_copy_conf_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
917: l_deactivate_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
910: l_config_item_id Number;
911: l_config_header_id Number;
912: l_config_rev_nbr Number;
913: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
914: l_model_line_rec aso_quote_pub.qte_line_rec_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
915: l_line_count Number :=0;
916: l_copy_conf_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
917: l_deactivate_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
918: x boolean := FALSE;
912: l_config_rev_nbr Number;
913: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
914: l_model_line_rec aso_quote_pub.qte_line_rec_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
915: l_line_count Number :=0;
916: l_copy_conf_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
917: l_deactivate_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
918: x boolean := FALSE;
919: k Number;
920: l_macd_flag varchar2(30);
913: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;
914: l_model_line_rec aso_quote_pub.qte_line_rec_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
915: l_line_count Number :=0;
916: l_copy_conf_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
917: l_deactivate_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;
918: x boolean := FALSE;
919: k Number;
920: l_macd_flag varchar2(30);
921:
919: k Number;
920: l_macd_flag varchar2(30);
921:
922: l_last_update_date Date;
923: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
924: l_obj_version_number number;
925:
926: Begin
927: