APPS.ZX_TDS_RATE_DETM_PKG SQL Statements

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

Line: 109

  SELECT Allow_Offset_Tax_Flag
    FROM zx_party_tax_profile
   WHERE party_tax_profile_id = c_ptp_id;

Line: 114

  SELECT numeric_result
    FROM zx_process_results
   WHERE result_id = c_result_id;

Line: 122

  SELECT offset_tax_flag
    FROM ap_suppliers
   WHERE vendor_id      = c_account_id ;

Line: 129

  SELECT offset_tax_flag
    FROM ap_supplier_sites_all
   WHERE vendor_id      = c_account_id
     AND vendor_site_id = c_account_site_id;

Line: 167

  l_exempt_info_tbl.DELETE;

Line: 623

/*  -- bug 4673667: do not need to check delete_flag
    WHEN
    -- bug 3330127
      -- Tax lines calculated by provider will not be pulled in for processing
      ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NOT NULL
       OR

      UPPER(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag) = 'Y'
    THEN
      -- Do not perform rate determination for tax lines calculated by providers
      -- or for tax lines marked for deletion.

      NULL;

Line: 644

        nvl(upper(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag),'N') <> 'Y' AND
        ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id is NULL
*/
       ) OR
       ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_manual_entry IN
         ('TAX_STATUS', 'TAX_RATE_CODE') -- AND --bug 5237144
         -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX'
       ) OR
       ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'APPLIED_FROM' AND
         ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).applied_amt_handling_flag = 'R'
       ) OR
	-- Bug 5176149: need to populate tax rate id and tax rate % for matched invoice
       ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE = 'REFERENCE'
       ) OR
       ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).direct_rate_result_id IS NOT NULL
       ) OR
       ( p_event_class_rec.template_usage_code = 'TAX_RULES' AND
         ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL
       )
      )
    ) OR
    ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' AND
      --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_code IS NOT NULL AND
      ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NULL
    )
    THEN
      -- This is the normal processing case where rate determination needs to be performed
      -- When tax is not calculated by provider service and rate is not already
      -- available in detail tax lines structure and delete flag is not 'Y'
      -- or an override case with last_manual_entry as 'TAX_STATUS', then determine
      -- the tax rate to be applied to the tax line.

      -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).process_for_recovery_flag:= 'Y';

Line: 1000

                                 p_structure_index) IN ('CREATE', 'UPDATE')
        AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(
                                 p_structure_index) = 'INTERCOMPANY_TRX'
        AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag = 'Y'
      THEN

        -- for intercompany the Offset_Flag on detail tax line marked as 'Y'
        -- only when the offset_tax_rate_code is not null, so no need to check
        -- whether the offset_tax_rate_code is null in this case.

        validate_offset_tax (
          p_tax_regime_code        => l_tax_regime_code,
          p_tax                    => l_offset_tax,
          p_tax_determine_date     => l_tax_date,
          p_tax_status_code        => l_offset_status_code,
          p_tax_jurisdiction_code  => l_tax_jurisdiction_code, --? does offset tax rate has jurisdiction info
          p_tax_class              => l_tax_class,
          p_tax_rate_code          => l_offset_tax_rate_code,
          x_return_status          => p_return_status,
          x_error_buffer           => p_error_buffer
         );

Line: 1656

       update_tax_rate(-- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl,
                    i,
                    l_tax_rate_code,
                    l_tax_rate,
                    l_tax_rate_id,
                    l_Rate_Type_Code);

Line: 1802

PROCEDURE UPDATE_TAX_RATE(
--  ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl   in out nocopy   zx_api_pub.detail_tax_line_tbl_type,
  p_tax_line_index        in              number,
  p_tax_rate_code         in              zx_lines.tax_rate_code%TYPE,
  p_tax_rate              in              zx_lines.tax_rate%TYPE,
  p_tax_rate_id           in              number,
  p_Rate_Type_Code             in              zx_rates_b.Rate_Type_Code%TYPE) IS

begin

 g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line: 1816

                  'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',
                  'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');

Line: 1834

                  'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.END',
                  'ZX_TDS_RATE_DETM_PKG.update_tax_rate(-) ');

Line: 1843

                     'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate',
                     sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line: 1847

end  update_tax_rate;

Line: 1880

    SELECT tax_rate_id
      FROM ZX_SCO_RATES_B_V    -- Bug#5395227
      WHERE tax_rate_code   = c_tax_rate_code         AND
            tax             = c_tax                   AND
            tax_regime_code = c_tax_regime_code       AND
            tax_status_code = c_tax_status_code       AND
            active_flag     = 'Y'                     AND
            c_tax_determine_date >= effective_from    AND
            (c_tax_determine_date <= effective_to     OR
             effective_to IS NULL)
      ORDER BY subscription_level_code;             -- Bug#5395227