APPS.PAY_US_TAXABILITY_RULES_PKG_F SQL Statements

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

Line: 4

PROCEDURE get_or_update(X_MODE                      VARCHAR2,
                        X_CONTEXT                   VARCHAR2,
                        X_JURISDICTION              VARCHAR2,
                        X_TAX_CAT                   VARCHAR2,
                        X_classification_id         NUMBER,
                        X_BOX1        IN OUT NOCOPY VARCHAR2,
                        X_BOX2        IN OUT NOCOPY VARCHAR2,
                        X_BOX3        IN OUT NOCOPY VARCHAR2) IS
-- Local Variables
P_ret      VARCHAR2(1) := 'N';

Line: 28

       select TRD.TAXABILITY_RULES_DATE_ID,
              TRD.VALID_DATE_FROM, TRD.VALID_DATE_TO
       from   PAY_TAXABILITY_RULES_DATES TRD
       where  p_date between TRD.VALID_DATE_FROM and
                             TRD.VALID_DATE_TO
       and    TRD.LEGISLATION_CODE = p_legislation_code;

Line: 53

       select 'Y'
       from   PAY_TAXABILITY_RULES
       where  JURISDICTION_CODE        = P_jurisdiction
       and    TAX_TYPE                 = P_tax_type
       and    TAX_CATEGORY             = P_category
       and    CLASSIFICATION_ID        = p_classification_id
       and    TAXABILITY_RULES_DATE_ID = p_taxability_rules_date_id
       and    LEGISLATION_CODE         = 'US'
       and    nvl(STATUS,'VALID') <> 'D';

Line: 75

FUNCTION insert_rules(P_jurisdiction               VARCHAR2,
                      P_tax_type                   VARCHAR2,
                      P_category                   VARCHAR2,
                      P_classification_id          NUMBER,
                      P_taxability_rules_date_id   NUMBER)
RETURN NUMBER IS
--
ret number := 0;

Line: 85

   update pay_taxability_rules
      set status = null
    where jurisdiction_code = P_jurisdiction
    and tax_type          = P_tax_type
    and tax_category      = P_category
    and classification_id = p_classification_id
    and taxability_rules_date_id = P_taxability_rules_date_id;

Line: 95

     INSERT INTO pay_taxability_rules(
            JURISDICTION_CODE,
            TAX_TYPE,
            TAX_CATEGORY,
            classification_id,
            TAXABILITY_RULES_DATE_ID,
            LEGISLATION_CODE,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            CREATED_BY,
            CREATION_DATE)
     VALUES (
            P_jurisdiction,
            P_tax_type,
            P_category,
            P_classification_id,
            P_taxability_rules_date_id,
            'US',
            SYSDATE,
            P_user_id,
            P_Login_Id,
            P_user_id,
            SYSDATE);

Line: 121

        hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');

Line: 129

END insert_rules;

Line: 131

FUNCTION delete_rules(P_jurisdiction               VARCHAR2,
                      P_tax_type                   VARCHAR2,
                      P_category                   VARCHAR2,
                      p_classification_id          NUMBER,
                      p_taxability_rules_date_id   NUMBER)
RETURN NUMBER IS
--
ret number := 0;

Line: 140

  update pay_taxability_rules
    set  status = 'D'
  where jurisdiction_code        = P_jurisdiction
  and   tax_type                 = P_tax_type
  and   tax_category             = P_category
  and   classification_id        = p_classification_id
  and   taxability_rules_date_id = P_taxability_rules_date_id;

Line: 150

     hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');

Line: 157

END delete_rules;

Line: 177

SELECT   'Y'
FROM  pay_taxability_rules
WHERE jurisdiction_code = p_jurisdiction_code
AND   tax_type    = p_tax_type
AND   classification_id = p_classification_id
AND   tax_category      <> p_tax_category
AND   legislation_code = 'US';

Line: 229

   elsif X_MODE = 'UPDATE' then
      P_User_Id  := FND_PROFILE.Value('USER_ID');

Line: 233

      SELECT taxability_rules_date_id
        INTO p_taxability_rules_date_id
        FROM pay_taxability_rules_dates
       WHERE sysdate between valid_date_from and valid_date_to
         AND legislation_code = p_legislation_code;

Line: 247

         P_i := delete_rules(X_jurisdiction,'CSDI',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 249

         P_i := insert_rules(X_jurisdiction,'CSDI',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 260

         P_i := delete_rules(X_jurisdiction,'GDI',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 262

         P_i := insert_rules(X_jurisdiction,'GDI',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 273

         P_i := delete_rules(X_jurisdiction,'DCIA',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 275

         P_i := insert_rules(X_jurisdiction,'DCIA',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line: 282

END get_or_update;

Line: 294

SELECT pec.classification_id
FROM   pay_element_classifications pec
WHERE  pec.classification_name = p_classification_name
AND    pec.legislation_code = 'US';