APPS.PAY_PGR_SHD dependencies on PAY_GRADE_RULES_F

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_GRADE_RULES_F_FK1') 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 37: ElsIf (p_constraint_name = 'PAY_GRADE_RULES_F_FK2') 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;
37: ElsIf (p_constraint_name = 'PAY_GRADE_RULES_F_FK2') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;

Line 42: ElsIf (p_constraint_name = 'PAY_GRADE_RULES_F_PK') Then

38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_GRADE_RULES_F_PK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;

Line 92: from pay_grade_rules_f

88: ,program_id
89: ,program_update_date
90: ,object_version_number
91: ,currency_code
92: from pay_grade_rules_f
93: where grade_rule_id = p_grade_rule_id
94: and p_effective_date
95: between effective_start_date and effective_end_date;
96: --

Line 168: ,p_base_table_name => 'pay_grade_rules_f'

164: -- Call the corresponding datetrack api
165: --
166: dt_api.find_dt_upd_modes
167: (p_effective_date => p_effective_date
168: ,p_base_table_name => 'pay_grade_rules_f'
169: ,p_base_key_column => 'grade_rule_id'
170: ,p_base_key_value => p_base_key_value
171: ,p_correction => p_correction
172: ,p_update => p_update

Line 202: ,p_base_table_name => 'pay_grade_rules_f'

198: -- Call the corresponding datetrack api
199: --
200: dt_api.find_dt_del_modes
201: (p_effective_date => p_effective_date
202: ,p_base_table_name => 'pay_grade_rules_f'
203: ,p_base_key_column => 'grade_rule_id'
204: ,p_base_key_value => p_base_key_value
205: ,p_zap => p_zap
206: ,p_delete => p_delete

Line 237: (p_base_table_name => 'pay_grade_rules_f'

233: -- version number.
234: --
235: l_object_version_number :=
236: dt_api.get_object_version_number
237: (p_base_table_name => 'pay_grade_rules_f'
238: ,p_base_key_column => 'grade_rule_id'
239: ,p_base_key_value => p_base_key_value
240: );
241: --

Line 248: update pay_grade_rules_f t

244: --
245: -- Update the specified datetrack row setting the effective
246: -- end date to the specified new effective end date.
247: --
248: update pay_grade_rules_f t
249: set t.effective_end_date = p_new_effective_end_date
250: , t.object_version_number = l_object_version_number
251: where t.grade_rule_id = p_base_key_value
252: and p_effective_date

Line 306: from pay_grade_rules_f

302: ,program_id
303: ,program_update_date
304: ,object_version_number
305: ,currency_code
306: from pay_grade_rules_f
307: where grade_rule_id = p_grade_rule_id
308: and p_effective_date
309: between effective_start_date and effective_end_date
310: for update nowait;

Line 375: ,p_base_table_name => 'pay_grade_rules_f'

371: --
372: dt_api.validate_dt_mode
373: (p_effective_date => p_effective_date
374: ,p_datetrack_mode => p_datetrack_mode
375: ,p_base_table_name => 'pay_grade_rules_f'
376: ,p_base_key_column => 'grade_rule_id'
377: ,p_base_key_value => p_grade_rule_id
378: ,p_parent_table_name1 => 'per_all_assignments_f'
379: ,p_parent_key_column1 => 'assignment_id'

Line 392: ,p_base_table_name => 'pay_grade_rules_f'

388: --
389: dt_api.validate_dt_mode
390: (p_effective_date => p_effective_date
391: ,p_datetrack_mode => p_datetrack_mode
392: ,p_base_table_name => 'pay_grade_rules_f'
393: ,p_base_key_column => 'grade_rule_id'
394: ,p_base_key_value => p_grade_rule_id
395: ,p_enforce_foreign_locking => true
396: ,p_validation_start_date => l_validation_start_date

Line 430: fnd_message.set_token('TABLE_NAME', 'pay_grade_rules_f');

426: -- The object is locked therefore we need to supply a meaningful
427: -- error message.
428: --
429: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
430: fnd_message.set_token('TABLE_NAME', 'pay_grade_rules_f');
431: fnd_message.raise_error;
432: End lck;
433: --
434: -- ----------------------------------------------------------------------------