eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_SIM_CONDITIONS1_PKG SQL Statements

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

Line: 10


  PROCEDURE Insert_Row
       (p_sim_condition_id                         NUMBER,
        p_trx_id                                   NUMBER,
        p_trx_line_id                              NUMBER,
        p_tax_line_number                          NUMBER,
        p_det_factor_class_code                    VARCHAR2, --p_determining_factor_class_code
        p_determining_factor_code                  VARCHAR2,
        p_data_type_code                           VARCHAR2,
        p_operator_code                            VARCHAR2,
        p_tax_parameter_code                       VARCHAR2,
        p_determining_factor_cq_code               VARCHAR2,
        p_numeric_value                            NUMBER,
        p_date_value                               DATE,
        p_alphanumeric_value                       VARCHAR2,
        p_value_low                                VARCHAR2,
        p_value_high                               VARCHAR2,
        p_applicability_flag                       VARCHAR2,
        p_status_determine_flag                    VARCHAR2,
        p_default_status_code                      VARCHAR2,
        p_rate_determine_flag                      VARCHAR2,
        p_direct_rate_determine_flag               VARCHAR2,
        p_taxable_basis_determine_flag             VARCHAR2,
        p_calculate_tax_determine_flag             VARCHAR2,
        p_place_of_supply_det_flag                 VARCHAR2, --p_place_of_supply_determine_flag
        p_registration_determine_flag              VARCHAR2,
        p_created_by                               NUMBER,
        p_creation_date                            DATE,
        p_last_updated_by                          NUMBER,
        p_last_update_date                         DATE,
        p_last_update_login                        NUMBER) IS

    l_return_status VARCHAR2(1000);

Line: 50


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Insert_Row (+)');

Line: 54


    INSERT INTO ZX_SIM_CONDITIONS (sim_condition_id,
                                   trx_id,
                                   trx_line_id,
                                   tax_line_number,
                                   determining_factor_class_code,
                                   determining_factor_code,
                                   data_type_code,
                                   operator_code,
                                   tax_parameter_code,
                                   determining_factor_cq_code,
                                   numeric_value,
                                   date_value,
                                   alphanumeric_value,
                                   value_low,
                                   value_high,
                                   applicability_flag,
                                   status_determine_flag,
                                   default_status_code,
                                   rate_determine_flag,
                                   direct_rate_determine_flag,
                                   taxable_basis_determine_flag,
                                   calculate_tax_determine_flag,
                                   place_of_supply_determine_flag,
                                   registration_determine_flag,
                                   created_by,
                                   creation_date,
                                   last_updated_by,
                                   last_update_date,
                                   last_update_login)
                           VALUES (p_sim_condition_id,
                                   p_trx_id,
                                   p_trx_line_id,
                                   p_tax_line_number,
                                   p_det_factor_class_code,
                                   p_determining_factor_code,
                                   p_data_type_code,
                                   p_operator_code,
                                   p_tax_parameter_code,
                                   p_determining_factor_cq_code,
                                   p_numeric_value,
                                   p_date_value,
                                   p_alphanumeric_value,
                                   p_value_low,
                                   p_value_high,
                                   p_applicability_flag,
                                   p_status_determine_flag,
                                   p_default_status_code,
                                   p_rate_determine_flag,
                                   p_direct_rate_determine_flag,
                                   p_taxable_basis_determine_flag,
                                   p_calculate_tax_determine_flag,
                                   p_place_of_supply_det_flag,
                                   p_registration_determine_flag,
                                   p_created_by,
                                   p_creation_date,
                                   p_last_updated_by,
                                   p_last_update_date,
                                   p_last_update_login);

Line: 115


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Insert_Row (-)');

Line: 118


  END Insert_Row;

Line: 120


  PROCEDURE Update_Row
       (p_sim_condition_id                         NUMBER,
        p_trx_id                                   NUMBER,
        p_trx_line_id                              NUMBER,
        p_tax_line_number                          NUMBER,
        p_det_factor_class_code                    VARCHAR2, --p_determining_factor_class_code
        p_determining_factor_code                  VARCHAR2,
        p_data_type_code                           VARCHAR2,
        p_operator_code                            VARCHAR2,
        p_tax_parameter_code                       VARCHAR2,
        p_determining_factor_cq_code               VARCHAR2,
        p_numeric_value                            NUMBER,
        p_date_value                               DATE,
        p_alphanumeric_value                       VARCHAR2,
        p_value_low                                VARCHAR2,
        p_value_high                               VARCHAR2,
        p_applicability_flag                       VARCHAR2,
        p_status_determine_flag                    VARCHAR2,
        p_default_status_code                      VARCHAR2,
        p_rate_determine_flag                      VARCHAR2,
        p_direct_rate_determine_flag               VARCHAR2,
        p_taxable_basis_determine_flag             VARCHAR2,
        p_calculate_tax_determine_flag             VARCHAR2,
        p_place_of_supply_det_flag                 VARCHAR2, --p_place_of_supply_determine_flag
        p_registration_determine_flag              VARCHAR2,
        p_created_by                               NUMBER,
        p_creation_date                            DATE,
        p_last_updated_by                          NUMBER,
        p_last_update_date                         DATE,
        p_last_update_login                        NUMBER) IS

    l_return_status VARCHAR2(1000);

Line: 160


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Update_Row (+)');

Line: 164


    UPDATE ZX_SIM_CONDITIONS
      SET sim_condition_id               = p_sim_condition_id,
          trx_id                         = p_trx_id,
          trx_line_id                    = p_trx_line_id,
          tax_line_number                = p_tax_line_number,
          determining_factor_class_code  = p_det_factor_class_code,
          determining_factor_code        = p_determining_factor_code,
          data_type_code                 = p_data_type_code,
          operator_code                  = p_operator_code,
          tax_parameter_code             = p_tax_parameter_code,
          determining_factor_cq_code     = p_determining_factor_cq_code,
          numeric_value                  = p_numeric_value,
          date_value                     = p_date_value,
          alphanumeric_value             = p_alphanumeric_value,
          value_low                      = p_value_low,
          value_high                     = p_value_high,
          applicability_flag             = p_applicability_flag,
          status_determine_flag          = p_status_determine_flag,
          default_status_code            = p_default_status_code,
          rate_determine_flag            = p_rate_determine_flag,
          direct_rate_determine_flag     = p_direct_rate_determine_flag,
          taxable_basis_determine_flag   = p_taxable_basis_determine_flag,
          calculate_tax_determine_flag   = p_calculate_tax_determine_flag,
          place_of_supply_determine_flag = p_place_of_supply_det_flag,
          registration_determine_flag    = p_registration_determine_flag,
          created_by                     = p_created_by,
          creation_date                  = p_creation_date,
          last_updated_by                = p_last_updated_by,
          last_update_date               = p_last_update_date,
          last_update_login              = p_last_update_login
      WHERE SIM_CONDITION_ID = p_sim_condition_id
      AND TRX_ID = p_trx_id
      AND TRX_LINE_ID = p_trx_line_id;

Line: 200


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Update_Row (-)');

Line: 203


  END Update_Row;

Line: 205


  PROCEDURE Delete_Row
       (p_sim_condition_id                         NUMBER,
        p_trx_id                                   NUMBER,
        p_trx_line_id                              NUMBER,
        p_tax_line_number                          NUMBER,
        p_det_factor_class_code                    VARCHAR2, --p_determining_factor_class_code
        p_determining_factor_code                  VARCHAR2,
        p_data_type_code                           VARCHAR2,
        p_operator_code                            VARCHAR2,
        p_tax_parameter_code                       VARCHAR2,
        p_determining_factor_cq_code               VARCHAR2,
        p_numeric_value                            NUMBER,
        p_date_value                               DATE,
        p_alphanumeric_value                       VARCHAR2,
        p_value_low                                VARCHAR2,
        p_value_high                               VARCHAR2,
        p_applicability_flag                       VARCHAR2,
        p_status_determine_flag                    VARCHAR2,
        p_default_status_code                      VARCHAR2,
        p_rate_determine_flag                      VARCHAR2,
        p_direct_rate_determine_flag               VARCHAR2,
        p_taxable_basis_determine_flag             VARCHAR2,
        p_calculate_tax_determine_flag             VARCHAR2,
        p_place_of_supply_det_flag                 VARCHAR2, --p_place_of_supply_determine_flag
        p_registration_determine_flag              VARCHAR2,
        p_created_by                               NUMBER,
        p_creation_date                            DATE,
        p_last_updated_by                          NUMBER,
        p_last_update_date                         DATE,
        p_last_update_login                        NUMBER) IS

    l_return_status VARCHAR2(1000);

Line: 245


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Delete_Row (+)');

Line: 251


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Delete_Row (-)');

Line: 254


  END Delete_Row;

Line: 283


        p_last_updated_by                          NUMBER,
        p_last_update_date                         DATE,
        p_last_update_login                        NUMBER) IS

    l_return_status VARCHAR2(1000);

Line: 292


      SELECT SIM_CONDITION_ID,
             TRX_ID,
             TRX_LINE_ID,
             TAX_LINE_NUMBER,
             DETERMINING_FACTOR_CLASS_CODE,
             DETERMINING_FACTOR_CODE,
             DATA_TYPE_CODE,
             OPERATOR_CODE,
             TAX_PARAMETER_CODE,
             DETERMINING_FACTOR_CQ_CODE,
             NUMERIC_VALUE,
             DATE_VALUE,
             ALPHANUMERIC_VALUE,
             VALUE_LOW,
             VALUE_HIGH,
             APPLICABILITY_FLAG,
             STATUS_DETERMINE_FLAG,
             DEFAULT_STATUS_CODE,
             RATE_DETERMINE_FLAG,
             DIRECT_RATE_DETERMINE_FLAG,
             TAXABLE_BASIS_DETERMINE_FLAG,
             CALCULATE_TAX_DETERMINE_FLAG,
             PLACE_OF_SUPPLY_DETERMINE_FLAG,
             REGISTRATION_DETERMINE_FLAG,
             CREATED_BY,
             CREATION_DATE,
             LAST_UPDATED_BY,
             LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN
        FROM ZX_SIM_CONDITIONS
        WHERE SIM_CONDITION_ID = p_sim_condition_id
        AND TRX_ID = p_trx_id
        AND TRX_LINE_ID = p_trx_line_id;

Line: 333


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Lock_Row (+)');

Line: 342


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 405


        (Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) AND
        (Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) AND
        ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR
         ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND
          (p_LAST_UPDATE_LOGIN IS NULL))) ) THEN
      RETURN;

Line: 418


                     'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
                     'ZX_SIM_RULES_PKG: Lock_Row (-)');