APPS.ASO_CONFIG_OPERATIONS_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

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

Line: 26

l_last_update_date       Date;

Line: 129

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

Line: 152

 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;

Line: 163

	FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

Line: 171

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

Line: 205

aso_debug_pub.add('Config_Operations:update_quote:X_Return_Status:'||X_Return_Status,1,'N');

Line: 206

aso_debug_pub.add('Config_Operations:update_quote:X_Msg_Count:'||X_Msg_Count,1,'N');