APPS.ASO_QUOTE_TMPL_PVT SQL Statements

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

Line: 24

    P_UPDATE_FLAG           IN   VARCHAR2                                 := 'Y',
    P_TEMPLATE_ID_TBL       IN   ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
    P_QTE_HEADER_REC        IN   ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
    P_CONTROL_REC           IN   ASO_QUOTE_PUB.CONTROL_REC_TYPE           := ASO_QUOTE_PUB.G_MISS_control_REC,
    x_Qte_Line_Tbl         OUT NOCOPY /* file.sql.39 change */       ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
    x_Qte_Line_Dtl_Tbl     OUT NOCOPY /* file.sql.39 change */       ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_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

    G_USER_ID                    NUMBER                                   := FND_GLOBAL.USER_ID;

Line: 104

    SELECT concatenated_segments
      FROM MTL_SYSTEM_ITEMS_VL
     WHERE inventory_item_id = l_inventory_item_id;

Line: 109

    SELECT A.quote_line_id
      FROM ASO_QUOTE_LINE_DETAILS A
      WHERE (config_header_id, config_revision_num) = ( SELECT config_header_id, config_revision_num FROM ASO_QUOTE_LINE_DETAILS WHERE quote_line_id = l_quote_line_id );

Line: 114

    SELECT quote_line_id
      FROM ASO_QUOTE_LINE_DETAILS
     WHERE service_ref_line_id = l_quote_line_id;

Line: 119

    SELECT service_item_flag
      FROM MTL_SYSTEM_ITEMS_VL
     WHERE inventory_item_id = l_inventory_item_id
       AND organization_id = l_organization_id;

Line: 125

    SELECT org_id
    FROM   aso_quote_headers_all
    WHERE  quote_header_id = l_qte_hdr_id;

Line: 189

	      select org_id into l_tmpl_org_id from aso_quote_headers_all
	      where quote_header_id=p_template_id_tbl(i);

Line: 436

                              p_handle_deleted_flag =>  NULL,
                              p_new_name            =>  NULL,
                              x_config_header_id    =>  lx_config_header_id,
                              x_config_revision_num =>  lx_config_rev_number,
                              x_orig_item_id_tbl    =>  lx_orig_item_id_tbl,
                              x_new_item_id_tbl     =>  lx_new_item_id_tbl,
                              x_return_status       =>  x_return_status,
                              x_msg_count           =>  x_msg_count,
                              x_msg_data            =>  x_msg_data
                            );

Line: 491

    IF p_update_flag = 'N' THEN
         x_qte_line_tbl := l_qte_line_tbl;

Line: 498

    			aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');

Line: 503

    		ASO_QUOTE_PUB.Update_Quote(
       		P_Api_Version_Number      => 1.0,
        		P_Init_Msg_List           => FND_API.G_FALSE,
        		P_Commit                  => FND_API.G_FALSE,
        		P_Control_Rec             => p_control_rec,
        		P_Qte_Header_Rec          => l_qte_header_rec,
        		P_Qte_Line_Tbl            => l_qte_line_tbL,
        		P_Qte_Line_Dtl_Tbl        => l_qte_line_dtl_tbl,
        		X_Qte_Header_Rec          => X_Qte_Header_Rec,
        		X_Qte_Line_Tbl            => X_Qte_Line_Tbl,
        		X_Qte_Line_Dtl_Tbl        => X_Qte_Line_Dtl_Tbl,
        		X_Hd_Price_Attributes_Tbl => X_Hd_Price_Attributes_Tbl,
        		X_Hd_Payment_Tbl          => X_Hd_Payment_Tbl,
        		X_Hd_Shipment_Tbl         => X_Hd_Shipment_Tbl,
        		X_Hd_Freight_Charge_Tbl   => X_Hd_Freight_Charge_Tbl,
        		X_Hd_Tax_Detail_Tbl       => X_Hd_Tax_Detail_Tbl,
        		X_Line_Attr_Ext_Tbl       => X_Line_Attr_Ext_Tbl,
        		X_line_rltship_tbl        => X_line_rltship_tbl,
        		X_Price_Adjustment_Tbl    => X_Price_Adjustment_Tbl,
        		X_Price_Adj_Attr_Tbl      => X_Price_Adj_Attr_Tbl,
        		X_Price_Adj_Rltship_Tbl   => X_Price_Adj_Rltship_Tbl,
        		X_Ln_Price_Attributes_Tbl => X_Ln_Price_Attributes_Tbl,
        		X_Ln_Payment_Tbl          => X_Ln_Payment_Tbl,
        		X_Ln_Shipment_Tbl         => X_Ln_Shipment_Tbl,
        		X_Ln_Freight_Charge_Tbl   => X_Ln_Freight_Charge_Tbl,
        		X_Ln_Tax_Detail_Tbl       => X_Ln_Tax_Detail_Tbl,
        		X_Return_Status           => x_return_status,
        		X_Msg_Count               => x_msg_count,
        		X_Msg_Data                => x_msg_data
    			);

Line: 537

    				aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:  after Update_Quote', 1, 'Y');

Line: 687

 SELECT concatenated_segments
 FROM MTL_SYSTEM_ITEMS_VL
 WHERE inventory_item_id = l_inventory_item_id;

Line: 692

 SELECT bom_item_type,
        primary_uom_code,
        service_item_flag
 FROM MTL_SYSTEM_ITEMS_VL
 WHERE inventory_item_id = l_inventory_item_id
 AND organization_id = l_organization_id
 AND customer_order_enabled_flag = 'Y'
 AND bom_item_type <> 2
 AND NVL(start_date_active, SYSDATE) <= SYSDATE
 AND NVL(end_date_active, SYSDATE) >= SYSDATE;

Line: 704

 select segment1
 from mtl_system_items_vl
 WHERE inventory_item_id = l_inventory_item_id
 AND organization_id = l_organization_id;

Line: 726

select service_ref_line_id
from aso_quote_line_Details
where quote_line_id=  l_Quote_line_id
and service_ref_type_code ='QUOTE';

Line: 732

select inventory_item_id
from aso_quote_lines_All
where quote_line_id = l_quote_line_id;

Line: 835

			aso_debug_pub.add('UPDATE_QUOTE:SERVICE_not available');