APPS.ZX_RATES_PKG SQL Statements

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

Line: 19

PROCEDURE UPDATE_LOOKUP_VALUES_PVT (
  p_lookup_type     IN VARCHAR2,
  p_tax_rate_code   IN VARCHAR2,
  p_description     IN VARCHAR2,
  p_meaning         IN VARCHAR2,
  p_effective_from  IN DATE,
  p_effective_to    IN DATE,
  x_return_status   OUT NOCOPY VARCHAR2
) IS

BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 33

  UPDATE fnd_lookup_values
  SET description  = P_TAX_RATE_CODE,
      meaning      = P_TAX_RATE_CODE,
      -- end_date_active   = P_EFFECTIVE_TO,   -- commenting for bug 9705409
      last_update_date  = SYSDATE,
      last_updated_by   = FND_GLOBAL.user_id,
      last_update_login = FND_GLOBAL.login_id
  WHERE lookup_type = P_LOOKUP_TYPE
    AND lookup_code = NVL(TAG,P_TAX_RATE_CODE)
    AND (source_lang = USERENV('LANG') OR language = USERENV('LANG'));

Line: 45

    INSERT_LOOKUP_VALUES(
      P_LOOKUP_TYPE,
      P_TAX_RATE_CODE,
      P_EFFECTIVE_FROM,
      P_EFFECTIVE_TO,
      P_TAX_RATE_CODE,
      P_TAX_RATE_CODE);

Line: 58

END UPDATE_LOOKUP_VALUES_PVT;

Line: 99

    SELECT MAX(start_date_active)
    INTO l_effective_from
    FROM fnd_lookups
    WHERE lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS', 'ZX_OUTPUT_CLASSIFICATIONS')
      AND enabled_flag = 'Y'
      AND SYSDATE BETWEEN start_date_active AND  NVL(end_date_active,SYSDATE)
      AND lookup_code = p_tax_rate_code;

Line: 108

      SELECT end_date_active
      INTO l_effective_to
      FROM fnd_lookups
      WHERE lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
        AND enabled_flag = 'Y'
        AND SYSDATE BETWEEN start_date_active AND  NVL(end_date_active,SYSDATE)
        AND lookup_code = p_TAX_RATE_CODE
        AND end_date_active IS NULL
        AND ROWNUM = 1;

Line: 119

        SELECT MAX(end_date_active)
        INTO l_effective_to
        FROM   fnd_lookups
        WHERE  lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
          AND  enabled_flag = 'Y'
          AND  SYSDATE BETWEEN start_date_active AND  NVL(end_date_active,SYSDATE)
          AND  lookup_code = p_tax_rate_code;

Line: 131

  UPDATE ZX_ID_TCC_MAPPING_ALL
  SET effective_to      = l_effective_to,
      active_flag       = p_active_flag,
      last_updated_by   = fnd_global.user_id,
      last_update_date  = SYSDATE,
      last_update_login = fnd_global.user_id
  WHERE tax_classification_code = p_tax_rate_code
    AND org_id                  = p_org_id
    AND ( tax_rate_code_id =  NVL(p_source_id,p_tax_rate_id)
          OR
          p_tax_rate_id < 0
        );

Line: 145

    INSERT INTO ZX_ID_TCC_MAPPING_ALL
    (
      tcc_mapping_id         ,
      org_id                 ,
      tax_class              ,
      tax_rate_code_id       ,
      tax_classification_code,
      tax_type               ,
      effective_from         ,
      effective_to           ,
      source                 ,
      created_by             ,
      creation_date          ,
      last_updated_by        ,
      last_update_date       ,
      last_update_login      ,
      request_id             ,
      program_application_id ,
      program_id             ,
      program_login_id       ,
      ledger_id              ,
      active_flag
    )
    SELECT
      zx_id_tcc_mapping_all_s.NEXTVAL , --tcc_mapping_id
      p_org_id                        , --org_id
      p_tax_class                     , --tax_class
      p_tax_rate_id                   , --tax_rate_code_id
      p_tax_rate_code                 , --tax_classification_code
      p_tax_type                      , --tax_type
      l_effective_from                , --effective_from
      l_effective_to                  , --effective_to
      p_source                        , --source
      fnd_global.user_id              , --created_by
      SYSDATE                         , --creation_date
      fnd_global.user_id              , --last_updated_by
      SYSDATE                         , --last_update_date
      fnd_global.user_id              , --last_update_login
      fnd_global.conc_request_id      , --request_id
      fnd_global.prog_appl_id         , --program_application_id
      fnd_global.conc_program_id      , --program_id
      fnd_global.conc_login_id        , --program_login_id
      p_ledger_id                     , --ledger_id
      p_active_flag                     --active_flag
    FROM DUAL
    WHERE NOT EXISTS (SELECT 1
                        FROM zx_id_tcc_mapping_all
                       WHERE tax_classification_code = p_tax_rate_code
                         AND org_id                  = p_org_id
                         AND tax_rate_code_id        = p_tax_rate_id
                     );

Line: 204

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_TAX_RATE_ID in NUMBER,
  X_TAX_RATE_CODE in VARCHAR2,
  X_CONTENT_OWNER_ID in NUMBER,
  X_EFFECTIVE_FROM in DATE,
  X_EFFECTIVE_TO in DATE,
  X_TAX_REGIME_CODE in VARCHAR2,
  X_TAX in VARCHAR2,
  X_TAX_STATUS_CODE in VARCHAR2,
  X_Schedule_Based_Rate_Flag in VARCHAR2,
  X_Rate_Type_Code in VARCHAR2,
  X_PERCENTAGE_RATE in NUMBER,
  X_QUANTITY_RATE in NUMBER,
  X_UOM_CODE in VARCHAR2,
  X_TAX_JURISDICTION_CODE in VARCHAR2,
  X_RECOVERY_TYPE_CODE in VARCHAR2,
  X_Active_Flag in VARCHAR2,
  X_Default_Rate_Flag in VARCHAR2,
  X_DEFAULT_FLG_EFFECTIVE_FROM in DATE,
  X_DEFAULT_FLG_EFFECTIVE_TO in DATE,
  X_DEFAULT_REC_TYPE_CODE in VARCHAR2,
  X_DEFAULT_REC_RATE_CODE in VARCHAR2,
  X_OFFSET_TAX in VARCHAR2,
  X_OFFSET_STATUS_CODE in VARCHAR2,
  X_OFFSET_TAX_RATE_CODE in VARCHAR2,
  X_RECOVERY_RULE_CODE in VARCHAR2,
  X_Def_Rec_Settlement_Option_Co in VARCHAR2,
  X_Vat_Transaction_Type_Code in VARCHAR2,
  X_Record_Type_Code in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_TAX_RATE_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_Program_Login_Id in  NUMBER,
  X_ALLOW_ADHOC_TAX_RATE_FLAG in VARCHAR2,
  X_ADJ_FOR_ADHOC_AMT_CODE in VARCHAR2,
  X_INCLUSIVE_TAX_FLAG in VARCHAR2,
  X_TAX_INCLUSIVE_OVERRIDE_FLAG VARCHAR2,
  X_TAX_CLASS VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ALLOW_EXEMPTIONS_FLAG in VARCHAR2,
  X_ALLOW_EXCEPTIONS_FLAG in VARCHAR2,
  X_SOURCE_ID in NUMBER,
  X_DESCRIPTION IN VARCHAR2,
  X_TAXABLE_BASIS_FORMULA_CODE in VARCHAR2

) is
  X_ORG_ID NUMBER;

Line: 275

  cursor C is select ROWID from ZX_RATES_B
    where TAX_RATE_ID = X_TAX_RATE_ID    ;

Line: 278

  insert into ZX_RATES_B (
    TAX_RATE_ID,
    TAX_RATE_CODE,
    CONTENT_OWNER_ID,
    EFFECTIVE_FROM,
    EFFECTIVE_TO,
    TAX_REGIME_CODE,
    TAX,
    TAX_STATUS_CODE,
    Schedule_Based_Rate_Flag,
    Rate_Type_Code,
    PERCENTAGE_RATE,
    QUANTITY_RATE,
    UOM_CODE,
    TAX_JURISDICTION_CODE,
    RECOVERY_TYPE_CODE,
    Active_Flag,
    Default_Rate_Flag,
    DEFAULT_FLG_EFFECTIVE_FROM,
    DEFAULT_FLG_EFFECTIVE_TO,
    DEFAULT_REC_TYPE_CODE,
    DEFAULT_REC_RATE_CODE,
    OFFSET_TAX,
    OFFSET_STATUS_CODE,
    OFFSET_TAX_RATE_CODE,
    RECOVERY_RULE_CODE,
    Def_Rec_Settlement_Option_Code,
    Vat_Transaction_Type_Code,
    Record_Type_Code,
    REQUEST_ID,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE_CATEGORY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID,
    PROGRAM_ID,
    Program_Login_Id,
    ALLOW_ADHOC_TAX_RATE_FLAG,
    ADJ_FOR_ADHOC_AMT_CODE,
    INCLUSIVE_TAX_FLAG,
    TAX_INCLUSIVE_OVERRIDE_FLAG,
    TAX_CLASS,
    OBJECT_VERSION_NUMBER,
    ALLOW_EXEMPTIONS_FLAG,
    ALLOW_EXCEPTIONS_FLAG,
    SOURCE_ID,
    -- DESCRIPTION, -- commented as part of fix for bug#  6820043
    TAXABLE_BASIS_FORMULA_CODE
  ) values (
    X_TAX_RATE_ID,
    X_TAX_RATE_CODE,
    X_CONTENT_OWNER_ID,
    X_EFFECTIVE_FROM,
    X_EFFECTIVE_TO,
    X_TAX_REGIME_CODE,
    X_TAX,
    X_TAX_STATUS_CODE,
    X_Schedule_Based_Rate_Flag,
    X_Rate_Type_Code,
    X_PERCENTAGE_RATE,
    X_QUANTITY_RATE,
    X_UOM_CODE,
    X_TAX_JURISDICTION_CODE,
    X_RECOVERY_TYPE_CODE,
    X_Active_Flag,
    X_Default_Rate_Flag,
    X_DEFAULT_FLG_EFFECTIVE_FROM,
    X_DEFAULT_FLG_EFFECTIVE_TO,
    X_DEFAULT_REC_TYPE_CODE,
    X_DEFAULT_REC_RATE_CODE,
    X_OFFSET_TAX,
    X_OFFSET_STATUS_CODE,
    X_OFFSET_TAX_RATE_CODE,
    X_RECOVERY_RULE_CODE,
    X_Def_Rec_Settlement_Option_Co,
    X_Vat_Transaction_Type_Code,
    X_Record_Type_Code,
    X_REQUEST_ID,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ATTRIBUTE_CATEGORY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_ID,
    X_Program_Login_Id,
    X_ALLOW_ADHOC_TAX_RATE_FLAG,
    X_ADJ_FOR_ADHOC_AMT_CODE,
    X_INCLUSIVE_TAX_FLAG,
    X_TAX_INCLUSIVE_OVERRIDE_FLAG,
    X_TAX_CLASS,
    X_OBJECT_VERSION_NUMBER,
    X_ALLOW_EXEMPTIONS_FLAG,
    X_ALLOW_EXCEPTIONS_FLAG,
    X_SOURCE_ID,
    -- X_DESCRIPTION, -- commented as part of fix for bug#  6820043
    X_TAXABLE_BASIS_FORMULA_CODE
  );

Line: 410

  insert into ZX_RATES_TL (
    TAX_RATE_ID,
    TAX_RATE_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG,
    description -- added as part of fix for bug#  6820043
  ) select
    X_TAX_RATE_ID,
    X_TAX_RATE_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG'),
    x_description -- added as part of fix for bug#  6820043
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from ZX_RATES_TL T
    where T.TAX_RATE_ID = X_TAX_RATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 454

    INSERT_LOOKUP_VALUES(
      'ZX_INPUT_CLASSIFICATIONS' ,
      X_TAX_RATE_CODE ,
      X_EFFECTIVE_FROM,
      X_EFFECTIVE_TO,
     -- start  bug#6992215
      X_TAX_RATE_CODE,
      X_TAX_RATE_CODE
     --end bug#6992215
    );

Line: 465

    INSERT_LOOKUP_VALUES(
      'ZX_OUTPUT_CLASSIFICATIONS' ,
      X_TAX_RATE_CODE ,
      X_EFFECTIVE_FROM,
      X_EFFECTIVE_TO,
      -- start  bug#6992215
      X_TAX_RATE_CODE,
      X_TAX_RATE_CODE
      -- end  bug#6992215
    );

Line: 479

    SELECT DECODE(c.party_type_code,'OU',c.party_id,-99) INTO X_ORG_ID
      FROM zx_party_tax_profile c
     WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;

Line: 484

      SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
        FROM ZX_TAXES_B A
       WHERE A.TAX = X_TAX
         AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
         AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;

Line: 492

        SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
          FROM ZX_TAXES_B A
         WHERE A.TAX = X_TAX
           AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
           AND A.CONTENT_OWNER_ID = -99;

Line: 517

end INSERT_ROW;

Line: 585

  cursor c is select
      TAX_RATE_CODE,
      CONTENT_OWNER_ID,
      EFFECTIVE_FROM,
      EFFECTIVE_TO,
      TAX_REGIME_CODE,
      TAX,
      TAX_STATUS_CODE,
      Schedule_Based_Rate_Flag,
      Rate_Type_Code,
      PERCENTAGE_RATE,
      QUANTITY_RATE,
      UOM_CODE,
      TAX_JURISDICTION_CODE,
      RECOVERY_TYPE_CODE,
      Active_Flag,
      Default_Rate_Flag,
      DEFAULT_FLG_EFFECTIVE_FROM,
      DEFAULT_FLG_EFFECTIVE_TO,
      DEFAULT_REC_TYPE_CODE,
      DEFAULT_REC_RATE_CODE,
      OFFSET_TAX,
      OFFSET_STATUS_CODE,
      OFFSET_TAX_RATE_CODE,
      RECOVERY_RULE_CODE,
      Def_Rec_Settlement_Option_Code,
      Vat_Transaction_Type_Code,
      Record_Type_Code,
      REQUEST_ID,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      ALLOW_ADHOC_TAX_RATE_FLAG,
      ADJ_FOR_ADHOC_AMT_CODE,
      INCLUSIVE_TAX_FLAG,
      TAX_INCLUSIVE_OVERRIDE_FLAG,
      TAX_CLASS,
      OBJECT_VERSION_NUMBER,
      ALLOW_EXEMPTIONS_FLAG,
      ALLOW_EXCEPTIONS_FLAG,
      SOURCE_ID,
      -- DESCRIPTION, -- commented as part of fix for bug# 6820043
      TAXABLE_BASIS_FORMULA_CODE
    from ZX_RATES_B
    where TAX_RATE_ID = X_TAX_RATE_ID
    for update of TAX_RATE_ID nowait;

Line: 645

  cursor c1 is select
      TAX_RATE_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from ZX_RATES_TL
    where TAX_RATE_ID = X_TAX_RATE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TAX_RATE_ID nowait;

Line: 657

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 792

procedure UPDATE_ROW (
  X_TAX_RATE_ID in NUMBER,
  X_TAX_RATE_CODE in VARCHAR2,
  X_CONTENT_OWNER_ID in NUMBER,
  X_EFFECTIVE_FROM in DATE,
  X_EFFECTIVE_TO in DATE,
  X_TAX_REGIME_CODE in VARCHAR2,
  X_TAX in VARCHAR2,
  X_TAX_STATUS_CODE in VARCHAR2,
  X_Schedule_Based_Rate_Flag in VARCHAR2,
  X_Rate_Type_Code in VARCHAR2,
  X_PERCENTAGE_RATE in NUMBER,
  X_QUANTITY_RATE in NUMBER,
  X_UOM_CODE in VARCHAR2,
  X_TAX_JURISDICTION_CODE in VARCHAR2,
  X_RECOVERY_TYPE_CODE in VARCHAR2,
  X_Active_Flag in VARCHAR2,
  X_Default_Rate_Flag in VARCHAR2,
  X_DEFAULT_FLG_EFFECTIVE_FROM in DATE,
  X_DEFAULT_FLG_EFFECTIVE_TO in DATE,
  X_DEFAULT_REC_TYPE_CODE in VARCHAR2,
  X_DEFAULT_REC_RATE_CODE in VARCHAR2,
  X_OFFSET_TAX in VARCHAR2,
  X_OFFSET_STATUS_CODE in VARCHAR2,
  X_OFFSET_TAX_RATE_CODE in VARCHAR2,
  X_RECOVERY_RULE_CODE in VARCHAR2,
  X_Def_Rec_Settlement_Option_Co in VARCHAR2,
  X_Vat_Transaction_Type_Code in VARCHAR2,
  X_Record_Type_Code in VARCHAR2,
  X_REQUEST_ID in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_TAX_RATE_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_PROGRAM_APPLICATION_ID in NUMBER,
  X_PROGRAM_ID in NUMBER,
  X_Program_Login_Id in NUMBER,
  X_ALLOW_ADHOC_TAX_RATE_FLAG in VARCHAR2,
  X_ADJ_FOR_ADHOC_AMT_CODE in VARCHAR2,
  X_INCLUSIVE_TAX_FLAG in VARCHAR2,
  X_TAX_INCLUSIVE_OVERRIDE_FLAG VARCHAR2,
  X_TAX_CLASS VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_ALLOW_EXEMPTIONS_FLAG in VARCHAR2,
  X_ALLOW_EXCEPTIONS_FLAG in VARCHAR2,
  X_SOURCE_ID in NUMBER,
  X_DESCRIPTION IN VARCHAR2,
  X_TAXABLE_BASIS_FORMULA_CODE in VARCHAR2
) is
  X_ORG_ID NUMBER;

Line: 862

  update ZX_RATES_B set
    TAX_RATE_CODE = X_TAX_RATE_CODE,
    CONTENT_OWNER_ID = X_CONTENT_OWNER_ID,
    EFFECTIVE_FROM = X_EFFECTIVE_FROM,
    EFFECTIVE_TO = X_EFFECTIVE_TO,
    TAX_REGIME_CODE = X_TAX_REGIME_CODE,
    TAX = X_TAX,
    TAX_STATUS_CODE = X_TAX_STATUS_CODE,
    Schedule_Based_Rate_Flag = X_Schedule_Based_Rate_Flag,
    Rate_Type_Code = X_Rate_Type_Code,
    PERCENTAGE_RATE = X_PERCENTAGE_RATE,
    QUANTITY_RATE = X_QUANTITY_RATE,
    UOM_CODE = X_UOM_CODE,
    TAX_JURISDICTION_CODE = X_TAX_JURISDICTION_CODE,
    RECOVERY_TYPE_CODE = X_RECOVERY_TYPE_CODE,
    Active_Flag = X_Active_Flag,
    Default_Rate_Flag = X_Default_Rate_Flag,
    DEFAULT_FLG_EFFECTIVE_FROM = X_DEFAULT_FLG_EFFECTIVE_FROM,
    DEFAULT_FLG_EFFECTIVE_TO = X_DEFAULT_FLG_EFFECTIVE_TO,
    DEFAULT_REC_TYPE_CODE = X_DEFAULT_REC_TYPE_CODE,
    DEFAULT_REC_RATE_CODE = X_DEFAULT_REC_RATE_CODE,
    OFFSET_TAX = X_OFFSET_TAX,
    OFFSET_STATUS_CODE = X_OFFSET_STATUS_CODE,
    OFFSET_TAX_RATE_CODE = X_OFFSET_TAX_RATE_CODE,
    RECOVERY_RULE_CODE = X_RECOVERY_RULE_CODE,
    Def_Rec_Settlement_Option_Code = X_Def_Rec_Settlement_Option_Co,
    Vat_Transaction_Type_Code = X_Vat_Transaction_Type_Code,
    Record_Type_Code = X_Record_Type_Code,
    REQUEST_ID = X_REQUEST_ID,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    PROGRAM_APPLICATION_ID  =  X_PROGRAM_APPLICATION_ID,
    PROGRAM_ID  = X_PROGRAM_ID,
    Program_Login_Id = X_Program_Login_Id,
    ALLOW_ADHOC_TAX_RATE_FLAG = X_ALLOW_ADHOC_TAX_RATE_FLAG,
    ADJ_FOR_ADHOC_AMT_CODE = X_ADJ_FOR_ADHOC_AMT_CODE,
    INCLUSIVE_TAX_FLAG = X_INCLUSIVE_TAX_FLAG,
    TAX_INCLUSIVE_OVERRIDE_FLAG = X_TAX_INCLUSIVE_OVERRIDE_FLAG,
    TAX_CLASS = X_TAX_CLASS,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    ALLOW_EXEMPTIONS_FLAG = X_ALLOW_EXEMPTIONS_FLAG,
    ALLOW_EXCEPTIONS_FLAG = X_ALLOW_EXCEPTIONS_FLAG,
    SOURCE_ID = X_SOURCE_ID,
    -- DESCRIPTION = X_DESCRIPTION,     -- commented as part of fix for bug#  6820043
    TAXABLE_BASIS_FORMULA_CODE = X_TAXABLE_BASIS_FORMULA_CODE
  where TAX_RATE_ID = X_TAX_RATE_ID;

Line: 928

  update ZX_RATES_TL set
    TAX_RATE_NAME = X_TAX_RATE_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    DESCRIPTION = X_DESCRIPTION, -- added as part of fix for bug# 6820043
    SOURCE_LANG = userenv('LANG')
  where TAX_RATE_ID = X_TAX_RATE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 947

     UPDATE_LOOKUP_VALUES_PVT(
        'ZX_INPUT_CLASSIFICATIONS' ,
        X_TAX_RATE_CODE ,
        X_TAX_RATE_CODE,
        X_TAX_RATE_CODE,
        X_EFFECTIVE_FROM,
        X_EFFECTIVE_TO,
        X_RETURN_STATUS
     );

Line: 957

     UPDATE_LOOKUP_VALUES_PVT(
        'ZX_OUTPUT_CLASSIFICATIONS' ,
        X_TAX_RATE_CODE ,
        X_TAX_RATE_CODE,
        X_TAX_RATE_CODE,
        X_EFFECTIVE_FROM,
        X_EFFECTIVE_TO,
        X_RETURN_STATUS
     );

Line: 967

     UPDATE_LOOKUP_VALUES_PVT(
        'ZX_WEB_EXP_TAX_CLASSIFICATIONS' ,
        X_TAX_RATE_CODE ,
        X_TAX_RATE_CODE,
        X_TAX_RATE_CODE,
        X_EFFECTIVE_FROM,
        X_EFFECTIVE_TO,
        X_RETURN_STATUS
     );

Line: 981

    SELECT decode(c.party_type_code,'OU',c.party_id,-99) INTO X_ORG_ID
      FROM zx_party_tax_profile c
     WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;

Line: 986

      SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
        FROM ZX_TAXES_B A
       WHERE A.TAX = X_TAX
         AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
         AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;

Line: 993

        SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
          FROM ZX_TAXES_B A
         WHERE A.TAX = X_TAX
           AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
           AND A.CONTENT_OWNER_ID = -99;

Line: 1018

end UPDATE_ROW;

Line: 1023

procedure DELETE_ROW (
  X_TAX_RATE_ID in NUMBER
) is
begin
  delete from ZX_RATES_TL
  where TAX_RATE_ID = X_TAX_RATE_ID;

Line: 1032

  delete from ZX_RATES_B
  where TAX_RATE_ID = X_TAX_RATE_ID;

Line: 1037

end DELETE_ROW;

Line: 1045

  delete from ZX_RATES_TL T
  where not exists
    (select NULL
    from ZX_RATES_B B
    where B.TAX_RATE_ID = T.TAX_RATE_ID
    );

Line: 1051

  update ZX_RATES_TL T set (
      TAX_RATE_NAME
    ) = (select
      B.TAX_RATE_NAME
    from ZX_RATES_TL B
    where B.TAX_RATE_ID = T.TAX_RATE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TAX_RATE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TAX_RATE_ID,
      SUBT.LANGUAGE
    from ZX_RATES_TL SUBB, ZX_RATES_TL SUBT
    where SUBB.TAX_RATE_ID = SUBT.TAX_RATE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TAX_RATE_NAME <> SUBT.TAX_RATE_NAME
      or (SUBB.TAX_RATE_NAME is null and SUBT.TAX_RATE_NAME is not null)
      or (SUBB.TAX_RATE_NAME is not null and SUBT.TAX_RATE_NAME is null)
  ));

Line: 1071

  insert into ZX_RATES_TL (
    TAX_RATE_ID,
    TAX_RATE_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    description, -- added as part of fix for bug#  6820043
    SOURCE_LANG
  ) select
    B.TAX_RATE_ID,
    B.TAX_RATE_NAME,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.DESCRIPTION,  -- added as part of fix for bug# 6820043
    B.SOURCE_LANG
  from ZX_RATES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ZX_RATES_TL T
    where T.TAX_RATE_ID = B.TAX_RATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 1106

Procedure INSERT_LOOKUP_VALUES (
  X_LOOKUP_TYPE in VARCHAR2,
  X_TAX_RATE_CODE in VARCHAR2,
  X_EFFECTIVE_FROM  in DATE,
  X_EFFECTIVE_TO   in DATE,
  --start bug#6992215
  X_DESCRIPTION in VARCHAR2 DEFAULT NULL ,  --bug#7274382 added default
  X_TAX_RATE_NAME IN VARCHAR2 DEFAULT NULL  --bug#7274382 added default
  -- end bug#6992215
) is

CURSOR cur_fnd_lookup_values (cp_lookup_type   IN VARCHAR2
                             ,cp_tax_rate_code IN VARCHAR2
                             ) IS
SELECT *
FROM fnd_lookup_values
WHERE lookup_type = cp_lookup_type
  AND lookup_code = NVL(TAG,cp_tax_rate_code)
  AND view_application_id = 0
  AND security_group_id = 0
  AND ROWNUM = 1;

Line: 1141

    fnd_lookup_values_pkg.update_row (
        x_lookup_type         => l_fnd_lookup_values_rec.lookup_type
       ,x_security_group_id   => l_fnd_lookup_values_rec.security_group_id
       ,x_view_application_id => l_fnd_lookup_values_rec.view_application_id
       ,x_lookup_code         => l_fnd_lookup_values_rec.lookup_code
       ,x_tag                 => l_fnd_lookup_values_rec.tag
       ,x_attribute_category  => l_fnd_lookup_values_rec.attribute_category
       ,x_attribute1          => l_fnd_lookup_values_rec.attribute1
       ,x_attribute2          => l_fnd_lookup_values_rec.attribute2
       ,x_attribute3          => l_fnd_lookup_values_rec.attribute3
       ,x_attribute4          => l_fnd_lookup_values_rec.attribute4
       ,x_enabled_flag        => l_fnd_lookup_values_rec.enabled_flag
       ,x_start_date_active   => l_fnd_lookup_values_rec.start_date_active
       ,x_end_date_active     => NULL
       ,x_territory_code      => l_fnd_lookup_values_rec.territory_code
       ,x_attribute5          => l_fnd_lookup_values_rec.attribute5
       ,x_attribute6          => l_fnd_lookup_values_rec.attribute6
       ,x_attribute7          => l_fnd_lookup_values_rec.attribute7
       ,x_attribute8          => l_fnd_lookup_values_rec.attribute8
       ,x_attribute9          => l_fnd_lookup_values_rec.attribute9
       ,x_attribute10         => l_fnd_lookup_values_rec.attribute10
       ,x_attribute11         => l_fnd_lookup_values_rec.attribute11
       ,x_attribute12         => l_fnd_lookup_values_rec.attribute12
       ,x_attribute13         => l_fnd_lookup_values_rec.attribute13
       ,x_attribute14         => l_fnd_lookup_values_rec.attribute14
       ,x_attribute15         => l_fnd_lookup_values_rec.attribute15
       ,x_meaning             => l_fnd_lookup_values_rec.meaning
       ,x_description         => l_fnd_lookup_values_rec.description
       ,x_last_update_date    => SYSDATE
       ,x_last_updated_by     => FND_GLOBAL.user_id
       ,x_last_update_login   => FND_GLOBAL.login_id
      );

Line: 1182

    fnd_lookup_values_pkg.insert_row (
        x_rowid               => l_rowid
       ,x_lookup_type         => x_lookup_type
       ,x_security_group_id   => 0
       ,x_view_application_id => 0
       ,x_lookup_code         => l_lookup_code
       ,x_tag                 => l_tag
       ,x_attribute_category  => NULL
       ,x_attribute1          => NULL
       ,x_attribute2          => NULL
       ,x_attribute3          => NULL
       ,x_attribute4          => NULL
       ,x_enabled_flag        => 'Y'
       ,x_start_date_active   => x_effective_from
       ,x_end_date_active     => x_effective_to
       ,x_territory_code      => NULL
       ,x_attribute5          => NULL
       ,x_attribute6          => NULL
       ,x_attribute7          => NULL
       ,x_attribute8          => NULL
       ,x_attribute9          => NULL
       ,x_attribute10         => NULL
       ,x_attribute11         => NULL
       ,x_attribute12         => NULL
       ,x_attribute13         => NULL
       ,x_attribute14         => NULL
       ,x_attribute15         => NULL
       ,x_meaning             => x_tax_rate_code
       ,x_description         => x_tax_rate_code
       ,x_creation_date       => SYSDATE
       ,x_created_by          => FND_GLOBAL.user_id
       ,x_last_update_date    => SYSDATE
       ,x_last_updated_by     => FND_GLOBAL.user_id
       ,x_last_update_login   => FND_GLOBAL.login_id
       );

Line: 1227

end INSERT_LOOKUP_VALUES;