APPS.ASO_SPLIT_LINE_INT SQL Statements

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

Line: 33

select quote_header_id
from aso_quote_lines_all
where quote_line_id = p_qte_line_id;

Line: 133

select config_header_id
from  aso_quote_line_details
where quote_line_id = p_original_qte_line_rec.quote_line_id;

Line: 138

select quote_header_id
from aso_quote_lines_all
where quote_line_id = p_original_qte_line_rec.quote_line_id;

Line: 156

     aso_debug_pub.add('P_Qte_Header_Rec.last_update_date:           '||P_Qte_Header_Rec.last_update_date, 1, 'Y');

Line: 157

     aso_debug_pub.add('P_Qte_Header_Rec.price_updated_date:         '||P_Qte_Header_Rec.price_updated_date, 1, 'Y');

Line: 158

     aso_debug_pub.add('P_Qte_Header_Rec.tax_updated_date:           '||P_Qte_Header_Rec.tax_updated_date, 1, 'Y');

Line: 598

select quote_line_id from aso_quote_line_details
where  service_ref_line_id   = p_service_ref_line_id
and    service_ref_type_code = 'QUOTE';

Line: 689

l_orig_line_deleted          varchar2(1) := 'N';

Line: 1294

           l_qte_line_rec.operation_code := 'DELETE';

Line: 1299

           l_orig_line_deleted := 'Y';

Line: 1302

           l_qte_line_rec.operation_code := 'UPDATE';

Line: 1315

         aso_debug_pub.add('Do_Split_Line: Before call to Update Quote', 1, 'Y');

Line: 1318

       ASO_QUOTE_PUB.Update_quote(
              P_Api_Version_Number       => 1.0,
              P_Init_Msg_List            => FND_API.G_FALSE,
              P_Commit                   => P_Commit,
              P_Validation_Level         => FND_API.G_VALID_LEVEL_FULL,
              P_Control_Rec              => l_control_rec,
              P_Qte_Header_Rec           => p_qte_header_rec,
              P_hd_Price_Attributes_Tbl  => ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
              P_hd_Payment_Tbl           => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
              P_hd_Shipment_Tbl          => ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
              P_hd_Freight_Charge_Tbl    => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
              P_hd_Tax_Detail_Tbl        => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
              P_hd_Attr_Ext_Tbl          => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
              P_hd_Sales_Credit_Tbl      => ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
              P_hd_Quote_Party_Tbl       => ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
              P_Qte_Line_Tbl             => l_to_create_quote_line_tbl,
              P_Qte_Line_Dtl_Tbl         => l_to_create_qte_line_dtl_tbl,
              P_Line_Attr_Ext_Tbl        => ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
              P_line_rltship_tbl         => ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
              P_Price_Adjustment_Tbl     => l_to_create_price_adj_tbl,
              P_Price_Adj_Attr_Tbl       => l_create_price_adj_attr_tbl,
              P_Price_Adj_Rltship_Tbl    => l_create_price_adj_rltn_tbl,
              P_Ln_Price_Attributes_Tbl  => l_to_create_price_attr_tbl,
              P_Ln_Payment_Tbl           => ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
              P_Ln_Shipment_Tbl          => l_to_create_shipment_tbl,
              P_Ln_Freight_Charge_Tbl    => ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
              P_Ln_Tax_Detail_Tbl        => ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
              P_ln_Sales_Credit_Tbl      => l_to_create_sales_credit_tbl,
              P_ln_Quote_Party_Tbl       => ASO_QUOTE_PUB.G_MISS_Quote_Party_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_hd_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: 1376

         aso_debug_pub.add('Do_Split_Line: After call to Update Quote');

Line: 1383

             aso_debug_pub.add('Do_Split_Line: Error in Update_Quote', 1, 'N');

Line: 1413

       IF ( l_orig_line_deleted = 'Y' ) THEN
          l_payment_tbl := l_orig_payment_tbl;

Line: 1421

               aso_debug_pub.add('Do_Split_Line: l_orig_line_deleted: '|| l_orig_line_deleted);

Line: 1524

                                ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
                                  (
                                    P_Api_Version_Number          =>  1.0,
                                    P_Init_Msg_List               => FND_API.G_FALSE,
                                    P_Commit                      => P_Commit,
                                    P_OLD_QUOTE_LINE_ID           => l_map_qte_line_tbl(i).quote_line_id,
                                    P_NEW_QUOTE_LINE_ID           => lx_qte_line_tbl(i).quote_line_id,
                                    X_Return_Status               => x_return_status,
                                    X_Msg_Count                   => X_Msg_Count,
                                    X_Msg_Data                    => X_Msg_Data );

Line: 1565

         aso_debug_pub.add('Do_Split_Line: No call made to Update_Quote');