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.

[Home] [Help]

APPS.PAY_CTY_SHD dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 45: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK1') Then

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PAY_USCTY_SD_EXEMPT_CHK') Then
43: hr_utility.set_message(801, 'PAY_72751_CTY_SD_Y_OR_N');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK1') Then
46: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE'); /* 26 SEP 97 */
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK2') Then
49: hr_utility.set_message(801, 'PAY_52969_TAX_BG_MATCH_ASG');

Line 48: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK2') Then

44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK1') Then
46: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE'); /* 26 SEP 97 */
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK2') Then
49: hr_utility.set_message(801, 'PAY_52969_TAX_BG_MATCH_ASG');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK3') Then
52: hr_utility.set_message(801, 'HR_51279_ADD_INV_CTY_CO_ST_CMB');

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

47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK2') Then
49: hr_utility.set_message(801, 'PAY_52969_TAX_BG_MATCH_ASG');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_US_EMP_CITY_TAX_RULES_FK3') Then
52: hr_utility.set_message(801, 'HR_51279_ADD_INV_CTY_CO_ST_CMB');
53: hr_utility.raise_error;
54: Else
55: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 161: from pay_us_emp_city_tax_rules_f

157: cty_information27,
158: cty_information28,
159: cty_information29,
160: cty_information30
161: from pay_us_emp_city_tax_rules_f
162: where emp_city_tax_rule_id = p_emp_city_tax_rule_id
163: and p_effective_date
164: between effective_start_date and effective_end_date;
165: --

Line 241: p_base_table_name => 'pay_us_emp_city_tax_rules_f',

237: -- Call the corresponding datetrack api
238: --
239: dt_api.find_dt_del_modes
240: (p_effective_date => p_effective_date,
241: p_base_table_name => 'pay_us_emp_city_tax_rules_f',
242: p_base_key_column => 'emp_city_tax_rule_id',
243: p_base_key_value => p_base_key_value,
244: p_zap => p_zap,
245: p_delete => p_delete,

Line 272: p_base_table_name => 'pay_us_emp_city_tax_rules_f',

268: -- Call the corresponding datetrack api
269: --
270: dt_api.find_dt_upd_modes
271: (p_effective_date => p_effective_date,
272: p_base_table_name => 'pay_us_emp_city_tax_rules_f',
273: p_base_key_column => 'emp_city_tax_rule_id',
274: p_base_key_value => p_base_key_value,
275: p_correction => p_correction,
276: p_update => p_update,

Line 305: (p_base_table_name => 'pay_us_emp_city_tax_rules_f',

301: -- version number.
302: --
303: l_object_version_number :=
304: dt_api.get_object_version_number
305: (p_base_table_name => 'pay_us_emp_city_tax_rules_f',
306: p_base_key_column => 'emp_city_tax_rule_id',
307: p_base_key_value => p_base_key_value);
308: --
309: hr_utility.set_location(l_proc, 10);

Line 315: update pay_us_emp_city_tax_rules_f t

311: --
312: -- Update the specified datetrack row setting the effective
313: -- end date to the specified new effective end date.
314: --
315: update pay_us_emp_city_tax_rules_f t
316: set t.effective_end_date = p_new_effective_end_date,
317: t.object_version_number = l_object_version_number
318: where t.emp_city_tax_rule_id = p_base_key_value
319: and p_effective_date

Line 437: from pay_us_emp_city_tax_rules_f

433: cty_information27,
434: cty_information28,
435: cty_information29,
436: cty_information30
437: from pay_us_emp_city_tax_rules_f
438: where emp_city_tax_rule_id = p_emp_city_tax_rule_id
439: and p_effective_date
440: between effective_start_date and effective_end_date
441: for update nowait;

Line 496: p_base_table_name => 'pay_us_emp_city_tax_rules_f',

492: --
493: dt_api.validate_dt_mode
494: (p_effective_date => p_effective_date,
495: p_datetrack_mode => p_datetrack_mode,
496: p_base_table_name => 'pay_us_emp_city_tax_rules_f',
497: p_base_key_column => 'emp_city_tax_rule_id',
498: p_base_key_value => p_emp_city_tax_rule_id,
499:
500: p_enforce_foreign_locking => true,

Line 531: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_city_tax_rules_f');

527: -- The object is locked therefore we need to supply a meaningful
528: -- error message.
529: --
530: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
531: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_city_tax_rules_f');
532: hr_utility.raise_error;
533: When l_object_invalid then
534: --
535: -- The object doesn't exist or is invalid

Line 538: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_city_tax_rules_f');

534: --
535: -- The object doesn't exist or is invalid
536: --
537: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
538: hr_utility.set_message_token('TABLE_NAME', 'pay_us_emp_city_tax_rules_f');
539: hr_utility.raise_error;
540: End lck;
541: --
542: -- ----------------------------------------------------------------------------