APPS.PAY_STA_UPD dependencies on PAY_STA_SHD

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

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

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

Line 177: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 190: pay_sta_shd.constraint_error

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

Line 194: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

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

Line 195: pay_sta_shd.constraint_error

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

Line 198: pay_sta_shd.g_api_dml := false; -- Unset the api dml status

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

Line 234: (p_rec in out nocopy pay_sta_shd.g_rec_type,

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

Line 298: (p_rec in out nocopy pay_sta_shd.g_rec_type,

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

Line 314: pay_sta_shd.upd_effective_end_date

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

Line 383: (p_rec in out nocopy pay_sta_shd.g_rec_type,

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

Line 439: (p_rec in pay_sta_shd.g_rec_type,

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

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

479: ,p_effective_date =>p_effective_date
480: ,p_datetrack_mode =>p_datetrack_mode
481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_sta_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code

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

480: ,p_datetrack_mode =>p_datetrack_mode
481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_sta_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id

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

481: ,p_validation_start_date =>p_validation_start_date
482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_sta_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount

Line 486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code

482: ,p_validation_end_date =>p_validation_end_date
483: ,p_effective_start_date_o =>pay_sta_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code

Line 487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code

483: ,p_effective_start_date_o =>pay_sta_shd.g_old_rec.effective_start_date
484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent

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

484: ,p_effective_end_date_o =>pay_sta_shd.g_old_rec.effective_end_date
485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa

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

485: ,p_assignment_id_o =>pay_sta_shd.g_old_rec.assignment_id
486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax

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

486: ,p_state_code_o =>pay_sta_shd.g_old_rec.state_code
487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount

Line 491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent

487: ,p_jurisdiction_code_o =>pay_sta_shd.g_old_rec.jurisdiction_code
488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate

Line 492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa

488: ,p_business_group_id_o =>pay_sta_shd.g_old_rec.business_group_id
489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances

Line 493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax

489: ,p_additional_wa_amount_o =>pay_sta_shd.g_old_rec.additional_wa_amount
490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date

Line 494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount

490: ,p_filing_status_code_o =>pay_sta_shd.g_old_rec.filing_status_code
491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt

Line 495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate

491: ,p_remainder_percent_o =>pay_sta_shd.g_old_rec.remainder_percent
492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt

Line 496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances

492: ,p_secondary_wa_o =>pay_sta_shd.g_old_rec.secondary_wa
493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind

Line 497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date

493: ,p_sit_additional_tax_o =>pay_sta_shd.g_old_rec.sit_additional_tax
494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert

Line 498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt

494: ,p_sit_override_amount_o =>pay_sta_shd.g_old_rec.sit_override_amount
495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt

Line 499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt

495: ,p_sit_override_rate_o =>pay_sta_shd.g_old_rec.sit_override_rate
496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt

Line 500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind

496: ,p_withholding_allowances_o =>pay_sta_shd.g_old_rec.withholding_allowances
497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt

Line 501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert

497: ,p_excessive_wa_reject_date_o =>pay_sta_shd.g_old_rec.excessive_wa_reject_date
498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>

Line 502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt

498: ,p_sdi_exempt_o =>pay_sta_shd.g_old_rec.sdi_exempt
499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount

Line 503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt

499: ,p_sit_exempt_o =>pay_sta_shd.g_old_rec.sit_exempt
500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount
507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate

Line 504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt

500: ,p_sit_optional_calc_ind_o =>pay_sta_shd.g_old_rec.sit_optional_calc_ind
501: ,p_state_non_resident_cert_o =>pay_sta_shd.g_old_rec.state_non_resident_cert
502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount
507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate
508: ,p_object_version_number_o =>pay_sta_shd.g_old_rec.object_version_number

Line 506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount

502: ,p_sui_exempt_o =>pay_sta_shd.g_old_rec.sui_exempt
503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount
507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate
508: ,p_object_version_number_o =>pay_sta_shd.g_old_rec.object_version_number
509: );
510: --

Line 507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate

503: ,p_wc_exempt_o =>pay_sta_shd.g_old_rec.wc_exempt
504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount
507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate
508: ,p_object_version_number_o =>pay_sta_shd.g_old_rec.object_version_number
509: );
510: --
511: exception

Line 508: ,p_object_version_number_o =>pay_sta_shd.g_old_rec.object_version_number

504: ,p_wage_exempt_o =>pay_sta_shd.g_old_rec.wage_exempt
505: ,p_sui_wage_base_override_amo_o =>
506: pay_sta_shd.g_old_rec.sui_wage_base_override_amount
507: ,p_supp_tax_override_rate_o =>pay_sta_shd.g_old_rec.supp_tax_override_rate
508: ,p_object_version_number_o =>pay_sta_shd.g_old_rec.object_version_number
509: );
510: --
511: exception
512: --

Line 573: Procedure convert_defs(p_rec in out nocopy pay_sta_shd.g_rec_type) is

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

Line 588: pay_sta_shd.g_old_rec.assignment_id;

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

Line 592: pay_sta_shd.g_old_rec.state_code;

588: pay_sta_shd.g_old_rec.assignment_id;
589: End If;
590: If (p_rec.state_code = hr_api.g_varchar2) then
591: p_rec.state_code :=
592: pay_sta_shd.g_old_rec.state_code;
593: End If;
594: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
595: p_rec.jurisdiction_code :=
596: pay_sta_shd.g_old_rec.jurisdiction_code;

Line 596: pay_sta_shd.g_old_rec.jurisdiction_code;

592: pay_sta_shd.g_old_rec.state_code;
593: End If;
594: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
595: p_rec.jurisdiction_code :=
596: pay_sta_shd.g_old_rec.jurisdiction_code;
597: End If;
598: If (p_rec.business_group_id = hr_api.g_number) then
599: p_rec.business_group_id :=
600: pay_sta_shd.g_old_rec.business_group_id;

Line 600: pay_sta_shd.g_old_rec.business_group_id;

596: pay_sta_shd.g_old_rec.jurisdiction_code;
597: End If;
598: If (p_rec.business_group_id = hr_api.g_number) then
599: p_rec.business_group_id :=
600: pay_sta_shd.g_old_rec.business_group_id;
601: End If;
602: If (p_rec.additional_wa_amount = hr_api.g_number) then
603: p_rec.additional_wa_amount :=
604: pay_sta_shd.g_old_rec.additional_wa_amount;

Line 604: pay_sta_shd.g_old_rec.additional_wa_amount;

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

Line 608: pay_sta_shd.g_old_rec.filing_status_code;

604: pay_sta_shd.g_old_rec.additional_wa_amount;
605: End If;
606: If (p_rec.filing_status_code = hr_api.g_varchar2) then
607: p_rec.filing_status_code :=
608: pay_sta_shd.g_old_rec.filing_status_code;
609: End If;
610: If (p_rec.remainder_percent = hr_api.g_number) then
611: p_rec.remainder_percent :=
612: pay_sta_shd.g_old_rec.remainder_percent;

Line 612: pay_sta_shd.g_old_rec.remainder_percent;

608: pay_sta_shd.g_old_rec.filing_status_code;
609: End If;
610: If (p_rec.remainder_percent = hr_api.g_number) then
611: p_rec.remainder_percent :=
612: pay_sta_shd.g_old_rec.remainder_percent;
613: End If;
614: If (p_rec.secondary_wa = hr_api.g_number) then
615: p_rec.secondary_wa :=
616: pay_sta_shd.g_old_rec.secondary_wa;

Line 616: pay_sta_shd.g_old_rec.secondary_wa;

612: pay_sta_shd.g_old_rec.remainder_percent;
613: End If;
614: If (p_rec.secondary_wa = hr_api.g_number) then
615: p_rec.secondary_wa :=
616: pay_sta_shd.g_old_rec.secondary_wa;
617: End If;
618: If (p_rec.sit_additional_tax = hr_api.g_number) then
619: p_rec.sit_additional_tax :=
620: pay_sta_shd.g_old_rec.sit_additional_tax;

Line 620: pay_sta_shd.g_old_rec.sit_additional_tax;

616: pay_sta_shd.g_old_rec.secondary_wa;
617: End If;
618: If (p_rec.sit_additional_tax = hr_api.g_number) then
619: p_rec.sit_additional_tax :=
620: pay_sta_shd.g_old_rec.sit_additional_tax;
621: End If;
622: If (p_rec.sit_override_amount = hr_api.g_number) then
623: p_rec.sit_override_amount :=
624: pay_sta_shd.g_old_rec.sit_override_amount;

Line 624: pay_sta_shd.g_old_rec.sit_override_amount;

620: pay_sta_shd.g_old_rec.sit_additional_tax;
621: End If;
622: If (p_rec.sit_override_amount = hr_api.g_number) then
623: p_rec.sit_override_amount :=
624: pay_sta_shd.g_old_rec.sit_override_amount;
625: End If;
626: If (p_rec.sit_override_rate = hr_api.g_number) then
627: p_rec.sit_override_rate :=
628: pay_sta_shd.g_old_rec.sit_override_rate;

Line 628: pay_sta_shd.g_old_rec.sit_override_rate;

624: pay_sta_shd.g_old_rec.sit_override_amount;
625: End If;
626: If (p_rec.sit_override_rate = hr_api.g_number) then
627: p_rec.sit_override_rate :=
628: pay_sta_shd.g_old_rec.sit_override_rate;
629: End If;
630: If (p_rec.withholding_allowances = hr_api.g_number) then
631: p_rec.withholding_allowances :=
632: pay_sta_shd.g_old_rec.withholding_allowances;

Line 632: pay_sta_shd.g_old_rec.withholding_allowances;

628: pay_sta_shd.g_old_rec.sit_override_rate;
629: End If;
630: If (p_rec.withholding_allowances = hr_api.g_number) then
631: p_rec.withholding_allowances :=
632: pay_sta_shd.g_old_rec.withholding_allowances;
633: End If;
634: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
635: p_rec.excessive_wa_reject_date :=
636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;

Line 636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;

632: pay_sta_shd.g_old_rec.withholding_allowances;
633: End If;
634: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
635: p_rec.excessive_wa_reject_date :=
636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;
637: End If;
638: If (p_rec.sdi_exempt = hr_api.g_varchar2) then
639: p_rec.sdi_exempt :=
640: pay_sta_shd.g_old_rec.sdi_exempt;

Line 640: pay_sta_shd.g_old_rec.sdi_exempt;

636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;
637: End If;
638: If (p_rec.sdi_exempt = hr_api.g_varchar2) then
639: p_rec.sdi_exempt :=
640: pay_sta_shd.g_old_rec.sdi_exempt;
641: End If;
642: If (p_rec.sit_exempt = hr_api.g_varchar2) then
643: p_rec.sit_exempt :=
644: pay_sta_shd.g_old_rec.sit_exempt;

Line 644: pay_sta_shd.g_old_rec.sit_exempt;

640: pay_sta_shd.g_old_rec.sdi_exempt;
641: End If;
642: If (p_rec.sit_exempt = hr_api.g_varchar2) then
643: p_rec.sit_exempt :=
644: pay_sta_shd.g_old_rec.sit_exempt;
645: End If;
646: If (p_rec.sit_optional_calc_ind = hr_api.g_varchar2) then
647: p_rec.sit_optional_calc_ind :=
648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;

Line 648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;

644: pay_sta_shd.g_old_rec.sit_exempt;
645: End If;
646: If (p_rec.sit_optional_calc_ind = hr_api.g_varchar2) then
647: p_rec.sit_optional_calc_ind :=
648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;
649: End If;
650: If (p_rec.state_non_resident_cert = hr_api.g_varchar2) then
651: p_rec.state_non_resident_cert :=
652: pay_sta_shd.g_old_rec.state_non_resident_cert;

Line 652: pay_sta_shd.g_old_rec.state_non_resident_cert;

648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;
649: End If;
650: If (p_rec.state_non_resident_cert = hr_api.g_varchar2) then
651: p_rec.state_non_resident_cert :=
652: pay_sta_shd.g_old_rec.state_non_resident_cert;
653: End If;
654: If (p_rec.sui_exempt = hr_api.g_varchar2) then
655: p_rec.sui_exempt :=
656: pay_sta_shd.g_old_rec.sui_exempt;

Line 656: pay_sta_shd.g_old_rec.sui_exempt;

652: pay_sta_shd.g_old_rec.state_non_resident_cert;
653: End If;
654: If (p_rec.sui_exempt = hr_api.g_varchar2) then
655: p_rec.sui_exempt :=
656: pay_sta_shd.g_old_rec.sui_exempt;
657: End If;
658: If (p_rec.wc_exempt = hr_api.g_varchar2) then
659: p_rec.wc_exempt :=
660: pay_sta_shd.g_old_rec.wc_exempt;

Line 660: pay_sta_shd.g_old_rec.wc_exempt;

656: pay_sta_shd.g_old_rec.sui_exempt;
657: End If;
658: If (p_rec.wc_exempt = hr_api.g_varchar2) then
659: p_rec.wc_exempt :=
660: pay_sta_shd.g_old_rec.wc_exempt;
661: End If;
662: If (p_rec.wage_exempt = hr_api.g_varchar2) then
663: p_rec.wage_exempt :=
664: pay_sta_shd.g_old_rec.wage_exempt;

Line 664: pay_sta_shd.g_old_rec.wage_exempt;

660: pay_sta_shd.g_old_rec.wc_exempt;
661: End If;
662: If (p_rec.wage_exempt = hr_api.g_varchar2) then
663: p_rec.wage_exempt :=
664: pay_sta_shd.g_old_rec.wage_exempt;
665: End If;
666: If (p_rec.sui_wage_base_override_amount = hr_api.g_number) then
667: p_rec.sui_wage_base_override_amount :=
668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;

Line 668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;

664: pay_sta_shd.g_old_rec.wage_exempt;
665: End If;
666: If (p_rec.sui_wage_base_override_amount = hr_api.g_number) then
667: p_rec.sui_wage_base_override_amount :=
668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;
669: End If;
670: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
671: p_rec.supp_tax_override_rate :=
672: pay_sta_shd.g_old_rec.supp_tax_override_rate;

Line 672: pay_sta_shd.g_old_rec.supp_tax_override_rate;

668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;
669: End If;
670: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
671: p_rec.supp_tax_override_rate :=
672: pay_sta_shd.g_old_rec.supp_tax_override_rate;
673: End If;
674: If (p_rec.attribute_category = hr_api.g_varchar2) then
675: p_rec.attribute_category :=
676: pay_sta_shd.g_old_rec.attribute_category;

Line 676: pay_sta_shd.g_old_rec.attribute_category;

672: pay_sta_shd.g_old_rec.supp_tax_override_rate;
673: End If;
674: If (p_rec.attribute_category = hr_api.g_varchar2) then
675: p_rec.attribute_category :=
676: pay_sta_shd.g_old_rec.attribute_category;
677: End If;
678: If (p_rec.attribute1 = hr_api.g_varchar2) then
679: p_rec.attribute1 :=
680: pay_sta_shd.g_old_rec.attribute1;

Line 680: pay_sta_shd.g_old_rec.attribute1;

676: pay_sta_shd.g_old_rec.attribute_category;
677: End If;
678: If (p_rec.attribute1 = hr_api.g_varchar2) then
679: p_rec.attribute1 :=
680: pay_sta_shd.g_old_rec.attribute1;
681: End If;
682: If (p_rec.attribute2 = hr_api.g_varchar2) then
683: p_rec.attribute2 :=
684: pay_sta_shd.g_old_rec.attribute2;

Line 684: pay_sta_shd.g_old_rec.attribute2;

680: pay_sta_shd.g_old_rec.attribute1;
681: End If;
682: If (p_rec.attribute2 = hr_api.g_varchar2) then
683: p_rec.attribute2 :=
684: pay_sta_shd.g_old_rec.attribute2;
685: End If;
686: If (p_rec.attribute3 = hr_api.g_varchar2) then
687: p_rec.attribute3 :=
688: pay_sta_shd.g_old_rec.attribute3;

Line 688: pay_sta_shd.g_old_rec.attribute3;

684: pay_sta_shd.g_old_rec.attribute2;
685: End If;
686: If (p_rec.attribute3 = hr_api.g_varchar2) then
687: p_rec.attribute3 :=
688: pay_sta_shd.g_old_rec.attribute3;
689: End If;
690: If (p_rec.attribute4 = hr_api.g_varchar2) then
691: p_rec.attribute4 :=
692: pay_sta_shd.g_old_rec.attribute4;

Line 692: pay_sta_shd.g_old_rec.attribute4;

688: pay_sta_shd.g_old_rec.attribute3;
689: End If;
690: If (p_rec.attribute4 = hr_api.g_varchar2) then
691: p_rec.attribute4 :=
692: pay_sta_shd.g_old_rec.attribute4;
693: End If;
694: If (p_rec.attribute5 = hr_api.g_varchar2) then
695: p_rec.attribute5 :=
696: pay_sta_shd.g_old_rec.attribute5;

Line 696: pay_sta_shd.g_old_rec.attribute5;

692: pay_sta_shd.g_old_rec.attribute4;
693: End If;
694: If (p_rec.attribute5 = hr_api.g_varchar2) then
695: p_rec.attribute5 :=
696: pay_sta_shd.g_old_rec.attribute5;
697: End If;
698: If (p_rec.attribute6 = hr_api.g_varchar2) then
699: p_rec.attribute6 :=
700: pay_sta_shd.g_old_rec.attribute6;

Line 700: pay_sta_shd.g_old_rec.attribute6;

696: pay_sta_shd.g_old_rec.attribute5;
697: End If;
698: If (p_rec.attribute6 = hr_api.g_varchar2) then
699: p_rec.attribute6 :=
700: pay_sta_shd.g_old_rec.attribute6;
701: End If;
702: If (p_rec.attribute7 = hr_api.g_varchar2) then
703: p_rec.attribute7 :=
704: pay_sta_shd.g_old_rec.attribute7;

Line 704: pay_sta_shd.g_old_rec.attribute7;

700: pay_sta_shd.g_old_rec.attribute6;
701: End If;
702: If (p_rec.attribute7 = hr_api.g_varchar2) then
703: p_rec.attribute7 :=
704: pay_sta_shd.g_old_rec.attribute7;
705: End If;
706: If (p_rec.attribute8 = hr_api.g_varchar2) then
707: p_rec.attribute8 :=
708: pay_sta_shd.g_old_rec.attribute8;

Line 708: pay_sta_shd.g_old_rec.attribute8;

704: pay_sta_shd.g_old_rec.attribute7;
705: End If;
706: If (p_rec.attribute8 = hr_api.g_varchar2) then
707: p_rec.attribute8 :=
708: pay_sta_shd.g_old_rec.attribute8;
709: End If;
710: If (p_rec.attribute9 = hr_api.g_varchar2) then
711: p_rec.attribute9 :=
712: pay_sta_shd.g_old_rec.attribute9;

Line 712: pay_sta_shd.g_old_rec.attribute9;

708: pay_sta_shd.g_old_rec.attribute8;
709: End If;
710: If (p_rec.attribute9 = hr_api.g_varchar2) then
711: p_rec.attribute9 :=
712: pay_sta_shd.g_old_rec.attribute9;
713: End If;
714: If (p_rec.attribute10 = hr_api.g_varchar2) then
715: p_rec.attribute10 :=
716: pay_sta_shd.g_old_rec.attribute10;

Line 716: pay_sta_shd.g_old_rec.attribute10;

712: pay_sta_shd.g_old_rec.attribute9;
713: End If;
714: If (p_rec.attribute10 = hr_api.g_varchar2) then
715: p_rec.attribute10 :=
716: pay_sta_shd.g_old_rec.attribute10;
717: End If;
718: If (p_rec.attribute11 = hr_api.g_varchar2) then
719: p_rec.attribute11 :=
720: pay_sta_shd.g_old_rec.attribute11;

Line 720: pay_sta_shd.g_old_rec.attribute11;

716: pay_sta_shd.g_old_rec.attribute10;
717: End If;
718: If (p_rec.attribute11 = hr_api.g_varchar2) then
719: p_rec.attribute11 :=
720: pay_sta_shd.g_old_rec.attribute11;
721: End If;
722: If (p_rec.attribute12 = hr_api.g_varchar2) then
723: p_rec.attribute12 :=
724: pay_sta_shd.g_old_rec.attribute12;

Line 724: pay_sta_shd.g_old_rec.attribute12;

720: pay_sta_shd.g_old_rec.attribute11;
721: End If;
722: If (p_rec.attribute12 = hr_api.g_varchar2) then
723: p_rec.attribute12 :=
724: pay_sta_shd.g_old_rec.attribute12;
725: End If;
726: If (p_rec.attribute13 = hr_api.g_varchar2) then
727: p_rec.attribute13 :=
728: pay_sta_shd.g_old_rec.attribute13;

Line 728: pay_sta_shd.g_old_rec.attribute13;

724: pay_sta_shd.g_old_rec.attribute12;
725: End If;
726: If (p_rec.attribute13 = hr_api.g_varchar2) then
727: p_rec.attribute13 :=
728: pay_sta_shd.g_old_rec.attribute13;
729: End If;
730: If (p_rec.attribute14 = hr_api.g_varchar2) then
731: p_rec.attribute14 :=
732: pay_sta_shd.g_old_rec.attribute14;

Line 732: pay_sta_shd.g_old_rec.attribute14;

728: pay_sta_shd.g_old_rec.attribute13;
729: End If;
730: If (p_rec.attribute14 = hr_api.g_varchar2) then
731: p_rec.attribute14 :=
732: pay_sta_shd.g_old_rec.attribute14;
733: End If;
734: If (p_rec.attribute15 = hr_api.g_varchar2) then
735: p_rec.attribute15 :=
736: pay_sta_shd.g_old_rec.attribute15;

Line 736: pay_sta_shd.g_old_rec.attribute15;

732: pay_sta_shd.g_old_rec.attribute14;
733: End If;
734: If (p_rec.attribute15 = hr_api.g_varchar2) then
735: p_rec.attribute15 :=
736: pay_sta_shd.g_old_rec.attribute15;
737: End If;
738: If (p_rec.attribute16 = hr_api.g_varchar2) then
739: p_rec.attribute16 :=
740: pay_sta_shd.g_old_rec.attribute16;

Line 740: pay_sta_shd.g_old_rec.attribute16;

736: pay_sta_shd.g_old_rec.attribute15;
737: End If;
738: If (p_rec.attribute16 = hr_api.g_varchar2) then
739: p_rec.attribute16 :=
740: pay_sta_shd.g_old_rec.attribute16;
741: End If;
742: If (p_rec.attribute17 = hr_api.g_varchar2) then
743: p_rec.attribute17 :=
744: pay_sta_shd.g_old_rec.attribute17;

Line 744: pay_sta_shd.g_old_rec.attribute17;

740: pay_sta_shd.g_old_rec.attribute16;
741: End If;
742: If (p_rec.attribute17 = hr_api.g_varchar2) then
743: p_rec.attribute17 :=
744: pay_sta_shd.g_old_rec.attribute17;
745: End If;
746: If (p_rec.attribute18 = hr_api.g_varchar2) then
747: p_rec.attribute18 :=
748: pay_sta_shd.g_old_rec.attribute18;

Line 748: pay_sta_shd.g_old_rec.attribute18;

744: pay_sta_shd.g_old_rec.attribute17;
745: End If;
746: If (p_rec.attribute18 = hr_api.g_varchar2) then
747: p_rec.attribute18 :=
748: pay_sta_shd.g_old_rec.attribute18;
749: End If;
750: If (p_rec.attribute19 = hr_api.g_varchar2) then
751: p_rec.attribute19 :=
752: pay_sta_shd.g_old_rec.attribute19;

Line 752: pay_sta_shd.g_old_rec.attribute19;

748: pay_sta_shd.g_old_rec.attribute18;
749: End If;
750: If (p_rec.attribute19 = hr_api.g_varchar2) then
751: p_rec.attribute19 :=
752: pay_sta_shd.g_old_rec.attribute19;
753: End If;
754: If (p_rec.attribute20 = hr_api.g_varchar2) then
755: p_rec.attribute20 :=
756: pay_sta_shd.g_old_rec.attribute20;

Line 756: pay_sta_shd.g_old_rec.attribute20;

752: pay_sta_shd.g_old_rec.attribute19;
753: End If;
754: If (p_rec.attribute20 = hr_api.g_varchar2) then
755: p_rec.attribute20 :=
756: pay_sta_shd.g_old_rec.attribute20;
757: End If;
758: If (p_rec.attribute21 = hr_api.g_varchar2) then
759: p_rec.attribute21 :=
760: pay_sta_shd.g_old_rec.attribute21;

Line 760: pay_sta_shd.g_old_rec.attribute21;

756: pay_sta_shd.g_old_rec.attribute20;
757: End If;
758: If (p_rec.attribute21 = hr_api.g_varchar2) then
759: p_rec.attribute21 :=
760: pay_sta_shd.g_old_rec.attribute21;
761: End If;
762: If (p_rec.attribute22 = hr_api.g_varchar2) then
763: p_rec.attribute22 :=
764: pay_sta_shd.g_old_rec.attribute22;

Line 764: pay_sta_shd.g_old_rec.attribute22;

760: pay_sta_shd.g_old_rec.attribute21;
761: End If;
762: If (p_rec.attribute22 = hr_api.g_varchar2) then
763: p_rec.attribute22 :=
764: pay_sta_shd.g_old_rec.attribute22;
765: End If;
766: If (p_rec.attribute23 = hr_api.g_varchar2) then
767: p_rec.attribute23 :=
768: pay_sta_shd.g_old_rec.attribute23;

Line 768: pay_sta_shd.g_old_rec.attribute23;

764: pay_sta_shd.g_old_rec.attribute22;
765: End If;
766: If (p_rec.attribute23 = hr_api.g_varchar2) then
767: p_rec.attribute23 :=
768: pay_sta_shd.g_old_rec.attribute23;
769: End If;
770: If (p_rec.attribute24 = hr_api.g_varchar2) then
771: p_rec.attribute24 :=
772: pay_sta_shd.g_old_rec.attribute24;

Line 772: pay_sta_shd.g_old_rec.attribute24;

768: pay_sta_shd.g_old_rec.attribute23;
769: End If;
770: If (p_rec.attribute24 = hr_api.g_varchar2) then
771: p_rec.attribute24 :=
772: pay_sta_shd.g_old_rec.attribute24;
773: End If;
774: If (p_rec.attribute25 = hr_api.g_varchar2) then
775: p_rec.attribute25 :=
776: pay_sta_shd.g_old_rec.attribute25;

Line 776: pay_sta_shd.g_old_rec.attribute25;

772: pay_sta_shd.g_old_rec.attribute24;
773: End If;
774: If (p_rec.attribute25 = hr_api.g_varchar2) then
775: p_rec.attribute25 :=
776: pay_sta_shd.g_old_rec.attribute25;
777: End If;
778: If (p_rec.attribute26 = hr_api.g_varchar2) then
779: p_rec.attribute26 :=
780: pay_sta_shd.g_old_rec.attribute26;

Line 780: pay_sta_shd.g_old_rec.attribute26;

776: pay_sta_shd.g_old_rec.attribute25;
777: End If;
778: If (p_rec.attribute26 = hr_api.g_varchar2) then
779: p_rec.attribute26 :=
780: pay_sta_shd.g_old_rec.attribute26;
781: End If;
782: If (p_rec.attribute27 = hr_api.g_varchar2) then
783: p_rec.attribute27 :=
784: pay_sta_shd.g_old_rec.attribute27;

Line 784: pay_sta_shd.g_old_rec.attribute27;

780: pay_sta_shd.g_old_rec.attribute26;
781: End If;
782: If (p_rec.attribute27 = hr_api.g_varchar2) then
783: p_rec.attribute27 :=
784: pay_sta_shd.g_old_rec.attribute27;
785: End If;
786: If (p_rec.attribute28 = hr_api.g_varchar2) then
787: p_rec.attribute28 :=
788: pay_sta_shd.g_old_rec.attribute28;

Line 788: pay_sta_shd.g_old_rec.attribute28;

784: pay_sta_shd.g_old_rec.attribute27;
785: End If;
786: If (p_rec.attribute28 = hr_api.g_varchar2) then
787: p_rec.attribute28 :=
788: pay_sta_shd.g_old_rec.attribute28;
789: End If;
790: If (p_rec.attribute29 = hr_api.g_varchar2) then
791: p_rec.attribute29 :=
792: pay_sta_shd.g_old_rec.attribute29;

Line 792: pay_sta_shd.g_old_rec.attribute29;

788: pay_sta_shd.g_old_rec.attribute28;
789: End If;
790: If (p_rec.attribute29 = hr_api.g_varchar2) then
791: p_rec.attribute29 :=
792: pay_sta_shd.g_old_rec.attribute29;
793: End If;
794: If (p_rec.attribute30 = hr_api.g_varchar2) then
795: p_rec.attribute30 :=
796: pay_sta_shd.g_old_rec.attribute30;

Line 796: pay_sta_shd.g_old_rec.attribute30;

792: pay_sta_shd.g_old_rec.attribute29;
793: End If;
794: If (p_rec.attribute30 = hr_api.g_varchar2) then
795: p_rec.attribute30 :=
796: pay_sta_shd.g_old_rec.attribute30;
797: End If;
798: If (p_rec.sta_information_category = hr_api.g_varchar2) then
799: p_rec.sta_information_category :=
800: pay_sta_shd.g_old_rec.sta_information_category;

Line 800: pay_sta_shd.g_old_rec.sta_information_category;

796: pay_sta_shd.g_old_rec.attribute30;
797: End If;
798: If (p_rec.sta_information_category = hr_api.g_varchar2) then
799: p_rec.sta_information_category :=
800: pay_sta_shd.g_old_rec.sta_information_category;
801: End If;
802: If (p_rec.sta_information1 = hr_api.g_varchar2) then
803: p_rec.sta_information1 :=
804: pay_sta_shd.g_old_rec.sta_information1;

Line 804: pay_sta_shd.g_old_rec.sta_information1;

800: pay_sta_shd.g_old_rec.sta_information_category;
801: End If;
802: If (p_rec.sta_information1 = hr_api.g_varchar2) then
803: p_rec.sta_information1 :=
804: pay_sta_shd.g_old_rec.sta_information1;
805: End If;
806: If (p_rec.sta_information2 = hr_api.g_varchar2) then
807: p_rec.sta_information2 :=
808: pay_sta_shd.g_old_rec.sta_information2;

Line 808: pay_sta_shd.g_old_rec.sta_information2;

804: pay_sta_shd.g_old_rec.sta_information1;
805: End If;
806: If (p_rec.sta_information2 = hr_api.g_varchar2) then
807: p_rec.sta_information2 :=
808: pay_sta_shd.g_old_rec.sta_information2;
809: End If;
810: If (p_rec.sta_information3 = hr_api.g_varchar2) then
811: p_rec.sta_information3 :=
812: pay_sta_shd.g_old_rec.sta_information3;

Line 812: pay_sta_shd.g_old_rec.sta_information3;

808: pay_sta_shd.g_old_rec.sta_information2;
809: End If;
810: If (p_rec.sta_information3 = hr_api.g_varchar2) then
811: p_rec.sta_information3 :=
812: pay_sta_shd.g_old_rec.sta_information3;
813: End If;
814: If (p_rec.sta_information4 = hr_api.g_varchar2) then
815: p_rec.sta_information4 :=
816: pay_sta_shd.g_old_rec.sta_information4;

Line 816: pay_sta_shd.g_old_rec.sta_information4;

812: pay_sta_shd.g_old_rec.sta_information3;
813: End If;
814: If (p_rec.sta_information4 = hr_api.g_varchar2) then
815: p_rec.sta_information4 :=
816: pay_sta_shd.g_old_rec.sta_information4;
817: End If;
818: If (p_rec.sta_information5 = hr_api.g_varchar2) then
819: p_rec.sta_information5 :=
820: pay_sta_shd.g_old_rec.sta_information5;

Line 820: pay_sta_shd.g_old_rec.sta_information5;

816: pay_sta_shd.g_old_rec.sta_information4;
817: End If;
818: If (p_rec.sta_information5 = hr_api.g_varchar2) then
819: p_rec.sta_information5 :=
820: pay_sta_shd.g_old_rec.sta_information5;
821: End If;
822: If (p_rec.sta_information6 = hr_api.g_varchar2) then
823: p_rec.sta_information6 :=
824: pay_sta_shd.g_old_rec.sta_information6;

Line 824: pay_sta_shd.g_old_rec.sta_information6;

820: pay_sta_shd.g_old_rec.sta_information5;
821: End If;
822: If (p_rec.sta_information6 = hr_api.g_varchar2) then
823: p_rec.sta_information6 :=
824: pay_sta_shd.g_old_rec.sta_information6;
825: End If;
826: If (p_rec.sta_information7 = hr_api.g_varchar2) then
827: p_rec.sta_information7 :=
828: pay_sta_shd.g_old_rec.sta_information7;

Line 828: pay_sta_shd.g_old_rec.sta_information7;

824: pay_sta_shd.g_old_rec.sta_information6;
825: End If;
826: If (p_rec.sta_information7 = hr_api.g_varchar2) then
827: p_rec.sta_information7 :=
828: pay_sta_shd.g_old_rec.sta_information7;
829: End If;
830: If (p_rec.sta_information8 = hr_api.g_varchar2) then
831: p_rec.sta_information8 :=
832: pay_sta_shd.g_old_rec.sta_information8;

Line 832: pay_sta_shd.g_old_rec.sta_information8;

828: pay_sta_shd.g_old_rec.sta_information7;
829: End If;
830: If (p_rec.sta_information8 = hr_api.g_varchar2) then
831: p_rec.sta_information8 :=
832: pay_sta_shd.g_old_rec.sta_information8;
833: End If;
834: If (p_rec.sta_information9 = hr_api.g_varchar2) then
835: p_rec.sta_information9 :=
836: pay_sta_shd.g_old_rec.sta_information9;

Line 836: pay_sta_shd.g_old_rec.sta_information9;

832: pay_sta_shd.g_old_rec.sta_information8;
833: End If;
834: If (p_rec.sta_information9 = hr_api.g_varchar2) then
835: p_rec.sta_information9 :=
836: pay_sta_shd.g_old_rec.sta_information9;
837: End If;
838: If (p_rec.sta_information10 = hr_api.g_varchar2) then
839: p_rec.sta_information10 :=
840: pay_sta_shd.g_old_rec.sta_information10;

Line 840: pay_sta_shd.g_old_rec.sta_information10;

836: pay_sta_shd.g_old_rec.sta_information9;
837: End If;
838: If (p_rec.sta_information10 = hr_api.g_varchar2) then
839: p_rec.sta_information10 :=
840: pay_sta_shd.g_old_rec.sta_information10;
841: End If;
842: If (p_rec.sta_information11 = hr_api.g_varchar2) then
843: p_rec.sta_information11 :=
844: pay_sta_shd.g_old_rec.sta_information11;

Line 844: pay_sta_shd.g_old_rec.sta_information11;

840: pay_sta_shd.g_old_rec.sta_information10;
841: End If;
842: If (p_rec.sta_information11 = hr_api.g_varchar2) then
843: p_rec.sta_information11 :=
844: pay_sta_shd.g_old_rec.sta_information11;
845: End If;
846: If (p_rec.sta_information12 = hr_api.g_varchar2) then
847: p_rec.sta_information12 :=
848: pay_sta_shd.g_old_rec.sta_information12;

Line 848: pay_sta_shd.g_old_rec.sta_information12;

844: pay_sta_shd.g_old_rec.sta_information11;
845: End If;
846: If (p_rec.sta_information12 = hr_api.g_varchar2) then
847: p_rec.sta_information12 :=
848: pay_sta_shd.g_old_rec.sta_information12;
849: End If;
850: If (p_rec.sta_information13 = hr_api.g_varchar2) then
851: p_rec.sta_information13 :=
852: pay_sta_shd.g_old_rec.sta_information13;

Line 852: pay_sta_shd.g_old_rec.sta_information13;

848: pay_sta_shd.g_old_rec.sta_information12;
849: End If;
850: If (p_rec.sta_information13 = hr_api.g_varchar2) then
851: p_rec.sta_information13 :=
852: pay_sta_shd.g_old_rec.sta_information13;
853: End If;
854: If (p_rec.sta_information14 = hr_api.g_varchar2) then
855: p_rec.sta_information14 :=
856: pay_sta_shd.g_old_rec.sta_information14;

Line 856: pay_sta_shd.g_old_rec.sta_information14;

852: pay_sta_shd.g_old_rec.sta_information13;
853: End If;
854: If (p_rec.sta_information14 = hr_api.g_varchar2) then
855: p_rec.sta_information14 :=
856: pay_sta_shd.g_old_rec.sta_information14;
857: End If;
858: If (p_rec.sta_information15 = hr_api.g_varchar2) then
859: p_rec.sta_information15 :=
860: pay_sta_shd.g_old_rec.sta_information15;

Line 860: pay_sta_shd.g_old_rec.sta_information15;

856: pay_sta_shd.g_old_rec.sta_information14;
857: End If;
858: If (p_rec.sta_information15 = hr_api.g_varchar2) then
859: p_rec.sta_information15 :=
860: pay_sta_shd.g_old_rec.sta_information15;
861: End If;
862: If (p_rec.sta_information16 = hr_api.g_varchar2) then
863: p_rec.sta_information16 :=
864: pay_sta_shd.g_old_rec.sta_information16;

Line 864: pay_sta_shd.g_old_rec.sta_information16;

860: pay_sta_shd.g_old_rec.sta_information15;
861: End If;
862: If (p_rec.sta_information16 = hr_api.g_varchar2) then
863: p_rec.sta_information16 :=
864: pay_sta_shd.g_old_rec.sta_information16;
865: End If;
866: If (p_rec.sta_information17 = hr_api.g_varchar2) then
867: p_rec.sta_information17 :=
868: pay_sta_shd.g_old_rec.sta_information17;

Line 868: pay_sta_shd.g_old_rec.sta_information17;

864: pay_sta_shd.g_old_rec.sta_information16;
865: End If;
866: If (p_rec.sta_information17 = hr_api.g_varchar2) then
867: p_rec.sta_information17 :=
868: pay_sta_shd.g_old_rec.sta_information17;
869: End If;
870: If (p_rec.sta_information18 = hr_api.g_varchar2) then
871: p_rec.sta_information18 :=
872: pay_sta_shd.g_old_rec.sta_information18;

Line 872: pay_sta_shd.g_old_rec.sta_information18;

868: pay_sta_shd.g_old_rec.sta_information17;
869: End If;
870: If (p_rec.sta_information18 = hr_api.g_varchar2) then
871: p_rec.sta_information18 :=
872: pay_sta_shd.g_old_rec.sta_information18;
873: End If;
874: If (p_rec.sta_information19 = hr_api.g_varchar2) then
875: p_rec.sta_information19 :=
876: pay_sta_shd.g_old_rec.sta_information19;

Line 876: pay_sta_shd.g_old_rec.sta_information19;

872: pay_sta_shd.g_old_rec.sta_information18;
873: End If;
874: If (p_rec.sta_information19 = hr_api.g_varchar2) then
875: p_rec.sta_information19 :=
876: pay_sta_shd.g_old_rec.sta_information19;
877: End If;
878: If (p_rec.sta_information20 = hr_api.g_varchar2) then
879: p_rec.sta_information20 :=
880: pay_sta_shd.g_old_rec.sta_information20;

Line 880: pay_sta_shd.g_old_rec.sta_information20;

876: pay_sta_shd.g_old_rec.sta_information19;
877: End If;
878: If (p_rec.sta_information20 = hr_api.g_varchar2) then
879: p_rec.sta_information20 :=
880: pay_sta_shd.g_old_rec.sta_information20;
881: End If;
882: If (p_rec.sta_information21 = hr_api.g_varchar2) then
883: p_rec.sta_information21 :=
884: pay_sta_shd.g_old_rec.sta_information21;

Line 884: pay_sta_shd.g_old_rec.sta_information21;

880: pay_sta_shd.g_old_rec.sta_information20;
881: End If;
882: If (p_rec.sta_information21 = hr_api.g_varchar2) then
883: p_rec.sta_information21 :=
884: pay_sta_shd.g_old_rec.sta_information21;
885: End If;
886: If (p_rec.sta_information22 = hr_api.g_varchar2) then
887: p_rec.sta_information22 :=
888: pay_sta_shd.g_old_rec.sta_information22;

Line 888: pay_sta_shd.g_old_rec.sta_information22;

884: pay_sta_shd.g_old_rec.sta_information21;
885: End If;
886: If (p_rec.sta_information22 = hr_api.g_varchar2) then
887: p_rec.sta_information22 :=
888: pay_sta_shd.g_old_rec.sta_information22;
889: End If;
890: If (p_rec.sta_information23 = hr_api.g_varchar2) then
891: p_rec.sta_information23 :=
892: pay_sta_shd.g_old_rec.sta_information23;

Line 892: pay_sta_shd.g_old_rec.sta_information23;

888: pay_sta_shd.g_old_rec.sta_information22;
889: End If;
890: If (p_rec.sta_information23 = hr_api.g_varchar2) then
891: p_rec.sta_information23 :=
892: pay_sta_shd.g_old_rec.sta_information23;
893: End If;
894: If (p_rec.sta_information24 = hr_api.g_varchar2) then
895: p_rec.sta_information24 :=
896: pay_sta_shd.g_old_rec.sta_information24;

Line 896: pay_sta_shd.g_old_rec.sta_information24;

892: pay_sta_shd.g_old_rec.sta_information23;
893: End If;
894: If (p_rec.sta_information24 = hr_api.g_varchar2) then
895: p_rec.sta_information24 :=
896: pay_sta_shd.g_old_rec.sta_information24;
897: End If;
898: If (p_rec.sta_information25 = hr_api.g_varchar2) then
899: p_rec.sta_information25 :=
900: pay_sta_shd.g_old_rec.sta_information25;

Line 900: pay_sta_shd.g_old_rec.sta_information25;

896: pay_sta_shd.g_old_rec.sta_information24;
897: End If;
898: If (p_rec.sta_information25 = hr_api.g_varchar2) then
899: p_rec.sta_information25 :=
900: pay_sta_shd.g_old_rec.sta_information25;
901: End If;
902: If (p_rec.sta_information26 = hr_api.g_varchar2) then
903: p_rec.sta_information26 :=
904: pay_sta_shd.g_old_rec.sta_information26;

Line 904: pay_sta_shd.g_old_rec.sta_information26;

900: pay_sta_shd.g_old_rec.sta_information25;
901: End If;
902: If (p_rec.sta_information26 = hr_api.g_varchar2) then
903: p_rec.sta_information26 :=
904: pay_sta_shd.g_old_rec.sta_information26;
905: End If;
906: If (p_rec.sta_information27 = hr_api.g_varchar2) then
907: p_rec.sta_information27 :=
908: pay_sta_shd.g_old_rec.sta_information27;

Line 908: pay_sta_shd.g_old_rec.sta_information27;

904: pay_sta_shd.g_old_rec.sta_information26;
905: End If;
906: If (p_rec.sta_information27 = hr_api.g_varchar2) then
907: p_rec.sta_information27 :=
908: pay_sta_shd.g_old_rec.sta_information27;
909: End If;
910: If (p_rec.sta_information28 = hr_api.g_varchar2) then
911: p_rec.sta_information28 :=
912: pay_sta_shd.g_old_rec.sta_information28;

Line 912: pay_sta_shd.g_old_rec.sta_information28;

908: pay_sta_shd.g_old_rec.sta_information27;
909: End If;
910: If (p_rec.sta_information28 = hr_api.g_varchar2) then
911: p_rec.sta_information28 :=
912: pay_sta_shd.g_old_rec.sta_information28;
913: End If;
914: If (p_rec.sta_information29 = hr_api.g_varchar2) then
915: p_rec.sta_information29 :=
916: pay_sta_shd.g_old_rec.sta_information29;

Line 916: pay_sta_shd.g_old_rec.sta_information29;

912: pay_sta_shd.g_old_rec.sta_information28;
913: End If;
914: If (p_rec.sta_information29 = hr_api.g_varchar2) then
915: p_rec.sta_information29 :=
916: pay_sta_shd.g_old_rec.sta_information29;
917: End If;
918: If (p_rec.sta_information30 = hr_api.g_varchar2) then
919: p_rec.sta_information30 :=
920: pay_sta_shd.g_old_rec.sta_information30;

Line 920: pay_sta_shd.g_old_rec.sta_information30;

916: pay_sta_shd.g_old_rec.sta_information29;
917: End If;
918: If (p_rec.sta_information30 = hr_api.g_varchar2) then
919: p_rec.sta_information30 :=
920: pay_sta_shd.g_old_rec.sta_information30;
921: End If;
922:
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 933: p_rec in out nocopy pay_sta_shd.g_rec_type,

929: -- |---------------------------------< upd >----------------------------------|
930: -- ----------------------------------------------------------------------------
931: Procedure upd
932: (
933: p_rec in out nocopy pay_sta_shd.g_rec_type,
934: p_effective_date in date,
935: p_datetrack_mode in varchar2
936: ) is
937: --

Line 951: pay_sta_shd.lck

947: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
948: --
949: -- We must lock the row which we need to update.
950: --
951: pay_sta_shd.lck
952: (p_effective_date => p_effective_date,
953: p_datetrack_mode => p_datetrack_mode,
954: p_emp_state_tax_rule_id => p_rec.emp_state_tax_rule_id,
955: p_object_version_number => p_rec.object_version_number,

Line 1094: l_rec pay_sta_shd.g_rec_type;

1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1092: ) is
1093: --
1094: l_rec pay_sta_shd.g_rec_type;
1095: l_proc varchar2(72) := g_package||'upd';
1096: --
1097: Begin
1098: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1104: pay_sta_shd.convert_args

1100: -- Call conversion function to turn arguments into the
1101: -- l_rec structure.
1102: --
1103: l_rec :=
1104: pay_sta_shd.convert_args
1105: (
1106: p_emp_state_tax_rule_id,
1107: null,
1108: null,