APPS.JL_ZZ_AR_TX_RULES_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row
       (X_rowid             IN OUT NOCOPY VARCHAR2,
        X_rule_id                         NUMBER,
        X_tax_rule_level                  VARCHAR2,
        X_rule                            VARCHAR2,
        X_tax_category_id                 NUMBER,
        X_contributor_type                VARCHAR2,
        X_cust_trx_type_id                NUMBER,
        X_last_update_date                DATE,
        X_last_updated_by                 NUMBER,
        X_priority                        NUMBER,
        X_description                     VARCHAR2,
        X_org_id                          NUMBER,
        X_last_update_login               NUMBER,
        X_creation_date                   DATE,
        X_created_by                      NUMBER,
        X_calling_sequence  IN            VARCHAR2) IS

    CURSOR C IS
      SELECT rowid
      FROM jl_zz_ar_tx_rules
      WHERE rule = X_rule
      AND tax_rule_level = X_tax_rule_level
      AND tax_category_id = X_tax_category_id
      AND contributor_type = X_contributor_type
      AND cust_trx_type_id = X_cust_trx_type_id
      AND priority = X_priority
      AND org_id = X_org_id;

Line: 39

    current_calling_sequence := 'JL_ZZ_AR_TX_RULES_PKG.INSERT_ROW<-' ||
                                X_calling_sequence;

Line: 42

    debug_info := 'Insert into JL_ZZ_AR_TX_RULES  ';

Line: 43

    INSERT INTO JL_ZZ_AR_TX_RULES(rule_id,
                                  tax_rule_level,
                                  rule,
                                  tax_category_id,
                                  contributor_type,
                                  cust_trx_type_id,
                                  org_id,
                                  last_update_date,
                                  last_updated_by,
                                  priority,
                                  description,
                                  last_update_login,
                                  creation_date,
                                  created_by)
                          VALUES (X_rule_id,
                                  X_tax_rule_level,
                                  X_rule,
                                  X_tax_category_id,
                                  X_contributor_type,
                                  X_cust_trx_type_id,
                                  X_org_id,
                                  X_last_update_date,
                                  X_last_updated_by,
                                  X_priority,
                                  X_description,
                                  X_last_update_login,
                                  X_creation_date,
                                  X_created_by);

Line: 101

  END Insert_Row;

Line: 111

        X_last_update_date                DATE,
        X_last_updated_by                 NUMBER,
        X_priority                        NUMBER,
        X_description                     VARCHAR2,
        X_org_id                          NUMBER,
        X_last_update_login               NUMBER,
        X_creation_date                   DATE,
        X_created_by                      NUMBER,
        X_calling_sequence   IN           VARCHAR2) IS

    CURSOR C IS
      SELECT *
      FROM jl_zz_ar_tx_rules
      WHERE rule = X_rule
      AND tax_rule_level = X_tax_rule_level
      AND tax_category_id = X_tax_category_id
      AND contributor_type = X_contributor_type
      AND cust_trx_type_id = X_cust_trx_type_id
      AND priority = X_priority
      AND org_id = X_org_id
      FOR UPDATE of rule,
                    tax_rule_level,
                    tax_category_id,
                    contributor_type,
                    cust_trx_type_id,
                    priority
      NOWAIT;

Line: 157

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

Line: 170

        (Recinfo.last_updated_by = X_last_updated_by) AND
        (Recinfo.last_update_date = X_last_update_date) AND
        ((Recinfo.description = X_description) OR
         ((Recinfo.description IS NULL) AND
          (X_description IS NULL))) AND
        ((Recinfo.last_update_login = X_last_update_login) OR
         ((Recinfo.last_update_login IS NULL) AND
          (X_last_update_login IS NULL))) AND
        ((Recinfo.creation_date = X_creation_date) OR
         ((Recinfo.creation_date IS NULL) AND
          (X_creation_date IS NULL))) AND
        ((Recinfo.created_by = X_created_by) OR
         ((Recinfo.created_by IS NULL) AND
          (X_created_by IS NULL)))) THEN
      return;

Line: 212

  PROCEDURE Update_Row
       (X_rowid                           VARCHAR2,
        X_rule_id                         NUMBER,
        X_tax_rule_level                  VARCHAR2,
        X_rule                            VARCHAR2,
        X_tax_category_id                 NUMBER,
        X_contributor_type                VARCHAR2,
        X_cust_trx_type_id                NUMBER,
        X_last_update_date                DATE,
        X_last_updated_by                 NUMBER,
        X_priority                        NUMBER,
        X_description                     VARCHAR2,
        X_org_id                          NUMBER,
        X_last_update_login               NUMBER,
        X_creation_date                   DATE,
        X_created_by                      NUMBER,
        X_calling_sequence        IN      VARCHAR2) IS

  BEGIN
    UPDATE jl_zz_ar_tx_rules
    SET rule_id           = X_rule_id,
        tax_rule_level    = X_tax_rule_level,
        rule              = X_rule,
        tax_category_id   = X_tax_category_id,
        contributor_type  = X_contributor_type,
        cust_trx_type_id  = X_cust_trx_type_id,
        org_id            = X_org_id,
        last_update_date  = X_last_update_date,
        last_updated_by   = X_last_updated_by,
        priority          = X_priority,
        description       = X_description,
        last_update_login = X_last_update_login,
        creation_date     = X_creation_date,
        created_by        = X_created_by
    WHERE  rowid = X_rowid;

Line: 251

  END Update_Row;

Line: 253

  PROCEDURE Delete_Row
       (X_rowid                   VARCHAR2) IS

  BEGIN
    DELETE
    FROM jl_zz_ar_tx_rules
    WHERE rowid = X_rowid;

Line: 264

  END Delete_Row;