DBA Data[Home] [Help]

APPS.OKL_TTD_PVT SQL Statements

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

Line: 101

    SELECT
            ID,
            TXS_ID,
            TAX_DETERMINE_DATE,
            TAX_RATE_ID,
            TAX_RATE_CODE,
            TAXABLE_AMT,
            TAX_EXEMPTION_ID,
            TAX_RATE,
            TAX_AMT,
            BILLED_YN,
            TAX_CALL_TYPE_CODE,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER,
	    -- Modified by dcshanmu for eBTax - modification starts
	    TAX_DATE,
	    LINE_AMT,
	    INTERNAL_ORGANIZATION_ID,
	    APPLICATION_ID,
	    ENTITY_CODE,
	    EVENT_CLASS_CODE,
	    EVENT_TYPE_CODE,
	    TRX_ID,
	    TRX_LINE_ID,
	    TRX_LEVEL_TYPE,
	    TRX_LINE_NUMBER,
	    TAX_LINE_NUMBER,
	    TAX_REGIME_ID,
	    TAX_REGIME_CODE,
	    TAX_ID,
	    TAX,
	    TAX_STATUS_ID,
	    TAX_STATUS_CODE,
	    TAX_APPORTIONMENT_LINE_NUMBER,
	    LEGAL_ENTITY_ID,
	    TRX_NUMBER,
	    TRX_DATE,
	    TAX_JURISDICTION_ID,
	    TAX_JURISDICTION_CODE,
	    TAX_TYPE_CODE,
	    TAX_CURRENCY_CODE,
	    TAXABLE_AMT_TAX_CURR,
	    TRX_CURRENCY_CODE,
	    MINIMUM_ACCOUNTABLE_UNIT,
	    PRECISION,
	    CURRENCY_CONVERSION_TYPE,
	    CURRENCY_CONVERSION_RATE,
	    CURRENCY_CONVERSION_DATE
	    -- Modified by dcshanmu for eBTax - modification end
      FROM Okl_Tax_Trx_Details
     WHERE okl_tax_trx_details.id = p_id;
Line: 197

              l_ttdv_rec.program_update_date,
              l_ttdv_rec.attribute_category,
              l_ttdv_rec.attribute1,
              l_ttdv_rec.attribute2,
              l_ttdv_rec.attribute3,
              l_ttdv_rec.attribute4,
              l_ttdv_rec.attribute5,
              l_ttdv_rec.attribute6,
              l_ttdv_rec.attribute7,
              l_ttdv_rec.attribute8,
              l_ttdv_rec.attribute9,
              l_ttdv_rec.attribute10,
              l_ttdv_rec.attribute11,
              l_ttdv_rec.attribute12,
              l_ttdv_rec.attribute13,
              l_ttdv_rec.attribute14,
              l_ttdv_rec.attribute15,
              l_ttdv_rec.created_by,
              l_ttdv_rec.creation_date,
              l_ttdv_rec.last_updated_by,
              l_ttdv_rec.last_update_date,
              l_ttdv_rec.last_update_login,
              l_ttdv_rec.object_version_number,
	      -- Modified by dcshanmu for eBTax - modification starts
              l_ttdv_rec.tax_date,
              l_ttdv_rec.line_amt,
              l_ttdv_rec.internal_organization_id,
              l_ttdv_rec.application_id,
              l_ttdv_rec.entity_code,
              l_ttdv_rec.event_class_code,
              l_ttdv_rec.event_type_code,
              l_ttdv_rec.trx_id,
              l_ttdv_rec.trx_line_id,
              l_ttdv_rec.trx_level_type,
              l_ttdv_rec.trx_line_number,
              l_ttdv_rec.tax_line_number,
              l_ttdv_rec.tax_regime_id,
              l_ttdv_rec.tax_regime_code,
              l_ttdv_rec.tax_id,
              l_ttdv_rec.tax,
              l_ttdv_rec.tax_status_id,
              l_ttdv_rec.tax_status_code,
              l_ttdv_rec.tax_apportionment_line_number,
              l_ttdv_rec.legal_entity_id,
              l_ttdv_rec.trx_number,
              l_ttdv_rec.trx_date,
              l_ttdv_rec.tax_jurisdiction_id,
              l_ttdv_rec.tax_jurisdiction_code,
              l_ttdv_rec.tax_type_code,
              l_ttdv_rec.tax_currency_code,
              l_ttdv_rec.taxable_amt_tax_curr,
              l_ttdv_rec.trx_currency_code,
              l_ttdv_rec.minimum_accountable_unit,
              l_ttdv_rec.precision,
              l_ttdv_rec.currency_conversion_type,
              l_ttdv_rec.currency_conversion_rate,
              l_ttdv_rec.currency_conversion_date;
Line: 296

    SELECT
            ID,
            TXS_ID,
            TAX_DETERMINE_DATE,
            TAX_RATE_ID,
            TAX_RATE_CODE,
            TAXABLE_AMT,
            TAX_EXEMPTION_ID,
            TAX_RATE,
            TAX_AMT,
            BILLED_YN,
            TAX_CALL_TYPE_CODE,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            OBJECT_VERSION_NUMBER,
	    -- Modified by dcshanmu for eBTax - modification starts
	    TAX_DATE,
            LINE_AMT,
            INTERNAL_ORGANIZATION_ID,
            APPLICATION_ID,
            ENTITY_CODE,
            EVENT_CLASS_CODE,
            EVENT_TYPE_CODE,
            TRX_ID,
            TRX_LINE_ID,
            TRX_LEVEL_TYPE,
            TRX_LINE_NUMBER,
            TAX_LINE_NUMBER,
            TAX_REGIME_ID,
            TAX_REGIME_CODE,
            TAX_ID,
            TAX,
            TAX_STATUS_ID,
            TAX_STATUS_CODE,
            TAX_APPORTIONMENT_LINE_NUMBER,
            LEGAL_ENTITY_ID,
            TRX_NUMBER,
            TRX_DATE,
            TAX_JURISDICTION_ID,
            TAX_JURISDICTION_CODE,
            TAX_TYPE_CODE,
            TAX_CURRENCY_CODE,
            TAXABLE_AMT_TAX_CURR,
            TRX_CURRENCY_CODE,
            MINIMUM_ACCOUNTABLE_UNIT,
            PRECISION,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE
	    -- Modified by dcshanmu for eBTax - modification end

      FROM Okl_Tax_Trx_Details
     WHERE okl_tax_trx_details.id = p_id;
Line: 393

              l_ttd_rec.program_update_date,
              l_ttd_rec.attribute_category,
              l_ttd_rec.attribute1,
              l_ttd_rec.attribute2,
              l_ttd_rec.attribute3,
              l_ttd_rec.attribute4,
              l_ttd_rec.attribute5,
              l_ttd_rec.attribute6,
              l_ttd_rec.attribute7,
              l_ttd_rec.attribute8,
              l_ttd_rec.attribute9,
              l_ttd_rec.attribute10,
              l_ttd_rec.attribute11,
              l_ttd_rec.attribute12,
              l_ttd_rec.attribute13,
              l_ttd_rec.attribute14,
              l_ttd_rec.attribute15,
              l_ttd_rec.created_by,
              l_ttd_rec.creation_date,
              l_ttd_rec.last_updated_by,
              l_ttd_rec.last_update_date,
              l_ttd_rec.last_update_login,
              l_ttd_rec.object_version_number,
	      -- Modified by dcshanmu for eBTax - modification starts
              l_ttd_rec.tax_date,
              l_ttd_rec.line_amt,
              l_ttd_rec.internal_organization_id,
              l_ttd_rec.application_id,
              l_ttd_rec.entity_code,
              l_ttd_rec.event_class_code,
              l_ttd_rec.event_type_code,
              l_ttd_rec.trx_id,
              l_ttd_rec.trx_line_id,
              l_ttd_rec.trx_level_type,
              l_ttd_rec.trx_line_number,
              l_ttd_rec.tax_line_number,
              l_ttd_rec.tax_regime_id,
              l_ttd_rec.tax_regime_code,
              l_ttd_rec.tax_id,
              l_ttd_rec.tax,
              l_ttd_rec.tax_status_id,
              l_ttd_rec.tax_status_code,
              l_ttd_rec.tax_apportionment_line_number,
              l_ttd_rec.legal_entity_id,
              l_ttd_rec.trx_number,
              l_ttd_rec.trx_date,
              l_ttd_rec.tax_jurisdiction_id,
              l_ttd_rec.tax_jurisdiction_code,
              l_ttd_rec.tax_type_code,
              l_ttd_rec.tax_currency_code,
              l_ttd_rec.taxable_amt_tax_curr,
              l_ttd_rec.trx_currency_code,
              l_ttd_rec.minimum_accountable_unit,
              l_ttd_rec.precision,
              l_ttd_rec.currency_conversion_type,
              l_ttd_rec.currency_conversion_rate,
              l_ttd_rec.currency_conversion_date;
Line: 534

    IF (l_ttdv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
      l_ttdv_rec.program_update_date := NULL;
Line: 591

    IF (l_ttdv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_ttdv_rec.last_updated_by := NULL;
Line: 594

    IF (l_ttdv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_ttdv_rec.last_update_date := NULL;
Line: 597

    IF (l_ttdv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_ttdv_rec.last_update_login := NULL;
Line: 748

      SELECT 'x'
        FROM Okl_tax_sources
       WHERE id   = p_id;
Line: 798

      SELECT 'x'
      FROM Fnd_Lookup_Values
      WHERE fnd_lookup_values.lookup_code = p_lookup_code
      AND   fnd_lookup_values.lookup_type = p_lookup_type;
Line: 853

      SELECT 'x'
      FROM zx_rates_b
      WHERE zx_rates_b.tax_rate_id = p_id;
Line: 904

      SELECT 'x'
      FROM zx_rates_b
      WHERE zx_rates_b.tax_rate_code = p_code;
Line: 955

      SELECT 'x'
      FROM zx_exemptions
      WHERE zx_exemptions.tax_exemption_id = p_id;
Line: 1006

      SELECT 'x'
      FROM hr_all_organization_units
      WHERE hr_all_organization_units.organization_id = p_id;
Line: 1061

      SELECT 'x'
      FROM fnd_application
      WHERE fnd_application.application_id = p_id;
Line: 1298

      SELECT 'x'
      FROM zx_regimes_b
      WHERE zx_regimes_b.tax_regime_id = p_id;
Line: 1346

      SELECT 'x'
      FROM zx_regimes_b
      WHERE zx_regimes_b.tax_regime_code = p_code;
Line: 1394

      SELECT 'x'
      FROM zx_taxes_b
      WHERE zx_taxes_b.tax_id = p_id;
Line: 1442

      SELECT 'x'
      FROM zx_status_b
      WHERE zx_status_b.tax_status_id = p_id;
Line: 1490

      SELECT 'x'
      FROM zx_jurisdictions_b
      WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
Line: 1538

      SELECT 'x'
      FROM fnd_currencies
      WHERE fnd_currencies.currency_code = p_code;
Line: 1586

      SELECT 'x'
      FROM fnd_currencies
      WHERE fnd_currencies.currency_code = p_code;
Line: 1965

      SELECT 'x'
        FROM Fnd_Lookups
       WHERE fnd_lookups.lookup_code = p_lookup_code;
Line: 1971

      SELECT 'x'
        FROM Okl_Tax_Sources
       WHERE okl_tax_sources.id   = p_id;
Line: 1977

      SELECT 'x'
      FROM zx_rates_b
      WHERE zx_rates_b.tax_rate_id = p_id;
Line: 1983

      SELECT 'x'
      FROM zx_rates_b
      WHERE zx_rates_b.tax_rate_code = p_code;
Line: 1989

      SELECT 'x'
      FROM zx_exemptions
      WHERE zx_exemptions.tax_exemption_id = p_id;
Line: 1995

      SELECT 'x'
      FROM hr_all_organization_units
      WHERE hr_all_organization_units.organization_id = p_id;
Line: 2001

      SELECT 'x'
      FROM fnd_application
      WHERE fnd_application.application_id = p_id;
Line: 2007

      SELECT 'x'
      FROM zx_regimes_b
      WHERE zx_regimes_b.tax_regime_id = p_id;
Line: 2013

      SELECT 'x'
      FROM zx_regimes_b
      WHERE zx_regimes_b.tax_regime_code = p_code;
Line: 2019

      SELECT 'x'
      FROM zx_taxes_b
      WHERE zx_taxes_b.tax_id = p_id;
Line: 2025

      SELECT 'x'
      FROM zx_status_b
      WHERE zx_status_b.tax_status_id = p_id;
Line: 2031

      SELECT 'x'
      FROM zx_jurisdictions_b
      WHERE zx_jurisdictions_b.tax_jurisdiction_id = p_id;
Line: 2037

      SELECT 'x'
      FROM fnd_currencies
      WHERE fnd_currencies.currency_code = p_code;
Line: 2043

      SELECT 'x'
      FROM fnd_currencies
      WHERE fnd_currencies.currency_code = p_code;
Line: 2292

    p_to.program_update_date := p_from.program_update_date;
Line: 2311

    p_to.last_updated_by := p_from.last_updated_by;
Line: 2312

    p_to.last_update_date := p_from.last_update_date;
Line: 2313

    p_to.last_update_login := p_from.last_update_login;
Line: 2371

    p_to.program_update_date := p_from.program_update_date;
Line: 2390

    p_to.last_updated_by := p_from.last_updated_by;
Line: 2391

    p_to.last_update_date := p_from.last_update_date;
Line: 2392

    p_to.last_update_login := p_from.last_update_login;
Line: 2678

  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttd_rec                      IN ttd_rec_type,
    x_ttd_rec                      OUT NOCOPY ttd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2687

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 2723

    INSERT INTO OKL_TAX_TRX_DETAILS(
      id,
      txs_id,
      tax_determine_date,
      tax_rate_id,
      tax_rate_code,
      taxable_amt,
      tax_exemption_id,
      tax_rate,
      tax_amt,
      billed_yn,
      tax_call_type_code,
      program_id,
      request_id,
      program_application_id,
      program_update_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      object_version_number,
      -- Modified by dcshanmu for eBTax - modification starts
      tax_date,
      line_amt,
      internal_organization_id,
      application_id,
      entity_code,
      event_class_code,
      event_type_code,
      trx_id,
      trx_line_id,
      trx_level_type,
      trx_line_number,
      tax_line_number,
      tax_regime_id,
      tax_regime_code,
      tax_id,
      tax,
      tax_status_id,
      tax_status_code,
      tax_apportionment_line_number,
      legal_entity_id,
      trx_number,
      trx_date,
      tax_jurisdiction_id,
      tax_jurisdiction_code,
      tax_type_code,
      tax_currency_code,
      taxable_amt_tax_curr,
      trx_currency_code,
      minimum_accountable_unit,
      precision,
      currency_conversion_type,
      currency_conversion_rate,
      currency_conversion_date)
      -- Modified by dcshanmu for eBTax - modification end
    VALUES (
      l_ttd_rec.id,
      l_ttd_rec.txs_id,
      l_ttd_rec.tax_determine_date,
      l_ttd_rec.tax_rate_id,
      l_ttd_rec.tax_rate_code,
      l_ttd_rec.taxable_amt,
      l_ttd_rec.tax_exemption_id,
      l_ttd_rec.tax_rate,
      l_ttd_rec.tax_amt,
      l_ttd_rec.billed_yn,
      l_ttd_rec.tax_call_type_code,
      l_ttd_rec.program_id,
      l_ttd_rec.request_id,
      l_ttd_rec.program_application_id,
      l_ttd_rec.program_update_date,
      l_ttd_rec.attribute_category,
      l_ttd_rec.attribute1,
      l_ttd_rec.attribute2,
      l_ttd_rec.attribute3,
      l_ttd_rec.attribute4,
      l_ttd_rec.attribute5,
      l_ttd_rec.attribute6,
      l_ttd_rec.attribute7,
      l_ttd_rec.attribute8,
      l_ttd_rec.attribute9,
      l_ttd_rec.attribute10,
      l_ttd_rec.attribute11,
      l_ttd_rec.attribute12,
      l_ttd_rec.attribute13,
      l_ttd_rec.attribute14,
      l_ttd_rec.attribute15,
      l_ttd_rec.created_by,
      l_ttd_rec.creation_date,
      l_ttd_rec.last_updated_by,
      l_ttd_rec.last_update_date,
      l_ttd_rec.last_update_login,
      l_ttd_rec.object_version_number,
      -- Modified by dcshanmu for eBTax - modification starts
      l_ttd_rec.tax_date,
      l_ttd_rec.line_amt,
      l_ttd_rec.internal_organization_id,
      l_ttd_rec.application_id,
      l_ttd_rec.entity_code,
      l_ttd_rec.event_class_code,
      l_ttd_rec.event_type_code,
      l_ttd_rec.trx_id,
      l_ttd_rec.trx_line_id,
      l_ttd_rec.trx_level_type,
      l_ttd_rec.trx_line_number,
      l_ttd_rec.tax_line_number,
      l_ttd_rec.tax_regime_id,
      l_ttd_rec.tax_regime_code,
      l_ttd_rec.tax_id,
      l_ttd_rec.tax,
      l_ttd_rec.tax_status_id,
      l_ttd_rec.tax_status_code,
      l_ttd_rec.tax_apportionment_line_number,
      l_ttd_rec.legal_entity_id,
      l_ttd_rec.trx_number,
      l_ttd_rec.trx_date,
      l_ttd_rec.tax_jurisdiction_id,
      l_ttd_rec.tax_jurisdiction_code,
      l_ttd_rec.tax_type_code,
      l_ttd_rec.tax_currency_code,
      l_ttd_rec.taxable_amt_tax_curr,
      l_ttd_rec.trx_currency_code,
      l_ttd_rec.minimum_accountable_unit,
      l_ttd_rec.precision,
      l_ttd_rec.currency_conversion_type,
      l_ttd_rec.currency_conversion_rate,
      l_ttd_rec.currency_conversion_date);
Line: 2904

  END insert_row;
Line: 2908

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_rec    				   IN ttdv_rec_type,
    x_ttdv_rec    				   OUT NOCOPY ttdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2918

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 2934

      l_ttdv_rec.LAST_UPDATE_DATE := l_ttdv_rec.CREATION_DATE;
Line: 2935

      l_ttdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2936

      l_ttdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3002

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ttd_rec,
      lx_ttd_rec
    );
Line: 3051

  END insert_row;
Line: 3055

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    				   IN ttdv_tbl_type,
    x_ttdv_tbl                     OUT NOCOPY ttdv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3066

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 3080

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ttdv_rec    => p_ttdv_tbl(i),
            x_ttdv_rec    => x_ttdv_tbl(i));
Line: 3148

  END insert_row;
Line: 3155

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    IN ttdv_tbl_type,
    x_ttdv_tbl    OUT NOCOPY ttdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3165

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 3172

      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_ttdv_tbl    => p_ttdv_tbl,
        x_ttdv_tbl    => x_ttdv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3214

  END insert_row;
Line: 3232

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TAX_TRX_DETAILS
     WHERE ID = p_ttd_rec.id
       AND OBJECT_VERSION_NUMBER = p_ttd_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 3239

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TAX_TRX_DETAILS
     WHERE ID = p_ttd_rec.id;
Line: 3280

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 3289

      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 3569

  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttd_rec                      IN ttd_rec_type,
    x_ttd_rec                      OUT NOCOPY ttd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3578

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 3654

        IF (x_ttd_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ttd_rec.program_update_date := l_ttd_rec.program_update_date;
Line: 3730

        IF (x_ttd_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_ttd_rec.last_updated_by := l_ttd_rec.last_updated_by;
Line: 3734

        IF (x_ttd_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ttd_rec.last_update_date := l_ttd_rec.last_update_date;
Line: 3738

        IF (x_ttd_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_ttd_rec.last_update_login := l_ttd_rec.last_update_login;
Line: 3926

    UPDATE OKL_TAX_TRX_DETAILS
    SET TXS_ID = l_def_ttd_rec.txs_id,
        TAX_DETERMINE_DATE = l_def_ttd_rec.tax_determine_date,
        TAX_RATE_ID = l_def_ttd_rec.tax_rate_id,
        TAX_RATE_CODE = l_def_ttd_rec.tax_rate_code,
        TAXABLE_AMT = l_def_ttd_rec.taxable_amt,
        TAX_EXEMPTION_ID = l_def_ttd_rec.tax_exemption_id,
        TAX_RATE = l_def_ttd_rec.tax_rate,
        TAX_AMT = l_def_ttd_rec.tax_amt,
        BILLED_YN = l_def_ttd_rec.billed_yn,
        TAX_CALL_TYPE_CODE = l_def_ttd_rec.tax_call_type_code,
        PROGRAM_ID = l_def_ttd_rec.program_id,
        REQUEST_ID = l_def_ttd_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_ttd_rec.program_application_id,
        PROGRAM_UPDATE_DATE = l_def_ttd_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_ttd_rec.attribute_category,
        ATTRIBUTE1 = l_def_ttd_rec.attribute1,
        ATTRIBUTE2 = l_def_ttd_rec.attribute2,
        ATTRIBUTE3 = l_def_ttd_rec.attribute3,
        ATTRIBUTE4 = l_def_ttd_rec.attribute4,
        ATTRIBUTE5 = l_def_ttd_rec.attribute5,
        ATTRIBUTE6 = l_def_ttd_rec.attribute6,
        ATTRIBUTE7 = l_def_ttd_rec.attribute7,
        ATTRIBUTE8 = l_def_ttd_rec.attribute8,
        ATTRIBUTE9 = l_def_ttd_rec.attribute9,
        ATTRIBUTE10 = l_def_ttd_rec.attribute10,
        ATTRIBUTE11 = l_def_ttd_rec.attribute11,
        ATTRIBUTE12 = l_def_ttd_rec.attribute12,
        ATTRIBUTE13 = l_def_ttd_rec.attribute13,
        ATTRIBUTE14 = l_def_ttd_rec.attribute14,
        ATTRIBUTE15 = l_def_ttd_rec.attribute15,
        CREATED_BY = l_def_ttd_rec.created_by,
        CREATION_DATE = l_def_ttd_rec.creation_date,
        LAST_UPDATED_BY = l_def_ttd_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ttd_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ttd_rec.last_update_login,
        OBJECT_VERSION_NUMBER = l_def_ttd_rec.object_version_number,
	-- Modified by dcshanmu for eBTax - modification starts
        TAX_DATE = l_def_ttd_rec.tax_date,
        LINE_AMT = l_def_ttd_rec.line_amt,
        INTERNAL_ORGANIZATION_ID = l_def_ttd_rec.internal_organization_id,
        APPLICATION_ID = l_def_ttd_rec.application_id,
        ENTITY_CODE = l_def_ttd_rec.entity_code,
        EVENT_CLASS_CODE = l_def_ttd_rec.event_class_code,
        EVENT_TYPE_CODE = l_def_ttd_rec.event_type_code,
        TRX_ID = l_def_ttd_rec.trx_id,
        TRX_LINE_ID = l_def_ttd_rec.trx_line_id,
        TRX_LEVEL_TYPE = l_def_ttd_rec.trx_level_type,
        TRX_LINE_NUMBER = l_def_ttd_rec.trx_line_number,
        TAX_LINE_NUMBER = l_def_ttd_rec.tax_line_number,
        TAX_REGIME_ID = l_def_ttd_rec.tax_regime_id,
        TAX_REGIME_CODE = l_def_ttd_rec.tax_regime_code,
        TAX_ID = l_def_ttd_rec.tax_id,
        TAX = l_def_ttd_rec.tax,
        TAX_STATUS_ID = l_def_ttd_rec.tax_status_id,
        TAX_STATUS_CODE = l_def_ttd_rec.tax_status_code,
        TAX_APPORTIONMENT_LINE_NUMBER = l_def_ttd_rec.tax_apportionment_line_number,
        LEGAL_ENTITY_ID = l_def_ttd_rec.legal_entity_id,
        TRX_NUMBER = l_def_ttd_rec.trx_number,
        TRX_DATE = l_def_ttd_rec.trx_date,
        TAX_JURISDICTION_ID = l_def_ttd_rec.tax_jurisdiction_id,
        TAX_JURISDICTION_CODE = l_def_ttd_rec.tax_jurisdiction_code,
        TAX_TYPE_CODE = l_def_ttd_rec.tax_type_code,
        TAX_CURRENCY_CODE = l_def_ttd_rec.tax_currency_code,
        TAXABLE_AMT_TAX_CURR = l_def_ttd_rec.taxable_amt_tax_curr,
        TRX_CURRENCY_CODE = l_def_ttd_rec.trx_currency_code,
        MINIMUM_ACCOUNTABLE_UNIT = l_def_ttd_rec.minimum_accountable_unit,
        PRECISION = l_def_ttd_rec.precision,
        CURRENCY_CONVERSION_TYPE = l_def_ttd_rec.currency_conversion_type,
        CURRENCY_CONVERSION_RATE = l_def_ttd_rec.currency_conversion_rate,
        CURRENCY_CONVERSION_DATE = l_def_ttd_rec.currency_conversion_date
	-- Modified by dcshanmu for eBTax - modification end

    WHERE ID = l_def_ttd_rec.id;
Line: 4035

  END update_row;
Line: 4039

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_rec    				   IN ttdv_rec_type,
    x_ttdv_rec    					OUT NOCOPY ttdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4049

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 4064

      l_ttdv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 4065

      l_ttdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 4066

      l_ttdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 4149

        IF (x_ttdv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ttdv_rec.program_update_date := l_db_ttdv_rec.program_update_date;
Line: 4225

        IF (x_ttdv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_ttdv_rec.last_updated_by := l_db_ttdv_rec.last_updated_by;
Line: 4229

        IF (x_ttdv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_ttdv_rec.last_update_date := l_db_ttdv_rec.last_update_date;
Line: 4233

        IF (x_ttdv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_ttdv_rec.last_update_login := l_db_ttdv_rec.last_update_login;
Line: 4456

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ttd_rec,
      lx_ttd_rec
    );
Line: 4504

  END update_row;
Line: 4508

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    				   IN ttdv_tbl_type,
    x_ttdv_tbl    				   OUT NOCOPY ttdv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4519

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 4533

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ttdv_rec    => p_ttdv_tbl(i),
            x_ttdv_rec    => x_ttdv_tbl(i));
Line: 4601

  END update_row;
Line: 4608

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    				   IN ttdv_tbl_type,
    x_ttdv_tbl    				   OUT NOCOPY ttdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4618

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 4625

      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_ttdv_tbl    => p_ttdv_tbl,
        x_ttdv_tbl    => x_ttdv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 4667

  END update_row;
Line: 4675

  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttd_rec                      IN ttd_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4683

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 4698

    DELETE FROM OKL_TAX_TRX_DETAILS
     WHERE ID = p_ttd_rec.id;
Line: 4734

  END delete_row;
Line: 4738

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_rec    IN ttdv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4747

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 4771

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ttd_rec
    );
Line: 4816

  END delete_row;
Line: 4820

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    IN ttdv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4830

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 4844

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_ttdv_rec    => p_ttdv_tbl(i));
Line: 4911

  END delete_row;
Line: 4916

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ttdv_tbl    				   IN ttdv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 4925

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 4932

      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_ttdv_tbl    => p_ttdv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 4973

  END delete_row;