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_FED_UPD dependencies on PAY_FED_SHD

Line 58: (p_rec in out nocopy pay_fed_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_fed_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 81: pay_fed_shd.g_api_dml := true; -- Set the api dml status

77: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
78: p_base_key_column => 'emp_fed_tax_rule_id',
79: p_base_key_value => p_rec.emp_fed_tax_rule_id);
80: --
81: pay_fed_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the pay_us_emp_fed_tax_rules_f Row
84: --
85: update pay_us_emp_fed_tax_rules_f

Line 176: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

172: where emp_fed_tax_rule_id = p_rec.emp_fed_tax_rule_id
173: and effective_start_date = p_validation_start_date
174: and effective_end_date = p_validation_end_date;
175: --
176: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: -- Set the effective start and end dates
179: --
180: p_rec.effective_start_date := p_validation_start_date;

Line 188: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

184: hr_utility.set_location(' Leaving:'||l_proc, 15);
185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
189: pay_fed_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.unique_integrity_violated Then
192: -- Unique integrity has been violated

Line 189: pay_fed_shd.constraint_error

185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
189: pay_fed_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.unique_integrity_violated Then
192: -- Unique integrity has been violated
193: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

Line 193: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

189: pay_fed_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.unique_integrity_violated Then
192: -- Unique integrity has been violated
193: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
194: pay_fed_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When Others Then
197: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

Line 194: pay_fed_shd.constraint_error

190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.unique_integrity_violated Then
192: -- Unique integrity has been violated
193: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
194: pay_fed_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When Others Then
197: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
198: Raise;

Line 197: pay_fed_shd.g_api_dml := false; -- Unset the api dml status

193: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
194: pay_fed_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When Others Then
197: pay_fed_shd.g_api_dml := false; -- Unset the api dml status
198: Raise;
199: End dt_update_dml;
200: --
201: -- ----------------------------------------------------------------------------

Line 233: (p_rec in out nocopy pay_fed_shd.g_rec_type,

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure update_dml
233: (p_rec in out nocopy pay_fed_shd.g_rec_type,
234: p_effective_date in date,
235: p_datetrack_mode in varchar2,
236: p_validation_start_date in date,
237: p_validation_end_date in date) is

Line 297: (p_rec in out nocopy pay_fed_shd.g_rec_type,

293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure dt_pre_update
297: (p_rec in out nocopy pay_fed_shd.g_rec_type,
298: p_effective_date in date,
299: p_datetrack_mode in varchar2,
300: p_validation_start_date in date,
301: p_validation_end_date in date) is

Line 313: pay_fed_shd.upd_effective_end_date

309: hr_utility.set_location(l_proc, 10);
310: --
311: -- Update the current effective end date
312: --
313: pay_fed_shd.upd_effective_end_date
314: (p_effective_date => p_effective_date,
315: p_base_key_value => p_rec.emp_fed_tax_rule_id,
316: p_new_effective_end_date => (p_validation_start_date - 1),
317: p_validation_start_date => p_validation_start_date,

Line 382: (p_rec in out nocopy pay_fed_shd.g_rec_type,

378: --
379: -- {End Of Comments}
380: -- ----------------------------------------------------------------------------
381: Procedure pre_update
382: (p_rec in out nocopy pay_fed_shd.g_rec_type,
383: p_effective_date in date,
384: p_datetrack_mode in varchar2,
385: p_validation_start_date in date,
386: p_validation_end_date in date) is

Line 438: (p_rec in pay_fed_shd.g_rec_type,

434: --
435: -- {End Of Comments}
436: -- ----------------------------------------------------------------------------
437: Procedure post_update
438: (p_rec in pay_fed_shd.g_rec_type,
439: p_effective_date in date,
440: p_datetrack_mode in varchar2,
441: p_validation_start_date in date,
442: p_validation_end_date in date) is

Line 483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date

479: ,p_effective_date =>p_effective_date
480: ,p_datetrack_mode =>p_datetrack_mode
481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code

Line 484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date

480: ,p_datetrack_mode =>p_datetrack_mode
481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id

Line 485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id

481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount

Line 486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code

482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code

Line 487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code

483: ,p_effective_start_date_o =>pay_fed_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount

Line 488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id

484: ,p_effective_end_date_o =>pay_fed_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate

Line 489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount

485: ,p_assignment_id_o =>pay_fed_shd.g_old_rec.assignment_id
486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances

Line 490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code

486: ,p_sui_state_code_o =>pay_fed_shd.g_old_rec.sui_state_code
487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation

Line 491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount

487: ,p_sui_jurisdiction_code_o =>pay_fed_shd.g_old_rec.sui_jurisdiction_code
488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code

Line 492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate

488: ,p_business_group_id_o =>pay_fed_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax

Line 493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances

489: ,p_additional_wa_amount_o =>pay_fed_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt

Line 494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation

490: ,p_filing_status_code_o =>pay_fed_shd.g_old_rec.filing_status_code
491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt

Line 495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code

491: ,p_fit_override_amount_o =>pay_fed_shd.g_old_rec.fit_override_amount
492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt

Line 496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax

492: ,p_fit_override_rate_o =>pay_fed_shd.g_old_rec.fit_override_rate
493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt

Line 497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt

493: ,p_withholding_allowances_o =>pay_fed_shd.g_old_rec.withholding_allowances
494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt

Line 498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt

494: ,p_cumulative_taxation_o =>pay_fed_shd.g_old_rec.cumulative_taxation
495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee

Line 499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt

495: ,p_eic_filing_status_code_o =>pay_fed_shd.g_old_rec.eic_filing_status_code
496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year

Line 500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt

496: ,p_fit_additional_tax_o =>pay_fed_shd.g_old_rec.fit_additional_tax
497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate

Line 501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt

497: ,p_fit_exempt_o =>pay_fed_shd.g_old_rec.fit_exempt
498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date

Line 502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee

498: ,p_futa_tax_exempt_o =>pay_fed_shd.g_old_rec.futa_tax_exempt
499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date
506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number

Line 503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year

499: ,p_medicare_tax_exempt_o =>pay_fed_shd.g_old_rec.medicare_tax_exempt
500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date
506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number
507: );

Line 504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate

500: ,p_ss_tax_exempt_o =>pay_fed_shd.g_old_rec.ss_tax_exempt
501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date
506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number
507: );
508: --

Line 505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date

501: ,p_wage_exempt_o =>pay_fed_shd.g_old_rec.wage_exempt
502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date
506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number
507: );
508: --
509: exception

Line 506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number

502: ,p_statutory_employee_o =>pay_fed_shd.g_old_rec.statutory_employee
503: ,p_w2_filed_year_o =>pay_fed_shd.g_old_rec.w2_filed_year
504: ,p_supp_tax_override_rate_o =>pay_fed_shd.g_old_rec.supp_tax_override_rate
505: ,p_excessive_wa_reject_date_o =>pay_fed_shd.g_old_rec.excessive_wa_reject_date
506: ,p_object_version_number_o =>pay_fed_shd.g_old_rec.object_version_number
507: );
508: --
509: exception
510: --

Line 571: Procedure convert_defs(p_rec in out nocopy pay_fed_shd.g_rec_type) is

567: -- Internal Row Handler Use Only.
568: --
569: -- {End Of Comments}
570: -- ----------------------------------------------------------------------------
571: Procedure convert_defs(p_rec in out nocopy pay_fed_shd.g_rec_type) is
572: --
573: l_proc varchar2(72) := g_package||'convert_defs';
574: --
575: Begin

Line 586: pay_fed_shd.g_old_rec.assignment_id;

582: -- is being used then we must set to the 'current' argument value.
583: --
584: If (p_rec.assignment_id = hr_api.g_number) then
585: p_rec.assignment_id :=
586: pay_fed_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.sui_state_code = hr_api.g_varchar2) then
589: p_rec.sui_state_code :=
590: pay_fed_shd.g_old_rec.sui_state_code;

Line 590: pay_fed_shd.g_old_rec.sui_state_code;

586: pay_fed_shd.g_old_rec.assignment_id;
587: End If;
588: If (p_rec.sui_state_code = hr_api.g_varchar2) then
589: p_rec.sui_state_code :=
590: pay_fed_shd.g_old_rec.sui_state_code;
591: End If;
592: If (p_rec.sui_jurisdiction_code = hr_api.g_varchar2) then
593: p_rec.sui_jurisdiction_code :=
594: pay_fed_shd.g_old_rec.sui_jurisdiction_code;

Line 594: pay_fed_shd.g_old_rec.sui_jurisdiction_code;

590: pay_fed_shd.g_old_rec.sui_state_code;
591: End If;
592: If (p_rec.sui_jurisdiction_code = hr_api.g_varchar2) then
593: p_rec.sui_jurisdiction_code :=
594: pay_fed_shd.g_old_rec.sui_jurisdiction_code;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: pay_fed_shd.g_old_rec.business_group_id;

Line 598: pay_fed_shd.g_old_rec.business_group_id;

594: pay_fed_shd.g_old_rec.sui_jurisdiction_code;
595: End If;
596: If (p_rec.business_group_id = hr_api.g_number) then
597: p_rec.business_group_id :=
598: pay_fed_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.additional_wa_amount = hr_api.g_number) then
601: p_rec.additional_wa_amount :=
602: pay_fed_shd.g_old_rec.additional_wa_amount;

Line 602: pay_fed_shd.g_old_rec.additional_wa_amount;

598: pay_fed_shd.g_old_rec.business_group_id;
599: End If;
600: If (p_rec.additional_wa_amount = hr_api.g_number) then
601: p_rec.additional_wa_amount :=
602: pay_fed_shd.g_old_rec.additional_wa_amount;
603: End If;
604: If (p_rec.filing_status_code = hr_api.g_varchar2) then
605: p_rec.filing_status_code :=
606: pay_fed_shd.g_old_rec.filing_status_code;

Line 606: pay_fed_shd.g_old_rec.filing_status_code;

602: pay_fed_shd.g_old_rec.additional_wa_amount;
603: End If;
604: If (p_rec.filing_status_code = hr_api.g_varchar2) then
605: p_rec.filing_status_code :=
606: pay_fed_shd.g_old_rec.filing_status_code;
607: End If;
608: If (p_rec.fit_override_amount = hr_api.g_number) then
609: p_rec.fit_override_amount :=
610: pay_fed_shd.g_old_rec.fit_override_amount;

Line 610: pay_fed_shd.g_old_rec.fit_override_amount;

606: pay_fed_shd.g_old_rec.filing_status_code;
607: End If;
608: If (p_rec.fit_override_amount = hr_api.g_number) then
609: p_rec.fit_override_amount :=
610: pay_fed_shd.g_old_rec.fit_override_amount;
611: End If;
612: If (p_rec.fit_override_rate = hr_api.g_number) then
613: p_rec.fit_override_rate :=
614: pay_fed_shd.g_old_rec.fit_override_rate;

Line 614: pay_fed_shd.g_old_rec.fit_override_rate;

610: pay_fed_shd.g_old_rec.fit_override_amount;
611: End If;
612: If (p_rec.fit_override_rate = hr_api.g_number) then
613: p_rec.fit_override_rate :=
614: pay_fed_shd.g_old_rec.fit_override_rate;
615: End If;
616: If (p_rec.withholding_allowances = hr_api.g_number) then
617: p_rec.withholding_allowances :=
618: pay_fed_shd.g_old_rec.withholding_allowances;

Line 618: pay_fed_shd.g_old_rec.withholding_allowances;

614: pay_fed_shd.g_old_rec.fit_override_rate;
615: End If;
616: If (p_rec.withholding_allowances = hr_api.g_number) then
617: p_rec.withholding_allowances :=
618: pay_fed_shd.g_old_rec.withholding_allowances;
619: End If;
620: If (p_rec.cumulative_taxation = hr_api.g_varchar2) then
621: p_rec.cumulative_taxation :=
622: pay_fed_shd.g_old_rec.cumulative_taxation;

Line 622: pay_fed_shd.g_old_rec.cumulative_taxation;

618: pay_fed_shd.g_old_rec.withholding_allowances;
619: End If;
620: If (p_rec.cumulative_taxation = hr_api.g_varchar2) then
621: p_rec.cumulative_taxation :=
622: pay_fed_shd.g_old_rec.cumulative_taxation;
623: End If;
624: If (p_rec.eic_filing_status_code = hr_api.g_varchar2) then
625: p_rec.eic_filing_status_code :=
626: pay_fed_shd.g_old_rec.eic_filing_status_code;

Line 626: pay_fed_shd.g_old_rec.eic_filing_status_code;

622: pay_fed_shd.g_old_rec.cumulative_taxation;
623: End If;
624: If (p_rec.eic_filing_status_code = hr_api.g_varchar2) then
625: p_rec.eic_filing_status_code :=
626: pay_fed_shd.g_old_rec.eic_filing_status_code;
627: End If;
628: If (p_rec.fit_additional_tax = hr_api.g_number) then
629: p_rec.fit_additional_tax :=
630: pay_fed_shd.g_old_rec.fit_additional_tax;

Line 630: pay_fed_shd.g_old_rec.fit_additional_tax;

626: pay_fed_shd.g_old_rec.eic_filing_status_code;
627: End If;
628: If (p_rec.fit_additional_tax = hr_api.g_number) then
629: p_rec.fit_additional_tax :=
630: pay_fed_shd.g_old_rec.fit_additional_tax;
631: End If;
632: If (p_rec.fit_exempt = hr_api.g_varchar2) then
633: p_rec.fit_exempt :=
634: pay_fed_shd.g_old_rec.fit_exempt;

Line 634: pay_fed_shd.g_old_rec.fit_exempt;

630: pay_fed_shd.g_old_rec.fit_additional_tax;
631: End If;
632: If (p_rec.fit_exempt = hr_api.g_varchar2) then
633: p_rec.fit_exempt :=
634: pay_fed_shd.g_old_rec.fit_exempt;
635: End If;
636: If (p_rec.futa_tax_exempt = hr_api.g_varchar2) then
637: p_rec.futa_tax_exempt :=
638: pay_fed_shd.g_old_rec.futa_tax_exempt;

Line 638: pay_fed_shd.g_old_rec.futa_tax_exempt;

634: pay_fed_shd.g_old_rec.fit_exempt;
635: End If;
636: If (p_rec.futa_tax_exempt = hr_api.g_varchar2) then
637: p_rec.futa_tax_exempt :=
638: pay_fed_shd.g_old_rec.futa_tax_exempt;
639: End If;
640: If (p_rec.medicare_tax_exempt = hr_api.g_varchar2) then
641: p_rec.medicare_tax_exempt :=
642: pay_fed_shd.g_old_rec.medicare_tax_exempt;

Line 642: pay_fed_shd.g_old_rec.medicare_tax_exempt;

638: pay_fed_shd.g_old_rec.futa_tax_exempt;
639: End If;
640: If (p_rec.medicare_tax_exempt = hr_api.g_varchar2) then
641: p_rec.medicare_tax_exempt :=
642: pay_fed_shd.g_old_rec.medicare_tax_exempt;
643: End If;
644: If (p_rec.ss_tax_exempt = hr_api.g_varchar2) then
645: p_rec.ss_tax_exempt :=
646: pay_fed_shd.g_old_rec.ss_tax_exempt;

Line 646: pay_fed_shd.g_old_rec.ss_tax_exempt;

642: pay_fed_shd.g_old_rec.medicare_tax_exempt;
643: End If;
644: If (p_rec.ss_tax_exempt = hr_api.g_varchar2) then
645: p_rec.ss_tax_exempt :=
646: pay_fed_shd.g_old_rec.ss_tax_exempt;
647: End If;
648: If (p_rec.wage_exempt = hr_api.g_varchar2) then
649: p_rec.wage_exempt :=
650: pay_fed_shd.g_old_rec.wage_exempt;

Line 650: pay_fed_shd.g_old_rec.wage_exempt;

646: pay_fed_shd.g_old_rec.ss_tax_exempt;
647: End If;
648: If (p_rec.wage_exempt = hr_api.g_varchar2) then
649: p_rec.wage_exempt :=
650: pay_fed_shd.g_old_rec.wage_exempt;
651: End If;
652: If (p_rec.statutory_employee = hr_api.g_varchar2) then
653: p_rec.statutory_employee :=
654: pay_fed_shd.g_old_rec.statutory_employee;

Line 654: pay_fed_shd.g_old_rec.statutory_employee;

650: pay_fed_shd.g_old_rec.wage_exempt;
651: End If;
652: If (p_rec.statutory_employee = hr_api.g_varchar2) then
653: p_rec.statutory_employee :=
654: pay_fed_shd.g_old_rec.statutory_employee;
655: End If;
656: If (p_rec.w2_filed_year = hr_api.g_number) then
657: p_rec.w2_filed_year :=
658: pay_fed_shd.g_old_rec.w2_filed_year;

Line 658: pay_fed_shd.g_old_rec.w2_filed_year;

654: pay_fed_shd.g_old_rec.statutory_employee;
655: End If;
656: If (p_rec.w2_filed_year = hr_api.g_number) then
657: p_rec.w2_filed_year :=
658: pay_fed_shd.g_old_rec.w2_filed_year;
659: End If;
660: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
661: p_rec.supp_tax_override_rate :=
662: pay_fed_shd.g_old_rec.supp_tax_override_rate;

Line 662: pay_fed_shd.g_old_rec.supp_tax_override_rate;

658: pay_fed_shd.g_old_rec.w2_filed_year;
659: End If;
660: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
661: p_rec.supp_tax_override_rate :=
662: pay_fed_shd.g_old_rec.supp_tax_override_rate;
663: End If;
664: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
665: p_rec.excessive_wa_reject_date :=
666: pay_fed_shd.g_old_rec.excessive_wa_reject_date;

Line 666: pay_fed_shd.g_old_rec.excessive_wa_reject_date;

662: pay_fed_shd.g_old_rec.supp_tax_override_rate;
663: End If;
664: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
665: p_rec.excessive_wa_reject_date :=
666: pay_fed_shd.g_old_rec.excessive_wa_reject_date;
667: End If;
668: If (p_rec.attribute_category = hr_api.g_varchar2) then
669: p_rec.attribute_category :=
670: pay_fed_shd.g_old_rec.attribute_category;

Line 670: pay_fed_shd.g_old_rec.attribute_category;

666: pay_fed_shd.g_old_rec.excessive_wa_reject_date;
667: End If;
668: If (p_rec.attribute_category = hr_api.g_varchar2) then
669: p_rec.attribute_category :=
670: pay_fed_shd.g_old_rec.attribute_category;
671: End If;
672: If (p_rec.attribute1 = hr_api.g_varchar2) then
673: p_rec.attribute1 :=
674: pay_fed_shd.g_old_rec.attribute1;

Line 674: pay_fed_shd.g_old_rec.attribute1;

670: pay_fed_shd.g_old_rec.attribute_category;
671: End If;
672: If (p_rec.attribute1 = hr_api.g_varchar2) then
673: p_rec.attribute1 :=
674: pay_fed_shd.g_old_rec.attribute1;
675: End If;
676: If (p_rec.attribute2 = hr_api.g_varchar2) then
677: p_rec.attribute2 :=
678: pay_fed_shd.g_old_rec.attribute2;

Line 678: pay_fed_shd.g_old_rec.attribute2;

674: pay_fed_shd.g_old_rec.attribute1;
675: End If;
676: If (p_rec.attribute2 = hr_api.g_varchar2) then
677: p_rec.attribute2 :=
678: pay_fed_shd.g_old_rec.attribute2;
679: End If;
680: If (p_rec.attribute3 = hr_api.g_varchar2) then
681: p_rec.attribute3 :=
682: pay_fed_shd.g_old_rec.attribute3;

Line 682: pay_fed_shd.g_old_rec.attribute3;

678: pay_fed_shd.g_old_rec.attribute2;
679: End If;
680: If (p_rec.attribute3 = hr_api.g_varchar2) then
681: p_rec.attribute3 :=
682: pay_fed_shd.g_old_rec.attribute3;
683: End If;
684: If (p_rec.attribute4 = hr_api.g_varchar2) then
685: p_rec.attribute4 :=
686: pay_fed_shd.g_old_rec.attribute4;

Line 686: pay_fed_shd.g_old_rec.attribute4;

682: pay_fed_shd.g_old_rec.attribute3;
683: End If;
684: If (p_rec.attribute4 = hr_api.g_varchar2) then
685: p_rec.attribute4 :=
686: pay_fed_shd.g_old_rec.attribute4;
687: End If;
688: If (p_rec.attribute5 = hr_api.g_varchar2) then
689: p_rec.attribute5 :=
690: pay_fed_shd.g_old_rec.attribute5;

Line 690: pay_fed_shd.g_old_rec.attribute5;

686: pay_fed_shd.g_old_rec.attribute4;
687: End If;
688: If (p_rec.attribute5 = hr_api.g_varchar2) then
689: p_rec.attribute5 :=
690: pay_fed_shd.g_old_rec.attribute5;
691: End If;
692: If (p_rec.attribute6 = hr_api.g_varchar2) then
693: p_rec.attribute6 :=
694: pay_fed_shd.g_old_rec.attribute6;

Line 694: pay_fed_shd.g_old_rec.attribute6;

690: pay_fed_shd.g_old_rec.attribute5;
691: End If;
692: If (p_rec.attribute6 = hr_api.g_varchar2) then
693: p_rec.attribute6 :=
694: pay_fed_shd.g_old_rec.attribute6;
695: End If;
696: If (p_rec.attribute7 = hr_api.g_varchar2) then
697: p_rec.attribute7 :=
698: pay_fed_shd.g_old_rec.attribute7;

Line 698: pay_fed_shd.g_old_rec.attribute7;

694: pay_fed_shd.g_old_rec.attribute6;
695: End If;
696: If (p_rec.attribute7 = hr_api.g_varchar2) then
697: p_rec.attribute7 :=
698: pay_fed_shd.g_old_rec.attribute7;
699: End If;
700: If (p_rec.attribute8 = hr_api.g_varchar2) then
701: p_rec.attribute8 :=
702: pay_fed_shd.g_old_rec.attribute8;

Line 702: pay_fed_shd.g_old_rec.attribute8;

698: pay_fed_shd.g_old_rec.attribute7;
699: End If;
700: If (p_rec.attribute8 = hr_api.g_varchar2) then
701: p_rec.attribute8 :=
702: pay_fed_shd.g_old_rec.attribute8;
703: End If;
704: If (p_rec.attribute9 = hr_api.g_varchar2) then
705: p_rec.attribute9 :=
706: pay_fed_shd.g_old_rec.attribute9;

Line 706: pay_fed_shd.g_old_rec.attribute9;

702: pay_fed_shd.g_old_rec.attribute8;
703: End If;
704: If (p_rec.attribute9 = hr_api.g_varchar2) then
705: p_rec.attribute9 :=
706: pay_fed_shd.g_old_rec.attribute9;
707: End If;
708: If (p_rec.attribute10 = hr_api.g_varchar2) then
709: p_rec.attribute10 :=
710: pay_fed_shd.g_old_rec.attribute10;

Line 710: pay_fed_shd.g_old_rec.attribute10;

706: pay_fed_shd.g_old_rec.attribute9;
707: End If;
708: If (p_rec.attribute10 = hr_api.g_varchar2) then
709: p_rec.attribute10 :=
710: pay_fed_shd.g_old_rec.attribute10;
711: End If;
712: If (p_rec.attribute11 = hr_api.g_varchar2) then
713: p_rec.attribute11 :=
714: pay_fed_shd.g_old_rec.attribute11;

Line 714: pay_fed_shd.g_old_rec.attribute11;

710: pay_fed_shd.g_old_rec.attribute10;
711: End If;
712: If (p_rec.attribute11 = hr_api.g_varchar2) then
713: p_rec.attribute11 :=
714: pay_fed_shd.g_old_rec.attribute11;
715: End If;
716: If (p_rec.attribute12 = hr_api.g_varchar2) then
717: p_rec.attribute12 :=
718: pay_fed_shd.g_old_rec.attribute12;

Line 718: pay_fed_shd.g_old_rec.attribute12;

714: pay_fed_shd.g_old_rec.attribute11;
715: End If;
716: If (p_rec.attribute12 = hr_api.g_varchar2) then
717: p_rec.attribute12 :=
718: pay_fed_shd.g_old_rec.attribute12;
719: End If;
720: If (p_rec.attribute13 = hr_api.g_varchar2) then
721: p_rec.attribute13 :=
722: pay_fed_shd.g_old_rec.attribute13;

Line 722: pay_fed_shd.g_old_rec.attribute13;

718: pay_fed_shd.g_old_rec.attribute12;
719: End If;
720: If (p_rec.attribute13 = hr_api.g_varchar2) then
721: p_rec.attribute13 :=
722: pay_fed_shd.g_old_rec.attribute13;
723: End If;
724: If (p_rec.attribute14 = hr_api.g_varchar2) then
725: p_rec.attribute14 :=
726: pay_fed_shd.g_old_rec.attribute14;

Line 726: pay_fed_shd.g_old_rec.attribute14;

722: pay_fed_shd.g_old_rec.attribute13;
723: End If;
724: If (p_rec.attribute14 = hr_api.g_varchar2) then
725: p_rec.attribute14 :=
726: pay_fed_shd.g_old_rec.attribute14;
727: End If;
728: If (p_rec.attribute15 = hr_api.g_varchar2) then
729: p_rec.attribute15 :=
730: pay_fed_shd.g_old_rec.attribute15;

Line 730: pay_fed_shd.g_old_rec.attribute15;

726: pay_fed_shd.g_old_rec.attribute14;
727: End If;
728: If (p_rec.attribute15 = hr_api.g_varchar2) then
729: p_rec.attribute15 :=
730: pay_fed_shd.g_old_rec.attribute15;
731: End If;
732: If (p_rec.attribute16 = hr_api.g_varchar2) then
733: p_rec.attribute16 :=
734: pay_fed_shd.g_old_rec.attribute16;

Line 734: pay_fed_shd.g_old_rec.attribute16;

730: pay_fed_shd.g_old_rec.attribute15;
731: End If;
732: If (p_rec.attribute16 = hr_api.g_varchar2) then
733: p_rec.attribute16 :=
734: pay_fed_shd.g_old_rec.attribute16;
735: End If;
736: If (p_rec.attribute17 = hr_api.g_varchar2) then
737: p_rec.attribute17 :=
738: pay_fed_shd.g_old_rec.attribute17;

Line 738: pay_fed_shd.g_old_rec.attribute17;

734: pay_fed_shd.g_old_rec.attribute16;
735: End If;
736: If (p_rec.attribute17 = hr_api.g_varchar2) then
737: p_rec.attribute17 :=
738: pay_fed_shd.g_old_rec.attribute17;
739: End If;
740: If (p_rec.attribute18 = hr_api.g_varchar2) then
741: p_rec.attribute18 :=
742: pay_fed_shd.g_old_rec.attribute18;

Line 742: pay_fed_shd.g_old_rec.attribute18;

738: pay_fed_shd.g_old_rec.attribute17;
739: End If;
740: If (p_rec.attribute18 = hr_api.g_varchar2) then
741: p_rec.attribute18 :=
742: pay_fed_shd.g_old_rec.attribute18;
743: End If;
744: If (p_rec.attribute19 = hr_api.g_varchar2) then
745: p_rec.attribute19 :=
746: pay_fed_shd.g_old_rec.attribute19;

Line 746: pay_fed_shd.g_old_rec.attribute19;

742: pay_fed_shd.g_old_rec.attribute18;
743: End If;
744: If (p_rec.attribute19 = hr_api.g_varchar2) then
745: p_rec.attribute19 :=
746: pay_fed_shd.g_old_rec.attribute19;
747: End If;
748: If (p_rec.attribute20 = hr_api.g_varchar2) then
749: p_rec.attribute20 :=
750: pay_fed_shd.g_old_rec.attribute20;

Line 750: pay_fed_shd.g_old_rec.attribute20;

746: pay_fed_shd.g_old_rec.attribute19;
747: End If;
748: If (p_rec.attribute20 = hr_api.g_varchar2) then
749: p_rec.attribute20 :=
750: pay_fed_shd.g_old_rec.attribute20;
751: End If;
752: If (p_rec.attribute21 = hr_api.g_varchar2) then
753: p_rec.attribute21 :=
754: pay_fed_shd.g_old_rec.attribute21;

Line 754: pay_fed_shd.g_old_rec.attribute21;

750: pay_fed_shd.g_old_rec.attribute20;
751: End If;
752: If (p_rec.attribute21 = hr_api.g_varchar2) then
753: p_rec.attribute21 :=
754: pay_fed_shd.g_old_rec.attribute21;
755: End If;
756: If (p_rec.attribute22 = hr_api.g_varchar2) then
757: p_rec.attribute22 :=
758: pay_fed_shd.g_old_rec.attribute22;

Line 758: pay_fed_shd.g_old_rec.attribute22;

754: pay_fed_shd.g_old_rec.attribute21;
755: End If;
756: If (p_rec.attribute22 = hr_api.g_varchar2) then
757: p_rec.attribute22 :=
758: pay_fed_shd.g_old_rec.attribute22;
759: End If;
760: If (p_rec.attribute23 = hr_api.g_varchar2) then
761: p_rec.attribute23 :=
762: pay_fed_shd.g_old_rec.attribute23;

Line 762: pay_fed_shd.g_old_rec.attribute23;

758: pay_fed_shd.g_old_rec.attribute22;
759: End If;
760: If (p_rec.attribute23 = hr_api.g_varchar2) then
761: p_rec.attribute23 :=
762: pay_fed_shd.g_old_rec.attribute23;
763: End If;
764: If (p_rec.attribute24 = hr_api.g_varchar2) then
765: p_rec.attribute24 :=
766: pay_fed_shd.g_old_rec.attribute24;

Line 766: pay_fed_shd.g_old_rec.attribute24;

762: pay_fed_shd.g_old_rec.attribute23;
763: End If;
764: If (p_rec.attribute24 = hr_api.g_varchar2) then
765: p_rec.attribute24 :=
766: pay_fed_shd.g_old_rec.attribute24;
767: End If;
768: If (p_rec.attribute25 = hr_api.g_varchar2) then
769: p_rec.attribute25 :=
770: pay_fed_shd.g_old_rec.attribute25;

Line 770: pay_fed_shd.g_old_rec.attribute25;

766: pay_fed_shd.g_old_rec.attribute24;
767: End If;
768: If (p_rec.attribute25 = hr_api.g_varchar2) then
769: p_rec.attribute25 :=
770: pay_fed_shd.g_old_rec.attribute25;
771: End If;
772: If (p_rec.attribute26 = hr_api.g_varchar2) then
773: p_rec.attribute26 :=
774: pay_fed_shd.g_old_rec.attribute26;

Line 774: pay_fed_shd.g_old_rec.attribute26;

770: pay_fed_shd.g_old_rec.attribute25;
771: End If;
772: If (p_rec.attribute26 = hr_api.g_varchar2) then
773: p_rec.attribute26 :=
774: pay_fed_shd.g_old_rec.attribute26;
775: End If;
776: If (p_rec.attribute27 = hr_api.g_varchar2) then
777: p_rec.attribute27 :=
778: pay_fed_shd.g_old_rec.attribute27;

Line 778: pay_fed_shd.g_old_rec.attribute27;

774: pay_fed_shd.g_old_rec.attribute26;
775: End If;
776: If (p_rec.attribute27 = hr_api.g_varchar2) then
777: p_rec.attribute27 :=
778: pay_fed_shd.g_old_rec.attribute27;
779: End If;
780: If (p_rec.attribute28 = hr_api.g_varchar2) then
781: p_rec.attribute28 :=
782: pay_fed_shd.g_old_rec.attribute28;

Line 782: pay_fed_shd.g_old_rec.attribute28;

778: pay_fed_shd.g_old_rec.attribute27;
779: End If;
780: If (p_rec.attribute28 = hr_api.g_varchar2) then
781: p_rec.attribute28 :=
782: pay_fed_shd.g_old_rec.attribute28;
783: End If;
784: If (p_rec.attribute29 = hr_api.g_varchar2) then
785: p_rec.attribute29 :=
786: pay_fed_shd.g_old_rec.attribute29;

Line 786: pay_fed_shd.g_old_rec.attribute29;

782: pay_fed_shd.g_old_rec.attribute28;
783: End If;
784: If (p_rec.attribute29 = hr_api.g_varchar2) then
785: p_rec.attribute29 :=
786: pay_fed_shd.g_old_rec.attribute29;
787: End If;
788: If (p_rec.attribute30 = hr_api.g_varchar2) then
789: p_rec.attribute30 :=
790: pay_fed_shd.g_old_rec.attribute30;

Line 790: pay_fed_shd.g_old_rec.attribute30;

786: pay_fed_shd.g_old_rec.attribute29;
787: End If;
788: If (p_rec.attribute30 = hr_api.g_varchar2) then
789: p_rec.attribute30 :=
790: pay_fed_shd.g_old_rec.attribute30;
791: End If;
792: If (p_rec.fed_information_category = hr_api.g_varchar2) then
793: p_rec.fed_information_category :=
794: pay_fed_shd.g_old_rec.fed_information_category;

Line 794: pay_fed_shd.g_old_rec.fed_information_category;

790: pay_fed_shd.g_old_rec.attribute30;
791: End If;
792: If (p_rec.fed_information_category = hr_api.g_varchar2) then
793: p_rec.fed_information_category :=
794: pay_fed_shd.g_old_rec.fed_information_category;
795: End If;
796: If (p_rec.fed_information1 = hr_api.g_varchar2) then
797: p_rec.fed_information1 :=
798: pay_fed_shd.g_old_rec.fed_information1;

Line 798: pay_fed_shd.g_old_rec.fed_information1;

794: pay_fed_shd.g_old_rec.fed_information_category;
795: End If;
796: If (p_rec.fed_information1 = hr_api.g_varchar2) then
797: p_rec.fed_information1 :=
798: pay_fed_shd.g_old_rec.fed_information1;
799: End If;
800: If (p_rec.fed_information2 = hr_api.g_varchar2) then
801: p_rec.fed_information2 :=
802: pay_fed_shd.g_old_rec.fed_information2;

Line 802: pay_fed_shd.g_old_rec.fed_information2;

798: pay_fed_shd.g_old_rec.fed_information1;
799: End If;
800: If (p_rec.fed_information2 = hr_api.g_varchar2) then
801: p_rec.fed_information2 :=
802: pay_fed_shd.g_old_rec.fed_information2;
803: End If;
804: If (p_rec.fed_information3 = hr_api.g_varchar2) then
805: p_rec.fed_information3 :=
806: pay_fed_shd.g_old_rec.fed_information3;

Line 806: pay_fed_shd.g_old_rec.fed_information3;

802: pay_fed_shd.g_old_rec.fed_information2;
803: End If;
804: If (p_rec.fed_information3 = hr_api.g_varchar2) then
805: p_rec.fed_information3 :=
806: pay_fed_shd.g_old_rec.fed_information3;
807: End If;
808: If (p_rec.fed_information4 = hr_api.g_varchar2) then
809: p_rec.fed_information4 :=
810: pay_fed_shd.g_old_rec.fed_information4;

Line 810: pay_fed_shd.g_old_rec.fed_information4;

806: pay_fed_shd.g_old_rec.fed_information3;
807: End If;
808: If (p_rec.fed_information4 = hr_api.g_varchar2) then
809: p_rec.fed_information4 :=
810: pay_fed_shd.g_old_rec.fed_information4;
811: End If;
812: If (p_rec.fed_information5 = hr_api.g_varchar2) then
813: p_rec.fed_information5 :=
814: pay_fed_shd.g_old_rec.fed_information5;

Line 814: pay_fed_shd.g_old_rec.fed_information5;

810: pay_fed_shd.g_old_rec.fed_information4;
811: End If;
812: If (p_rec.fed_information5 = hr_api.g_varchar2) then
813: p_rec.fed_information5 :=
814: pay_fed_shd.g_old_rec.fed_information5;
815: End If;
816: If (p_rec.fed_information6 = hr_api.g_varchar2) then
817: p_rec.fed_information6 :=
818: pay_fed_shd.g_old_rec.fed_information6;

Line 818: pay_fed_shd.g_old_rec.fed_information6;

814: pay_fed_shd.g_old_rec.fed_information5;
815: End If;
816: If (p_rec.fed_information6 = hr_api.g_varchar2) then
817: p_rec.fed_information6 :=
818: pay_fed_shd.g_old_rec.fed_information6;
819: End If;
820: If (p_rec.fed_information7 = hr_api.g_varchar2) then
821: p_rec.fed_information7 :=
822: pay_fed_shd.g_old_rec.fed_information7;

Line 822: pay_fed_shd.g_old_rec.fed_information7;

818: pay_fed_shd.g_old_rec.fed_information6;
819: End If;
820: If (p_rec.fed_information7 = hr_api.g_varchar2) then
821: p_rec.fed_information7 :=
822: pay_fed_shd.g_old_rec.fed_information7;
823: End If;
824: If (p_rec.fed_information8 = hr_api.g_varchar2) then
825: p_rec.fed_information8 :=
826: pay_fed_shd.g_old_rec.fed_information8;

Line 826: pay_fed_shd.g_old_rec.fed_information8;

822: pay_fed_shd.g_old_rec.fed_information7;
823: End If;
824: If (p_rec.fed_information8 = hr_api.g_varchar2) then
825: p_rec.fed_information8 :=
826: pay_fed_shd.g_old_rec.fed_information8;
827: End If;
828: If (p_rec.fed_information9 = hr_api.g_varchar2) then
829: p_rec.fed_information9 :=
830: pay_fed_shd.g_old_rec.fed_information9;

Line 830: pay_fed_shd.g_old_rec.fed_information9;

826: pay_fed_shd.g_old_rec.fed_information8;
827: End If;
828: If (p_rec.fed_information9 = hr_api.g_varchar2) then
829: p_rec.fed_information9 :=
830: pay_fed_shd.g_old_rec.fed_information9;
831: End If;
832: If (p_rec.fed_information10 = hr_api.g_varchar2) then
833: p_rec.fed_information10 :=
834: pay_fed_shd.g_old_rec.fed_information10;

Line 834: pay_fed_shd.g_old_rec.fed_information10;

830: pay_fed_shd.g_old_rec.fed_information9;
831: End If;
832: If (p_rec.fed_information10 = hr_api.g_varchar2) then
833: p_rec.fed_information10 :=
834: pay_fed_shd.g_old_rec.fed_information10;
835: End If;
836: If (p_rec.fed_information11 = hr_api.g_varchar2) then
837: p_rec.fed_information11 :=
838: pay_fed_shd.g_old_rec.fed_information11;

Line 838: pay_fed_shd.g_old_rec.fed_information11;

834: pay_fed_shd.g_old_rec.fed_information10;
835: End If;
836: If (p_rec.fed_information11 = hr_api.g_varchar2) then
837: p_rec.fed_information11 :=
838: pay_fed_shd.g_old_rec.fed_information11;
839: End If;
840: If (p_rec.fed_information12 = hr_api.g_varchar2) then
841: p_rec.fed_information12 :=
842: pay_fed_shd.g_old_rec.fed_information12;

Line 842: pay_fed_shd.g_old_rec.fed_information12;

838: pay_fed_shd.g_old_rec.fed_information11;
839: End If;
840: If (p_rec.fed_information12 = hr_api.g_varchar2) then
841: p_rec.fed_information12 :=
842: pay_fed_shd.g_old_rec.fed_information12;
843: End If;
844: If (p_rec.fed_information13 = hr_api.g_varchar2) then
845: p_rec.fed_information13 :=
846: pay_fed_shd.g_old_rec.fed_information13;

Line 846: pay_fed_shd.g_old_rec.fed_information13;

842: pay_fed_shd.g_old_rec.fed_information12;
843: End If;
844: If (p_rec.fed_information13 = hr_api.g_varchar2) then
845: p_rec.fed_information13 :=
846: pay_fed_shd.g_old_rec.fed_information13;
847: End If;
848: If (p_rec.fed_information14 = hr_api.g_varchar2) then
849: p_rec.fed_information14 :=
850: pay_fed_shd.g_old_rec.fed_information14;

Line 850: pay_fed_shd.g_old_rec.fed_information14;

846: pay_fed_shd.g_old_rec.fed_information13;
847: End If;
848: If (p_rec.fed_information14 = hr_api.g_varchar2) then
849: p_rec.fed_information14 :=
850: pay_fed_shd.g_old_rec.fed_information14;
851: End If;
852: If (p_rec.fed_information15 = hr_api.g_varchar2) then
853: p_rec.fed_information15 :=
854: pay_fed_shd.g_old_rec.fed_information15;

Line 854: pay_fed_shd.g_old_rec.fed_information15;

850: pay_fed_shd.g_old_rec.fed_information14;
851: End If;
852: If (p_rec.fed_information15 = hr_api.g_varchar2) then
853: p_rec.fed_information15 :=
854: pay_fed_shd.g_old_rec.fed_information15;
855: End If;
856: If (p_rec.fed_information16 = hr_api.g_varchar2) then
857: p_rec.fed_information16 :=
858: pay_fed_shd.g_old_rec.fed_information16;

Line 858: pay_fed_shd.g_old_rec.fed_information16;

854: pay_fed_shd.g_old_rec.fed_information15;
855: End If;
856: If (p_rec.fed_information16 = hr_api.g_varchar2) then
857: p_rec.fed_information16 :=
858: pay_fed_shd.g_old_rec.fed_information16;
859: End If;
860: If (p_rec.fed_information17 = hr_api.g_varchar2) then
861: p_rec.fed_information17 :=
862: pay_fed_shd.g_old_rec.fed_information17;

Line 862: pay_fed_shd.g_old_rec.fed_information17;

858: pay_fed_shd.g_old_rec.fed_information16;
859: End If;
860: If (p_rec.fed_information17 = hr_api.g_varchar2) then
861: p_rec.fed_information17 :=
862: pay_fed_shd.g_old_rec.fed_information17;
863: End If;
864: If (p_rec.fed_information18 = hr_api.g_varchar2) then
865: p_rec.fed_information18 :=
866: pay_fed_shd.g_old_rec.fed_information18;

Line 866: pay_fed_shd.g_old_rec.fed_information18;

862: pay_fed_shd.g_old_rec.fed_information17;
863: End If;
864: If (p_rec.fed_information18 = hr_api.g_varchar2) then
865: p_rec.fed_information18 :=
866: pay_fed_shd.g_old_rec.fed_information18;
867: End If;
868: If (p_rec.fed_information19 = hr_api.g_varchar2) then
869: p_rec.fed_information19 :=
870: pay_fed_shd.g_old_rec.fed_information19;

Line 870: pay_fed_shd.g_old_rec.fed_information19;

866: pay_fed_shd.g_old_rec.fed_information18;
867: End If;
868: If (p_rec.fed_information19 = hr_api.g_varchar2) then
869: p_rec.fed_information19 :=
870: pay_fed_shd.g_old_rec.fed_information19;
871: End If;
872: If (p_rec.fed_information20 = hr_api.g_varchar2) then
873: p_rec.fed_information20 :=
874: pay_fed_shd.g_old_rec.fed_information20;

Line 874: pay_fed_shd.g_old_rec.fed_information20;

870: pay_fed_shd.g_old_rec.fed_information19;
871: End If;
872: If (p_rec.fed_information20 = hr_api.g_varchar2) then
873: p_rec.fed_information20 :=
874: pay_fed_shd.g_old_rec.fed_information20;
875: End If;
876: If (p_rec.fed_information21 = hr_api.g_varchar2) then
877: p_rec.fed_information21 :=
878: pay_fed_shd.g_old_rec.fed_information21;

Line 878: pay_fed_shd.g_old_rec.fed_information21;

874: pay_fed_shd.g_old_rec.fed_information20;
875: End If;
876: If (p_rec.fed_information21 = hr_api.g_varchar2) then
877: p_rec.fed_information21 :=
878: pay_fed_shd.g_old_rec.fed_information21;
879: End If;
880: If (p_rec.fed_information22 = hr_api.g_varchar2) then
881: p_rec.fed_information22 :=
882: pay_fed_shd.g_old_rec.fed_information22;

Line 882: pay_fed_shd.g_old_rec.fed_information22;

878: pay_fed_shd.g_old_rec.fed_information21;
879: End If;
880: If (p_rec.fed_information22 = hr_api.g_varchar2) then
881: p_rec.fed_information22 :=
882: pay_fed_shd.g_old_rec.fed_information22;
883: End If;
884: If (p_rec.fed_information23 = hr_api.g_varchar2) then
885: p_rec.fed_information23 :=
886: pay_fed_shd.g_old_rec.fed_information23;

Line 886: pay_fed_shd.g_old_rec.fed_information23;

882: pay_fed_shd.g_old_rec.fed_information22;
883: End If;
884: If (p_rec.fed_information23 = hr_api.g_varchar2) then
885: p_rec.fed_information23 :=
886: pay_fed_shd.g_old_rec.fed_information23;
887: End If;
888: If (p_rec.fed_information24 = hr_api.g_varchar2) then
889: p_rec.fed_information24 :=
890: pay_fed_shd.g_old_rec.fed_information24;

Line 890: pay_fed_shd.g_old_rec.fed_information24;

886: pay_fed_shd.g_old_rec.fed_information23;
887: End If;
888: If (p_rec.fed_information24 = hr_api.g_varchar2) then
889: p_rec.fed_information24 :=
890: pay_fed_shd.g_old_rec.fed_information24;
891: End If;
892: If (p_rec.fed_information25 = hr_api.g_varchar2) then
893: p_rec.fed_information25 :=
894: pay_fed_shd.g_old_rec.fed_information25;

Line 894: pay_fed_shd.g_old_rec.fed_information25;

890: pay_fed_shd.g_old_rec.fed_information24;
891: End If;
892: If (p_rec.fed_information25 = hr_api.g_varchar2) then
893: p_rec.fed_information25 :=
894: pay_fed_shd.g_old_rec.fed_information25;
895: End If;
896: If (p_rec.fed_information26 = hr_api.g_varchar2) then
897: p_rec.fed_information26 :=
898: pay_fed_shd.g_old_rec.fed_information26;

Line 898: pay_fed_shd.g_old_rec.fed_information26;

894: pay_fed_shd.g_old_rec.fed_information25;
895: End If;
896: If (p_rec.fed_information26 = hr_api.g_varchar2) then
897: p_rec.fed_information26 :=
898: pay_fed_shd.g_old_rec.fed_information26;
899: End If;
900: If (p_rec.fed_information27 = hr_api.g_varchar2) then
901: p_rec.fed_information27 :=
902: pay_fed_shd.g_old_rec.fed_information27;

Line 902: pay_fed_shd.g_old_rec.fed_information27;

898: pay_fed_shd.g_old_rec.fed_information26;
899: End If;
900: If (p_rec.fed_information27 = hr_api.g_varchar2) then
901: p_rec.fed_information27 :=
902: pay_fed_shd.g_old_rec.fed_information27;
903: End If;
904: If (p_rec.fed_information28 = hr_api.g_varchar2) then
905: p_rec.fed_information28 :=
906: pay_fed_shd.g_old_rec.fed_information28;

Line 906: pay_fed_shd.g_old_rec.fed_information28;

902: pay_fed_shd.g_old_rec.fed_information27;
903: End If;
904: If (p_rec.fed_information28 = hr_api.g_varchar2) then
905: p_rec.fed_information28 :=
906: pay_fed_shd.g_old_rec.fed_information28;
907: End If;
908: If (p_rec.fed_information29 = hr_api.g_varchar2) then
909: p_rec.fed_information29 :=
910: pay_fed_shd.g_old_rec.fed_information29;

Line 910: pay_fed_shd.g_old_rec.fed_information29;

906: pay_fed_shd.g_old_rec.fed_information28;
907: End If;
908: If (p_rec.fed_information29 = hr_api.g_varchar2) then
909: p_rec.fed_information29 :=
910: pay_fed_shd.g_old_rec.fed_information29;
911: End If;
912: If (p_rec.fed_information30 = hr_api.g_varchar2) then
913: p_rec.fed_information30 :=
914: pay_fed_shd.g_old_rec.fed_information30;

Line 914: pay_fed_shd.g_old_rec.fed_information30;

910: pay_fed_shd.g_old_rec.fed_information29;
911: End If;
912: If (p_rec.fed_information30 = hr_api.g_varchar2) then
913: p_rec.fed_information30 :=
914: pay_fed_shd.g_old_rec.fed_information30;
915: End If;
916:
917: --
918: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 927: p_rec in out nocopy pay_fed_shd.g_rec_type,

923: -- |---------------------------------< upd >----------------------------------|
924: -- ----------------------------------------------------------------------------
925: Procedure upd
926: (
927: p_rec in out nocopy pay_fed_shd.g_rec_type,
928: p_effective_date in date,
929: p_datetrack_mode in varchar2
930: ) is
931: --

Line 945: pay_fed_shd.lck

941: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
942: --
943: -- We must lock the row which we need to update.
944: --
945: pay_fed_shd.lck
946: (p_effective_date => p_effective_date,
947: p_datetrack_mode => p_datetrack_mode,
948: p_emp_fed_tax_rule_id => p_rec.emp_fed_tax_rule_id,
949: p_object_version_number => p_rec.object_version_number,

Line 1089: l_rec pay_fed_shd.g_rec_type;

1085: p_fed_information30 in varchar2 default hr_api.g_varchar2,
1086: p_datetrack_mode in varchar2
1087: ) is
1088: --
1089: l_rec pay_fed_shd.g_rec_type;
1090: l_proc varchar2(72) := g_package||'upd';
1091: --
1092: Begin
1093: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1099: pay_fed_shd.convert_args

1095: -- Call conversion function to turn arguments into the
1096: -- l_rec structure.
1097: --
1098: l_rec :=
1099: pay_fed_shd.convert_args
1100: (
1101: p_emp_fed_tax_rule_id,
1102: null,
1103: null,