APPS.ASO_QUOTE_TMPL_PVT SQL Statements

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

Line: 21

    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: 97

    SELECT concatenated_segments
      FROM MTL_SYSTEM_ITEMS_VL
     WHERE inventory_item_id = l_inventory_item_id;

Line: 102

    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: 107

    SELECT quote_line_id
      FROM ASO_QUOTE_LINE_DETAILS
     WHERE service_ref_line_id = l_quote_line_id;

Line: 112

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

Line: 118

    SELECT org_id
    FROM   aso_quote_headers_all
    WHERE  quote_header_id = l_qte_hdr_id;

Line: 373

                              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: 428

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

Line: 435

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

Line: 439

    		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: 471

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