APPS.PAY_TAXABILITY_RULES_API SQL Statements

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

Line: 25

         select nvl(status, 'V'),last_updated_by
           from pay_taxability_rules
          where jurisdiction_code = cp_jurisdiction
            and nvl(tax_type,'X') = nvl(cp_tax_type,'X')
            and nvl(tax_category,'X') = nvl(cp_category,'X')
            and nvl(classification_id,0) = nvl(cp_classification_id,0)
            and nvl(secondary_classification_id,0) =
                           nvl(cp_secondary_classification_id,0)
            and legislation_code = cp_legislation_code;

Line: 36

    lv_last_updated_by NUMBER(15);

Line: 37

    lv_seed_last_updated_by NUMBER(15);

Line: 49

    fetch c_check_taxability_rule into lv_status,lv_last_updated_by;

Line: 55

    lv_seed_last_updated_by:=  fnd_load_util.owner_id('ORACLE');

Line: 56

    hr_utility.trace('lv_seed_last_updated_by = '||to_char(lv_seed_last_updated_by));

Line: 57

    hr_utility.trace('lv_last_updated_by = '||to_char(lv_last_updated_by));

Line: 61

    if lv_last_updated_by = lv_seed_last_updated_by  Then

         lv_status := 'S';

Line: 135

PROCEDURE update_taxability_rules
                (p_validate                 IN BOOLEAN
                ,p_jurisdiction             IN VARCHAR2
                ,p_tax_type                 IN VARCHAR2 default null
                ,p_tax_category             IN VARCHAR2 default null
                ,p_classification_id        IN  NUMBER default null
                ,p_taxability_rules_date_id IN NUMBER
                ,p_legislation_code         IN  VARCHAR2
                ,p_status                   IN  VARCHAR2
                ,p_secondary_classification_id IN  NUMBER default null)
IS

  l_proc            VARCHAR2(72) := g_package||'update_taxability_rules';

Line: 155

  savepoint update_taxability_rules;

Line: 179

    ROLLBACK TO update_taxability_rules;

Line: 183

    ROLLBACK TO update_taxability_rules;

Line: 187

end update_taxability_rules;

Line: 196

** Commenting out the delete becasue of the reason mentioned
** above.
************************************************************
PROCEDURE delete_taxability_rules
                ( p_validate                IN BOOLEAN
                ,p_jurisdiction             IN VARCHAR2
                ,p_tax_type                 IN VARCHAR2 default null
                ,p_tax_category             IN VARCHAR2 default null
                ,p_classification_id        IN  NUMBER default null
                ,p_taxability_rules_date_id IN NUMBER
                ,p_legislation_code         IN  VARCHAR2
                ,p_status                   IN  VARCHAR2,
                ,p_secondary_classification_id IN  NUMBER default null)
IS

BEGIN
  null;

Line: 213

END delete_taxability_rules;