5:
6: Procedure Submit_price_tax_req(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10: p_control_rec IN ASO_QUOTE_PUB.Control_Rec_Type :=ASO_QUOTE_PUB.G_Miss_Control_Rec,
11: x_request_id OUT NOCOPY /* file.sql.39 change */ Number,
12: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13: x_msg_count OUT NOCOPY /* file.sql.39 change */ Number,
6: Procedure Submit_price_tax_req(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10: p_control_rec IN ASO_QUOTE_PUB.Control_Rec_Type :=ASO_QUOTE_PUB.G_Miss_Control_Rec,
11: x_request_id OUT NOCOPY /* file.sql.39 change */ Number,
12: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13: x_msg_count OUT NOCOPY /* file.sql.39 change */ Number,
14: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35: l_tax_status_indicator VARCHAR2(11);
36: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
36: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
37: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
38: x_status VARCHAR2(1);
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
39: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
40: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
41: l_hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
42: l_hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
43: l_hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
44: l_hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
45: l_hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
46: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
47: l_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
48: l_hd_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
49: l_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
50: l_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
52: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
53: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
54: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
55: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
56: l_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
57: l_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
58: l_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
59: l_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
60: l_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
61: l_ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
62: l_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
63:
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
64: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
65: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
66: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
67: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
68: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
69: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
70: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
71: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
72: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
73: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
74: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
75: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
76: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
77: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
78: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
86: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
79: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
86: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
87: l_org_id NUMBER ;
80: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
86: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
87: l_org_id NUMBER ;
88:
81: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
86: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
87: l_org_id NUMBER ;
88:
89: Begin
82: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
83: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
84: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
86: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
87: l_org_id NUMBER ;
88:
89: Begin
90:
291: l_qte_header_rec.price_request_id := lx_request_id;
292: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;
293: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;
294:
295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,
298: p_commit => FND_API.G_FALSE,
299: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
433: l_subject VARCHAR2(2000);
434: l_body VARCHAR2(2000);
435: l_quote_name VARCHAR2(240);
436: l_org_id VARCHAR2(240);
437: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
438: x_return_status VARCHAR2(1);
439: l_last_update_date DATE;
440: x_msg_count Number;
441: l_request_id Number;
440: x_msg_count Number;
441: l_request_id Number;
442: x_msg_index Number;
443: x_Msg_Data VARCHAR2(2000);
444: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
445:
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
442: x_msg_index Number;
443: x_Msg_Data VARCHAR2(2000);
444: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
445:
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
443: x_Msg_Data VARCHAR2(2000);
444: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
445:
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
444: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
445:
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
445:
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
446: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
447: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
448: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_line_tbl_type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
449: lx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
450: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
451: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
452: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
453: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
454: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
455: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
456: lX_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
457: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
458: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
459: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
460: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
461: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
462: lx_hd_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
470: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
463: lx_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
470: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
471:
464: lX_Ln_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
470: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
471:
472: Begin
465: lX_Ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
470: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
471:
472: Begin
473:
466: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
467: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
468: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
469: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
470: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
471:
472: Begin
473:
474: SAVEPOINT Batch_Pricing_INT;
534:
535: FND_FILE.PUT_LINE(FND_FILE.LOG,'Before Update quote');
536: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org ID : '||l_org_id);
537:
538: ASO_QUOTE_PUB.Update_Quote(
539: p_api_version_number => 1.0,
540: p_init_msg_list => FND_API.G_FALSE,
541: p_commit => FND_API.G_false,
542: p_control_rec => l_control_rec,
690:
691: Procedure Cancel_price_tax_req(
692: P_Api_Version_Number IN NUMBER,
693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
696: x_msg_count OUT NOCOPY /* file.sql.39 change */ Number,
697: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
698: ) is