APPS.PER_PGS_SHD dependencies on PER_GRADE_SPINES_F

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_GRADE_SPINES_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 = 'PER_GRADE_SPINES_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 = 'PER_GRADE_SPINES_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 = 'PER_GRADE_SPINES_F_FK3') 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 = 'PER_GRADE_SPINES_F_FK3') 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 47: ElsIf (p_constraint_name = 'PER_GRADE_SPINES_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;
47: ElsIf (p_constraint_name = 'PER_GRADE_SPINES_F_PK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;

Line 87: from per_grade_spines_f

83: ,program_application_id
84: ,program_id
85: ,program_update_date
86: ,object_version_number
87: from per_grade_spines_f
88: where grade_spine_id = p_grade_spine_id
89: and p_effective_date
90: between effective_start_date and effective_end_date;
91: --

Line 163: ,p_base_table_name => 'per_grade_spines_f'

159: -- Call the corresponding datetrack api
160: --
161: dt_api.find_dt_upd_modes
162: (p_effective_date => p_effective_date
163: ,p_base_table_name => 'per_grade_spines_f'
164: ,p_base_key_column => 'grade_spine_id'
165: ,p_base_key_value => p_base_key_value
166: ,p_correction => p_correction
167: ,p_update => p_update

Line 197: ,p_base_table_name => 'per_grade_spines_f'

193: -- Call the corresponding datetrack api
194: --
195: dt_api.find_dt_del_modes
196: (p_effective_date => p_effective_date
197: ,p_base_table_name => 'per_grade_spines_f'
198: ,p_base_key_column => 'grade_spine_id'
199: ,p_base_key_value => p_base_key_value
200: ,p_zap => p_zap
201: ,p_delete => p_delete

Line 232: (p_base_table_name => 'per_grade_spines_f'

228: -- version number.
229: --
230: l_object_version_number :=
231: dt_api.get_object_version_number
232: (p_base_table_name => 'per_grade_spines_f'
233: ,p_base_key_column => 'grade_spine_id'
234: ,p_base_key_value => p_base_key_value
235: );
236: --

Line 243: update per_grade_spines_f t

239: --
240: -- Update the specified datetrack row setting the effective
241: -- end date to the specified new effective end date.
242: --
243: update per_grade_spines_f t
244: set t.effective_end_date = p_new_effective_end_date
245: , t.object_version_number = l_object_version_number
246: where t.grade_spine_id = p_base_key_value
247: and p_effective_date

Line 296: from per_grade_spines_f

292: ,program_application_id
293: ,program_id
294: ,program_update_date
295: ,object_version_number
296: from per_grade_spines_f
297: where grade_spine_id = p_grade_spine_id
298: and p_effective_date
299: between effective_start_date and effective_end_date
300: for update nowait;

Line 359: ,p_base_table_name => 'per_grade_spines_f'

355: --
356: dt_api.validate_dt_mode
357: (p_effective_date => p_effective_date
358: ,p_datetrack_mode => p_datetrack_mode
359: ,p_base_table_name => 'per_grade_spines_f'
360: ,p_base_key_column => 'grade_spine_id'
361: ,p_base_key_value => p_grade_spine_id
362: ,p_child_table_name1 => 'per_spinal_point_steps_f'
363: ,p_child_key_column1 => 'step_id'

Line 398: fnd_message.set_token('TABLE_NAME', 'per_grade_spines_f');

394: -- The object is locked therefore we need to supply a meaningful
395: -- error message.
396: --
397: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
398: fnd_message.set_token('TABLE_NAME', 'per_grade_spines_f');
399: fnd_message.raise_error;
400: End lck;
401: --
402: -- ----------------------------------------------------------------------------