APPS.ASO_PRICING_FLOWS_PVT SQL Statements

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

Line: 450

  SELECT adj.PRICE_ADJUSTMENT_ID
  BULK COLLECT INTO
  l_adj_id_tbl
  FROM ASO_PRICE_ADJUSTMENTS adj
  WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
  AND adj.price_adjustment_id NOT IN (SELECT column_value
  							   FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);

Line: 459

     aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount: '||sql%rowcount,1,'Y');

Line: 476

        aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

Line: 479

            DELETE FROM ASO_PRICE_ADJ_ATTRIBS
            WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line: 483

        aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:No of adjustment attribute lines deleted is sql%rowcount: '||sql%rowcount,1,'Y');

Line: 489

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');

Line: 491

  DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
  WHERE QUOTE_LINE_ID in (SELECT quote_line_id
                          FROM ASO_PRICE_ADJUSTMENTS
                          WHERE quote_header_id = p_qte_header_rec.quote_header_id
                          AND quote_line_id IS NOT NULL);

Line: 498

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 499

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

Line: 502

  DELETE FROM ASO_PRICE_ADJUSTMENTS
  WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 505

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 548

  l_req_control_rec.TEMP_TABLE_INSERT_FLAG := 'N';  ---- Modified

Line: 739

	 SELECT service_ref_type_code , service_ref_line_id
	 FROM   ASO_QUOTE_LINE_DETAILS
	 WHERE  quote_line_id = p_qte_line_id;

Line: 744

	 SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,
	        unit_list_price, price_list_id
	 FROM OE_ORDER_LINES_ALL
	 WHERE line_id = p_order_line_id;

Line: 751

	 SELECT cust_account_id
	 FROM ASO_QUOTE_HEADERS_ALL
	 WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 756

	 SELECT   original_order_line_id
	 FROM     csi_instance_accts_rg_v
	 WHERE    customer_product_id = p_instance_id
	 AND      account_id          = p_cust_account_id;

Line: 867

      DELETE FROM aso_price_adjustments
      WHERE quote_header_id = p_qte_header_rec.quote_header_id
      AND   quote_line_id IS NULL;

Line: 873

       aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted if p_qte_line_tbl.count = 0 '||sql%ROWCOUNT,1,'Y');

Line: 889

        aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Filtering Quote lines that are deleted...',1,'Y');

Line: 902

	IF p_qte_line_tbl(i).operation_code = 'DELETE' THEN
              IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
                 aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: p_qte_line_tbl('||i||').quote_line_id - deleted :'||NVL(to_char(p_qte_line_tbl(i).quote_line_id),'NULL'),1,'Y');

Line: 908

	   -- Operation is either CREATE or UPDATE.

	   -- Service Processing Logic Begins Here...

		IF NVL(p_qte_line_tbl(i).serviceable_product_flag,'N') = 'Y'  AND
                   NVL(l_service_proc_done_flag,'N') = 'N'
		THEN
		    l_service_product_id_tbl(p_qte_line_tbl(i).quote_line_id) := p_qte_line_tbl(i).quote_line_id;

Line: 1278

		aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

Line: 1281

		DELETE FROM ASO_PRICE_ADJ_ATTRIBS
		WHERE  PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
								 FROM ASO_PRICE_ADJUSTMENTS
								 WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
								 AND QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id);

Line: 1288

			aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adj Attribs Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 1289

		     aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');

Line: 1291

		DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
		WHERE QUOTE_LINE_ID = l_qte_line_tbl(i).quote_line_id;

Line: 1294

			aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 1295

			aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

Line: 1298

		DELETE FROM ASO_PRICE_ADJUSTMENTS
		WHERE quote_line_id = l_qte_line_tbl(i).quote_line_id;

Line: 1301

			aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 1337

	l_req_control_rec.TEMP_TABLE_INSERT_FLAG := 'N';  ---- Modified

Line: 1674

      l_qte_line_id_tbl.delete;

Line: 1677

      l_qte_adj_id_tbl.delete;

Line: 1680

	 l_service_qte_line_id_tbl.delete;

Line: 1713

          if p_qte_line_tbl(i).operation_code <> 'DELETE' Then
             --changed line
             --assign all the Is_line_changed_flag to 'N' for the ones that are created and updated i.e. are the chg lines
		   --Is Line Changed flag is set to 'N' because this value is what needs to be sent to BuildContext
		   IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
                aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Assign the Is_line_changed_flag to N',1,'Y');

Line: 1964

        SELECT count(rowid)
        INTO   l_db_ln_counter
        FROM ASO_QUOTE_LINES_ALL
        WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 2050

    SELECT adj.PRICE_ADJUSTMENT_ID
    BULK COLLECT INTO
    l_adj_id_tbl
    FROM ASO_PRICE_ADJUSTMENTS adj
    WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
    AND adj.price_adjustment_id NOT IN (SELECT column_value
    							     FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);

Line: 2059

       aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount(Both hdr and lines): '
                          ||sql%rowcount,1,'Y');

Line: 2063

     SELECT adj.PRICE_ADJUSTMENT_ID
     BULK COLLECT INTO
     l_adj_id_tbl
     FROM ASO_PRICE_ADJUSTMENTS adj
     WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
     AND adj.quote_line_id IS NULL;

Line: 2070

       aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount(Header): '
                          ||sql%rowcount,1,'Y');

Line: 2089

        aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_ATTRIBS', 1, 'Y');

Line: 2092

           DELETE FROM ASO_PRICE_ADJ_ATTRIBS
           WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line: 2096

        aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:No of adjustment attribute lines deleted is sql%rowcount: '
	                    ||sql%rowcount,1,'Y');

Line: 2103

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_complete_qte_flag before delete:'||l_complete_qte_flag,1,'Y');

Line: 2110

       aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');

Line: 2112

    DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
    WHERE QUOTE_LINE_ID in (SELECT quote_line_id
                           FROM ASO_PRICE_ADJUSTMENTS
                           WHERE quote_header_id = p_qte_header_rec.quote_header_id
                           AND quote_line_id IS NOT NULL);

Line: 2119

      aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 2120

      aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

Line: 2123

    DELETE FROM ASO_PRICE_ADJUSTMENTS
    WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 2126

      aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 2134

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS', 1, 'Y');

Line: 2136

              aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE for l_qte_line_id_tbl(i):'
  		                      ||l_qte_line_id_tbl(i), 1, 'Y');

Line: 2141

       DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
       WHERE quote_line_id IN (SELECT column_value
                              FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)));

Line: 2146

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 2150

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');

Line: 2152

       DELETE FROM ASO_PRICE_ADJUSTMENTS
       WHERE quote_line_id IN (SELECT column_value
                              FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))
       AND quote_header_id = p_qte_header_rec.quote_header_id;

Line: 2157

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 2160

       DELETE FROM ASO_PRICE_ADJUSTMENTS
	  WHERE quote_header_id = p_qte_header_rec.quote_header_id
	  AND quote_line_id is NULL;

Line: 2165

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Header Adjustment deleted '||sql%ROWCOUNT,1,'Y');

Line: 2168

      DELETE FROM ASO_PRICE_ADJUSTMENTS
      WHERE quote_header_id = p_qte_header_rec.quote_header_id
      AND quote_line_id is NULL;

Line: 2173

          aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Header Adjustment deleted '||sql%ROWCOUNT,1,'Y');

Line: 2227

  l_req_control_rec.TEMP_TABLE_INSERT_FLAG := 'N';  ---- Modified

Line: 2276

  /*Insert all the applied adjustments and the nonapplied manual adjustments*/
  ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
     		P_Api_Version_Number       => 1.0,
     		P_Init_Msg_List            => FND_API.G_FALSE,
     		P_Commit                   => FND_API.G_FALSE,
     		p_control_rec		       => l_prc_control_rec,
     		p_qte_header_rec           => p_qte_header_rec,
			P_Insert_Type              => 'HDR',
     		x_return_status            => x_return_status,
     		x_msg_count                => x_msg_count,
     		x_msg_data                 => x_msg_data);

Line: 2741

  DELETE FROM ASO_PRICE_ADJUSTMENTS
  WHERE quote_header_id = p_qte_header_rec.quote_header_id
  AND quote_line_id IS NULL
  AND (applied_flag = 'Y' OR updated_flag = 'Y');

Line: 2746

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');

Line: 2748

  DELETE FROM ASO_PRICE_ADJ_ATTRIBS
  WHERE  PRICE_ADJUSTMENT_ID IN (SELECT PRICE_ADJUSTMENT_ID
                                 FROM ASO_PRICE_ADJUSTMENTS
                                 WHERE QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
                                 AND QUOTE_LINE_ID is NULL
						   AND (applied_flag = 'Y' OR updated_flag = 'Y'));

Line: 2755

    aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Hdr Adjustment Attributes deleted '||sql%ROWCOUNT,1,'Y');

Line: 2789

  l_req_control_rec.TEMP_TABLE_INSERT_FLAG := 'N';  ---- Modified

Line: 2843

               p_insert_type              => 'HDR_ONLY',
               x_return_status            => x_return_status,
               x_msg_count                => x_msg_count,
               x_msg_data                 => x_msg_data);