DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PAY_FED_UPD

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

4415: else
4416: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4417: end if;
4418: close csr_fed_rule_exists;
4419: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);
4420: maintain_wc(
4421: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4422: ,p_effective_start_date => l_fed_rec.effective_start_date
4423: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4451: -- correct the federal record. Do the same for the workers comp entry.
4452: --
4453: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4454: --
4455: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4456: maintain_wc(
4457: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4458: ,p_effective_start_date => l_fed_rec.effective_start_date
4459: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4469: else
4470: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4471: end if;
4472: close csr_fed_rule_exists;
4473: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4474: maintain_wc(
4475: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4476: ,p_effective_start_date => l_fed_rec.effective_start_date
4477: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4582:
4583: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4584: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4585:
4586: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4587: 'CORRECTION');
4588: maintain_wc(
4589: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4590: ,p_effective_start_date => l_fed_rec.effective_start_date

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

4625: -- correct the federal record. Do the same for the workers comp entry.
4626: --
4627: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4628: --
4629: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4630: maintain_wc(
4631: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4632: ,p_effective_start_date => l_fed_rec.effective_start_date
4633: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4643: else
4644: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4645: end if;
4646: close csr_fed_rule_exists;
4647: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4648: maintain_wc(
4649: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4650: ,p_effective_start_date => l_fed_rec.effective_start_date
4651: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4756: /* changes for bug 1970341 possible a DB issue. */
4757:
4758: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4759: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4760: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4761: 'CORRECTION');
4762: maintain_wc(
4763: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4764: ,p_effective_start_date => l_fed_rec.effective_start_date

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

4801: else
4802: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4803: end if;
4804: close csr_fed_rule_exists;
4805: pay_fed_upd.upd(l_fed_rec, l_chg_effective_end_date + 1, l_dt_mode);
4806: maintain_wc(
4807: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4808: ,p_effective_start_date => l_fed_rec.effective_start_date
4809: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4837: -- correct the federal record. Do the same for the workers comp entry.
4838: --
4839: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
4840: --
4841: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
4842: maintain_wc(
4843: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4844: ,p_effective_start_date => l_fed_rec.effective_start_date
4845: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4855: else
4856: l_dt_mode := 'UPDATE_CHANGE_INSERT';
4857: end if;
4858: close csr_fed_rule_exists;
4859: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
4860: maintain_wc(
4861: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4862: ,p_effective_start_date => l_fed_rec.effective_start_date
4863: ,p_effective_end_date => l_fed_rec.effective_end_date

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

4969: /* changes for bug 1970341 possible a DB issue. */
4970:
4971: l_fed_rec_dup.sui_state_code := l_sui_state_code;
4972: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
4973: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
4974: 'CORRECTION');
4975: maintain_wc(
4976: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
4977: ,p_effective_start_date => l_fed_rec.effective_start_date

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

5011: -- correct the federal record. Do the same for the workers comp entry.
5012: --
5013: if l_fed_rec.effective_start_date = l_chg_effective_start_date then
5014: --
5015: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, 'CORRECTION');
5016: maintain_wc(
5017: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
5018: ,p_effective_start_date => l_fed_rec.effective_start_date
5019: ,p_effective_end_date => l_fed_rec.effective_end_date

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

5029: else
5030: l_dt_mode := 'UPDATE_CHANGE_INSERT';
5031: end if;
5032: close csr_fed_rule_exists;
5033: pay_fed_upd.upd(l_fed_rec, l_chg_effective_start_date, l_dt_mode);
5034: maintain_wc(
5035: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
5036: ,p_effective_start_date => l_fed_rec.effective_start_date
5037: ,p_effective_end_date => l_fed_rec.effective_end_date

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

5142: /* changes for bug 1970341 possible a DB issue. */
5143:
5144: l_fed_rec_dup.sui_state_code := l_sui_state_code;
5145: l_fed_rec_dup.sui_jurisdiction_code := l_sui_state_code || '-000-0000';
5146: pay_fed_upd.upd(l_fed_rec_dup, l_fed_rec_dup.effective_start_date,
5147: 'CORRECTION');
5148: maintain_wc(
5149: p_emp_fed_tax_rule_id => l_fed_rec.emp_fed_tax_rule_id
5150: ,p_effective_start_date => l_fed_rec.effective_start_date

Line 6179: pay_fed_upd.upd(p_rec => l_fed_rec_dup

6175: if l_fed_rec_dup.effective_start_date <> p_new_default_date then
6176: open csr_future_fed_rule(l_fed_rec_dup.effective_end_date);
6177: fetch csr_future_fed_rule into l_temp_char;
6178: if csr_future_fed_rule%notfound then
6179: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6180: ,p_effective_date => p_new_default_date
6181: ,p_datetrack_mode => 'UPDATE');
6182: else
6183: pay_fed_upd.upd(p_rec => l_fed_rec_dup

Line 6183: pay_fed_upd.upd(p_rec => l_fed_rec_dup

6179: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6180: ,p_effective_date => p_new_default_date
6181: ,p_datetrack_mode => 'UPDATE');
6182: else
6183: pay_fed_upd.upd(p_rec => l_fed_rec_dup
6184: ,p_effective_date => p_new_default_date
6185: ,p_datetrack_mode => 'UPDATE_CHANGE_INSERT');
6186: end if;
6187: close csr_future_fed_rule;

Line 6622: pay_fed_upd.upd(p_rec => l_fed_rec

6618: fetch csr_fed_rec into l_fed_rec;
6619: open csr_future_fed_rule(l_fed_rec.effective_end_date);
6620: fetch csr_future_fed_rule into l_temp_char;
6621: if csr_future_fed_rule%notfound then
6622: pay_fed_upd.upd(p_rec => l_fed_rec
6623: ,p_effective_date => l_defaulting_date
6624: ,p_datetrack_mode => 'UPDATE');
6625: else
6626: pay_fed_upd.upd(p_rec => l_fed_rec

Line 6626: pay_fed_upd.upd(p_rec => l_fed_rec

6622: pay_fed_upd.upd(p_rec => l_fed_rec
6623: ,p_effective_date => l_defaulting_date
6624: ,p_datetrack_mode => 'UPDATE');
6625: else
6626: pay_fed_upd.upd(p_rec => l_fed_rec
6627: ,p_effective_date => l_defaulting_date
6628: ,p_datetrack_mode => 'UPDATE_CHANGE_INSERT');
6629: end if;
6630: close csr_future_fed_rule;

Line 6648: pay_fed_upd.upd(p_rec => l_fed_rec

6644: open csr_fed_rec(p_assignment_id, l_new_default_date);
6645: fetch csr_fed_rec into l_fed_rec;
6646: l_fed_rec.sui_state_code := l_loc_ovrd_state_code;
6647: l_fed_rec.sui_jurisdiction_code := l_loc_ovrd_state_code||'-000-0000';
6648: pay_fed_upd.upd(p_rec => l_fed_rec
6649: ,p_effective_date => l_new_default_date
6650: ,p_datetrack_mode => 'CORRECTION');
6651: close csr_fed_rec;
6652: --

Line 7028: pay_fed_upd.upd(p_rec => l_fed_rec_dup

7024: l_fed_rec_dup.fed_information30 := l_fed_rec.fed_information30;
7025:
7026: /* changes for bug 1970341 possible a DB issue. */
7027:
7028: pay_fed_upd.upd(p_rec => l_fed_rec_dup
7029: ,p_effective_date => l_fed_rec_dup.effective_start_date
7030: ,p_datetrack_mode => 'CORRECTION');
7031: maintain_wc(
7032: p_emp_fed_tax_rule_id => l_emp_fed_tax_rule_id