DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PAY_FED_UPD

Line 4335: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);

4331: else
4332: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4333: end if;
4334: close csr_fed_rule_exists;
4335: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);
4336: maintain_wc(
4337: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4338: ,p_effective_start_date => l_fed_rec.effective_start_date
4339: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4371: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');

4367: -- correct the federal record. Do the same for the workers comp entry.
4368: --
4369: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4370: --
4371: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4372: maintain_wc(
4373: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4374: ,p_effective_start_date => l_fed_rec.effective_start_date
4375: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4389: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);

4385: else
4386: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4387: end if;
4388: close csr_fed_rule_exists;
4389: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4390: maintain_wc(
4391: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4392: ,p_effective_start_date => l_fed_rec.effective_start_date
4393: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4502: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,

4498:
4499: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4500: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4501:
4502: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4503: 'CORRECTION');
4504: maintain_wc(
4505: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4506: ,p_effective_start_date => l_fed_rec.effective_start_date

Line 4545: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');

4541: -- correct the federal record. Do the same for the workers comp entry.
4542: --
4543: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4544: --
4545: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4546: maintain_wc(
4547: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4548: ,p_effective_start_date => l_fed_rec.effective_start_date
4549: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4563: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);

4559: else
4560: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4561: end if;
4562: close csr_fed_rule_exists;
4563: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4564: maintain_wc(
4565: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4566: ,p_effective_start_date => l_fed_rec.effective_start_date
4567: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4676: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,

4672: /* changes for bug 1970341 possible a DB issue. */
4673:
4674: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4675: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4676: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4677: 'CORRECTION');
4678: maintain_wc(
4679: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4680: ,p_effective_start_date => l_fed_rec.effective_start_date

Line 4721: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);

4717: else
4718: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4719: end if;
4720: close csr_fed_rule_exists;
4721: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);
4722: maintain_wc(
4723: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4724: ,p_effective_start_date => l_fed_rec.effective_start_date
4725: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4757: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');

4753: -- correct the federal record. Do the same for the workers comp entry.
4754: --
4755: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4756: --
4757: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4758: maintain_wc(
4759: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4760: ,p_effective_start_date => l_fed_rec.effective_start_date
4761: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4775: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);

4771: else
4772: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4773: end if;
4774: close csr_fed_rule_exists;
4775: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4776: maintain_wc(
4777: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4778: ,p_effective_start_date => l_fed_rec.effective_start_date
4779: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4889: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,

4885: /* changes for bug 1970341 possible a DB issue. */
4886:
4887: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4888: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4889: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4890: 'CORRECTION');
4891: maintain_wc(
4892: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4893: ,p_effective_start_date => l_fed_rec.effective_start_date

Line 4931: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');

4927: -- correct the federal record. Do the same for the workers comp entry.
4928: --
4929: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4930: --
4931: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4932: maintain_wc(
4933: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4934: ,p_effective_start_date => l_fed_rec.effective_start_date
4935: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 4949: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);

4945: else
4946: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4947: end if;
4948: close csr_fed_rule_exists;
4949: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4950: maintain_wc(
4951: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4952: ,p_effective_start_date => l_fed_rec.effective_start_date
4953: ,p_effective_end_date => l_fed_rec.effective_end_date

Line 5062: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,

5058: /* changes for bug 1970341 possible a DB issue. */
5059:
5060: l_fed_rec_dup.sui_state_code := l_sui_state_code;
5061: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
5062: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
5063: 'CORRECTION');
5064: maintain_wc(
5065: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
5066: ,p_effective_start_date => l_fed_rec.effective_start_date

Line 6095: pay_fed_upd.upd(p_rec => l_fed_rec_dup

6091: if l_fed_rec_dup.effective_start_date <> p_new_default_date then
6092: open csr_future_fed_rule(l_fed_rec_dup.effective_end_date);
6093: fetch csr_future_fed_rule into l_temp_char;
6094: if csr_future_fed_rule%notfound then
6095: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6096: ,p_effective_date => p_new_default_date
6097: ,p_datetrack_mode => 'UPDATE');
6098: else
6099: pay_fed_upd.upd(p_rec => l_fed_rec_dup

Line 6099: pay_fed_upd.upd(p_rec => l_fed_rec_dup

6095: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6096: ,p_effective_date => p_new_default_date
6097: ,p_datetrack_mode => 'UPDATE');
6098: else
6099: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6100: ,p_effective_date => p_new_default_date
6101: ,p_datetrack_mode => 'UPDATE_CHANGE_INSERT');
6102: end if;
6103: close csr_future_fed_rule;

Line 6538: pay_fed_upd.upd(p_rec => l_fed_rec

6534: fetch csr_fed_rec into l_fed_rec;
6535: open csr_future_fed_rule(l_fed_rec.effective_end_date);
6536: fetch csr_future_fed_rule into l_temp_char;
6537: if csr_future_fed_rule%notfound then
6538: pay_fed_upd.upd(p_rec => l_fed_rec
6539: ,p_effective_date => l_defaulting_date
6540: ,p_datetrack_mode => 'UPDATE');
6541: else
6542: pay_fed_upd.upd(p_rec => l_fed_rec

Line 6542: pay_fed_upd.upd(p_rec => l_fed_rec

6538: pay_fed_upd.upd(p_rec => l_fed_rec
6539: ,p_effective_date => l_defaulting_date
6540: ,p_datetrack_mode => 'UPDATE');
6541: else
6542: pay_fed_upd.upd(p_rec => l_fed_rec
6543: ,p_effective_date => l_defaulting_date
6544: ,p_datetrack_mode => 'UPDATE_CHANGE_INSERT');
6545: end if;
6546: close csr_future_fed_rule;

Line 6564: pay_fed_upd.upd(p_rec => l_fed_rec

6560: open csr_fed_rec(p_assignment_id, l_new_default_date);
6561: fetch csr_fed_rec into l_fed_rec;
6562: l_fed_rec.sui_state_code := l_loc_ovrd_state_code;
6563: l_fed_rec.sui_jurisdiction_code := l_loc_ovrd_state_code||'-000-0000';
6564: pay_fed_upd.upd(p_rec => l_fed_rec
6565: ,p_effective_date => l_new_default_date
6566: ,p_datetrack_mode => 'CORRECTION');
6567: close csr_fed_rec;
6568: --

Line 6944: pay_fed_upd.upd(p_rec => l_fed_rec_dup

6940: l_fed_rec_dup.fed_information30 := l_fed_rec.fed_information30;
6941:
6942: /* changes for bug 1970341 possible a DB issue. */
6943:
6944: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6945: ,p_effective_date => l_fed_rec_dup.effective_start_date
6946: ,p_datetrack_mode => 'CORRECTION');
6947: maintain_wc(
6948: p_emp_fed_tax_rule_id => l_emp_fed_tax_rule_id