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_STA_SHD dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 51: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK1') Then

47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_USSTR_WC_EXEMPT_CHK') Then
49: hr_utility.set_message(801, 'PAY_72828_STA_WC_Y_OR_N');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK1') Then
52: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK2') Then
55: hr_utility.set_message(801, 'PAY_52969_TAX_BG_MATCH_ASG');

Line 54: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK2') Then

50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK1') Then
52: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'PAY_US_EMP_STATE_TAX_RULES_FK2') Then
55: hr_utility.set_message(801, 'PAY_52969_TAX_BG_MATCH_ASG');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 169: from pay_us_emp_state_tax_rules_f

165: sta_information27,
166: sta_information28,
167: sta_information29,
168: sta_information30
169: from pay_us_emp_state_tax_rules_f
170: where emp_state_tax_rule_id = p_emp_state_tax_rule_id
171: and p_effective_date
172: between effective_start_date and effective_end_date;
173: --

Line 246: p_base_table_name => 'pay_us_emp_state_tax_rules_f',

242: -- Call the corresponding datetrack api
243: --
244: dt_api.find_dt_del_modes
245: (p_effective_date => p_effective_date,
246: p_base_table_name => 'pay_us_emp_state_tax_rules_f',
247: p_base_key_column => 'emp_state_tax_rule_id',
248: p_base_key_value => p_base_key_value,
249: p_zap => p_zap,
250: p_delete => p_delete,

Line 282: p_base_table_name => 'pay_us_emp_state_tax_rules_f',

278: -- Call the corresponding datetrack api
279: --
280: dt_api.find_dt_upd_modes
281: (p_effective_date => p_effective_date,
282: p_base_table_name => 'pay_us_emp_state_tax_rules_f',
283: p_base_key_column => 'emp_state_tax_rule_id',
284: p_base_key_value => p_base_key_value,
285: p_correction => p_correction,
286: p_update => p_update,

Line 315: (p_base_table_name => 'pay_us_emp_state_tax_rules_f',

311: -- version number.
312: --
313: l_object_version_number :=
314: dt_api.get_object_version_number
315: (p_base_table_name => 'pay_us_emp_state_tax_rules_f',
316: p_base_key_column => 'emp_state_tax_rule_id',
317: p_base_key_value => p_base_key_value);
318: --
319: hr_utility.set_location(l_proc, 10);

Line 325: update pay_us_emp_state_tax_rules_f t

321: --
322: -- Update the specified datetrack row setting the effective
323: -- end date to the specified new effective end date.
324: --
325: update pay_us_emp_state_tax_rules_f t
326: set t.effective_end_date = p_new_effective_end_date,
327: t.object_version_number = l_object_version_number
328: where t.emp_state_tax_rule_id = p_base_key_value
329: and p_effective_date

Line 452: from pay_us_emp_state_tax_rules_f

448: sta_information27,
449: sta_information28,
450: sta_information29,
451: sta_information30
452: from pay_us_emp_state_tax_rules_f
453: where emp_state_tax_rule_id = p_emp_state_tax_rule_id
454: and p_effective_date
455: between effective_start_date and effective_end_date
456: for update nowait;

Line 511: p_base_table_name => 'pay_us_emp_state_tax_rules_f',

507: --
508: dt_api.validate_dt_mode
509: (p_effective_date => p_effective_date,
510: p_datetrack_mode => p_datetrack_mode,
511: p_base_table_name => 'pay_us_emp_state_tax_rules_f',
512: p_base_key_column => 'emp_state_tax_rule_id',
513: p_base_key_value => p_emp_state_tax_rule_id,
514: p_enforce_foreign_locking => true,
515: p_validation_start_date => l_validation_start_date,

Line 545: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_state_tax_rules_f');

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

Line 552: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_state_tax_rules_f');

548: --
549: -- The object doesn't exist or is invalid
550: --
551: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
552: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_state_tax_rules_f');
553: hr_utility.raise_error;
554: End lck;
555: --
556: -- ----------------------------------------------------------------------------