DBA Data[Home] [Help]

APPS.PAY_CA_TAXABILITY_RULES_PKG SQL Statements

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

Line: 42

PROCEDURE get_or_update(X_MODE                VARCHAR2,
                        X_CONTEXT             VARCHAR2,
                        X_JURISDICTION        VARCHAR2,
                        X_TAX_CAT             VARCHAR2,
			X_classification_id   NUMBER,
			X_legislation_code    VARCHAR2,
			X_taxability_rules_date_id out nocopy NUMBER,
			X_valid_date_from  in out nocopy DATE,
                        X_valid_date_to    in out nocopy DATE,
			X_session_date		DATE,
                        X_BOX1         IN OUT nocopy VARCHAR2,
                        X_BOX2         IN OUT nocopy VARCHAR2,
                        X_BOX3         IN OUT nocopy VARCHAR2,
                        X_BOX4         IN OUT nocopy VARCHAR2,
                        X_BOX5         IN OUT nocopy VARCHAR2,
                        X_BOX6         IN OUT nocopy VARCHAR2,
			X_BOX7         IN OUT nocopy VARCHAR2,
			X_BOX8         IN OUT nocopy VARCHAR2,
			X_BOX9         IN OUT nocopy VARCHAR2,
			X_BOX10        IN OUT nocopy VARCHAR2) IS

TYPE character_data_table IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
Line: 80

       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: 104

       select 'Y'
       from   PAY_TAXABILITY_RULES PTR
       where  PTR.JURISDICTION_CODE = P_jurisdiction
       and    PTR.TAX_TYPE          = P_tax_type
       and    PTR.TAX_CATEGORY      = P_category
       and    PTR.CLASSIFICATION_ID = p_classification_id
       and    PTR.TAXABILITY_RULES_DATE_ID = p_taxability_rules_date_id;
Line: 126

PROCEDURE insert_rules(P_jurisdiction       VARCHAR2,
                      P_tax_type           VARCHAR2,
                      P_category           VARCHAR2,
		      P_classification_id  NUMBER,
		      P_taxability_rules_date_id NUMBER) IS
--
begin

  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,
	 'CA',
         SYSDATE,
         P_user_id,
         P_Login_Id,
         P_user_id,
         SYSDATE);
Line: 160

     hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
Line: 165

END insert_rules;
Line: 168

PROCEDURE delete_rules(P_jurisdiction       VARCHAR2,
                      P_tax_type           VARCHAR2,
                      P_category           VARCHAR2,
		      p_classification_id  NUMBER,
		      P_taxability_rules_date_id NUMBER) IS
--
begin
  delete 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;
Line: 183

     hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
Line: 189

END delete_rules;
Line: 339

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

        select taxability_rules_date_id
	into   X_taxability_rules_date_id
        from   pay_taxability_rules_dates
        where  X_session_date between valid_date_from and valid_date_to
	and    legislation_code = X_legislation_code;
Line: 368

           delete_rules(X_jurisdiction, l_fed_tax_type(i), X_tax_cat,
		        X_classification_id, X_taxability_rules_date_id);
Line: 371

           insert_rules(X_jurisdiction,l_fed_tax_type(i), X_tax_cat,
			X_classification_id, X_taxability_rules_date_id);
Line: 406

           delete_rules(substr(X_jurisdiction,1,2)||'-000-0000', l_prv_tax_type(i), X_tax_cat,
                        X_classification_id, X_taxability_rules_date_id);
Line: 409

           insert_rules(substr(X_jurisdiction,1,2)||'-000-0000',l_prv_tax_type(i), X_tax_cat,
                        X_classification_id, X_taxability_rules_date_id);
Line: 445

           delete_rules(substr(X_jurisdiction,1,2)||'-000-0000', l_qbc_tax_type(i), X_tax_cat,
                        X_classification_id, X_taxability_rules_date_id);
Line: 448

           insert_rules(substr(X_jurisdiction,1,2)||'-000-0000',l_qbc_tax_type(i), X_tax_cat,
                        X_classification_id, X_taxability_rules_date_id);
Line: 457

END get_or_update;
Line: 466

SELECT classification_id
FROM   pay_element_classifications
WHERE  classification_name = p_classification_name
AND    legislation_code = 'CA';