APPS.PV_PRICE_PVT SQL Statements

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

Line: 19

  select 1
  into   l_return
  from   dual
  where exists
  (
   select hzu.party_site_use_id
   from   hz_party_sites     hzs,
	  hz_party_site_uses hzu
   where  hzs.party_id in (p_partner_party_id, p_contact_party_id)
   and    hzu.party_site_id = hzs.party_site_id
   and    hzu.site_use_type = 'BILL_TO'
   and    hzs.status = 'A'
   and    hzu.status = 'A'
  );

Line: 142

      SELECT  /*+ CARDINALITY(erequests 10) */ pvpp.inventory_item_id, pver.enrl_request_id, pver.object_version_number
      FROM PV_PARTNER_PROGRAM_B pvpp, PV_PG_ENRL_REQUESTS pver,
      (Select  column_value from table (CAST(p_enrl_req_id AS JTF_NUMBER_TABLE))) erequests
      WHERE pver.enrl_request_id = erequests.column_value
      and pver.PROGRAM_ID = pvpp.program_id
      and pver.custom_setup_id in (7004, 7005)
      and (pver.order_header_id is null
      OR  (pver.order_header_id is not null and pver.payment_status_code <> 'AUTHORIZED_PAYMENT'));

Line: 155

     SELECT  LiNE_INDEX, LINE_ID, adjusted_unit_price, UNIT_PRICE, LINE_UNIT_PRICE, ORDER_UOM_SELLING_PRICE, LINE_AMOUNT, EXTENDED_PRICE
            ,LiNE_UOM_CODE, PRICED_QUANTITY, PRICED_UOM_CODE, UOM_QUANTITY
	    , LINE_TYPE_CODE, LiNE_QUANTiTY, PRiCiNG_STATUS_CODE, PRICING_STATUS_TEXT, price_list_header_id, currency_code
     FROM QP_PREQ_LiNES_TMP
     ORDER BY LiNE_INDEX;

Line: 162

      select pvppv.program_name
      from pv_partner_program_vl pvppv, PV_PG_ENRL_REQUESTS pver
      where pver.enrl_request_id = cv_enrl_request_id
      and pver.program_id = pvppv.program_id;

Line: 276

       l_control_rec.temp_table_insert_flag := 'N';

Line: 287

	 select msi.primary_uom_code
         into   l_uom_code
         from   mtl_system_items_b msi
         where  msi.inventory_item_id = l_inventory_item_id_tbl(line_index)
         and    rownum = 1;

Line: 401

       	  PVX_UTiLiTY_PVT.debug_message('Before inserting into temporary tables');

Line: 405

        QP_PREQ_GRP.iNSERT_LiNES2
           (p_LiNE_iNDEX               => G_LiNE_iNDEX_TBL,
            p_LiNE_TYPE_CODE           => G_LiNE_TYPE_CODE_TBL,
            p_PRiCiNG_EFFECTiVE_DATE   => G_PRiCiNG_EFFECTiVE_DATE_TBL,
            p_ACTiVE_DATE_FiRST        => G_ACTiVE_DATE_FiRST_TBL,
            p_ACTiVE_DATE_FiRST_TYPE   => G_ACTiVE_DATE_FiRST_TYPE_TBL,
            p_ACTiVE_DATE_SECOND       => G_ACTiVE_DATE_SECOND_TBL,
            p_ACTiVE_DATE_SECOND_TYPE  => G_ACTiVE_DATE_SECOND_TYPE_TBL,
            p_LiNE_QUANTiTY            => G_LiNE_QUANTiTY_TBL,
            p_LiNE_UOM_CODE            => G_line_UOM_CODE_TBL,
            p_REQUEST_TYPE_CODE        => G_REQUEST_TYPE_CODE_TBL,
            p_PRiCED_QUANTiTY          => G_PRiCED_QUANTiTY_TBL,
            p_PRiCED_UOM_CODE          => G_line_UOM_CODE_TBL,
            p_CURRENCY_CODE            => G_CURRENCY_CODE_TBL,
            p_UNiT_PRiCE               => G_UNiT_PRiCE_TBL,
            p_PERCENT_PRiCE            => G_PERCENT_PRiCE_TBL,
            p_UOM_QUANTiTY             => G_UOM_QUANTiTY_TBL,
            p_ADJUSTED_UNiT_PRiCE      => G_ADJUSTED_UNiT_PRiCE_TBL,
            p_UPD_ADJUSTED_UNiT_PRiCE  => G_UPD_ADJUSTED_UNiT_PRiCE_TBL,
            p_PROCESSED_FLAG           => G_PROCESSED_FLAG_TBL,
            p_PRiCE_FLAG               => G_PRiCE_FLAG_TBL,
            p_LiNE_iD                  => G_LiNE_iD_TBL,
            p_PROCESSiNG_ORDER         => G_PROCESSiNG_ORDER_TBL,
            p_PRiCiNG_STATUS_CODE      => G_PRiCiNG_STATUS_CODE_TBL,
            p_PRiCiNG_STATUS_TEXT      => G_PRiCiNG_STATUS_TEXT_TBL,
            p_ROUNDiNG_FLAG            => G_ROUNDiNG_FLAG_TBL,
            p_ROUNDiNG_FACTOR          => G_ROUNDiNG_FACTOR_TBL,
            p_QUALiFiERS_EXiST_FLAG    => G_QUALiFiERS_EXiST_FLAG_TBL,
            p_PRiCiNG_ATTRS_EXiST_FLAG => G_PRiCiNG_ATTRS_EXiST_FLAG_TBL,
            p_PRiCE_LiST_iD            => G_PRiCE_LiST_iD_TBL,
            p_VALiDATED_FLAG           => G_PL_VALiDATED_FLAG_TBL,
            p_PRiCE_REQUEST_CODE       => G_PRiCE_REQUEST_CODE_TBL,
            p_USAGE_PRiCiNG_TYPE       => G_USAGE_PRiCiNG_TYPE_TBL,
            --p_line_category            => G_LiNE_CATEGORY_TBL,
            x_status_code              => x_return_status,
            x_status_text              => l_return_status_text);

Line: 445

               PVX_UTiLiTY_PVT.debug_message('Return Status ater inserting : '|| x_return_status);

Line: 449

               PVX_UTiLiTY_PVT.debug_message('Return Status text after inserting : '|| l_return_status_text);

Line: 520

		                 l_pricing_status_code <> QP_PREQ_PUB.G_STATUS_UPDATED;

Line: 569

                PV_Pg_Enrl_Requests_PVT.Update_Pg_Enrl_Requests
		(
                    p_api_version_number        =>  p_api_version_number,
                    p_init_msg_list             =>  Fnd_Api.G_FALSE,
                    p_commit                    =>  Fnd_Api.G_FALSE,
                    p_validation_level          =>  Fnd_Api.G_VALID_LEVEL_FULL,
                    x_return_status             =>  x_return_status,
                    x_msg_count                 =>  x_msg_count,
                    x_msg_data                  =>  x_msg_data,
                    p_enrl_request_rec          =>  l_enrl_req_rec
                );

Line: 588

	        update pv_pg_enrl_requests
	        set MEMBERSHIP_FEE  = l_adjusted_unit_price , TRANS_CURR_CODE = l_currency_code
	        where enrl_request_id = l_enrl_req_id_tbl(l_line_index);