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.PAY_RI_AC_TAX_RULE SQL Statements

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

Line: 29


  l_datetrack_update_mode  Varchar2(50);

Line: 31


  l_dt_update              Boolean;

Line: 65


     ,p_update                => l_dt_update
     ,p_update_override       => l_dt_upd_override
     ,p_update_change_insert  => l_upd_chg_ins
      );

Line: 71


     IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 74


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 83


          l_datetrack_update_mode := 'CORRECTION';

Line: 84


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 90


   pay_federal_tax_rule_api.update_fed_tax_rule
   (
    p_effective_date                 => p_effective_date
   ,p_datetrack_update_mode          => l_datetrack_update_mode
   ,p_emp_fed_tax_rule_id            => l_pay_us_fedtax_rule_rec.emp_fed_tax_rule_id
   ,p_object_version_number          => ln_ovn
   ,p_sui_state_code                 => l_pay_us_fedtax_rule_rec.sui_state_code
   ,p_filing_status_code             => l_pay_us_fedtax_rule_rec.FILING_STATUS_CODE
   ,p_fit_override_amount            => l_pay_us_fedtax_rule_rec.FIT_OVERRIDE_AMOUNT
   ,p_fit_override_rate              => l_pay_us_fedtax_rule_rec.FIT_OVERRIDE_RATE
   ,p_withholding_allowances         => l_pay_us_fedtax_rule_rec.WITHHOLDING_ALLOWANCES
   ,p_cumulative_taxation            => l_pay_us_fedtax_rule_rec.CUMULATIVE_TAXATION
   ,p_eic_filing_status_code         => l_pay_us_fedtax_rule_rec.EIC_FILING_STATUS_CODE
   ,p_fit_additional_tax             => l_pay_us_fedtax_rule_rec.FIT_ADDITIONAL_TAX
   ,p_fit_exempt                     => l_pay_us_fedtax_rule_rec.FIT_EXEMPT
   ,p_futa_tax_exempt                => l_pay_us_fedtax_rule_rec.FUTA_TAX_EXEMPT
   ,p_medicare_tax_exempt            => l_pay_us_fedtax_rule_rec.MEDICARE_TAX_EXEMPT
   ,p_ss_tax_exempt                  => l_pay_us_fedtax_rule_rec.SS_TAX_EXEMPT
   ,p_statutory_employee             => l_pay_us_fedtax_rule_rec.STATUTORY_EMPLOYEE
   ,p_supp_tax_override_rate         => l_pay_us_fedtax_rule_rec.SUPP_TAX_OVERRIDE_RATE
   ,p_excessive_wa_reject_date       => l_pay_us_fedtax_rule_rec.EXCESSIVE_WA_REJECT_DATE
   ,p_effective_start_date           => ld_eff_start_date
   ,p_effective_end_date             => ld_eff_end_date
  );

Line: 115


    hr_utility.trace('call to hrdpp_UPDATE_FED_TAX_RULE.insert_batch_lines done');

Line: 123


    if p_dp_mode = 'UPDATE' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 134


     ,p_update                => l_dt_update
     ,p_update_override       => l_dt_upd_override
     ,p_update_change_insert  => l_upd_chg_ins
      );

Line: 140


     IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 143


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 150


          l_datetrack_update_mode := 'CORRECTION';

Line: 151


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 157


      hr_utility.trace('Calling PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE');

Line: 158


      PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE
         (P_EFFECTIVE_DATE                 => l_effective_date
         ,P_DATETRACK_UPDATE_MODE          => l_datetrack_update_mode
         ,P_EMP_STATE_TAX_RULE_ID          => l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID
         ,p_object_version_number          => ln_ovn
         ,P_ADDITIONAL_WA_AMOUNT           => l_pay_us_statetax_rule_rec.ADDITIONAL_WA_AMOUNT
         ,P_FILING_STATUS_CODE             => l_pay_us_statetax_rule_rec.FILING_STATUS_CODE
         ,P_SECONDARY_WA                   => l_pay_us_statetax_rule_rec.SECONDARY_WA
         ,P_SIT_ADDITIONAL_TAX             => l_pay_us_statetax_rule_rec.SIT_ADDITIONAL_TAX
         ,P_SIT_OVERRIDE_AMOUNT            => l_pay_us_statetax_rule_rec.SIT_OVERRIDE_AMOUNT
         ,P_SIT_OVERRIDE_RATE              => l_pay_us_statetax_rule_rec.SIT_OVERRIDE_RATE
         ,P_WITHHOLDING_ALLOWANCES         => l_pay_us_statetax_rule_rec.WITHHOLDING_ALLOWANCES
         ,P_EXCESSIVE_WA_REJECT_DATE       => l_pay_us_statetax_rule_rec.EXCESSIVE_WA_REJECT_DATE
         ,P_SDI_EXEMPT                     => l_pay_us_statetax_rule_rec.SDI_EXEMPT
         ,P_SIT_EXEMPT                     => l_pay_us_statetax_rule_rec.SIT_EXEMPT
         ,P_SIT_OPTIONAL_CALC_IND          => l_pay_us_statetax_rule_rec.SIT_OPTIONAL_CALC_IND
         ,P_STATE_NON_RESIDENT_CERT        => l_pay_us_statetax_rule_rec.STATE_NON_RESIDENT_CERT
         ,P_SUI_EXEMPT                     => l_pay_us_statetax_rule_rec.SUI_EXEMPT
         ,P_WC_EXEMPT                      => l_pay_us_statetax_rule_rec.WC_EXEMPT
         ,P_SUI_WAGE_BASE_OVERRIDE_AMOUN   => l_pay_us_statetax_rule_rec.SUI_WAGE_BASE_OVERRIDE_AMOUNT
         ,P_SUPP_TAX_OVERRIDE_RATE         => l_pay_us_statetax_rule_rec.SUPP_TAX_OVERRIDE_RATE
         ,P_STA_INFORMATION_CATEGORY       => l_pay_us_statetax_rule_rec.STA_INFORMATION_CATEGORY
         ,P_STA_INFORMATION1               => l_pay_us_statetax_rule_rec.STA_INFORMATION1
         ,P_STA_INFORMATION2               => l_pay_us_statetax_rule_rec.STA_INFORMATION2
         ,P_STA_INFORMATION3               => l_pay_us_statetax_rule_rec.STA_INFORMATION3
         ,P_STA_INFORMATION4               => l_pay_us_statetax_rule_rec.STA_INFORMATION4
         ,P_STA_INFORMATION5               => l_pay_us_statetax_rule_rec.STA_INFORMATION5
         ,P_STA_INFORMATION6               => l_pay_us_statetax_rule_rec.STA_INFORMATION6
         ,P_STA_INFORMATION7               => l_pay_us_statetax_rule_rec.STA_INFORMATION7
         ,P_STA_INFORMATION8               => l_pay_us_statetax_rule_rec.STA_INFORMATION8
         ,P_STA_INFORMATION9               => l_pay_us_statetax_rule_rec.STA_INFORMATION9
         ,P_STA_INFORMATION10               => l_pay_us_statetax_rule_rec.STA_INFORMATION10
         ,P_STA_INFORMATION11               => l_pay_us_statetax_rule_rec.STA_INFORMATION11
         ,P_STA_INFORMATION12               => l_pay_us_statetax_rule_rec.STA_INFORMATION12
         ,P_STA_INFORMATION13               => l_pay_us_statetax_rule_rec.STA_INFORMATION13
         ,P_STA_INFORMATION14               => l_pay_us_statetax_rule_rec.STA_INFORMATION14
         ,P_STA_INFORMATION15               => l_pay_us_statetax_rule_rec.STA_INFORMATION15
         ,P_STA_INFORMATION16               => l_pay_us_statetax_rule_rec.STA_INFORMATION16
         ,P_STA_INFORMATION17               => l_pay_us_statetax_rule_rec.STA_INFORMATION17
         ,P_STA_INFORMATION18               => l_pay_us_statetax_rule_rec.STA_INFORMATION18
         ,P_STA_INFORMATION19               => l_pay_us_statetax_rule_rec.STA_INFORMATION19
         ,P_STA_INFORMATION20               => l_pay_us_statetax_rule_rec.STA_INFORMATION20
         ,P_STA_INFORMATION21               => l_pay_us_statetax_rule_rec.STA_INFORMATION21
         ,P_STA_INFORMATION22               => l_pay_us_statetax_rule_rec.STA_INFORMATION22
         ,P_STA_INFORMATION23               => l_pay_us_statetax_rule_rec.STA_INFORMATION23
         ,P_STA_INFORMATION24               => l_pay_us_statetax_rule_rec.STA_INFORMATION24
         ,P_STA_INFORMATION25               => l_pay_us_statetax_rule_rec.STA_INFORMATION25
         ,P_STA_INFORMATION26               => l_pay_us_statetax_rule_rec.STA_INFORMATION26
         ,P_STA_INFORMATION27               => l_pay_us_statetax_rule_rec.STA_INFORMATION27
         ,P_STA_INFORMATION28               => l_pay_us_statetax_rule_rec.STA_INFORMATION28
         ,P_STA_INFORMATION29              => l_pay_us_statetax_rule_rec.STA_INFORMATION29
         ,P_STA_INFORMATION30              => l_pay_us_statetax_rule_rec.STA_INFORMATION30
         ,p_effective_start_date           => ld_eff_start_date
         ,p_effective_end_date             => ld_eff_end_date
         );

Line: 214


    hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');

Line: 216


   elsif p_dp_mode = 'INSERT' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 288


    if p_dp_mode = 'UPDATE' then

       hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 300


      ,p_update                => l_dt_update
      ,p_update_override       => l_dt_upd_override
      ,p_update_change_insert  => l_upd_chg_ins
       );

Line: 306


      IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 309


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 319


          l_datetrack_update_mode := 'CORRECTION';

Line: 320


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 325


       pay_county_tax_rule_api.update_county_tax_rule
       (p_emp_county_tax_rule_id         => l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID
       ,p_effective_start_date           => ld_eff_start_date
       ,p_effective_end_date             => ld_eff_end_date
       ,p_additional_wa_rate             => l_pay_us_countytax_rule_rec.ADDITIONAL_WA_RATE
       ,p_filing_status_code             => l_pay_us_countytax_rule_rec.FILING_STATUS_CODE
       ,p_lit_additional_tax             => l_pay_us_countytax_rule_rec.LIT_ADDITIONAL_TAX
       ,p_lit_override_amount            => l_pay_us_countytax_rule_rec.LIT_OVERRIDE_AMOUNT
       ,p_lit_override_rate              => l_pay_us_countytax_rule_rec.LIT_OVERRIDE_RATE
       ,p_withholding_allowances         => l_pay_us_countytax_rule_rec.WITHHOLDING_ALLOWANCES
       ,p_lit_exempt                     => l_pay_us_countytax_rule_rec.LIT_EXEMPT
       ,p_sd_exempt                      => l_pay_us_countytax_rule_rec.SD_EXEMPT
       ,p_ht_exempt                      => l_pay_us_countytax_rule_rec.HT_EXEMPT
       ,p_school_district_code           => l_pay_us_countytax_rule_rec.SCHOOL_DISTRICT_CODE
       ,p_object_version_number          => ln_ovn
       ,p_effective_date                 => l_effective_date
       ,p_datetrack_mode                 => l_datetrack_update_mode
       );

Line: 343


      hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');

Line: 345


    elsif p_dp_mode = 'INSERT' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 379


    if p_dp_mode = 'UPDATE' then

       hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 390


      ,p_update                => l_dt_update
      ,p_update_override       => l_dt_upd_override
      ,p_update_change_insert  => l_upd_chg_ins
       );

Line: 395


        IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 398


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 408


          l_datetrack_update_mode := 'CORRECTION';

Line: 409


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 415


         pay_city_tax_rule_api.update_city_tax_rule
         (P_DATETRACK_MODE                 => l_datetrack_update_mode
         ,P_EFFECTIVE_DATE                 => l_effective_date
         ,P_ADDITIONAL_WA_RATE             => l_pay_us_citytax_rule_rec.ADDITIONAL_WA_RATE
         ,P_FILING_STATUS_CODE             => l_pay_us_citytax_rule_rec.FILING_STATUS_CODE
         ,P_LIT_ADDITIONAL_TAX             => l_pay_us_citytax_rule_rec.LIT_ADDITIONAL_TAX
         ,P_LIT_OVERRIDE_AMOUNT            => l_pay_us_citytax_rule_rec.LIT_OVERRIDE_AMOUNT
         ,P_LIT_OVERRIDE_RATE              => l_pay_us_citytax_rule_rec.LIT_OVERRIDE_RATE
         ,P_WITHHOLDING_ALLOWANCES         => l_pay_us_citytax_rule_rec.WITHHOLDING_ALLOWANCES
         ,P_LIT_EXEMPT                     => l_pay_us_citytax_rule_rec.LIT_EXEMPT
         ,P_SD_EXEMPT                      => l_pay_us_citytax_rule_rec.SD_EXEMPT
         ,P_HT_EXEMPT                      => l_pay_us_citytax_rule_rec.HT_EXEMPT
         ,P_SCHOOL_DISTRICT_CODE           => l_pay_us_citytax_rule_rec.SCHOOL_DISTRICT_CODE
         ,p_emp_city_tax_rule_id           => l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID
         ,p_object_version_number          => ln_ovn
         ,p_effective_start_date           => ld_eff_start_date
         ,p_effective_end_date             => ld_eff_end_date
         );

Line: 434


         hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');

Line: 436


    elsif p_dp_mode = 'INSERT' then

         hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 469


    if p_dp_mode = 'UPDATE' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 480


     ,p_update                => l_dt_update
     ,p_update_override       => l_dt_upd_override
     ,p_update_change_insert  => l_upd_chg_ins
      );

Line: 485


       IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 488


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 498


          l_datetrack_update_mode := 'CORRECTION';

Line: 499


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 504


      pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf
      (P_ASSIGNMENT_ID 				=> l_pay_ca_fedtax_rule_rec.ASSIGNMENT_ID
      ,P_LEGISLATION_CODE                       => l_pay_ca_fedtax_rule_rec.LEGISLATION_CODE
      ,P_EMPLOYMENT_PROVINCE 			=> l_pay_ca_fedtax_rule_rec.EMPLOYMENT_PROVINCE
      ,P_TAX_CREDIT_AMOUNT 			=> l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT
      ,P_BASIC_EXEMPTION_FLAG 			=> l_pay_ca_fedtax_rule_rec.BASIC_EXEMPTION_FLAG
      ,P_ADDITIONAL_TAX 			=> l_pay_ca_fedtax_rule_rec.ADDITIONAL_TAX
      ,P_ANNUAL_DEDN 				=> l_pay_ca_fedtax_rule_rec.ANNUAL_DEDN
      ,P_TOTAL_EXPENSE_BY_COMMISSION 		=> l_pay_ca_fedtax_rule_rec.TOTAL_EXPENSE_BY_COMMISSION
      ,P_TOTAL_REMNRTN_BY_COMMISSION 		=> l_pay_ca_fedtax_rule_rec.TOTAL_REMNRTN_BY_COMMISSION
      ,P_PRESCRIBED_ZONE_DEDN_AMT 		=> l_pay_ca_fedtax_rule_rec.PRESCRIBED_ZONE_DEDN_AMT
      ,P_CPP_QPP_EXEMPT_FLAG 			=> l_pay_ca_fedtax_rule_rec.CPP_QPP_EXEMPT_FLAG
      ,P_FED_EXEMPT_FLAG 			=> l_pay_ca_fedtax_rule_rec.FED_EXEMPT_FLAG
      ,P_EI_EXEMPT_FLAG 			=> l_pay_ca_fedtax_rule_rec.EI_EXEMPT_FLAG
      ,P_FED_OVERRIDE_AMOUNT 			=> l_pay_ca_fedtax_rule_rec.FED_OVERRIDE_AMOUNT
      ,P_FED_OVERRIDE_RATE 			=> l_pay_ca_fedtax_rule_rec.FED_OVERRIDE_RATE
      ,P_OTHER_FEDTAX_CREDITS                   => l_pay_ca_fedtax_rule_rec.OTHER_FEDTAX_CREDITS
      ,P_CA_TAX_INFORMATION_CATEGORY 		=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION_CATEGORY
      ,P_CA_TAX_INFORMATION1 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION1
      ,P_CA_TAX_INFORMATION2 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION2
      ,P_CA_TAX_INFORMATION3 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION3
      ,P_CA_TAX_INFORMATION4 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION4
      ,P_CA_TAX_INFORMATION5 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION5
      ,P_CA_TAX_INFORMATION6 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION6
      ,P_CA_TAX_INFORMATION7 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION7
      ,P_CA_TAX_INFORMATION8 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION8
      ,P_CA_TAX_INFORMATION9 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION9
      ,P_CA_TAX_INFORMATION10 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION10
      ,P_CA_TAX_INFORMATION11 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION11
      ,P_CA_TAX_INFORMATION12 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION12
      ,P_CA_TAX_INFORMATION13 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION13
      ,P_CA_TAX_INFORMATION14 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION14
      ,P_CA_TAX_INFORMATION15 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION15
      ,P_CA_TAX_INFORMATION16 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION16
      ,P_CA_TAX_INFORMATION17 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION17
      ,P_CA_TAX_INFORMATION18 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION18
      ,P_CA_TAX_INFORMATION19 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION19
      ,P_CA_TAX_INFORMATION20 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION20
      ,P_CA_TAX_INFORMATION21 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION21
      ,P_CA_TAX_INFORMATION22 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION22
      ,P_CA_TAX_INFORMATION23 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION23
      ,P_CA_TAX_INFORMATION24 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION24
      ,P_CA_TAX_INFORMATION25 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION25
      ,P_CA_TAX_INFORMATION26 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION26
      ,P_CA_TAX_INFORMATION27 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION27
      ,P_CA_TAX_INFORMATION28 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION28
      ,P_CA_TAX_INFORMATION29 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION29
      ,P_CA_TAX_INFORMATION30 			=> l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION30
      ,P_FED_LSF_AMOUNT 			=> l_pay_ca_fedtax_rule_rec.FED_LSF_AMOUNT
      ,p_emp_fed_tax_inf_id                     => l_pay_ca_fedtax_rule_rec.emp_fed_tax_inf_id
      ,P_EFFECTIVE_DATE 			=> l_effective_date
      ,P_DATETRACK_MODE 			=> l_datetrack_update_mode
      ,p_effective_start_date                   => ld_eff_start_date
      ,p_effective_end_date                     => ld_eff_end_date
      ,p_object_version_number                  => ln_ovn);

Line: 560


    hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');

Line: 562


   elsif p_dp_mode = 'INSERT' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 629


    if p_dp_mode = 'UPDATE' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 640


     ,p_update                => l_dt_update
     ,p_update_override       => l_dt_upd_override
     ,p_update_change_insert  => l_upd_chg_ins
      );

Line: 646


       IF l_dt_update THEN

          l_datetrack_update_mode := 'UPDATE';

Line: 649


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 659


          l_datetrack_update_mode := 'CORRECTION';

Line: 660


          hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);

Line: 665


       PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf
        (p_emp_province_tax_inf_id       => l_pay_ca_provtax_rule_rec.EMP_PROVINCE_TAX_INF_ID
        ,P_LEGISLATION_CODE                => l_pay_ca_provtax_rule_rec.LEGISLATION_CODE
        ,P_ASSIGNMENT_ID                   => l_pay_ca_provtax_rule_rec.ASSIGNMENT_ID
        ,P_PROVINCE_CODE                   => l_pay_ca_provtax_rule_rec.PROVINCE_CODE
        ,P_TAX_CREDIT_AMOUNT               => l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT
        ,P_BASIC_EXEMPTION_FLAG            => l_pay_ca_provtax_rule_rec.BASIC_EXEMPTION_FLAG
        ,P_MARRIAGE_STATUS                 => l_pay_ca_provtax_rule_rec.MARRIAGE_STATUS
        ,P_NO_OF_INFIRM_DEPENDANTS         => l_pay_ca_provtax_rule_rec.NO_OF_INFIRM_DEPENDANTS
        ,P_NON_RESIDENT_STATUS             => l_pay_ca_provtax_rule_rec.NON_RESIDENT_STATUS
        ,P_DISABILITY_STATUS               => l_pay_ca_provtax_rule_rec.DISABILITY_STATUS
        ,P_NO_OF_DEPENDANTS                => l_pay_ca_provtax_rule_rec.NO_OF_DEPENDANTS
        ,P_ANNUAL_DEDN                     => l_pay_ca_provtax_rule_rec.ANNUAL_DEDN
        ,P_TOTAL_EXPENSE_BY_COMMISSION     => l_pay_ca_provtax_rule_rec.TOTAL_EXPENSE_BY_COMMISSION
        ,P_TOTAL_REMNRTN_BY_COMMISSION     => l_pay_ca_provtax_rule_rec.TOTAL_REMNRTN_BY_COMMISSION
        ,P_PRESCRIBED_ZONE_DEDN_AMT        => l_pay_ca_provtax_rule_rec.PRESCRIBED_ZONE_DEDN_AMT
        ,P_ADDITIONAL_TAX                  => l_pay_ca_provtax_rule_rec.ADDITIONAL_TAX
        ,P_PROV_OVERRIDE_RATE              => l_pay_ca_provtax_rule_rec.PROV_OVERRIDE_RATE
        ,P_PROV_OVERRIDE_AMOUNT            => l_pay_ca_provtax_rule_rec.PROV_OVERRIDE_AMOUNT
        ,P_PROV_EXEMPT_FLAG                => l_pay_ca_provtax_rule_rec.PROV_EXEMPT_FLAG
        ,P_PMED_EXEMPT_FLAG                => l_pay_ca_provtax_rule_rec.PMED_EXEMPT_FLAG
        ,P_WC_EXEMPT_FLAG                  => l_pay_ca_provtax_rule_rec.WC_EXEMPT_FLAG
        ,P_QPP_EXEMPT_FLAG                 => l_pay_ca_provtax_rule_rec.QPP_EXEMPT_FLAG
        ,P_EXTRA_INFO_NOT_PROVIDED         => l_pay_ca_provtax_rule_rec.EXTRA_INFO_NOT_PROVIDED
        ,P_OTHER_TAX_CREDIT                => l_pay_ca_provtax_rule_rec.OTHER_TAX_CREDIT
        ,P_CA_TAX_INFORMATION_CATEGORY     => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION_CATEGORY
        ,P_CA_TAX_INFORMATION1             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION1
        ,P_CA_TAX_INFORMATION2             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION2
        ,P_CA_TAX_INFORMATION3             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION3
        ,P_CA_TAX_INFORMATION4             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION4
        ,P_CA_TAX_INFORMATION5             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION5
        ,P_CA_TAX_INFORMATION6             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION6
        ,P_CA_TAX_INFORMATION7             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION7
        ,P_CA_TAX_INFORMATION8             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION8
        ,P_CA_TAX_INFORMATION9             => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION9
        ,P_CA_TAX_INFORMATION10            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION10
        ,P_CA_TAX_INFORMATION11            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION11
        ,P_CA_TAX_INFORMATION12            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION12
        ,P_CA_TAX_INFORMATION13            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION13
        ,P_CA_TAX_INFORMATION14            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION14
        ,P_CA_TAX_INFORMATION15            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION15
        ,P_CA_TAX_INFORMATION16            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION16
        ,P_CA_TAX_INFORMATION17            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION17
        ,P_CA_TAX_INFORMATION18            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION18
        ,P_CA_TAX_INFORMATION19            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION19
        ,P_CA_TAX_INFORMATION20            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION20
        ,P_CA_TAX_INFORMATION21            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION21
        ,P_CA_TAX_INFORMATION22            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION22
        ,P_CA_TAX_INFORMATION23            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION23
        ,P_CA_TAX_INFORMATION24            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION24
        ,P_CA_TAX_INFORMATION25            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION25
        ,P_CA_TAX_INFORMATION26            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION26
        ,P_CA_TAX_INFORMATION27            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION27
        ,P_CA_TAX_INFORMATION28            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION28
        ,P_CA_TAX_INFORMATION29            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION29
        ,P_CA_TAX_INFORMATION30            => l_pay_ca_provtax_rule_rec.CA_TAX_INFORMATION30
        ,P_PROV_LSP_AMOUNT                 => l_pay_ca_provtax_rule_rec.PROV_LSP_AMOUNT
        ,P_EFFECTIVE_DATE                  => l_effective_date
        ,P_DATETRACK_MODE 		   => l_datetrack_update_mode
	,p_effective_start_date            => ld_eff_start_date
        ,p_effective_end_date              => ld_eff_end_date
        ,p_object_version_number           => ln_ovn);

Line: 728


    hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');

Line: 730


   elsif p_dp_mode = 'INSERT' then

      hr_utility.trace('p_dp_mode :'||p_dp_mode);

Line: 950


  select ftr.EMP_FED_TAX_RULE_ID,ftr.object_version_number
  from pay_us_emp_fed_tax_rules_f ftr
  where ftr.assignment_id = cp_asg_id
  and p_effective_date between ftr.effective_start_date and ftr.effective_end_date
  and ftr.business_group_id = p_business_group;

Line: 959


  select str.EMP_STATE_TAX_RULE_ID,str.object_version_number
  from PAY_US_EMP_STATE_TAX_RULES_F str
  where str.assignment_id = cp_asg_id
  and p_effective_date between str.effective_start_date and str.effective_end_date
  and str.business_group_id =  p_business_group
  and str.state_code = ltrim(rtrim(p_state_prov_code));

Line: 969


  select ctr.EMP_COUNTY_TAX_RULE_ID,ctr.object_version_number
  from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
  where ctr.assignment_id = cp_asg_id
  and p_effective_date between ctr.effective_start_date and ctr.effective_end_date
  and ctr.business_group_id =  p_business_group
  and ctr.state_code = ltrim(rtrim(p_state_prov_code))
  and ctr.county_code = ltrim(rtrim(cp_county_code));

Line: 979


  select county_code
  from pay_us_counties
  where state_code = ltrim(rtrim(p_state_prov_code))
  and county_name = ltrim(rtrim(p_county));

Line: 986


  select school_dst_code
  from pay_us_county_school_dsts
  where state_code = ltrim(rtrim(p_state_prov_code))
  and county_code = cp_county_code
  and school_dst_name = ltrim(rtrim(P_SCHOOL_DISTRICT));

Line: 996


  select ctr.EMP_CITY_TAX_RULE_ID,ctr.object_version_number
  from PAY_US_EMP_CITY_TAX_RULES_F ctr
  where ctr.assignment_id = cp_asg_id
  and ctr.business_group_id =  p_business_group
  and p_effective_date between ctr.effective_start_date and ctr.effective_end_date
  and ctr.state_code = ltrim(rtrim(p_state_prov_code))
  and ctr.county_code = ltrim(rtrim(cp_county_code))
  and ctr.city_code = ltrim(rtrim(cp_city_code));

Line: 1007


  select city_code
  from pay_us_city_names
  where state_code = ltrim(rtrim(p_state_prov_code))
  and county_code = ltrim(rtrim(cp_county_code))
  and city_name = ltrim(rtrim(p_city));

Line: 1017


  select SCHOOL_DST_CODE
  from PAY_US_CITY_SCHOOL_DSTS
  where state_code = ltrim(rtrim(p_state_prov_code))
  and county_code = cp_county_code
  and city_code = cp_city_code
  and SCHOOL_DST_NAME = ltrim(rtrim(P_SCHOOL_DISTRICT));

Line: 1026


  select paf.assignment_id
  from per_all_assignments_f paf,
       per_all_people_f ppf
  where ppf.full_name = p_employee
  and ppf.person_id = paf.person_id
  and ppf.business_group_id = p_business_group
  and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
  and paf.assignment_number = p_assignment
  and p_effective_date between paf.effective_start_date and paf.effective_end_date
  and paf.business_group_id =  p_business_group;

Line: 1040


  select lookup_code
  from hr_lookups
  where lookup_type = cp_lookup_type
  and meaning = cp_meaning;

Line: 1047


  select ftr.EMP_FED_TAX_INF_ID,ftr.object_version_number
  from PAY_CA_EMP_FED_TAX_INFO_F ftr
  where ftr.assignment_id = cp_asg_id
  and p_effective_date between ftr.effective_start_date and ftr.effective_end_date
  and ftr.business_group_id =  p_business_group;

Line: 1056


  select pti.EMP_PROVINCE_TAX_INF_ID,pti.object_version_number
  from PAY_CA_EMP_PROV_TAX_INFO_F pti
  where pti.assignment_id = cp_asg_id
  and p_effective_date between pti.effective_start_date and pti.effective_end_date
  and pti.business_group_id =  p_business_group
  and pti.province_code = ltrim(rtrim(p_state_prov_code));

Line: 1271


       HR_DataPump( p_dp_mode                 => 'UPDATE'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1279


       HR_DataPump( p_dp_mode                 => 'INSERT'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1330


                   p_dp_mode                 => 'UPDATE'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1339


                   p_dp_mode                 => 'INSERT'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1393


                   p_dp_mode                 => 'UPDATE'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1402


                   p_dp_mode                 => 'INSERT'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1485


                   p_dp_mode                 => 'UPDATE'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1494


                   p_dp_mode                 => 'INSERT'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1606


                    p_dp_mode                 => 'UPDATE'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );

Line: 1616


                   p_dp_mode                 => 'INSERT'
                   ,p_effective_date          => p_effective_date
                   ,p_spreadsheet_identifier  => p_spreadsheet_identifier
                  );