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 413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

409: Where config_header_id = p_config_hdr_id
410: AND config_revision_num = p_config_rev_nbr ;
411:
412: l_Api_Version_Number NUMBER := 1.0 ;
413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

Line 414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

410: AND config_revision_num = p_config_rev_nbr ;
411:
412: l_Api_Version_Number NUMBER := 1.0 ;
413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

Line 415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

411:
412: l_Api_Version_Number NUMBER := 1.0 ;
413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;

Line 416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

412: l_Api_Version_Number NUMBER := 1.0 ;
413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;

Line 417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;

413: l_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;

414: l_miss_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;

415: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;

416: l_miss_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

417: X_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type ;
418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;

Line 422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

418: X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type ;
419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;

Line 423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

419: X_payment_tbl ASO_QUOTE_PUB.Payment_tbl_type ;
420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;

Line 424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

420: X_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type ;
421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;

Line 425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;

421: X_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
429: Begin

Line 426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;

422: X_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
429: Begin
430:

Line 427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;

423: X_price_attributes_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
429: Begin
430:
431: For i_update_revision IN c_update_revision Loop

Line 428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;

424: X_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
425: X_line_attribs_ext_tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type;
426: X_price_adj_tbl ASO_QUOTE_PUB.Price_adj_tbl_type ;
427: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type ;
428: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type ;
429: Begin
430:
431: For i_update_revision IN c_update_revision Loop
432: l_qte_line_rec := l_miss_line_rec ;

Line 481: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=

477: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
478: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
479: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
480:
481: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=
482: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;
483: l_api_name Constant Varchar2(30) := 'Create_Relationship' ;
484: l_api_version_number NUMBER := 1.0 ;
485: l_line_relationship_id NUMBER ;

Line 482: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;

478: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
479: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
480:
481: l_LINE_RLTSHIP_Rec ASO_quote_PUB.LINE_RLTSHIP_Rec_Type :=
482: ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC ;
483: l_api_name Constant Varchar2(30) := 'Create_Relationship' ;
484: l_api_version_number NUMBER := 1.0 ;
485: l_line_relationship_id NUMBER ;
486: l_dummy_line_id NUMBER;

Line 506: l_line_rltship_rec := aso_quote_pub.G_MISS_Line_rltship_rec ;

502: If G_rtln_tbl(i).parent_config_item_id = p_config_item_id
503: AND G_rtln_tbl(i).included_flag = 'N'
504: AND G_rtln_tbl(i).parent_config_item_id IS NOT NULL Then
505:
506: l_line_rltship_rec := aso_quote_pub.G_MISS_Line_rltship_rec ;
507:
508: --populate line relationship record
509: l_line_rltship_rec.OPERATION_CODE := 'CREATE' ;
510: l_line_rltship_rec.QUOTE_LINE_ID := parent_quote_line_id ;

Line 727: p_control_rec IN aso_quote_pub.control_rec_type

723: PROCEDURE Get_config_details(
724: p_api_version_number IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

Line 728: := aso_quote_pub.G_MISS_control_rec,

724: p_api_version_number IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
732: p_config_hdr_id IN NUMBER,

Line 729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,

725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
732: p_config_hdr_id IN NUMBER,
733: p_config_rev_nbr IN NUMBER,

Line 730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,

726: p_commit IN VARCHAR2 := FND_API.G_FALSE,
727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
732: p_config_hdr_id IN NUMBER,
733: p_config_rev_nbr IN NUMBER,
734: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,

727: p_control_rec IN aso_quote_pub.control_rec_type
728: := aso_quote_pub.G_MISS_control_rec,
729: p_qte_header_rec IN aso_quote_pub.qte_header_rec_type,
730: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
731: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
732: p_config_hdr_id IN NUMBER,
733: p_config_rev_nbr IN NUMBER,
734: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
735: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

876: l_ship_model_complete_flag VARCHAR2(1);
877:
878: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691

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

877:
878: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;

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

878: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:

Line 883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;

879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;

881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;

Line 887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

884: -- bug 11696691
885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;

885: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type1 := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl1;
886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

886:
887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

887: l_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

888: l_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

889: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_rec_Type;
890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

890: l_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

891: l_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

892: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

893: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

894: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

Line 899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

895: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:

Line 900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

896: l_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

897: l_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;

898: l_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
899: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

900: l_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

901: l_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

902: l_shipment_tbl ASO_QUOTE_PUB.Shipment_tbl_Type;
903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

903:
904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

904: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

905: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

906: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

907: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

908: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

909: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

910: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

911: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

912: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

913: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

914: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
922:

Line 919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

915: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
922:
923: l_file varchar2(200);

Line 920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

916: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
922:
923: l_file varchar2(200);
924: lx_return_status varchar2(10);

Line 921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

917: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
918: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
919: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
920: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
921: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
922:
923: l_file varchar2(200);
924: lx_return_status varchar2(10);
925: l_config_model_type varchar2(30);

Line 1508: ASO_QUOTE_PUB.Update_Quote(

1504: aso_debug_pub.add( 'Get_Config_details: l_Qte_Line_Dtl_Tbl.count: '||l_Qte_Line_Dtl_Tbl.count);
1505:
1506: END IF;
1507:
1508: ASO_QUOTE_PUB.Update_Quote(
1509: p_api_version_number => 1.0,
1510: p_init_msg_list => FND_API.G_FALSE,
1511: p_commit => FND_API.G_FALSE,
1512: p_control_rec => p_control_rec,

Line 1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1934: where inventory_item_id = p_inventory_item_id
1935: and organization_id = p_organization_id;
1936:
1937: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

Line 1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1935: and organization_id = p_organization_id;
1936:
1937: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1936:
1937: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1937: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_rec_Type;
1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

1938: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1939: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1940: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1941: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1942: l_hd_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1943: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1944: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1945: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;

Line 1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1946: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1947: l_l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1948: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;

1949: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:

Line 1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1950: l_l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1951: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

1952: l_l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1953: l_ln_price_attr_rec ASO_QUOTE_PUB.Price_Attributes_rec_Type;
1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1954: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1955: l_l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1956: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1964:

Line 1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1957:
1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1964:
1965: lx_return_status VARCHAR2(1);

Line 1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1958: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1964:
1965: lx_return_status VARCHAR2(1);
1966: lx_msg_count NUMBER;

Line 1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1959: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1960: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1961: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1962: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1963: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1964:
1965: lx_return_status VARCHAR2(1);
1966: lx_msg_count NUMBER;
1967: lx_msg_data VARCHAR2(2000);

Line 2579: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

2575:
2576: FUNCTION Query_Qte_Line_Rows (
2577: P_Qte_Header_Id IN NUMBER,
2578: p_qte_line_id IN NUMBER
2579: ) RETURN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2580: IS
2581:
2582: cursor c_qte_line is
2583: select quote_line_id,

Line 2600: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2596: where quote_line_id = p_qte_line_id ))
2597: and quote_line_id <> p_qte_line_id;
2598:
2599:
2600: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2601: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2602:
2603: l_index NUMBER := 0;
2604:

Line 2601: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

2597: and quote_line_id <> p_qte_line_id;
2598:
2599:
2600: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2601: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2602:
2603: l_index NUMBER := 0;
2604:
2605: BEGIN

Line 2677: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2673: param_value param_value_type;
2674:
2675: l_rec_index BINARY_INTEGER;
2676:
2677: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2678: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2679: l_org_id NUMBER;
2680:
2681: --Configurator specific params

Line 2678: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2674:
2675: l_rec_index BINARY_INTEGER;
2676:
2677: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2678: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2679: l_org_id NUMBER;
2680:
2681: --Configurator specific params
2682: l_calling_application_id VARCHAR2(30);

Line 2952: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

2948:
2949: --------------------------------------------------------------------------*/
2950:
2951: PROCEDURE Send_input_xml
2952: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2953: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2954: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2955: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2956: P_xml_hdr IN VARCHAR2,

Line 2953: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

2949: --------------------------------------------------------------------------*/
2950:
2951: PROCEDURE Send_input_xml
2952: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2953: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2954: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2955: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2956: P_xml_hdr IN VARCHAR2,
2957: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,

Line 2954: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

2950:
2951: PROCEDURE Send_input_xml
2952: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2953: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2954: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2955: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2956: P_xml_hdr IN VARCHAR2,
2957: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
2958: X_config_changed OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- CZ ER

Line 2955: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

2951: PROCEDURE Send_input_xml
2952: ( P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
2953: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
2954: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
2955: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2956: P_xml_hdr IN VARCHAR2,
2957: X_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
2958: X_config_changed OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- CZ ER
2959: X_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2968: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2964: l_html_pieces CZ_CF_API.CFG_OUTPUT_PIECES; -- table of VARCHAR2(2000)
2965: l_option_rec CZ_CF_API.INPUT_SELECTION;
2966: l_batch_val_tbl CZ_CF_API.CFG_INPUT_LIST;
2967:
2968: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2969: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2970:
2971: l_delete_qty VARCHAR2(30) := '0';
2972:

Line 2969: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2965: l_option_rec CZ_CF_API.INPUT_SELECTION;
2966: l_batch_val_tbl CZ_CF_API.CFG_INPUT_LIST;
2967:
2968: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2969: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2970:
2971: l_delete_qty VARCHAR2(30) := '0';
2972:
2973: --variable to fetch from cursor Get_Options

Line 3341: p_control_rec IN aso_quote_pub.control_rec_type

3337: PROCEDURE Validate_Configuration
3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

Line 3342: := aso_quote_pub.G_MISS_control_rec,

3338: (P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
3339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

3340: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3347: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3348: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

3341: p_control_rec IN aso_quote_pub.control_rec_type
3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3347: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3348: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3349: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

3342: := aso_quote_pub.G_MISS_control_rec,
3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3347: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3348: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3349: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
3350: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3347: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

3343: P_model_line_id IN NUMBER,
3344: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3345: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
3346: P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
3347: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
3348: X_config_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
3349: X_config_revision_num OUT NOCOPY /* file.sql.39 change */ NUMBER,
3350: X_valid_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3351: X_complete_configuration_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

3357: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Configuration' ;
3358: l_api_version_number CONSTANT NUMBER := 1.0;
3359:
3360: l_model_line_id NUMBER := p_model_line_id;
3361: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3362: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3363: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3364:
3365: l_config_header_id NUMBER;

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

3358: l_api_version_number CONSTANT NUMBER := 1.0;
3359:
3360: l_model_line_id NUMBER := p_model_line_id;
3361: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3362: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3363: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3364:
3365: l_config_header_id NUMBER;
3366: l_config_revision_num NUMBER;

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

3359:
3360: l_model_line_id NUMBER := p_model_line_id;
3361: l_qte_header_rec aso_quote_pub.qte_header_rec_type := aso_quote_pub.g_miss_qte_header_rec;
3362: l_model_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
3363: l_model_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
3364:
3365: l_config_header_id NUMBER;
3366: l_config_revision_num NUMBER;
3367: l_valid_configuration_flag VARCHAR2(1);