DBA Data[Home] [Help]

APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on ASO_QUOTE_PUB

Line 11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,

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,

Line 12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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,

Line 15: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 67: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;

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;

Line 68: l_model_line_rec aso_quote_pub.qte_line_rec_type;

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:

Line 71: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

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;

Line 372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,

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,

Line 373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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,

Line 375: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 440: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;

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:

Line 441: l_model_line_rec aso_quote_pub.qte_line_rec_type;

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;

Line 442: l_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_Tbl_Type :=ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

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;

Line 443: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

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;

Line 445: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

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;

Line 446: lx_QTE_LINE_TBL ASO_QUOTE_PUB.Qte_Line_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;

Line 447: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_dtl_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;

Line 449: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_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;

Line 450: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_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;

Line 451: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_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;

Line 452: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_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;

Line 453: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_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;

Line 454: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_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;

Line 455: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_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;

Line 456: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_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;

Line 457: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_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;

Line 458: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_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;

Line 459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_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;

Line 460: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_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;

Line 461: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_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;

Line 462: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_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;

Line 463: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_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;

Line 464: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_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;

Line 465: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_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:

Line 466: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_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:
470:

Line 467: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_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:
471: Begin

Line 468: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_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
472:

Line 609: ASO_QUOTE_PUB.Update_Quote(

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,

Line 815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_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,

Line 816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,

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,

Line 817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,

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,

Line 819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 900: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;

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;

Line 901: l_macd_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl;

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);

Line 902: l_qte_line_rec ASO_QUOTE_PUB.qte_line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;

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;

Line 913: l_config_rec aso_quote_pub.qte_line_dtl_rec_type;

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;

Line 914: l_model_line_rec aso_quote_pub.qte_line_rec_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;

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;

Line 916: l_copy_conf_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;

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);

Line 917: l_deactivate_mdl_Tbl aso_quote_pub.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_TBL;

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:

Line 923: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

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: