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

         select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id) cust_account_id
         from ASO_QUOTE_HEADERS_ALL
         WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 757

	select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID) cust_account_id
         from ASO_QUOTE_LINES_ALL
         WHERE quote_line_id = p_qte_line_id;

Line: 762

     select  price_list_id
     from    aso_quote_headers_all
     where   quote_header_id = p_qte_hdr_id;

Line: 771

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

         SELECT si.concatenated_segments product, si.inventory_item_id, cii.quantity, cii.unit_of_measure
	FROM mtl_system_items_kfv si, csi_item_instances cii
	WHERE NVL(cii.active_end_date, (SYSDATE + 1)) > SYSDATE
	AND cii.inventory_item_id = si.inventory_item_id
	AND si.organization_id = cii.inv_master_organization_id
	AND cii.instance_id =p_instance_id;

Line: 790

	/* SELECT   distinct a.product,b.inventory_item_id,a.quantity,a.unit_of_measure_code
      FROM     csi_instance_accts_rg_v a ,mtl_system_items_vl  b
      where    a.product = b.concatenated_segments
	 AND      a.customer_product_id = p_instance_id;

Line: 917

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

Line: 923

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

Line: 939

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

Line: 952

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

	   -- Operation is either CREATE or UPDATE.

	   if  p_qte_line_tbl(i).operation_code='UPDATE' then

	     select nvl(service_item_flag,'N'), nvl(serviceable_product_flag,'N')
	     into  l_service_item_flg, l_servicable_item_flg
	     from aso_quote_lines_all
	     where quote_line_id=p_qte_line_tbl(i).quote_line_id;

Line: 995

				  if  p_qte_line_tbl(j).operation_code='UPDATE' then

					select nvl(service_item_flag,'N'), nvl(serviceable_product_flag,'N')
					into  l_service_item_flg1, l_servicable_item_flg1
					from aso_quote_lines_all
					where quote_line_id=p_qte_line_tbl(j).quote_line_id;

Line: 1456

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

Line: 1459

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

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

Line: 1467

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

Line: 1469

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

Line: 1472

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

Line: 1473

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

Line: 1476

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

Line: 1479

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

Line: 1515

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

Line: 1858

      l_qte_line_id_tbl.delete;

Line: 1861

      l_qte_adj_id_tbl.delete;

Line: 1864

	 l_service_qte_line_id_tbl.delete;

Line: 1897

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

		   select nvl(item_type_code,'X') into l_item_type_code
		   from aso_quote_lines_all
		   where quote_line_id = p_qte_line_tbl(i).quote_line_id;

Line: 1919

		    if p_qte_line_tbl(i).item_type_code='SRV'  and (p_qte_line_tbl(i).operation_code='CREATE'  or p_qte_line_tbl(i).operation_code = 'UPDATE') then
                              If (lx_order_status_rec.all_lines_flag = 'N') AND (lx_order_status_rec.changed_lines_flag = 'Y') then
		                  IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
                                       aso_debug_pub.add(' rassharm ASO_PRICING_FLOWS_PVT:service ITEM line id :'||p_qte_line_tbl(i).quote_line_id,1,'Y');

Line: 1937

                      if (l_item_type_code='MDL') and (p_qte_line_tbl(i).operation_code = 'UPDATE') then
		           If (lx_order_status_rec.all_lines_flag = 'N') AND (lx_order_status_rec.changed_lines_flag = 'Y') then
			        IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
                                               aso_debug_pub.add('8976983 ASO_PRICING_FLOWS_PVT:MODEL ITEM header id :'||p_qte_line_tbl(i).quote_header_id,1,'Y');

Line: 1944

				         SELECT quote_line_id
                                         FROM   aso_quote_line_details
					  WHERE  ref_type_code = 'CONFIG'
						AND    top_model_line_id = p_qte_line_tbl(i).quote_line_id
						AND    quote_line_id  in (
						select quote_line_id from aso_quote_lines_all
						where quote_header_id=p_qte_line_tbl(i).quote_header_id
						and item_type_code in ('CFG')))
				loop
				         IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
                                               aso_debug_pub.add('8976983 ASO_PRICING_FLOWS_PVT:MODEL ITEM:'||opt_cursor.quote_line_id,1,'Y');

Line: 2204

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

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

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

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

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

Line: 2329

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

Line: 2332

           DELETE FROM ASO_PRICE_ADJ_ATTRIBS
           WHERE PRICE_ADJUSTMENT_ID = l_adj_id_tbl(i);

Line: 2336

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

Line: 2343

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

Line: 2350

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

Line: 2352

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

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

Line: 2360

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

Line: 2363

    DELETE FROM ASO_PRICE_ADJUSTMENTS
    WHERE quote_header_id = p_qte_header_rec.quote_header_id;

Line: 2366

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

Line: 2374

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

Line: 2376

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

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

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

Line: 2390

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

Line: 2392

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

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

Line: 2400

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

Line: 2405

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

Line: 2408

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

Line: 2413

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

Line: 2467

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

Line: 2516

  /*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: 2981

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

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

Line: 2988

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

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

Line: 3029

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

Line: 3083

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