APPS.PAY_FRR_SHD dependencies on PAY_FORMULA_RESULT_RULES_F

Line 32: If (p_constraint_name = 'PAY_FORMULA_RESULT_RULES_F_PK') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_FORMULA_RESULT_RULES_F_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;

Line 82: from pay_formula_result_rules_f

78: ,legislation_subgroup
79: ,severity_level
80: ,input_value_id
81: ,object_version_number
82: from pay_formula_result_rules_f
83: where formula_result_rule_id = p_formula_result_rule_id
84: and p_effective_date
85: between effective_start_date and effective_end_date;
86: --

Line 158: ,p_base_table_name => 'pay_formula_result_rules_f'

154: -- Call the corresponding datetrack api
155: --
156: dt_api.find_dt_upd_modes
157: (p_effective_date => p_effective_date
158: ,p_base_table_name => 'pay_formula_result_rules_f'
159: ,p_base_key_column => 'formula_result_rule_id'
160: ,p_base_key_value => p_base_key_value
161: ,p_correction => p_correction
162: ,p_update => p_update

Line 192: ,p_base_table_name => 'pay_formula_result_rules_f'

188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
191: (p_effective_date => p_effective_date
192: ,p_base_table_name => 'pay_formula_result_rules_f'
193: ,p_base_key_column => 'formula_result_rule_id'
194: ,p_base_key_value => p_base_key_value
195: ,p_zap => p_zap
196: ,p_delete => p_delete

Line 227: (p_base_table_name => 'pay_formula_result_rules_f'

223: -- version number.
224: --
225: l_object_version_number :=
226: dt_api.get_object_version_number
227: (p_base_table_name => 'pay_formula_result_rules_f'
228: ,p_base_key_column => 'formula_result_rule_id'
229: ,p_base_key_value => p_base_key_value
230: );
231: --

Line 238: update pay_formula_result_rules_f t

234: --
235: -- Update the specified datetrack row setting the effective
236: -- end date to the specified new effective end date.
237: --
238: update pay_formula_result_rules_f t
239: set t.effective_end_date = p_new_effective_end_date
240: , t.object_version_number = l_object_version_number
241: where t.formula_result_rule_id = p_base_key_value
242: and p_effective_date

Line 291: from pay_formula_result_rules_f

287: ,legislation_subgroup
288: ,severity_level
289: ,input_value_id
290: ,object_version_number
291: from pay_formula_result_rules_f
292: where formula_result_rule_id = p_formula_result_rule_id
293: and p_effective_date
294: between effective_start_date and effective_end_date
295: for update nowait;

Line 354: ,p_base_table_name => 'pay_formula_result_rules_f'

350: --
351: dt_api.validate_dt_mode
352: (p_effective_date => p_effective_date
353: ,p_datetrack_mode => p_datetrack_mode
354: ,p_base_table_name => 'pay_formula_result_rules_f'
355: ,p_base_key_column => 'formula_result_rule_id'
356: ,p_base_key_value => p_formula_result_rule_id
357: ,p_enforce_foreign_locking => true
358: ,p_validation_start_date => l_validation_start_date

Line 389: fnd_message.set_token('TABLE_NAME', 'pay_formula_result_rules_f');

385: -- The object is locked therefore we need to supply a meaningful
386: -- error message.
387: --
388: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
389: fnd_message.set_token('TABLE_NAME', 'pay_formula_result_rules_f');
390: fnd_message.raise_error;
391: End lck;
392: --
393: -- ----------------------------------------------------------------------------