[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_cnt_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
77: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',
78: p_base_key_column => 'emp_county_tax_rule_id',
79: p_base_key_value => p_rec.emp_county_tax_rule_id);
80: --
81: pay_cnt_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the pay_us_emp_county_tax_rules_f Row
84: --
85: update pay_us_emp_county_tax_rules_f
167: where emp_county_tax_rule_id = p_rec.emp_county_tax_rule_id
168: and effective_start_date = p_validation_start_date
169: and effective_end_date = p_validation_end_date;
170: --
171: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: -- Set the effective start and end dates
174: --
175: p_rec.effective_start_date := p_validation_start_date;
179: hr_utility.set_location(' Leaving:'||l_proc, 15);
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
184: pay_cnt_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
184: pay_cnt_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
184: pay_cnt_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
189: pay_cnt_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
189: pay_cnt_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
188: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
189: pay_cnt_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: pay_cnt_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
194: End dt_update_dml;
195: --
196: -- ----------------------------------------------------------------------------
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure update_dml
228: (p_rec in out nocopy pay_cnt_shd.g_rec_type,
229: p_effective_date in date,
230: p_datetrack_mode in varchar2,
231: p_validation_start_date in date,
232: p_validation_end_date in date) is
288: --
289: -- {End Of Comments}
290: -- ----------------------------------------------------------------------------
291: Procedure dt_pre_update
292: (p_rec in out nocopy pay_cnt_shd.g_rec_type,
293: p_effective_date in date,
294: p_datetrack_mode in varchar2,
295: p_validation_start_date in date,
296: p_validation_end_date in date) is
304: hr_utility.set_location(l_proc, 10);
305: --
306: -- Update the current effective end date
307: --
308: pay_cnt_shd.upd_effective_end_date
309: (p_effective_date => p_effective_date,
310: p_base_key_value => p_rec.emp_county_tax_rule_id,
311: p_new_effective_end_date => (p_validation_start_date - 1),
312: p_validation_start_date => p_validation_start_date,
373: --
374: -- {End Of Comments}
375: -- ----------------------------------------------------------------------------
376: Procedure pre_update
377: (p_rec in out nocopy pay_cnt_shd.g_rec_type,
378: p_effective_date in date,
379: p_datetrack_mode in varchar2,
380: p_validation_start_date in date,
381: p_validation_end_date in date) is
429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure post_update
433: (p_rec in pay_cnt_shd.g_rec_type,
434: p_effective_date in date,
435: p_datetrack_mode in varchar2,
436: p_validation_start_date in date,
437: p_validation_end_date in date) is
467: ,p_effective_date =>p_effective_date
468: ,p_datetrack_mode =>p_datetrack_mode
469: ,p_validation_start_date =>p_validation_start_date
470: ,p_validation_end_date =>p_validation_end_date
471: ,p_effective_start_date_o =>pay_cnt_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
468: ,p_datetrack_mode =>p_datetrack_mode
469: ,p_validation_start_date =>p_validation_start_date
470: ,p_validation_end_date =>p_validation_end_date
471: ,p_effective_start_date_o =>pay_cnt_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
469: ,p_validation_start_date =>p_validation_start_date
470: ,p_validation_end_date =>p_validation_end_date
471: ,p_effective_start_date_o =>pay_cnt_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
470: ,p_validation_end_date =>p_validation_end_date
471: ,p_effective_start_date_o =>pay_cnt_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
471: ,p_effective_start_date_o =>pay_cnt_shd.g_old_rec.effective_start_date
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
472: ,p_effective_end_date_o =>pay_cnt_shd.g_old_rec.effective_end_date
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
473: ,p_assignment_id_o =>pay_cnt_shd.g_old_rec.assignment_id
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
474: ,p_state_code_o =>pay_cnt_shd.g_old_rec.state_code
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
475: ,p_county_code_o =>pay_cnt_shd.g_old_rec.county_code
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
476: ,p_business_group_id_o =>pay_cnt_shd.g_old_rec.business_group_id
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
477: ,p_additional_wa_rate_o =>pay_cnt_shd.g_old_rec.additional_wa_rate
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
478: ,p_filing_status_code_o =>pay_cnt_shd.g_old_rec.filing_status_code
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
479: ,p_jurisdiction_code_o =>pay_cnt_shd.g_old_rec.jurisdiction_code
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
480: ,p_lit_additional_tax_o =>pay_cnt_shd.g_old_rec.lit_additional_tax
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
481: ,p_lit_override_amount_o =>pay_cnt_shd.g_old_rec.lit_override_amount
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
489: ,p_object_version_number_o =>pay_cnt_shd.g_old_rec.object_version_number
482: ,p_lit_override_rate_o =>pay_cnt_shd.g_old_rec.lit_override_rate
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
489: ,p_object_version_number_o =>pay_cnt_shd.g_old_rec.object_version_number
490: );
483: ,p_withholding_allowances_o =>pay_cnt_shd.g_old_rec.withholding_allowances
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
489: ,p_object_version_number_o =>pay_cnt_shd.g_old_rec.object_version_number
490: );
491: --
484: ,p_lit_exempt_o =>pay_cnt_shd.g_old_rec.lit_exempt
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
489: ,p_object_version_number_o =>pay_cnt_shd.g_old_rec.object_version_number
490: );
491: --
492: exception
485: ,p_sd_exempt_o =>pay_cnt_shd.g_old_rec.sd_exempt
486: ,p_ht_exempt_o =>pay_cnt_shd.g_old_rec.ht_exempt
487: ,p_wage_exempt_o =>pay_cnt_shd.g_old_rec.wage_exempt
488: ,p_school_district_code_o =>pay_cnt_shd.g_old_rec.school_district_code
489: ,p_object_version_number_o =>pay_cnt_shd.g_old_rec.object_version_number
490: );
491: --
492: exception
493: --
549: -- Internal Row Handler Use Only.
550: --
551: -- {End Of Comments}
552: -- ----------------------------------------------------------------------------
553: Procedure convert_defs(p_rec in out nocopy pay_cnt_shd.g_rec_type) is
554: --
555: l_proc varchar2(72) := g_package||'convert_defs';
556: --
557: Begin
564: -- is being used then we must set to the 'current' argument value.
565: --
566: If (p_rec.assignment_id = hr_api.g_number) then
567: p_rec.assignment_id :=
568: pay_cnt_shd.g_old_rec.assignment_id;
569: End If;
570: If (p_rec.state_code = hr_api.g_varchar2) then
571: p_rec.state_code :=
572: pay_cnt_shd.g_old_rec.state_code;
568: pay_cnt_shd.g_old_rec.assignment_id;
569: End If;
570: If (p_rec.state_code = hr_api.g_varchar2) then
571: p_rec.state_code :=
572: pay_cnt_shd.g_old_rec.state_code;
573: End If;
574: If (p_rec.county_code = hr_api.g_varchar2) then
575: p_rec.county_code :=
576: pay_cnt_shd.g_old_rec.county_code;
572: pay_cnt_shd.g_old_rec.state_code;
573: End If;
574: If (p_rec.county_code = hr_api.g_varchar2) then
575: p_rec.county_code :=
576: pay_cnt_shd.g_old_rec.county_code;
577: End If;
578: If (p_rec.business_group_id = hr_api.g_number) then
579: p_rec.business_group_id :=
580: pay_cnt_shd.g_old_rec.business_group_id;
576: pay_cnt_shd.g_old_rec.county_code;
577: End If;
578: If (p_rec.business_group_id = hr_api.g_number) then
579: p_rec.business_group_id :=
580: pay_cnt_shd.g_old_rec.business_group_id;
581: End If;
582: If (p_rec.additional_wa_rate = hr_api.g_number) then
583: p_rec.additional_wa_rate :=
584: pay_cnt_shd.g_old_rec.additional_wa_rate;
580: pay_cnt_shd.g_old_rec.business_group_id;
581: End If;
582: If (p_rec.additional_wa_rate = hr_api.g_number) then
583: p_rec.additional_wa_rate :=
584: pay_cnt_shd.g_old_rec.additional_wa_rate;
585: End If;
586: If (p_rec.filing_status_code = hr_api.g_varchar2) then
587: p_rec.filing_status_code :=
588: pay_cnt_shd.g_old_rec.filing_status_code;
584: pay_cnt_shd.g_old_rec.additional_wa_rate;
585: End If;
586: If (p_rec.filing_status_code = hr_api.g_varchar2) then
587: p_rec.filing_status_code :=
588: pay_cnt_shd.g_old_rec.filing_status_code;
589: End If;
590: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
591: p_rec.jurisdiction_code :=
592: pay_cnt_shd.g_old_rec.jurisdiction_code;
588: pay_cnt_shd.g_old_rec.filing_status_code;
589: End If;
590: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
591: p_rec.jurisdiction_code :=
592: pay_cnt_shd.g_old_rec.jurisdiction_code;
593: End If;
594: If (p_rec.lit_additional_tax = hr_api.g_number) then
595: p_rec.lit_additional_tax :=
596: pay_cnt_shd.g_old_rec.lit_additional_tax;
592: pay_cnt_shd.g_old_rec.jurisdiction_code;
593: End If;
594: If (p_rec.lit_additional_tax = hr_api.g_number) then
595: p_rec.lit_additional_tax :=
596: pay_cnt_shd.g_old_rec.lit_additional_tax;
597: End If;
598: If (p_rec.lit_override_amount = hr_api.g_number) then
599: p_rec.lit_override_amount :=
600: pay_cnt_shd.g_old_rec.lit_override_amount;
596: pay_cnt_shd.g_old_rec.lit_additional_tax;
597: End If;
598: If (p_rec.lit_override_amount = hr_api.g_number) then
599: p_rec.lit_override_amount :=
600: pay_cnt_shd.g_old_rec.lit_override_amount;
601: End If;
602: If (p_rec.lit_override_rate = hr_api.g_number) then
603: p_rec.lit_override_rate :=
604: pay_cnt_shd.g_old_rec.lit_override_rate;
600: pay_cnt_shd.g_old_rec.lit_override_amount;
601: End If;
602: If (p_rec.lit_override_rate = hr_api.g_number) then
603: p_rec.lit_override_rate :=
604: pay_cnt_shd.g_old_rec.lit_override_rate;
605: End If;
606: If (p_rec.withholding_allowances = hr_api.g_number) then
607: p_rec.withholding_allowances :=
608: pay_cnt_shd.g_old_rec.withholding_allowances;
604: pay_cnt_shd.g_old_rec.lit_override_rate;
605: End If;
606: If (p_rec.withholding_allowances = hr_api.g_number) then
607: p_rec.withholding_allowances :=
608: pay_cnt_shd.g_old_rec.withholding_allowances;
609: End If;
610: If (p_rec.lit_exempt = hr_api.g_varchar2) then
611: p_rec.lit_exempt :=
612: pay_cnt_shd.g_old_rec.lit_exempt;
608: pay_cnt_shd.g_old_rec.withholding_allowances;
609: End If;
610: If (p_rec.lit_exempt = hr_api.g_varchar2) then
611: p_rec.lit_exempt :=
612: pay_cnt_shd.g_old_rec.lit_exempt;
613: End If;
614: If (p_rec.sd_exempt = hr_api.g_varchar2) then
615: p_rec.sd_exempt :=
616: pay_cnt_shd.g_old_rec.sd_exempt;
612: pay_cnt_shd.g_old_rec.lit_exempt;
613: End If;
614: If (p_rec.sd_exempt = hr_api.g_varchar2) then
615: p_rec.sd_exempt :=
616: pay_cnt_shd.g_old_rec.sd_exempt;
617: End If;
618: If (p_rec.ht_exempt = hr_api.g_varchar2) then
619: p_rec.ht_exempt :=
620: pay_cnt_shd.g_old_rec.ht_exempt;
616: pay_cnt_shd.g_old_rec.sd_exempt;
617: End If;
618: If (p_rec.ht_exempt = hr_api.g_varchar2) then
619: p_rec.ht_exempt :=
620: pay_cnt_shd.g_old_rec.ht_exempt;
621: End If;
622: If (p_rec.wage_exempt = hr_api.g_varchar2) then
623: p_rec.wage_exempt :=
624: pay_cnt_shd.g_old_rec.wage_exempt;
620: pay_cnt_shd.g_old_rec.ht_exempt;
621: End If;
622: If (p_rec.wage_exempt = hr_api.g_varchar2) then
623: p_rec.wage_exempt :=
624: pay_cnt_shd.g_old_rec.wage_exempt;
625: End If;
626: If (p_rec.school_district_code = hr_api.g_varchar2) then
627: p_rec.school_district_code :=
628: pay_cnt_shd.g_old_rec.school_district_code;
624: pay_cnt_shd.g_old_rec.wage_exempt;
625: End If;
626: If (p_rec.school_district_code = hr_api.g_varchar2) then
627: p_rec.school_district_code :=
628: pay_cnt_shd.g_old_rec.school_district_code;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: pay_cnt_shd.g_old_rec.attribute_category;
628: pay_cnt_shd.g_old_rec.school_district_code;
629: End If;
630: If (p_rec.attribute_category = hr_api.g_varchar2) then
631: p_rec.attribute_category :=
632: pay_cnt_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: pay_cnt_shd.g_old_rec.attribute1;
632: pay_cnt_shd.g_old_rec.attribute_category;
633: End If;
634: If (p_rec.attribute1 = hr_api.g_varchar2) then
635: p_rec.attribute1 :=
636: pay_cnt_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: pay_cnt_shd.g_old_rec.attribute2;
636: pay_cnt_shd.g_old_rec.attribute1;
637: End If;
638: If (p_rec.attribute2 = hr_api.g_varchar2) then
639: p_rec.attribute2 :=
640: pay_cnt_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: pay_cnt_shd.g_old_rec.attribute3;
640: pay_cnt_shd.g_old_rec.attribute2;
641: End If;
642: If (p_rec.attribute3 = hr_api.g_varchar2) then
643: p_rec.attribute3 :=
644: pay_cnt_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: pay_cnt_shd.g_old_rec.attribute4;
644: pay_cnt_shd.g_old_rec.attribute3;
645: End If;
646: If (p_rec.attribute4 = hr_api.g_varchar2) then
647: p_rec.attribute4 :=
648: pay_cnt_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: pay_cnt_shd.g_old_rec.attribute5;
648: pay_cnt_shd.g_old_rec.attribute4;
649: End If;
650: If (p_rec.attribute5 = hr_api.g_varchar2) then
651: p_rec.attribute5 :=
652: pay_cnt_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: pay_cnt_shd.g_old_rec.attribute6;
652: pay_cnt_shd.g_old_rec.attribute5;
653: End If;
654: If (p_rec.attribute6 = hr_api.g_varchar2) then
655: p_rec.attribute6 :=
656: pay_cnt_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: pay_cnt_shd.g_old_rec.attribute7;
656: pay_cnt_shd.g_old_rec.attribute6;
657: End If;
658: If (p_rec.attribute7 = hr_api.g_varchar2) then
659: p_rec.attribute7 :=
660: pay_cnt_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: pay_cnt_shd.g_old_rec.attribute8;
660: pay_cnt_shd.g_old_rec.attribute7;
661: End If;
662: If (p_rec.attribute8 = hr_api.g_varchar2) then
663: p_rec.attribute8 :=
664: pay_cnt_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: pay_cnt_shd.g_old_rec.attribute9;
664: pay_cnt_shd.g_old_rec.attribute8;
665: End If;
666: If (p_rec.attribute9 = hr_api.g_varchar2) then
667: p_rec.attribute9 :=
668: pay_cnt_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: pay_cnt_shd.g_old_rec.attribute10;
668: pay_cnt_shd.g_old_rec.attribute9;
669: End If;
670: If (p_rec.attribute10 = hr_api.g_varchar2) then
671: p_rec.attribute10 :=
672: pay_cnt_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: pay_cnt_shd.g_old_rec.attribute11;
672: pay_cnt_shd.g_old_rec.attribute10;
673: End If;
674: If (p_rec.attribute11 = hr_api.g_varchar2) then
675: p_rec.attribute11 :=
676: pay_cnt_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: pay_cnt_shd.g_old_rec.attribute12;
676: pay_cnt_shd.g_old_rec.attribute11;
677: End If;
678: If (p_rec.attribute12 = hr_api.g_varchar2) then
679: p_rec.attribute12 :=
680: pay_cnt_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: pay_cnt_shd.g_old_rec.attribute13;
680: pay_cnt_shd.g_old_rec.attribute12;
681: End If;
682: If (p_rec.attribute13 = hr_api.g_varchar2) then
683: p_rec.attribute13 :=
684: pay_cnt_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: pay_cnt_shd.g_old_rec.attribute14;
684: pay_cnt_shd.g_old_rec.attribute13;
685: End If;
686: If (p_rec.attribute14 = hr_api.g_varchar2) then
687: p_rec.attribute14 :=
688: pay_cnt_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: pay_cnt_shd.g_old_rec.attribute15;
688: pay_cnt_shd.g_old_rec.attribute14;
689: End If;
690: If (p_rec.attribute15 = hr_api.g_varchar2) then
691: p_rec.attribute15 :=
692: pay_cnt_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: pay_cnt_shd.g_old_rec.attribute16;
692: pay_cnt_shd.g_old_rec.attribute15;
693: End If;
694: If (p_rec.attribute16 = hr_api.g_varchar2) then
695: p_rec.attribute16 :=
696: pay_cnt_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: pay_cnt_shd.g_old_rec.attribute17;
696: pay_cnt_shd.g_old_rec.attribute16;
697: End If;
698: If (p_rec.attribute17 = hr_api.g_varchar2) then
699: p_rec.attribute17 :=
700: pay_cnt_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: pay_cnt_shd.g_old_rec.attribute18;
700: pay_cnt_shd.g_old_rec.attribute17;
701: End If;
702: If (p_rec.attribute18 = hr_api.g_varchar2) then
703: p_rec.attribute18 :=
704: pay_cnt_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: pay_cnt_shd.g_old_rec.attribute19;
704: pay_cnt_shd.g_old_rec.attribute18;
705: End If;
706: If (p_rec.attribute19 = hr_api.g_varchar2) then
707: p_rec.attribute19 :=
708: pay_cnt_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: pay_cnt_shd.g_old_rec.attribute20;
708: pay_cnt_shd.g_old_rec.attribute19;
709: End If;
710: If (p_rec.attribute20 = hr_api.g_varchar2) then
711: p_rec.attribute20 :=
712: pay_cnt_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: pay_cnt_shd.g_old_rec.attribute21;
712: pay_cnt_shd.g_old_rec.attribute20;
713: End If;
714: If (p_rec.attribute21 = hr_api.g_varchar2) then
715: p_rec.attribute21 :=
716: pay_cnt_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: pay_cnt_shd.g_old_rec.attribute22;
716: pay_cnt_shd.g_old_rec.attribute21;
717: End If;
718: If (p_rec.attribute22 = hr_api.g_varchar2) then
719: p_rec.attribute22 :=
720: pay_cnt_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: pay_cnt_shd.g_old_rec.attribute23;
720: pay_cnt_shd.g_old_rec.attribute22;
721: End If;
722: If (p_rec.attribute23 = hr_api.g_varchar2) then
723: p_rec.attribute23 :=
724: pay_cnt_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: pay_cnt_shd.g_old_rec.attribute24;
724: pay_cnt_shd.g_old_rec.attribute23;
725: End If;
726: If (p_rec.attribute24 = hr_api.g_varchar2) then
727: p_rec.attribute24 :=
728: pay_cnt_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: pay_cnt_shd.g_old_rec.attribute25;
728: pay_cnt_shd.g_old_rec.attribute24;
729: End If;
730: If (p_rec.attribute25 = hr_api.g_varchar2) then
731: p_rec.attribute25 :=
732: pay_cnt_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: pay_cnt_shd.g_old_rec.attribute26;
732: pay_cnt_shd.g_old_rec.attribute25;
733: End If;
734: If (p_rec.attribute26 = hr_api.g_varchar2) then
735: p_rec.attribute26 :=
736: pay_cnt_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: pay_cnt_shd.g_old_rec.attribute27;
736: pay_cnt_shd.g_old_rec.attribute26;
737: End If;
738: If (p_rec.attribute27 = hr_api.g_varchar2) then
739: p_rec.attribute27 :=
740: pay_cnt_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: pay_cnt_shd.g_old_rec.attribute28;
740: pay_cnt_shd.g_old_rec.attribute27;
741: End If;
742: If (p_rec.attribute28 = hr_api.g_varchar2) then
743: p_rec.attribute28 :=
744: pay_cnt_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: pay_cnt_shd.g_old_rec.attribute29;
744: pay_cnt_shd.g_old_rec.attribute28;
745: End If;
746: If (p_rec.attribute29 = hr_api.g_varchar2) then
747: p_rec.attribute29 :=
748: pay_cnt_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: pay_cnt_shd.g_old_rec.attribute30;
748: pay_cnt_shd.g_old_rec.attribute29;
749: End If;
750: If (p_rec.attribute30 = hr_api.g_varchar2) then
751: p_rec.attribute30 :=
752: pay_cnt_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.cnt_information_category = hr_api.g_varchar2) then
755: p_rec.cnt_information_category :=
756: pay_cnt_shd.g_old_rec.cnt_information_category;
752: pay_cnt_shd.g_old_rec.attribute30;
753: End If;
754: If (p_rec.cnt_information_category = hr_api.g_varchar2) then
755: p_rec.cnt_information_category :=
756: pay_cnt_shd.g_old_rec.cnt_information_category;
757: End If;
758: If (p_rec.cnt_information1 = hr_api.g_varchar2) then
759: p_rec.cnt_information1 :=
760: pay_cnt_shd.g_old_rec.cnt_information1;
756: pay_cnt_shd.g_old_rec.cnt_information_category;
757: End If;
758: If (p_rec.cnt_information1 = hr_api.g_varchar2) then
759: p_rec.cnt_information1 :=
760: pay_cnt_shd.g_old_rec.cnt_information1;
761: End If;
762: If (p_rec.cnt_information2 = hr_api.g_varchar2) then
763: p_rec.cnt_information2 :=
764: pay_cnt_shd.g_old_rec.cnt_information2;
760: pay_cnt_shd.g_old_rec.cnt_information1;
761: End If;
762: If (p_rec.cnt_information2 = hr_api.g_varchar2) then
763: p_rec.cnt_information2 :=
764: pay_cnt_shd.g_old_rec.cnt_information2;
765: End If;
766: If (p_rec.cnt_information3 = hr_api.g_varchar2) then
767: p_rec.cnt_information3 :=
768: pay_cnt_shd.g_old_rec.cnt_information3;
764: pay_cnt_shd.g_old_rec.cnt_information2;
765: End If;
766: If (p_rec.cnt_information3 = hr_api.g_varchar2) then
767: p_rec.cnt_information3 :=
768: pay_cnt_shd.g_old_rec.cnt_information3;
769: End If;
770: If (p_rec.cnt_information4 = hr_api.g_varchar2) then
771: p_rec.cnt_information4 :=
772: pay_cnt_shd.g_old_rec.cnt_information4;
768: pay_cnt_shd.g_old_rec.cnt_information3;
769: End If;
770: If (p_rec.cnt_information4 = hr_api.g_varchar2) then
771: p_rec.cnt_information4 :=
772: pay_cnt_shd.g_old_rec.cnt_information4;
773: End If;
774: If (p_rec.cnt_information5 = hr_api.g_varchar2) then
775: p_rec.cnt_information5 :=
776: pay_cnt_shd.g_old_rec.cnt_information5;
772: pay_cnt_shd.g_old_rec.cnt_information4;
773: End If;
774: If (p_rec.cnt_information5 = hr_api.g_varchar2) then
775: p_rec.cnt_information5 :=
776: pay_cnt_shd.g_old_rec.cnt_information5;
777: End If;
778: If (p_rec.cnt_information6 = hr_api.g_varchar2) then
779: p_rec.cnt_information6 :=
780: pay_cnt_shd.g_old_rec.cnt_information6;
776: pay_cnt_shd.g_old_rec.cnt_information5;
777: End If;
778: If (p_rec.cnt_information6 = hr_api.g_varchar2) then
779: p_rec.cnt_information6 :=
780: pay_cnt_shd.g_old_rec.cnt_information6;
781: End If;
782: If (p_rec.cnt_information7 = hr_api.g_varchar2) then
783: p_rec.cnt_information7 :=
784: pay_cnt_shd.g_old_rec.cnt_information7;
780: pay_cnt_shd.g_old_rec.cnt_information6;
781: End If;
782: If (p_rec.cnt_information7 = hr_api.g_varchar2) then
783: p_rec.cnt_information7 :=
784: pay_cnt_shd.g_old_rec.cnt_information7;
785: End If;
786: If (p_rec.cnt_information8 = hr_api.g_varchar2) then
787: p_rec.cnt_information8 :=
788: pay_cnt_shd.g_old_rec.cnt_information8;
784: pay_cnt_shd.g_old_rec.cnt_information7;
785: End If;
786: If (p_rec.cnt_information8 = hr_api.g_varchar2) then
787: p_rec.cnt_information8 :=
788: pay_cnt_shd.g_old_rec.cnt_information8;
789: End If;
790: If (p_rec.cnt_information9 = hr_api.g_varchar2) then
791: p_rec.cnt_information9 :=
792: pay_cnt_shd.g_old_rec.cnt_information9;
788: pay_cnt_shd.g_old_rec.cnt_information8;
789: End If;
790: If (p_rec.cnt_information9 = hr_api.g_varchar2) then
791: p_rec.cnt_information9 :=
792: pay_cnt_shd.g_old_rec.cnt_information9;
793: End If;
794: If (p_rec.cnt_information10 = hr_api.g_varchar2) then
795: p_rec.cnt_information10 :=
796: pay_cnt_shd.g_old_rec.cnt_information10;
792: pay_cnt_shd.g_old_rec.cnt_information9;
793: End If;
794: If (p_rec.cnt_information10 = hr_api.g_varchar2) then
795: p_rec.cnt_information10 :=
796: pay_cnt_shd.g_old_rec.cnt_information10;
797: End If;
798: If (p_rec.cnt_information11 = hr_api.g_varchar2) then
799: p_rec.cnt_information11 :=
800: pay_cnt_shd.g_old_rec.cnt_information11;
796: pay_cnt_shd.g_old_rec.cnt_information10;
797: End If;
798: If (p_rec.cnt_information11 = hr_api.g_varchar2) then
799: p_rec.cnt_information11 :=
800: pay_cnt_shd.g_old_rec.cnt_information11;
801: End If;
802: If (p_rec.cnt_information12 = hr_api.g_varchar2) then
803: p_rec.cnt_information12 :=
804: pay_cnt_shd.g_old_rec.cnt_information12;
800: pay_cnt_shd.g_old_rec.cnt_information11;
801: End If;
802: If (p_rec.cnt_information12 = hr_api.g_varchar2) then
803: p_rec.cnt_information12 :=
804: pay_cnt_shd.g_old_rec.cnt_information12;
805: End If;
806: If (p_rec.cnt_information13 = hr_api.g_varchar2) then
807: p_rec.cnt_information13 :=
808: pay_cnt_shd.g_old_rec.cnt_information13;
804: pay_cnt_shd.g_old_rec.cnt_information12;
805: End If;
806: If (p_rec.cnt_information13 = hr_api.g_varchar2) then
807: p_rec.cnt_information13 :=
808: pay_cnt_shd.g_old_rec.cnt_information13;
809: End If;
810: If (p_rec.cnt_information14 = hr_api.g_varchar2) then
811: p_rec.cnt_information14 :=
812: pay_cnt_shd.g_old_rec.cnt_information14;
808: pay_cnt_shd.g_old_rec.cnt_information13;
809: End If;
810: If (p_rec.cnt_information14 = hr_api.g_varchar2) then
811: p_rec.cnt_information14 :=
812: pay_cnt_shd.g_old_rec.cnt_information14;
813: End If;
814: If (p_rec.cnt_information15 = hr_api.g_varchar2) then
815: p_rec.cnt_information15 :=
816: pay_cnt_shd.g_old_rec.cnt_information15;
812: pay_cnt_shd.g_old_rec.cnt_information14;
813: End If;
814: If (p_rec.cnt_information15 = hr_api.g_varchar2) then
815: p_rec.cnt_information15 :=
816: pay_cnt_shd.g_old_rec.cnt_information15;
817: End If;
818: If (p_rec.cnt_information16 = hr_api.g_varchar2) then
819: p_rec.cnt_information16 :=
820: pay_cnt_shd.g_old_rec.cnt_information16;
816: pay_cnt_shd.g_old_rec.cnt_information15;
817: End If;
818: If (p_rec.cnt_information16 = hr_api.g_varchar2) then
819: p_rec.cnt_information16 :=
820: pay_cnt_shd.g_old_rec.cnt_information16;
821: End If;
822: If (p_rec.cnt_information17 = hr_api.g_varchar2) then
823: p_rec.cnt_information17 :=
824: pay_cnt_shd.g_old_rec.cnt_information17;
820: pay_cnt_shd.g_old_rec.cnt_information16;
821: End If;
822: If (p_rec.cnt_information17 = hr_api.g_varchar2) then
823: p_rec.cnt_information17 :=
824: pay_cnt_shd.g_old_rec.cnt_information17;
825: End If;
826: If (p_rec.cnt_information18 = hr_api.g_varchar2) then
827: p_rec.cnt_information18 :=
828: pay_cnt_shd.g_old_rec.cnt_information18;
824: pay_cnt_shd.g_old_rec.cnt_information17;
825: End If;
826: If (p_rec.cnt_information18 = hr_api.g_varchar2) then
827: p_rec.cnt_information18 :=
828: pay_cnt_shd.g_old_rec.cnt_information18;
829: End If;
830: If (p_rec.cnt_information19 = hr_api.g_varchar2) then
831: p_rec.cnt_information19 :=
832: pay_cnt_shd.g_old_rec.cnt_information19;
828: pay_cnt_shd.g_old_rec.cnt_information18;
829: End If;
830: If (p_rec.cnt_information19 = hr_api.g_varchar2) then
831: p_rec.cnt_information19 :=
832: pay_cnt_shd.g_old_rec.cnt_information19;
833: End If;
834: If (p_rec.cnt_information20 = hr_api.g_varchar2) then
835: p_rec.cnt_information20 :=
836: pay_cnt_shd.g_old_rec.cnt_information20;
832: pay_cnt_shd.g_old_rec.cnt_information19;
833: End If;
834: If (p_rec.cnt_information20 = hr_api.g_varchar2) then
835: p_rec.cnt_information20 :=
836: pay_cnt_shd.g_old_rec.cnt_information20;
837: End If;
838: If (p_rec.cnt_information21 = hr_api.g_varchar2) then
839: p_rec.cnt_information21 :=
840: pay_cnt_shd.g_old_rec.cnt_information21;
836: pay_cnt_shd.g_old_rec.cnt_information20;
837: End If;
838: If (p_rec.cnt_information21 = hr_api.g_varchar2) then
839: p_rec.cnt_information21 :=
840: pay_cnt_shd.g_old_rec.cnt_information21;
841: End If;
842: If (p_rec.cnt_information22 = hr_api.g_varchar2) then
843: p_rec.cnt_information22 :=
844: pay_cnt_shd.g_old_rec.cnt_information22;
840: pay_cnt_shd.g_old_rec.cnt_information21;
841: End If;
842: If (p_rec.cnt_information22 = hr_api.g_varchar2) then
843: p_rec.cnt_information22 :=
844: pay_cnt_shd.g_old_rec.cnt_information22;
845: End If;
846: If (p_rec.cnt_information23 = hr_api.g_varchar2) then
847: p_rec.cnt_information23 :=
848: pay_cnt_shd.g_old_rec.cnt_information23;
844: pay_cnt_shd.g_old_rec.cnt_information22;
845: End If;
846: If (p_rec.cnt_information23 = hr_api.g_varchar2) then
847: p_rec.cnt_information23 :=
848: pay_cnt_shd.g_old_rec.cnt_information23;
849: End If;
850: If (p_rec.cnt_information24 = hr_api.g_varchar2) then
851: p_rec.cnt_information24 :=
852: pay_cnt_shd.g_old_rec.cnt_information24;
848: pay_cnt_shd.g_old_rec.cnt_information23;
849: End If;
850: If (p_rec.cnt_information24 = hr_api.g_varchar2) then
851: p_rec.cnt_information24 :=
852: pay_cnt_shd.g_old_rec.cnt_information24;
853: End If;
854: If (p_rec.cnt_information25 = hr_api.g_varchar2) then
855: p_rec.cnt_information25 :=
856: pay_cnt_shd.g_old_rec.cnt_information25;
852: pay_cnt_shd.g_old_rec.cnt_information24;
853: End If;
854: If (p_rec.cnt_information25 = hr_api.g_varchar2) then
855: p_rec.cnt_information25 :=
856: pay_cnt_shd.g_old_rec.cnt_information25;
857: End If;
858: If (p_rec.cnt_information26 = hr_api.g_varchar2) then
859: p_rec.cnt_information26 :=
860: pay_cnt_shd.g_old_rec.cnt_information26;
856: pay_cnt_shd.g_old_rec.cnt_information25;
857: End If;
858: If (p_rec.cnt_information26 = hr_api.g_varchar2) then
859: p_rec.cnt_information26 :=
860: pay_cnt_shd.g_old_rec.cnt_information26;
861: End If;
862: If (p_rec.cnt_information27 = hr_api.g_varchar2) then
863: p_rec.cnt_information27 :=
864: pay_cnt_shd.g_old_rec.cnt_information27;
860: pay_cnt_shd.g_old_rec.cnt_information26;
861: End If;
862: If (p_rec.cnt_information27 = hr_api.g_varchar2) then
863: p_rec.cnt_information27 :=
864: pay_cnt_shd.g_old_rec.cnt_information27;
865: End If;
866: If (p_rec.cnt_information28 = hr_api.g_varchar2) then
867: p_rec.cnt_information28 :=
868: pay_cnt_shd.g_old_rec.cnt_information28;
864: pay_cnt_shd.g_old_rec.cnt_information27;
865: End If;
866: If (p_rec.cnt_information28 = hr_api.g_varchar2) then
867: p_rec.cnt_information28 :=
868: pay_cnt_shd.g_old_rec.cnt_information28;
869: End If;
870: If (p_rec.cnt_information29 = hr_api.g_varchar2) then
871: p_rec.cnt_information29 :=
872: pay_cnt_shd.g_old_rec.cnt_information29;
868: pay_cnt_shd.g_old_rec.cnt_information28;
869: End If;
870: If (p_rec.cnt_information29 = hr_api.g_varchar2) then
871: p_rec.cnt_information29 :=
872: pay_cnt_shd.g_old_rec.cnt_information29;
873: End If;
874: If (p_rec.cnt_information30 = hr_api.g_varchar2) then
875: p_rec.cnt_information30 :=
876: pay_cnt_shd.g_old_rec.cnt_information30;
872: pay_cnt_shd.g_old_rec.cnt_information29;
873: End If;
874: If (p_rec.cnt_information30 = hr_api.g_varchar2) then
875: p_rec.cnt_information30 :=
876: pay_cnt_shd.g_old_rec.cnt_information30;
877: End If;
878:
879: --
880: hr_utility.set_location(' Leaving:'||l_proc, 10);
885: -- |---------------------------------< upd >----------------------------------|
886: -- ----------------------------------------------------------------------------
887: Procedure upd
888: (
889: p_rec in out nocopy pay_cnt_shd.g_rec_type,
890: p_effective_date in date,
891: p_datetrack_mode in varchar2
892: ) is
893: --
903: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
904: --
905: -- We must lock the row which we need to update.
906: --
907: pay_cnt_shd.lck
908: (p_effective_date => p_effective_date,
909: p_datetrack_mode => p_datetrack_mode,
910: p_emp_county_tax_rule_id => p_rec.emp_county_tax_rule_id,
911: p_object_version_number => p_rec.object_version_number,
1039: p_cnt_information29 in varchar2 default hr_api.g_varchar2,
1040: p_cnt_information30 in varchar2 default hr_api.g_varchar2
1041: ) is
1042: --
1043: l_rec pay_cnt_shd.g_rec_type;
1044: l_proc varchar2(72) := g_package||'upd';
1045: --
1046: Begin
1047: hr_utility.set_location('Entering:'||l_proc, 5);
1049: -- Call conversion function to turn arguments into the
1050: -- l_rec structure.
1051: --
1052: l_rec :=
1053: pay_cnt_shd.convert_args
1054: (
1055: p_emp_county_tax_rule_id,
1056: null,
1057: null,