APPS.PAY_FED_SHD dependencies on PAY_US_EMP_FED_TAX_RULES_F

Line 60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then

56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PAY_USFTR_STATUTORY_EMPLOY_CHK') Then
58: hr_utility.set_message(801, 'PAY_72795_FED_STAT_EMP_Y_OR_N');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'PAY_US_EMP_FED_TAX_RULES_FK1') Then
61: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
62: hr_utility.raise_error;
63: Else
64: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 174: from pay_us_emp_fed_tax_rules_f

170: fed_information27,
171: fed_information28,
172: fed_information29,
173: fed_information30
174: from pay_us_emp_fed_tax_rules_f
175: where emp_fed_tax_rule_id = p_emp_fed_tax_rule_id
176: and p_effective_date
177: between effective_start_date and effective_end_date;
178: --

Line 251: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',

247: -- Call the corresponding datetrack api
248: --
249: dt_api.find_dt_del_modes
250: (p_effective_date => p_effective_date,
251: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
252: p_base_key_column => 'emp_fed_tax_rule_id',
253: p_base_key_value => p_base_key_value,
254: p_zap => p_zap,
255: p_delete => p_delete,

Line 287: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',

283: -- Call the corresponding datetrack api
284: --
285: dt_api.find_dt_upd_modes
286: (p_effective_date => p_effective_date,
287: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
288: p_base_key_column => 'emp_fed_tax_rule_id',
289: p_base_key_value => p_base_key_value,
290: p_correction => p_correction,
291: p_update => p_update,

Line 320: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',

316: -- version number.
317: --
318: l_object_version_number :=
319: dt_api.get_object_version_number
320: (p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
321: p_base_key_column => 'emp_fed_tax_rule_id',
322: p_base_key_value => p_base_key_value);
323: --
324: hr_utility.set_location(l_proc, 10);

Line 330: update pay_us_emp_fed_tax_rules_f t

326: --
327: -- Update the specified datetrack row setting the effective
328: -- end date to the specified new effective end date.
329: --
330: update pay_us_emp_fed_tax_rules_f t
331: set t.effective_end_date = p_new_effective_end_date,
332: t.object_version_number = l_object_version_number
333: where t.emp_fed_tax_rule_id = p_base_key_value
334: and p_effective_date

Line 456: from pay_us_emp_fed_tax_rules_f

452: fed_information27,
453: fed_information28,
454: fed_information29,
455: fed_information30
456: from pay_us_emp_fed_tax_rules_f
457: where emp_fed_tax_rule_id = p_emp_fed_tax_rule_id
458: and p_effective_date
459: between effective_start_date and effective_end_date
460: for update nowait;

Line 515: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',

511: --
512: dt_api.validate_dt_mode
513: (p_effective_date => p_effective_date,
514: p_datetrack_mode => p_datetrack_mode,
515: p_base_table_name => 'pay_us_emp_fed_tax_rules_f',
516: p_base_key_column => 'emp_fed_tax_rule_id',
517: p_base_key_value => p_emp_fed_tax_rule_id,
518: p_enforce_foreign_locking => true,
519: p_validation_start_date => l_validation_start_date,

Line 549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');

545: -- The object is locked therefore we need to supply a meaningful
546: -- error message.
547: --
548: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
549: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
550: hr_utility.raise_error;
551: When l_object_invalid then
552: --
553: -- The object doesn't exist or is invalid

Line 556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');

552: --
553: -- The object doesn't exist or is invalid
554: --
555: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
556: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_fed_tax_rules_f');
557: hr_utility.raise_error;
558: End lck;
559: --
560: -- ----------------------------------------------------------------------------