The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)is
l_api_name CONSTANT VARCHAR2(30) := 'config_operations';
l_last_update_date Date;
p_delete_flag => p_delete_flag,
X_qte_header_rec => x_Qte_Header_Rec,
X_Return_Status => X_Return_Status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data
);
SELECT last_update_date, object_version_number into l_QTE_HEADER_REC.last_update_date, l_QTE_HEADER_REC.object_version_number
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_header_id = l_qte_header_rec.quote_header_id;
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
ASO_QUOTE_PUB.Update_Quote(
p_api_version_number => 1.0,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_control_rec => p_control_rec,
p_qte_header_rec => l_qte_header_rec,
X_Qte_Header_Rec => lx_qte_header_rec,
X_Qte_Line_Tbl => lx_Qte_Line_Tbl,
X_Qte_Line_Dtl_Tbl => lx_Qte_Line_Dtl_Tbl,
X_hd_Price_Attributes_Tbl => lx_hd_Price_Attr_Tbl,
X_hd_Payment_Tbl => lx_hd_Payment_Tbl,
X_hd_Shipment_Tbl => lx_hd_Shipment_Tbl,
X_hd_Freight_Charge_Tbl => lx_hd_Freight_Charge_Tbl,
X_hd_Tax_Detail_Tbl => lx_hd_Tax_Detail_Tbl,
X_hd_Attr_Ext_Tbl => lX_hd_Attr_Ext_Tbl,
X_hd_Sales_Credit_Tbl => lx_hd_Sales_Credit_Tbl,
X_hd_Quote_Party_Tbl => lx_Quote_Party_Tbl,
X_Line_Attr_Ext_Tbl => lx_Line_Attr_Ext_Tbl,
X_line_rltship_tbl => lx_line_rltship_tbl,
X_Price_Adjustment_Tbl => lx_Price_Adjustment_Tbl,
X_Price_Adj_Attr_Tbl => lx_Price_Adj_Attr_Tbl,
X_Price_Adj_Rltship_Tbl => lx_Price_Adj_Rltship_Tbl,
X_ln_Price_Attributes_Tbl=> lx_ln_Price_Attr_Tbl,
X_ln_Payment_Tbl => lx_ln_Payment_Tbl,
X_ln_Shipment_Tbl => lx_ln_Shipment_Tbl,
X_ln_Freight_Charge_Tbl => lx_ln_Freight_Charge_Tbl,
X_ln_Tax_Detail_Tbl => lx_ln_Tax_Detail_Tbl,
X_Ln_Sales_Credit_Tbl => lX_Ln_Sales_Credit_Tbl,
X_Ln_Quote_Party_Tbl => lX_Ln_Quote_Party_Tbl,
X_Return_Status => x_Return_Status,
X_Msg_Count => x_Msg_Count,
X_Msg_Data => x_Msg_Data);
aso_debug_pub.add('Config_Operations:update_quote:X_Return_Status:'||X_Return_Status,1,'N');
aso_debug_pub.add('Config_Operations:update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');