APPS.ASO_CONFIG_OPERATIONS_PVT SQL Statements

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

Line: 26

Select config_inst_hdr_id,config_inst_rev_num
from csi_item_instances
where instance_id = p_instance_id;

Line: 35

Select a.quote_header_id, a.uom_code, a.quantity, a.inventory_item_id, a.organization_id
from
ASO_QUOTE_LINES_ALL a
where a.quote_line_id = p_quote_line_id;

Line: 44

Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
from CZ_CONFIG_HDRS
where config_hdr_id = p_config_header_id
and config_rev_nbr = p_config_rev_number;

Line: 49

 Cursor c_last_update_date_csr(p_qte_header_id Number) is
 SELECT last_update_date
 FROM ASO_QUOTE_HEADERS_ALL
 WHERE quote_header_id = p_qte_header_id;

Line: 70

l_last_update_date Date;

Line: 116

Select a. config_header_id , a.config_revision_num
into l_hdr_id , l_rev_nbr
from
ASO_QUOTE_LINE_DETAILS a
where a.quote_line_id = p_quote_line_id;

Line: 254

   Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);

Line: 256

     fetch c_last_update_date_csr into l_last_update_date;

Line: 259

        aso_debug_pub.add('Add_to_Container_from_IB:Last Update date:'||l_last_update_date,1,'N');

Line: 262

            IF c_last_update_date_csr%NOTFOUND THEN
                CLOSE c_last_update_date_csr;

Line: 267

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

Line: 274

   Close c_last_update_date_csr;

Line: 278

   l_QTE_HEADER_REC.last_update_date  := l_last_update_date;

Line: 386

Select config_inst_hdr_id , config_inst_rev_num from csi_item_instances
where instance_id = p_instance_id;

Line: 394

Select  a.uom_code, a.quantity
from
cz_config_details_v a
where a.config_hdr_id =  p_config_hdr_id
and a.config_rev_nbr = p_config_rev_nbr
and a.config_item_id = p_config_item_id;

Line: 405

Select Decode (has_failures,'0','Y','N'), decode (config_status,'2','Y','N')
from CZ_CONFIG_HDRS
where config_hdr_id = p_config_header_id
and config_rev_nbr = p_config_rev_number;

Line: 415

Select a.quantity, a.uom_code
from aso_quote_lines_all a
where a.quote_line_id = p_quote_line_id;

Line: 420

Cursor to find last update date for quote
****************************************************************/

 Cursor c_last_update_date_csr(p_qte_header_id Number) is
 SELECT last_update_date
 FROM ASO_QUOTE_HEADERS_ALL
 WHERE quote_header_id = p_qte_header_id;

Line: 437

l_last_update_date Date;

Line: 546

Call  Update Quote for creating Quote lines
**************************************************************/

For  j  IN 1.. lx_out_config_tree_tbl.count Loop

Open c_uom_qty_csr(lx_out_config_tree_tbl(j).config_hdr_id,lx_out_config_tree_tbl(j).config_rev_nbr,lx_out_config_tree_tbl(j).config_item_id);

Line: 583

   Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);

Line: 585

     fetch c_last_update_date_csr into l_last_update_date;

Line: 588

        aso_debug_pub.add('Reconfigure_from_IB:Last Update date:'||l_last_update_date,1,'N');

Line: 591

            IF c_last_update_date_csr%NOTFOUND THEN
                CLOSE c_configuration_details_csr;

Line: 596

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

Line: 603

   Close c_last_update_date_csr;

Line: 607

   l_QTE_HEADER_REC.last_update_date  := l_last_update_date;

Line: 609

   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,
          P_Qte_Line_Tbl           => l_Qte_Line_Tbl,
          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: 644

aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Return status:'||x_return_status,1,'N');

Line: 645

aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Msg count:'||x_msg_count,1,'N');

Line: 818

	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

/*******************************************************************
  Cursor to check if item can be deactivated
********************************************************************/

Cursor  c_deactivate_item_csr(p_quote_line_id Number) is
Select a.config_header_id, a.config_revision_num, a.config_item_id,a.config_delta
from aso_quote_line_details  a
where a.quote_line_id =p_quote_line_id;

Line: 839

Select b.quote_line_id from aso_quote_line_details a,aso_quote_lines_all b
where b.quote_header_id = p_quote_header_id
and a.quote_line_id = b.quote_line_id
and a.config_delta = 0
and not exists(Select null from aso_quote_line_details c
where c.quote_line_id = a.ref_line_id
and c.config_delta = 0
);

Line: 852

Select b.config_header_id,b.config_revision_num
from
ASO_QUOTE_LINE_DETAILS b
where b.quote_line_id = P_quote_line_id
and b.ref_type_code ='CONFIG'
and b.ref_line_id is null;

Line: 864

Select b.config_item_id
from
ASO_QUOTE_LINE_DETAILS b
where b.config_header_id = p_config_header_id
and b.config_revision_num = p_config_revision_num
and b.ref_type_code ='CONFIG'
and b.ref_line_id is null;

Line: 876

Select a.quote_line_id,a.quantity, a.uom_code,
b.complete_configuration_flag, b.valid_configuration_flag
from
ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b
where a.quote_line_id = b.quote_line_id
and b.config_header_id = p_config_header_id
and b.config_revision_num   = p_config_revision_num
and b.config_item_id   = p_config_item_id;

Line: 886

select config_model_type
from aso_quote_lines_all
where quote_line_id = p_qte_line_id;

Line: 890

 Cursor c_last_update_date_csr(p_qte_header_id Number) is
 SELECT last_update_date,object_version_number
 FROM ASO_QUOTE_HEADERS_ALL
 WHERE quote_header_id = p_qte_header_id;

Line: 922

l_last_update_date Date;

Line: 1040

     If l_config_header_id is not null and p_delete_flag = fnd_api.g_true then

        /*******************************************************************
        Delete Quote line
        ********************************************************************/
        l_qte_line_rec.operation_code := 'DELETE';

Line: 1048

        ASO_QUOTE_LINES_PVT.Delete_Quote_Line (
			P_Api_Version_Number	 => 1.0,
			p_control_rec		     => p_control_rec,
			p_update_header_flag	 => FND_API.G_FALSE,
			P_qte_Line_Rec		     => l_qte_line_rec,
			X_Return_Status 		 => x_return_status,
			X_Msg_Count		         => x_msg_count,
			X_Msg_Data		         => x_msg_data);

Line: 1169

                    Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);

Line: 1170

                    fetch c_last_update_date_csr into l_last_update_date,l_obj_version_number;

Line: 1173

                       aso_debug_pub.add('Deactivate_from_quote:Last Update date:'||l_last_update_date,1,'N');

Line: 1177

                    IF c_last_update_date_csr%NOTFOUND THEN
                       CLOSE c_last_update_date_csr;

Line: 1182

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

Line: 1189

                    Close c_last_update_date_csr;

Line: 1193

                    l_QTE_HEADER_REC.last_update_date  := l_last_update_date;