APPS.PER_SPS_SHD dependencies on PER_SPINAL_POINT_STEPS_F

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

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_SPINAL_POINT_STEPS_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_SPINAL_POINT_STEPS_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_SPINAL_POINT_STEPS_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_SPINAL_POINT_STEPS_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 = 'PER_SPINAL_POINT_STEPS_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 112: from per_spinal_point_steps_f

108: ,information29
109: ,information30
110: ,information_category
111: ,object_version_number
112: from per_spinal_point_steps_f
113: where step_id = p_step_id
114: and p_effective_date
115: between effective_start_date and effective_end_date;
116: --

Line 188: ,p_base_table_name => 'per_spinal_point_steps_f'

184: -- Call the corresponding datetrack api
185: --
186: dt_api.find_dt_upd_modes
187: (p_effective_date => p_effective_date
188: ,p_base_table_name => 'per_spinal_point_steps_f'
189: ,p_base_key_column => 'step_id'
190: ,p_base_key_value => p_base_key_value
191: ,p_correction => p_correction
192: ,p_update => p_update

Line 219: from per_spinal_point_steps_f t

215: --
216: Cursor C_Sel1 Is
217: select
218: t.grade_spine_id
219: from per_spinal_point_steps_f t
220: where t.step_id = p_base_key_value
221: and p_effective_date
222: between t.effective_start_date and t.effective_end_date;
223: --

Line 242: ,p_base_table_name => 'per_spinal_point_steps_f'

238: -- Call the corresponding datetrack api
239: --
240: dt_api.find_dt_del_modes
241: (p_effective_date => p_effective_date
242: ,p_base_table_name => 'per_spinal_point_steps_f'
243: ,p_base_key_column => 'step_id'
244: ,p_base_key_value => p_base_key_value
245: ,p_parent_table_name1 => 'per_grade_spines_f'
246: ,p_parent_key_column1 => 'grade_spine_id'

Line 280: (p_base_table_name => 'per_spinal_point_steps_f'

276: -- version number.
277: --
278: l_object_version_number :=
279: dt_api.get_object_version_number
280: (p_base_table_name => 'per_spinal_point_steps_f'
281: ,p_base_key_column => 'step_id'
282: ,p_base_key_value => p_base_key_value
283: );
284: --

Line 291: update per_spinal_point_steps_f t

287: --
288: -- Update the specified datetrack row setting the effective
289: -- end date to the specified new effective end date.
290: --
291: update per_spinal_point_steps_f t
292: set t.effective_end_date = p_new_effective_end_date
293: , t.object_version_number = l_object_version_number
294: where t.step_id = p_base_key_value
295: and p_effective_date

Line 374: from per_spinal_point_steps_f

370: ,information29
371: ,information30
372: ,information_category
373: ,object_version_number
374: from per_spinal_point_steps_f
375: where step_id = p_step_id
376: and p_effective_date
377: between effective_start_date and effective_end_date
378: for update nowait;

Line 442: ,p_base_table_name => 'per_spinal_point_steps_f'

438: --
439: dt_api.validate_dt_mode
440: (p_effective_date => p_effective_date
441: ,p_datetrack_mode => p_datetrack_mode
442: ,p_base_table_name => 'per_spinal_point_steps_f'
443: ,p_base_key_column => 'step_id'
444: ,p_base_key_value => p_step_id
445: ,p_parent_table_name1 => 'per_grade_spines_f'
446: ,p_parent_key_column1 => 'grade_spine_id'

Line 489: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_steps_f');

485: -- The object is locked therefore we need to supply a meaningful
486: -- error message.
487: --
488: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
489: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_steps_f');
490: fnd_message.raise_error;
491: End lck;
492: --
493: -- ----------------------------------------------------------------------------