eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CFG_INT dependencies on ASO_QUOTE_PUB

Line 20: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,

16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoicfgb.pls';
17:
18: Procedure Populate_output_table(
19: p_oe_line_tbl IN OE_ORDER_PUB.line_tbl_type ,
20: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
21: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
22: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type) AS
23: Begin
24: If p_oe_line_tbl.count <= 0 Then

Line 21: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,

17:
18: Procedure Populate_output_table(
19: p_oe_line_tbl IN OE_ORDER_PUB.line_tbl_type ,
20: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
21: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
22: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type) AS
23: Begin
24: If p_oe_line_tbl.count <= 0 Then
25: Return;

Line 22: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type) AS

18: Procedure Populate_output_table(
19: p_oe_line_tbl IN OE_ORDER_PUB.line_tbl_type ,
20: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
21: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
22: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type) AS
23: Begin
24: If p_oe_line_tbl.count <= 0 Then
25: Return;
26: End If;

Line 49: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,

45: PROCEDURE Get_configuration_lines(
46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
48: p_top_model_line_id IN NUMBER,
49: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
50: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
51: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 50: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,

46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
48: p_top_model_line_id IN NUMBER,
49: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
50: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
51: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
54: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 51: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,

47: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
48: p_top_model_line_id IN NUMBER,
49: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_tbl_type,
50: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_line_dtl_tbl_type,
51: x_shipment_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.shipment_tbl_type ,
52: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
53: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
54: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
55: AS

Line 407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

403: Where config_header_id = p_config_hdr_id
404: AND config_revision_num = p_config_rev_nbr ;
405:
406: l_Api_Version_Number NUMBER := 1.0 ;
407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

Line 408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

404: AND config_revision_num = p_config_rev_nbr ;
405:
406: l_Api_Version_Number NUMBER := 1.0 ;
407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

Line 409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

405:
406: l_Api_Version_Number NUMBER := 1.0 ;
407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;

Line 410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

406: l_Api_Version_Number NUMBER := 1.0 ;
407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;

Line 411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

407: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

408: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;

409: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;

410: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

411: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;

Line 416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

412: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;

Line 417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

413: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;

Line 418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

414: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;

Line 419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;

415: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
423: Begin

Line 420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;

416: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
423: Begin
424:

Line 421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;

417: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
423: Begin
424:
425: For i_update_revision IN c_update_revision Loop

Line 422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;

418: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
419: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
420: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
421: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
422: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
423: Begin
424:
425: For i_update_revision IN c_update_revision Loop
426: l_qte_line_rec := l_miss_line_rec ;

Line 475: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=

471: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
472: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
473: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
474:
475: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=
476: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;
477: l_api_name Constant Varchar2(30) := 'Create_Relationship' ;
478: l_api_version_number NUMBER := 1.0 ;
479: l_line_relationship_id NUMBER ;

Line 476: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;

472: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
473: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
474:
475: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=
476: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;
477: l_api_name Constant Varchar2(30) := 'Create_Relationship' ;
478: l_api_version_number NUMBER := 1.0 ;
479: l_line_relationship_id NUMBER ;
480: l_dummy_line_id NUMBER;

Line 500: l_line_rltship_rec := aso_quote_pub.G_MISS_Line_rltship_rec ;

496: If G_rtln_tbl(i).parent_config_item_id = p_config_item_id
497: AND G_rtln_tbl(i).included_flag = 'N'
498: AND G_rtln_tbl(i).parent_config_item_id IS NOT NULL Then
499:
500: l_line_rltship_rec := aso_quote_pub.G_MISS_Line_rltship_rec ;
501:
502: --populate line relationship record
503: l_line_rltship_rec.OPERATION_CODE := 'CREATE' ;
504: l_line_rltship_rec.QUOTE_LINE_ID := parent_quote_line_id ;

Line 639: p_control_rec IN aso_quote_pub.control_rec_type

635: PROCEDURE Get_config_details(
636: p_api_version_number IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

Line 640: := aso_quote_pub.G_MISS_control_rec,

636: p_api_version_number IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
644: p_config_hdr_id IN NUMBER,

Line 641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
644: p_config_hdr_id IN NUMBER,
645: p_config_rev_nbr IN NUMBER,

Line 642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
644: p_config_hdr_id IN NUMBER,
645: p_config_rev_nbr IN NUMBER,
646: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

639: p_control_rec IN aso_quote_pub.control_rec_type
640: := aso_quote_pub.G_MISS_control_rec,
641: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
642: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
643: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
644: p_config_hdr_id IN NUMBER,
645: p_config_rev_nbr IN NUMBER,
646: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
647: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

788: l_ship_model_complete_flag VARCHAR2(1);
789:
790: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;

789:
790: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;

790: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;

Line 795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;

791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;

794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

796: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

797: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

798: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

799: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

800: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

801: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

802: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

803: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

Line 808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

804: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:

Line 809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

805: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

806: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

807: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
808: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

809: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

810: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

811: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

812:
813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

813: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

814: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

815: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

816: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

817: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

818: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

819: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

820: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

821: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

822: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

823: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
831:

Line 828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

824: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
831:
832: l_file varchar2(200);

Line 829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

825: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
831:
832: l_file varchar2(200);
833: lx_return_status varchar2(10);

Line 830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

826: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
827: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
828: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
829: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
830: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
831:
832: l_file varchar2(200);
833: lx_return_status varchar2(10);
834: l_config_model_type varchar2(30);

Line 1335: ASO_QUOTE_PUB.Update_Quote(

1331: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1332:
1333: END IF;
1334:
1335: ASO_QUOTE_PUB.Update_Quote(
1336: p_api_version_number => 1.0,
1337: p_init_msg_list => FND_API.G_FALSE,
1338: p_commit => FND_API.G_FALSE,
1339: p_control_rec => p_control_rec,

Line 1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1761: where inventory_item_id = p_inventory_item_id
1762: and organization_id = p_organization_id;
1763:
1764: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

Line 1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1762: and organization_id = p_organization_id;
1763:
1764: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1763:
1764: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1764: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

1765: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1766: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1767: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1768: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1769: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1770: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1771: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1772: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;

Line 1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1773: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1774: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1775: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;

1776: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:

Line 1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1777: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1778: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

1779: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1780: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1781: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1782: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1783: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1791:

Line 1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1784:
1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1791:
1792: lx_return_status VARCHAR2(1);

Line 1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1785: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1791:
1792: lx_return_status VARCHAR2(1);
1793: lx_msg_count NUMBER;

Line 1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1786: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1787: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1788: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1789: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1790: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1791:
1792: lx_return_status VARCHAR2(1);
1793: lx_msg_count NUMBER;
1794: lx_msg_data VARCHAR2(2000);

Line 2324: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

2320:
2321: FUNCTION Query_Qte_Line_Rows (
2322: P_Qte_Header_Id IN NUMBER,
2323: p_qte_line_id IN NUMBER
2324: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2325: IS
2326:
2327: cursor c_qte_line is
2328: select quote_line_id,

Line 2345: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2341: where quote_line_id = p_qte_line_id ))
2342: and quote_line_id <> p_qte_line_id;
2343:
2344:
2345: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2346: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2347:
2348: l_index NUMBER := 0;
2349:

Line 2346: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

2342: and quote_line_id <> p_qte_line_id;
2343:
2344:
2345: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2346: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2347:
2348: l_index NUMBER := 0;
2349:
2350: BEGIN

Line 2422: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2418: param_value param_value_type;
2419:
2420: l_rec_index BINARY_INTEGER;
2421:
2422: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2423: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2424: l_org_id NUMBER;
2425:
2426: --Configurator specific params

Line 2423: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2419:
2420: l_rec_index BINARY_INTEGER;
2421:
2422: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2423: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2424: l_org_id NUMBER;
2425:
2426: --Configurator specific params
2427: l_calling_application_id VARCHAR2(30);

Line 2661: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

2657:
2658: --------------------------------------------------------------------------*/
2659:
2660: PROCEDURE Send_input_xml
2661: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2662: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2663: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2664: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2665: P_xml_hdr IN VARCHAR2,

Line 2662: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

2658: --------------------------------------------------------------------------*/
2659:
2660: PROCEDURE Send_input_xml
2661: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2662: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2663: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2664: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2665: P_xml_hdr IN VARCHAR2,
2666: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,

Line 2663: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

2659:
2660: PROCEDURE Send_input_xml
2661: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2662: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2663: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2664: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2665: P_xml_hdr IN VARCHAR2,
2666: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
2667: X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2664: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

2660: PROCEDURE Send_input_xml
2661: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2662: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2663: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2664: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2665: P_xml_hdr IN VARCHAR2,
2666: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
2667: X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2668: X_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2676: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2672: l_html_pieces CZ_CF_API.CFG_OUTPUT_PIECES; -- table of VARCHAR2(2000)
2673: l_option_rec CZ_CF_API.INPUT_SELECTION;
2674: l_batch_val_tbl CZ_CF_API.CFG_INPUT_LIST;
2675:
2676: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2677: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2678:
2679: l_delete_qty VARCHAR2(30) := '0';
2680:

Line 2677: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2673: l_option_rec CZ_CF_API.INPUT_SELECTION;
2674: l_batch_val_tbl CZ_CF_API.CFG_INPUT_LIST;
2675:
2676: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2677: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2678:
2679: l_delete_qty VARCHAR2(30) := '0';
2680:
2681: --variable to fetch from cursor Get_Options

Line 3046: p_control_rec IN aso_quote_pub.control_rec_type

3042: PROCEDURE Validate_Configuration
3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

Line 3047: := aso_quote_pub.G_MISS_control_rec,

3043: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3044: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

3045: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3052: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3053: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

3046: p_control_rec IN aso_quote_pub.control_rec_type
3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3052: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3053: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3054: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

3047: := aso_quote_pub.G_MISS_control_rec,
3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3052: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3053: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3054: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
3055: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3052: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

3048: P_model_line_id IN NUMBER,
3049: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3050: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3051: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3052: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3053: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3054: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
3055: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3056: X_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3066: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;

3062: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Configuration' ;
3063: l_api_version_number CONSTANT NUMBER := 1.0;
3064:
3065: l_model_line_id NUMBER := p_model_line_id;
3066: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3067: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3068: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3069:
3070: l_config_header_id NUMBER;

Line 3067: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;

3063: l_api_version_number CONSTANT NUMBER := 1.0;
3064:
3065: l_model_line_id NUMBER := p_model_line_id;
3066: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3067: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3068: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3069:
3070: l_config_header_id NUMBER;
3071: l_config_revision_num NUMBER;

Line 3068: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;

3064:
3065: l_model_line_id NUMBER := p_model_line_id;
3066: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3067: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3068: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3069:
3070: l_config_header_id NUMBER;
3071: l_config_revision_num NUMBER;
3072: l_valid_configuration_flag VARCHAR2(1);