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_CTY_UPD dependencies on PAY_CTY_SHD

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

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_cty_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_cty_shd.g_api_dml := true; -- Set the api dml status

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

Line 172: pay_cty_shd.g_api_dml := false; -- Unset the api dml status

168: where emp_city_tax_rule_id = p_rec.emp_city_tax_rule_id
169: and effective_start_date = p_validation_start_date
170: and effective_end_date = p_validation_end_date;
171: --
172: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
173: --
174: -- Set the effective start and end dates
175: --
176: p_rec.effective_start_date := p_validation_start_date;

Line 184: pay_cty_shd.g_api_dml := false; -- Unset the api dml status

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

Line 185: pay_cty_shd.constraint_error

181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
185: pay_cty_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status

Line 189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status

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

Line 190: pay_cty_shd.constraint_error

186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.unique_integrity_violated Then
188: -- Unique integrity has been violated
189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
190: pay_cty_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;

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

189: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
190: pay_cty_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When Others Then
193: pay_cty_shd.g_api_dml := false; -- Unset the api dml status
194: Raise;
195: End dt_update_dml;
196: --
197: -- ----------------------------------------------------------------------------

Line 229: (p_rec in out nocopy pay_cty_shd.g_rec_type,

225: --
226: -- {End Of Comments}
227: -- ----------------------------------------------------------------------------
228: Procedure update_dml
229: (p_rec in out nocopy pay_cty_shd.g_rec_type,
230: p_effective_date in date,
231: p_datetrack_mode in varchar2,
232: p_validation_start_date in date,
233: p_validation_end_date in date) is

Line 293: (p_rec in out nocopy pay_cty_shd.g_rec_type,

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure dt_pre_update
293: (p_rec in out nocopy pay_cty_shd.g_rec_type,
294: p_effective_date in date,
295: p_datetrack_mode in varchar2,
296: p_validation_start_date in date,
297: p_validation_end_date in date) is

Line 309: pay_cty_shd.upd_effective_end_date

305: hr_utility.set_location(l_proc, 10);
306: --
307: -- Update the current effective end date
308: --
309: pay_cty_shd.upd_effective_end_date
310: (p_effective_date => p_effective_date,
311: p_base_key_value => p_rec.emp_city_tax_rule_id,
312: p_new_effective_end_date => (p_validation_start_date - 1),
313: p_validation_start_date => p_validation_start_date,

Line 378: (p_rec in out nocopy pay_cty_shd.g_rec_type,

374: --
375: -- {End Of Comments}
376: -- ----------------------------------------------------------------------------
377: Procedure pre_update
378: (p_rec in out nocopy pay_cty_shd.g_rec_type,
379: p_effective_date in date,
380: p_datetrack_mode in varchar2,
381: p_validation_start_date in date,
382: p_validation_end_date in date) is

Line 434: (p_rec in pay_cty_shd.g_rec_type,

430: --
431: -- {End Of Comments}
432: -- ----------------------------------------------------------------------------
433: Procedure post_update
434: (p_rec in pay_cty_shd.g_rec_type,
435: p_effective_date in date,
436: p_datetrack_mode in varchar2,
437: p_validation_start_date in date,
438: p_validation_end_date in date) is

Line 473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date

469: ,p_effective_date =>p_effective_date
470: ,p_datetrack_mode =>p_datetrack_mode
471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date
474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code

Line 474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date

470: ,p_datetrack_mode =>p_datetrack_mode
471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date
474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code

Line 475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id

471: ,p_validation_start_date =>p_validation_start_date
472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date
474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id

Line 476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code

472: ,p_validation_end_date =>p_validation_end_date
473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date
474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate

Line 477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code

473: ,p_effective_start_date_o =>pay_cty_shd.g_old_rec.effective_start_date
474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code

Line 478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code

474: ,p_effective_end_date_o =>pay_cty_shd.g_old_rec.effective_end_date
475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code

Line 479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id

475: ,p_assignment_id_o =>pay_cty_shd.g_old_rec.assignment_id
476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax

Line 480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate

476: ,p_state_code_o =>pay_cty_shd.g_old_rec.state_code
477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount

Line 481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code

477: ,p_county_code_o =>pay_cty_shd.g_old_rec.county_code
478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate

Line 482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code

478: ,p_city_code_o =>pay_cty_shd.g_old_rec.city_code
479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances

Line 483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax

479: ,p_business_group_id_o =>pay_cty_shd.g_old_rec.business_group_id
480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt

Line 484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount

480: ,p_additional_wa_rate_o =>pay_cty_shd.g_old_rec.additional_wa_rate
481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt

Line 485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate

481: ,p_filing_status_code_o =>pay_cty_shd.g_old_rec.filing_status_code
482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt

Line 486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances

482: ,p_jurisdiction_code_o =>pay_cty_shd.g_old_rec.jurisdiction_code
483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt

Line 487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt

483: ,p_lit_additional_tax_o =>pay_cty_shd.g_old_rec.lit_additional_tax
484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code

Line 488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt

484: ,p_lit_override_amount_o =>pay_cty_shd.g_old_rec.lit_override_amount
485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code
492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number

Line 489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt

485: ,p_lit_override_rate_o =>pay_cty_shd.g_old_rec.lit_override_rate
486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code
492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number
493: );

Line 490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt

486: ,p_withholding_allowances_o =>pay_cty_shd.g_old_rec.withholding_allowances
487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code
492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number
493: );
494: --

Line 491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code

487: ,p_lit_exempt_o =>pay_cty_shd.g_old_rec.lit_exempt
488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code
492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number
493: );
494: --
495: exception

Line 492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number

488: ,p_sd_exempt_o =>pay_cty_shd.g_old_rec.sd_exempt
489: ,p_ht_exempt_o =>pay_cty_shd.g_old_rec.ht_exempt
490: ,p_wage_exempt_o =>pay_cty_shd.g_old_rec.wage_exempt
491: ,p_school_district_code_o =>pay_cty_shd.g_old_rec.school_district_code
492: ,p_object_version_number_o =>pay_cty_shd.g_old_rec.object_version_number
493: );
494: --
495: exception
496: --

Line 555: Procedure convert_defs(p_rec in out nocopy pay_cty_shd.g_rec_type) is

551: -- Internal Row Handler Use Only.
552: --
553: -- {End Of Comments}
554: -- ----------------------------------------------------------------------------
555: Procedure convert_defs(p_rec in out nocopy pay_cty_shd.g_rec_type) is
556: --
557: l_proc varchar2(72) := g_package||'convert_defs';
558: --
559: Begin

Line 570: pay_cty_shd.g_old_rec.assignment_id;

566: -- is being used then we must set to the 'current' argument value.
567: --
568: If (p_rec.assignment_id = hr_api.g_number) then
569: p_rec.assignment_id :=
570: pay_cty_shd.g_old_rec.assignment_id;
571: End If;
572: If (p_rec.state_code = hr_api.g_varchar2) then
573: p_rec.state_code :=
574: pay_cty_shd.g_old_rec.state_code;

Line 574: pay_cty_shd.g_old_rec.state_code;

570: pay_cty_shd.g_old_rec.assignment_id;
571: End If;
572: If (p_rec.state_code = hr_api.g_varchar2) then
573: p_rec.state_code :=
574: pay_cty_shd.g_old_rec.state_code;
575: End If;
576: If (p_rec.county_code = hr_api.g_varchar2) then
577: p_rec.county_code :=
578: pay_cty_shd.g_old_rec.county_code;

Line 578: pay_cty_shd.g_old_rec.county_code;

574: pay_cty_shd.g_old_rec.state_code;
575: End If;
576: If (p_rec.county_code = hr_api.g_varchar2) then
577: p_rec.county_code :=
578: pay_cty_shd.g_old_rec.county_code;
579: End If;
580: If (p_rec.city_code = hr_api.g_varchar2) then
581: p_rec.city_code :=
582: pay_cty_shd.g_old_rec.city_code;

Line 582: pay_cty_shd.g_old_rec.city_code;

578: pay_cty_shd.g_old_rec.county_code;
579: End If;
580: If (p_rec.city_code = hr_api.g_varchar2) then
581: p_rec.city_code :=
582: pay_cty_shd.g_old_rec.city_code;
583: End If;
584: If (p_rec.business_group_id = hr_api.g_number) then
585: p_rec.business_group_id :=
586: pay_cty_shd.g_old_rec.business_group_id;

Line 586: pay_cty_shd.g_old_rec.business_group_id;

582: pay_cty_shd.g_old_rec.city_code;
583: End If;
584: If (p_rec.business_group_id = hr_api.g_number) then
585: p_rec.business_group_id :=
586: pay_cty_shd.g_old_rec.business_group_id;
587: End If;
588: If (p_rec.additional_wa_rate = hr_api.g_number) then
589: p_rec.additional_wa_rate :=
590: pay_cty_shd.g_old_rec.additional_wa_rate;

Line 590: pay_cty_shd.g_old_rec.additional_wa_rate;

586: pay_cty_shd.g_old_rec.business_group_id;
587: End If;
588: If (p_rec.additional_wa_rate = hr_api.g_number) then
589: p_rec.additional_wa_rate :=
590: pay_cty_shd.g_old_rec.additional_wa_rate;
591: End If;
592: If (p_rec.filing_status_code = hr_api.g_varchar2) then
593: p_rec.filing_status_code :=
594: pay_cty_shd.g_old_rec.filing_status_code;

Line 594: pay_cty_shd.g_old_rec.filing_status_code;

590: pay_cty_shd.g_old_rec.additional_wa_rate;
591: End If;
592: If (p_rec.filing_status_code = hr_api.g_varchar2) then
593: p_rec.filing_status_code :=
594: pay_cty_shd.g_old_rec.filing_status_code;
595: End If;
596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
597: p_rec.jurisdiction_code :=
598: pay_cty_shd.g_old_rec.jurisdiction_code;

Line 598: pay_cty_shd.g_old_rec.jurisdiction_code;

594: pay_cty_shd.g_old_rec.filing_status_code;
595: End If;
596: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
597: p_rec.jurisdiction_code :=
598: pay_cty_shd.g_old_rec.jurisdiction_code;
599: End If;
600: If (p_rec.lit_additional_tax = hr_api.g_number) then
601: p_rec.lit_additional_tax :=
602: pay_cty_shd.g_old_rec.lit_additional_tax;

Line 602: pay_cty_shd.g_old_rec.lit_additional_tax;

598: pay_cty_shd.g_old_rec.jurisdiction_code;
599: End If;
600: If (p_rec.lit_additional_tax = hr_api.g_number) then
601: p_rec.lit_additional_tax :=
602: pay_cty_shd.g_old_rec.lit_additional_tax;
603: End If;
604: If (p_rec.lit_override_amount = hr_api.g_number) then
605: p_rec.lit_override_amount :=
606: pay_cty_shd.g_old_rec.lit_override_amount;

Line 606: pay_cty_shd.g_old_rec.lit_override_amount;

602: pay_cty_shd.g_old_rec.lit_additional_tax;
603: End If;
604: If (p_rec.lit_override_amount = hr_api.g_number) then
605: p_rec.lit_override_amount :=
606: pay_cty_shd.g_old_rec.lit_override_amount;
607: End If;
608: If (p_rec.lit_override_rate = hr_api.g_number) then
609: p_rec.lit_override_rate :=
610: pay_cty_shd.g_old_rec.lit_override_rate;

Line 610: pay_cty_shd.g_old_rec.lit_override_rate;

606: pay_cty_shd.g_old_rec.lit_override_amount;
607: End If;
608: If (p_rec.lit_override_rate = hr_api.g_number) then
609: p_rec.lit_override_rate :=
610: pay_cty_shd.g_old_rec.lit_override_rate;
611: End If;
612: If (p_rec.withholding_allowances = hr_api.g_number) then
613: p_rec.withholding_allowances :=
614: pay_cty_shd.g_old_rec.withholding_allowances;

Line 614: pay_cty_shd.g_old_rec.withholding_allowances;

610: pay_cty_shd.g_old_rec.lit_override_rate;
611: End If;
612: If (p_rec.withholding_allowances = hr_api.g_number) then
613: p_rec.withholding_allowances :=
614: pay_cty_shd.g_old_rec.withholding_allowances;
615: End If;
616: If (p_rec.lit_exempt = hr_api.g_varchar2) then
617: p_rec.lit_exempt :=
618: pay_cty_shd.g_old_rec.lit_exempt;

Line 618: pay_cty_shd.g_old_rec.lit_exempt;

614: pay_cty_shd.g_old_rec.withholding_allowances;
615: End If;
616: If (p_rec.lit_exempt = hr_api.g_varchar2) then
617: p_rec.lit_exempt :=
618: pay_cty_shd.g_old_rec.lit_exempt;
619: End If;
620: If (p_rec.sd_exempt = hr_api.g_varchar2) then
621: p_rec.sd_exempt :=
622: pay_cty_shd.g_old_rec.sd_exempt;

Line 622: pay_cty_shd.g_old_rec.sd_exempt;

618: pay_cty_shd.g_old_rec.lit_exempt;
619: End If;
620: If (p_rec.sd_exempt = hr_api.g_varchar2) then
621: p_rec.sd_exempt :=
622: pay_cty_shd.g_old_rec.sd_exempt;
623: End If;
624: If (p_rec.ht_exempt = hr_api.g_varchar2) then
625: p_rec.ht_exempt :=
626: pay_cty_shd.g_old_rec.ht_exempt;

Line 626: pay_cty_shd.g_old_rec.ht_exempt;

622: pay_cty_shd.g_old_rec.sd_exempt;
623: End If;
624: If (p_rec.ht_exempt = hr_api.g_varchar2) then
625: p_rec.ht_exempt :=
626: pay_cty_shd.g_old_rec.ht_exempt;
627: End If;
628: If (p_rec.wage_exempt = hr_api.g_varchar2) then
629: p_rec.wage_exempt :=
630: pay_cty_shd.g_old_rec.wage_exempt;

Line 630: pay_cty_shd.g_old_rec.wage_exempt;

626: pay_cty_shd.g_old_rec.ht_exempt;
627: End If;
628: If (p_rec.wage_exempt = hr_api.g_varchar2) then
629: p_rec.wage_exempt :=
630: pay_cty_shd.g_old_rec.wage_exempt;
631: End If;
632: If (p_rec.school_district_code = hr_api.g_varchar2) then
633: p_rec.school_district_code :=
634: pay_cty_shd.g_old_rec.school_district_code;

Line 634: pay_cty_shd.g_old_rec.school_district_code;

630: pay_cty_shd.g_old_rec.wage_exempt;
631: End If;
632: If (p_rec.school_district_code = hr_api.g_varchar2) then
633: p_rec.school_district_code :=
634: pay_cty_shd.g_old_rec.school_district_code;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: pay_cty_shd.g_old_rec.attribute_category;

Line 638: pay_cty_shd.g_old_rec.attribute_category;

634: pay_cty_shd.g_old_rec.school_district_code;
635: End If;
636: If (p_rec.attribute_category = hr_api.g_varchar2) then
637: p_rec.attribute_category :=
638: pay_cty_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: pay_cty_shd.g_old_rec.attribute1;

Line 642: pay_cty_shd.g_old_rec.attribute1;

638: pay_cty_shd.g_old_rec.attribute_category;
639: End If;
640: If (p_rec.attribute1 = hr_api.g_varchar2) then
641: p_rec.attribute1 :=
642: pay_cty_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: pay_cty_shd.g_old_rec.attribute2;

Line 646: pay_cty_shd.g_old_rec.attribute2;

642: pay_cty_shd.g_old_rec.attribute1;
643: End If;
644: If (p_rec.attribute2 = hr_api.g_varchar2) then
645: p_rec.attribute2 :=
646: pay_cty_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: pay_cty_shd.g_old_rec.attribute3;

Line 650: pay_cty_shd.g_old_rec.attribute3;

646: pay_cty_shd.g_old_rec.attribute2;
647: End If;
648: If (p_rec.attribute3 = hr_api.g_varchar2) then
649: p_rec.attribute3 :=
650: pay_cty_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: pay_cty_shd.g_old_rec.attribute4;

Line 654: pay_cty_shd.g_old_rec.attribute4;

650: pay_cty_shd.g_old_rec.attribute3;
651: End If;
652: If (p_rec.attribute4 = hr_api.g_varchar2) then
653: p_rec.attribute4 :=
654: pay_cty_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: pay_cty_shd.g_old_rec.attribute5;

Line 658: pay_cty_shd.g_old_rec.attribute5;

654: pay_cty_shd.g_old_rec.attribute4;
655: End If;
656: If (p_rec.attribute5 = hr_api.g_varchar2) then
657: p_rec.attribute5 :=
658: pay_cty_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: pay_cty_shd.g_old_rec.attribute6;

Line 662: pay_cty_shd.g_old_rec.attribute6;

658: pay_cty_shd.g_old_rec.attribute5;
659: End If;
660: If (p_rec.attribute6 = hr_api.g_varchar2) then
661: p_rec.attribute6 :=
662: pay_cty_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: pay_cty_shd.g_old_rec.attribute7;

Line 666: pay_cty_shd.g_old_rec.attribute7;

662: pay_cty_shd.g_old_rec.attribute6;
663: End If;
664: If (p_rec.attribute7 = hr_api.g_varchar2) then
665: p_rec.attribute7 :=
666: pay_cty_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: pay_cty_shd.g_old_rec.attribute8;

Line 670: pay_cty_shd.g_old_rec.attribute8;

666: pay_cty_shd.g_old_rec.attribute7;
667: End If;
668: If (p_rec.attribute8 = hr_api.g_varchar2) then
669: p_rec.attribute8 :=
670: pay_cty_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: pay_cty_shd.g_old_rec.attribute9;

Line 674: pay_cty_shd.g_old_rec.attribute9;

670: pay_cty_shd.g_old_rec.attribute8;
671: End If;
672: If (p_rec.attribute9 = hr_api.g_varchar2) then
673: p_rec.attribute9 :=
674: pay_cty_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: pay_cty_shd.g_old_rec.attribute10;

Line 678: pay_cty_shd.g_old_rec.attribute10;

674: pay_cty_shd.g_old_rec.attribute9;
675: End If;
676: If (p_rec.attribute10 = hr_api.g_varchar2) then
677: p_rec.attribute10 :=
678: pay_cty_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: pay_cty_shd.g_old_rec.attribute11;

Line 682: pay_cty_shd.g_old_rec.attribute11;

678: pay_cty_shd.g_old_rec.attribute10;
679: End If;
680: If (p_rec.attribute11 = hr_api.g_varchar2) then
681: p_rec.attribute11 :=
682: pay_cty_shd.g_old_rec.attribute11;
683: End If;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: pay_cty_shd.g_old_rec.attribute12;

Line 686: pay_cty_shd.g_old_rec.attribute12;

682: pay_cty_shd.g_old_rec.attribute11;
683: End If;
684: If (p_rec.attribute12 = hr_api.g_varchar2) then
685: p_rec.attribute12 :=
686: pay_cty_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: pay_cty_shd.g_old_rec.attribute13;

Line 690: pay_cty_shd.g_old_rec.attribute13;

686: pay_cty_shd.g_old_rec.attribute12;
687: End If;
688: If (p_rec.attribute13 = hr_api.g_varchar2) then
689: p_rec.attribute13 :=
690: pay_cty_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: pay_cty_shd.g_old_rec.attribute14;

Line 694: pay_cty_shd.g_old_rec.attribute14;

690: pay_cty_shd.g_old_rec.attribute13;
691: End If;
692: If (p_rec.attribute14 = hr_api.g_varchar2) then
693: p_rec.attribute14 :=
694: pay_cty_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: pay_cty_shd.g_old_rec.attribute15;

Line 698: pay_cty_shd.g_old_rec.attribute15;

694: pay_cty_shd.g_old_rec.attribute14;
695: End If;
696: If (p_rec.attribute15 = hr_api.g_varchar2) then
697: p_rec.attribute15 :=
698: pay_cty_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: pay_cty_shd.g_old_rec.attribute16;

Line 702: pay_cty_shd.g_old_rec.attribute16;

698: pay_cty_shd.g_old_rec.attribute15;
699: End If;
700: If (p_rec.attribute16 = hr_api.g_varchar2) then
701: p_rec.attribute16 :=
702: pay_cty_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: pay_cty_shd.g_old_rec.attribute17;

Line 706: pay_cty_shd.g_old_rec.attribute17;

702: pay_cty_shd.g_old_rec.attribute16;
703: End If;
704: If (p_rec.attribute17 = hr_api.g_varchar2) then
705: p_rec.attribute17 :=
706: pay_cty_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: pay_cty_shd.g_old_rec.attribute18;

Line 710: pay_cty_shd.g_old_rec.attribute18;

706: pay_cty_shd.g_old_rec.attribute17;
707: End If;
708: If (p_rec.attribute18 = hr_api.g_varchar2) then
709: p_rec.attribute18 :=
710: pay_cty_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: pay_cty_shd.g_old_rec.attribute19;

Line 714: pay_cty_shd.g_old_rec.attribute19;

710: pay_cty_shd.g_old_rec.attribute18;
711: End If;
712: If (p_rec.attribute19 = hr_api.g_varchar2) then
713: p_rec.attribute19 :=
714: pay_cty_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: pay_cty_shd.g_old_rec.attribute20;

Line 718: pay_cty_shd.g_old_rec.attribute20;

714: pay_cty_shd.g_old_rec.attribute19;
715: End If;
716: If (p_rec.attribute20 = hr_api.g_varchar2) then
717: p_rec.attribute20 :=
718: pay_cty_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.attribute21 = hr_api.g_varchar2) then
721: p_rec.attribute21 :=
722: pay_cty_shd.g_old_rec.attribute21;

Line 722: pay_cty_shd.g_old_rec.attribute21;

718: pay_cty_shd.g_old_rec.attribute20;
719: End If;
720: If (p_rec.attribute21 = hr_api.g_varchar2) then
721: p_rec.attribute21 :=
722: pay_cty_shd.g_old_rec.attribute21;
723: End If;
724: If (p_rec.attribute22 = hr_api.g_varchar2) then
725: p_rec.attribute22 :=
726: pay_cty_shd.g_old_rec.attribute22;

Line 726: pay_cty_shd.g_old_rec.attribute22;

722: pay_cty_shd.g_old_rec.attribute21;
723: End If;
724: If (p_rec.attribute22 = hr_api.g_varchar2) then
725: p_rec.attribute22 :=
726: pay_cty_shd.g_old_rec.attribute22;
727: End If;
728: If (p_rec.attribute23 = hr_api.g_varchar2) then
729: p_rec.attribute23 :=
730: pay_cty_shd.g_old_rec.attribute23;

Line 730: pay_cty_shd.g_old_rec.attribute23;

726: pay_cty_shd.g_old_rec.attribute22;
727: End If;
728: If (p_rec.attribute23 = hr_api.g_varchar2) then
729: p_rec.attribute23 :=
730: pay_cty_shd.g_old_rec.attribute23;
731: End If;
732: If (p_rec.attribute24 = hr_api.g_varchar2) then
733: p_rec.attribute24 :=
734: pay_cty_shd.g_old_rec.attribute24;

Line 734: pay_cty_shd.g_old_rec.attribute24;

730: pay_cty_shd.g_old_rec.attribute23;
731: End If;
732: If (p_rec.attribute24 = hr_api.g_varchar2) then
733: p_rec.attribute24 :=
734: pay_cty_shd.g_old_rec.attribute24;
735: End If;
736: If (p_rec.attribute25 = hr_api.g_varchar2) then
737: p_rec.attribute25 :=
738: pay_cty_shd.g_old_rec.attribute25;

Line 738: pay_cty_shd.g_old_rec.attribute25;

734: pay_cty_shd.g_old_rec.attribute24;
735: End If;
736: If (p_rec.attribute25 = hr_api.g_varchar2) then
737: p_rec.attribute25 :=
738: pay_cty_shd.g_old_rec.attribute25;
739: End If;
740: If (p_rec.attribute26 = hr_api.g_varchar2) then
741: p_rec.attribute26 :=
742: pay_cty_shd.g_old_rec.attribute26;

Line 742: pay_cty_shd.g_old_rec.attribute26;

738: pay_cty_shd.g_old_rec.attribute25;
739: End If;
740: If (p_rec.attribute26 = hr_api.g_varchar2) then
741: p_rec.attribute26 :=
742: pay_cty_shd.g_old_rec.attribute26;
743: End If;
744: If (p_rec.attribute27 = hr_api.g_varchar2) then
745: p_rec.attribute27 :=
746: pay_cty_shd.g_old_rec.attribute27;

Line 746: pay_cty_shd.g_old_rec.attribute27;

742: pay_cty_shd.g_old_rec.attribute26;
743: End If;
744: If (p_rec.attribute27 = hr_api.g_varchar2) then
745: p_rec.attribute27 :=
746: pay_cty_shd.g_old_rec.attribute27;
747: End If;
748: If (p_rec.attribute28 = hr_api.g_varchar2) then
749: p_rec.attribute28 :=
750: pay_cty_shd.g_old_rec.attribute28;

Line 750: pay_cty_shd.g_old_rec.attribute28;

746: pay_cty_shd.g_old_rec.attribute27;
747: End If;
748: If (p_rec.attribute28 = hr_api.g_varchar2) then
749: p_rec.attribute28 :=
750: pay_cty_shd.g_old_rec.attribute28;
751: End If;
752: If (p_rec.attribute29 = hr_api.g_varchar2) then
753: p_rec.attribute29 :=
754: pay_cty_shd.g_old_rec.attribute29;

Line 754: pay_cty_shd.g_old_rec.attribute29;

750: pay_cty_shd.g_old_rec.attribute28;
751: End If;
752: If (p_rec.attribute29 = hr_api.g_varchar2) then
753: p_rec.attribute29 :=
754: pay_cty_shd.g_old_rec.attribute29;
755: End If;
756: If (p_rec.attribute30 = hr_api.g_varchar2) then
757: p_rec.attribute30 :=
758: pay_cty_shd.g_old_rec.attribute30;

Line 758: pay_cty_shd.g_old_rec.attribute30;

754: pay_cty_shd.g_old_rec.attribute29;
755: End If;
756: If (p_rec.attribute30 = hr_api.g_varchar2) then
757: p_rec.attribute30 :=
758: pay_cty_shd.g_old_rec.attribute30;
759: End If;
760: If (p_rec.cty_information_category = hr_api.g_varchar2) then
761: p_rec.cty_information_category :=
762: pay_cty_shd.g_old_rec.cty_information_category;

Line 762: pay_cty_shd.g_old_rec.cty_information_category;

758: pay_cty_shd.g_old_rec.attribute30;
759: End If;
760: If (p_rec.cty_information_category = hr_api.g_varchar2) then
761: p_rec.cty_information_category :=
762: pay_cty_shd.g_old_rec.cty_information_category;
763: End If;
764: If (p_rec.cty_information1 = hr_api.g_varchar2) then
765: p_rec.cty_information1 :=
766: pay_cty_shd.g_old_rec.cty_information1;

Line 766: pay_cty_shd.g_old_rec.cty_information1;

762: pay_cty_shd.g_old_rec.cty_information_category;
763: End If;
764: If (p_rec.cty_information1 = hr_api.g_varchar2) then
765: p_rec.cty_information1 :=
766: pay_cty_shd.g_old_rec.cty_information1;
767: End If;
768: If (p_rec.cty_information2 = hr_api.g_varchar2) then
769: p_rec.cty_information2 :=
770: pay_cty_shd.g_old_rec.cty_information2;

Line 770: pay_cty_shd.g_old_rec.cty_information2;

766: pay_cty_shd.g_old_rec.cty_information1;
767: End If;
768: If (p_rec.cty_information2 = hr_api.g_varchar2) then
769: p_rec.cty_information2 :=
770: pay_cty_shd.g_old_rec.cty_information2;
771: End If;
772: If (p_rec.cty_information3 = hr_api.g_varchar2) then
773: p_rec.cty_information3 :=
774: pay_cty_shd.g_old_rec.cty_information3;

Line 774: pay_cty_shd.g_old_rec.cty_information3;

770: pay_cty_shd.g_old_rec.cty_information2;
771: End If;
772: If (p_rec.cty_information3 = hr_api.g_varchar2) then
773: p_rec.cty_information3 :=
774: pay_cty_shd.g_old_rec.cty_information3;
775: End If;
776: If (p_rec.cty_information4 = hr_api.g_varchar2) then
777: p_rec.cty_information4 :=
778: pay_cty_shd.g_old_rec.cty_information4;

Line 778: pay_cty_shd.g_old_rec.cty_information4;

774: pay_cty_shd.g_old_rec.cty_information3;
775: End If;
776: If (p_rec.cty_information4 = hr_api.g_varchar2) then
777: p_rec.cty_information4 :=
778: pay_cty_shd.g_old_rec.cty_information4;
779: End If;
780: If (p_rec.cty_information5 = hr_api.g_varchar2) then
781: p_rec.cty_information5 :=
782: pay_cty_shd.g_old_rec.cty_information5;

Line 782: pay_cty_shd.g_old_rec.cty_information5;

778: pay_cty_shd.g_old_rec.cty_information4;
779: End If;
780: If (p_rec.cty_information5 = hr_api.g_varchar2) then
781: p_rec.cty_information5 :=
782: pay_cty_shd.g_old_rec.cty_information5;
783: End If;
784: If (p_rec.cty_information6 = hr_api.g_varchar2) then
785: p_rec.cty_information6 :=
786: pay_cty_shd.g_old_rec.cty_information6;

Line 786: pay_cty_shd.g_old_rec.cty_information6;

782: pay_cty_shd.g_old_rec.cty_information5;
783: End If;
784: If (p_rec.cty_information6 = hr_api.g_varchar2) then
785: p_rec.cty_information6 :=
786: pay_cty_shd.g_old_rec.cty_information6;
787: End If;
788: If (p_rec.cty_information7 = hr_api.g_varchar2) then
789: p_rec.cty_information7 :=
790: pay_cty_shd.g_old_rec.cty_information7;

Line 790: pay_cty_shd.g_old_rec.cty_information7;

786: pay_cty_shd.g_old_rec.cty_information6;
787: End If;
788: If (p_rec.cty_information7 = hr_api.g_varchar2) then
789: p_rec.cty_information7 :=
790: pay_cty_shd.g_old_rec.cty_information7;
791: End If;
792: If (p_rec.cty_information8 = hr_api.g_varchar2) then
793: p_rec.cty_information8 :=
794: pay_cty_shd.g_old_rec.cty_information8;

Line 794: pay_cty_shd.g_old_rec.cty_information8;

790: pay_cty_shd.g_old_rec.cty_information7;
791: End If;
792: If (p_rec.cty_information8 = hr_api.g_varchar2) then
793: p_rec.cty_information8 :=
794: pay_cty_shd.g_old_rec.cty_information8;
795: End If;
796: If (p_rec.cty_information9 = hr_api.g_varchar2) then
797: p_rec.cty_information9 :=
798: pay_cty_shd.g_old_rec.cty_information9;

Line 798: pay_cty_shd.g_old_rec.cty_information9;

794: pay_cty_shd.g_old_rec.cty_information8;
795: End If;
796: If (p_rec.cty_information9 = hr_api.g_varchar2) then
797: p_rec.cty_information9 :=
798: pay_cty_shd.g_old_rec.cty_information9;
799: End If;
800: If (p_rec.cty_information10 = hr_api.g_varchar2) then
801: p_rec.cty_information10 :=
802: pay_cty_shd.g_old_rec.cty_information10;

Line 802: pay_cty_shd.g_old_rec.cty_information10;

798: pay_cty_shd.g_old_rec.cty_information9;
799: End If;
800: If (p_rec.cty_information10 = hr_api.g_varchar2) then
801: p_rec.cty_information10 :=
802: pay_cty_shd.g_old_rec.cty_information10;
803: End If;
804: If (p_rec.cty_information11 = hr_api.g_varchar2) then
805: p_rec.cty_information11 :=
806: pay_cty_shd.g_old_rec.cty_information11;

Line 806: pay_cty_shd.g_old_rec.cty_information11;

802: pay_cty_shd.g_old_rec.cty_information10;
803: End If;
804: If (p_rec.cty_information11 = hr_api.g_varchar2) then
805: p_rec.cty_information11 :=
806: pay_cty_shd.g_old_rec.cty_information11;
807: End If;
808: If (p_rec.cty_information12 = hr_api.g_varchar2) then
809: p_rec.cty_information12 :=
810: pay_cty_shd.g_old_rec.cty_information12;

Line 810: pay_cty_shd.g_old_rec.cty_information12;

806: pay_cty_shd.g_old_rec.cty_information11;
807: End If;
808: If (p_rec.cty_information12 = hr_api.g_varchar2) then
809: p_rec.cty_information12 :=
810: pay_cty_shd.g_old_rec.cty_information12;
811: End If;
812: If (p_rec.cty_information13 = hr_api.g_varchar2) then
813: p_rec.cty_information13 :=
814: pay_cty_shd.g_old_rec.cty_information13;

Line 814: pay_cty_shd.g_old_rec.cty_information13;

810: pay_cty_shd.g_old_rec.cty_information12;
811: End If;
812: If (p_rec.cty_information13 = hr_api.g_varchar2) then
813: p_rec.cty_information13 :=
814: pay_cty_shd.g_old_rec.cty_information13;
815: End If;
816: If (p_rec.cty_information14 = hr_api.g_varchar2) then
817: p_rec.cty_information14 :=
818: pay_cty_shd.g_old_rec.cty_information14;

Line 818: pay_cty_shd.g_old_rec.cty_information14;

814: pay_cty_shd.g_old_rec.cty_information13;
815: End If;
816: If (p_rec.cty_information14 = hr_api.g_varchar2) then
817: p_rec.cty_information14 :=
818: pay_cty_shd.g_old_rec.cty_information14;
819: End If;
820: If (p_rec.cty_information15 = hr_api.g_varchar2) then
821: p_rec.cty_information15 :=
822: pay_cty_shd.g_old_rec.cty_information15;

Line 822: pay_cty_shd.g_old_rec.cty_information15;

818: pay_cty_shd.g_old_rec.cty_information14;
819: End If;
820: If (p_rec.cty_information15 = hr_api.g_varchar2) then
821: p_rec.cty_information15 :=
822: pay_cty_shd.g_old_rec.cty_information15;
823: End If;
824: If (p_rec.cty_information16 = hr_api.g_varchar2) then
825: p_rec.cty_information16 :=
826: pay_cty_shd.g_old_rec.cty_information16;

Line 826: pay_cty_shd.g_old_rec.cty_information16;

822: pay_cty_shd.g_old_rec.cty_information15;
823: End If;
824: If (p_rec.cty_information16 = hr_api.g_varchar2) then
825: p_rec.cty_information16 :=
826: pay_cty_shd.g_old_rec.cty_information16;
827: End If;
828: If (p_rec.cty_information17 = hr_api.g_varchar2) then
829: p_rec.cty_information17 :=
830: pay_cty_shd.g_old_rec.cty_information17;

Line 830: pay_cty_shd.g_old_rec.cty_information17;

826: pay_cty_shd.g_old_rec.cty_information16;
827: End If;
828: If (p_rec.cty_information17 = hr_api.g_varchar2) then
829: p_rec.cty_information17 :=
830: pay_cty_shd.g_old_rec.cty_information17;
831: End If;
832: If (p_rec.cty_information18 = hr_api.g_varchar2) then
833: p_rec.cty_information18 :=
834: pay_cty_shd.g_old_rec.cty_information18;

Line 834: pay_cty_shd.g_old_rec.cty_information18;

830: pay_cty_shd.g_old_rec.cty_information17;
831: End If;
832: If (p_rec.cty_information18 = hr_api.g_varchar2) then
833: p_rec.cty_information18 :=
834: pay_cty_shd.g_old_rec.cty_information18;
835: End If;
836: If (p_rec.cty_information19 = hr_api.g_varchar2) then
837: p_rec.cty_information19 :=
838: pay_cty_shd.g_old_rec.cty_information19;

Line 838: pay_cty_shd.g_old_rec.cty_information19;

834: pay_cty_shd.g_old_rec.cty_information18;
835: End If;
836: If (p_rec.cty_information19 = hr_api.g_varchar2) then
837: p_rec.cty_information19 :=
838: pay_cty_shd.g_old_rec.cty_information19;
839: End If;
840: If (p_rec.cty_information20 = hr_api.g_varchar2) then
841: p_rec.cty_information20 :=
842: pay_cty_shd.g_old_rec.cty_information20;

Line 842: pay_cty_shd.g_old_rec.cty_information20;

838: pay_cty_shd.g_old_rec.cty_information19;
839: End If;
840: If (p_rec.cty_information20 = hr_api.g_varchar2) then
841: p_rec.cty_information20 :=
842: pay_cty_shd.g_old_rec.cty_information20;
843: End If;
844: If (p_rec.cty_information21 = hr_api.g_varchar2) then
845: p_rec.cty_information21 :=
846: pay_cty_shd.g_old_rec.cty_information21;

Line 846: pay_cty_shd.g_old_rec.cty_information21;

842: pay_cty_shd.g_old_rec.cty_information20;
843: End If;
844: If (p_rec.cty_information21 = hr_api.g_varchar2) then
845: p_rec.cty_information21 :=
846: pay_cty_shd.g_old_rec.cty_information21;
847: End If;
848: If (p_rec.cty_information22 = hr_api.g_varchar2) then
849: p_rec.cty_information22 :=
850: pay_cty_shd.g_old_rec.cty_information22;

Line 850: pay_cty_shd.g_old_rec.cty_information22;

846: pay_cty_shd.g_old_rec.cty_information21;
847: End If;
848: If (p_rec.cty_information22 = hr_api.g_varchar2) then
849: p_rec.cty_information22 :=
850: pay_cty_shd.g_old_rec.cty_information22;
851: End If;
852: If (p_rec.cty_information23 = hr_api.g_varchar2) then
853: p_rec.cty_information23 :=
854: pay_cty_shd.g_old_rec.cty_information23;

Line 854: pay_cty_shd.g_old_rec.cty_information23;

850: pay_cty_shd.g_old_rec.cty_information22;
851: End If;
852: If (p_rec.cty_information23 = hr_api.g_varchar2) then
853: p_rec.cty_information23 :=
854: pay_cty_shd.g_old_rec.cty_information23;
855: End If;
856: If (p_rec.cty_information24 = hr_api.g_varchar2) then
857: p_rec.cty_information24 :=
858: pay_cty_shd.g_old_rec.cty_information24;

Line 858: pay_cty_shd.g_old_rec.cty_information24;

854: pay_cty_shd.g_old_rec.cty_information23;
855: End If;
856: If (p_rec.cty_information24 = hr_api.g_varchar2) then
857: p_rec.cty_information24 :=
858: pay_cty_shd.g_old_rec.cty_information24;
859: End If;
860: If (p_rec.cty_information25 = hr_api.g_varchar2) then
861: p_rec.cty_information25 :=
862: pay_cty_shd.g_old_rec.cty_information25;

Line 862: pay_cty_shd.g_old_rec.cty_information25;

858: pay_cty_shd.g_old_rec.cty_information24;
859: End If;
860: If (p_rec.cty_information25 = hr_api.g_varchar2) then
861: p_rec.cty_information25 :=
862: pay_cty_shd.g_old_rec.cty_information25;
863: End If;
864: If (p_rec.cty_information26 = hr_api.g_varchar2) then
865: p_rec.cty_information26 :=
866: pay_cty_shd.g_old_rec.cty_information26;

Line 866: pay_cty_shd.g_old_rec.cty_information26;

862: pay_cty_shd.g_old_rec.cty_information25;
863: End If;
864: If (p_rec.cty_information26 = hr_api.g_varchar2) then
865: p_rec.cty_information26 :=
866: pay_cty_shd.g_old_rec.cty_information26;
867: End If;
868: If (p_rec.cty_information27 = hr_api.g_varchar2) then
869: p_rec.cty_information27 :=
870: pay_cty_shd.g_old_rec.cty_information27;

Line 870: pay_cty_shd.g_old_rec.cty_information27;

866: pay_cty_shd.g_old_rec.cty_information26;
867: End If;
868: If (p_rec.cty_information27 = hr_api.g_varchar2) then
869: p_rec.cty_information27 :=
870: pay_cty_shd.g_old_rec.cty_information27;
871: End If;
872: If (p_rec.cty_information28 = hr_api.g_varchar2) then
873: p_rec.cty_information28 :=
874: pay_cty_shd.g_old_rec.cty_information28;

Line 874: pay_cty_shd.g_old_rec.cty_information28;

870: pay_cty_shd.g_old_rec.cty_information27;
871: End If;
872: If (p_rec.cty_information28 = hr_api.g_varchar2) then
873: p_rec.cty_information28 :=
874: pay_cty_shd.g_old_rec.cty_information28;
875: End If;
876: If (p_rec.cty_information29 = hr_api.g_varchar2) then
877: p_rec.cty_information29 :=
878: pay_cty_shd.g_old_rec.cty_information29;

Line 878: pay_cty_shd.g_old_rec.cty_information29;

874: pay_cty_shd.g_old_rec.cty_information28;
875: End If;
876: If (p_rec.cty_information29 = hr_api.g_varchar2) then
877: p_rec.cty_information29 :=
878: pay_cty_shd.g_old_rec.cty_information29;
879: End If;
880: If (p_rec.cty_information30 = hr_api.g_varchar2) then
881: p_rec.cty_information30 :=
882: pay_cty_shd.g_old_rec.cty_information30;

Line 882: pay_cty_shd.g_old_rec.cty_information30;

878: pay_cty_shd.g_old_rec.cty_information29;
879: End If;
880: If (p_rec.cty_information30 = hr_api.g_varchar2) then
881: p_rec.cty_information30 :=
882: pay_cty_shd.g_old_rec.cty_information30;
883: End If;
884:
885: --
886: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 895: p_rec in out nocopy pay_cty_shd.g_rec_type,

891: -- |---------------------------------< upd >----------------------------------|
892: -- ----------------------------------------------------------------------------
893: Procedure upd
894: (
895: p_rec in out nocopy pay_cty_shd.g_rec_type,
896: p_effective_date in date,
897: p_datetrack_mode in varchar2
898: ) is
899: --

Line 913: pay_cty_shd.lck

909: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
910: --
911: -- We must lock the row which we need to update.
912: --
913: pay_cty_shd.lck
914: (p_effective_date => p_effective_date,
915: p_datetrack_mode => p_datetrack_mode,
916: p_emp_city_tax_rule_id => p_rec.emp_city_tax_rule_id,
917: p_object_version_number => p_rec.object_version_number,

Line 1049: l_rec pay_cty_shd.g_rec_type;

1045: p_cty_information29 in varchar2 default hr_api.g_varchar2,
1046: p_cty_information30 in varchar2 default hr_api.g_varchar2
1047: ) is
1048: --
1049: l_rec pay_cty_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';
1051: --
1052: Begin
1053: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1059: pay_cty_shd.convert_args

1055: -- Call conversion function to turn arguments into the
1056: -- l_rec structure.
1057: --
1058: l_rec :=
1059: pay_cty_shd.convert_args
1060: (
1061: p_emp_city_tax_rule_id,
1062: hr_api.g_date,
1063: hr_api.g_date,