APPS.PAY_ITR_SHD dependencies on PAY_ITERATIVE_RULES_F

Line 21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then
22: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 74: from pay_iterative_rules_f

70: ,severity_level
71: ,business_group_id
72: ,legislation_code
73: ,object_version_number
74: from pay_iterative_rules_f
75: where iterative_rule_id = p_iterative_rule_id
76: and p_effective_date
77: between effective_start_date and effective_end_date;
78: --

Line 149: ,p_base_table_name => 'pay_iterative_rules_f'

145: -- Call the corresponding datetrack api
146: --
147: dt_api.find_dt_upd_modes
148: (p_effective_date => p_effective_date
149: ,p_base_table_name => 'pay_iterative_rules_f'
150: ,p_base_key_column => 'iterative_rule_id'
151: ,p_base_key_value => p_base_key_value
152: ,p_correction => p_correction
153: ,p_update => p_update

Line 183: ,p_base_table_name => 'pay_iterative_rules_f'

179: -- Call the corresponding datetrack api
180: --
181: dt_api.find_dt_del_modes
182: (p_effective_date => p_effective_date
183: ,p_base_table_name => 'pay_iterative_rules_f'
184: ,p_base_key_column => 'iterative_rule_id'
185: ,p_base_key_value => p_base_key_value
186: ,p_zap => p_zap
187: ,p_delete => p_delete

Line 218: (p_base_table_name => 'pay_iterative_rules_f'

214: -- version number.
215: --
216: l_object_version_number :=
217: dt_api.get_object_version_number
218: (p_base_table_name => 'pay_iterative_rules_f'
219: ,p_base_key_column => 'iterative_rule_id'
220: ,p_base_key_value => p_base_key_value
221: );
222: --

Line 229: update pay_iterative_rules_f t

225: --
226: -- Update the specified datetrack row setting the effective
227: -- end date to the specified new effective end date.
228: --
229: update pay_iterative_rules_f t
230: set t.effective_end_date = p_new_effective_end_date
231: , t.object_version_number = l_object_version_number
232: where t.iterative_rule_id = p_base_key_value
233: and p_effective_date

Line 275: from pay_iterative_rules_f

271: ,severity_level
272: ,business_group_id
273: ,legislation_code
274: ,object_version_number
275: from pay_iterative_rules_f
276: where iterative_rule_id = p_iterative_rule_id
277: and p_effective_date
278: between effective_start_date and effective_end_date
279: for update nowait;

Line 338: ,p_base_table_name => 'pay_iterative_rules_f'

334: --
335: dt_api.validate_dt_mode
336: (p_effective_date => p_effective_date
337: ,p_datetrack_mode => p_datetrack_mode
338: ,p_base_table_name => 'pay_iterative_rules_f'
339: ,p_base_key_column => 'iterative_rule_id'
340: ,p_base_key_value => p_iterative_rule_id
341: ,p_enforce_foreign_locking => true
342: ,p_validation_start_date => l_validation_start_date

Line 373: fnd_message.set_token('TABLE_NAME', 'pay_iterative_rules_f');

369: -- The object is locked therefore we need to supply a meaningful
370: -- error message.
371: --
372: fnd_message.set_name(801, 'HR_7165_OBJECT_LOCKED');
373: fnd_message.set_token('TABLE_NAME', 'pay_iterative_rules_f');
374: fnd_message.raise_error;
375: End lck;
376: --
377: -- ----------------------------------------------------------------------------