APPS.BEN_PCM_SHD dependencies on BEN_PER_CM_F

Line 36: If (p_constraint_name = 'BEN_PER_CM_F_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PER_CM_F_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'BEN_PER_CM_F_PK') Then

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

Line 119: from ben_per_cm_f

115: program_application_id,
116: program_id,
117: program_update_date,
118: object_version_number
119: from ben_per_cm_f
120: where per_cm_id = p_per_cm_id
121: and p_effective_date
122: between effective_start_date and effective_end_date;
123: --

Line 194: from ben_per_cm_f t

190: --
191: Cursor C_Sel1 Is
192: select t.cm_typ_id,
193: t.prtt_enrt_actn_id
194: from ben_per_cm_f t
195: where t.per_cm_id = p_base_key_value
196: and p_effective_date
197: between t.effective_start_date and t.effective_end_date;
198: --

Line 217: p_base_table_name => 'ben_per_cm_f',

213: -- Call the corresponding datetrack api
214: --
215: dt_api.find_dt_del_modes
216: (p_effective_date => p_effective_date,
217: p_base_table_name => 'ben_per_cm_f',
218: p_base_key_column => 'per_cm_id',
219: p_base_key_value => p_base_key_value,
220: p_parent_table_name1 => 'ben_cm_typ_f',
221: p_parent_key_column1 => 'cm_typ_id',

Line 254: p_base_table_name => 'ben_per_cm_f',

250: -- Call the corresponding datetrack api
251: --
252: dt_api.find_dt_upd_modes
253: (p_effective_date => p_effective_date,
254: p_base_table_name => 'ben_per_cm_f',
255: p_base_key_column => 'per_cm_id',
256: p_base_key_value => p_base_key_value,
257: p_correction => p_correction,
258: p_update => p_update,

Line 287: (p_base_table_name => 'ben_per_cm_f',

283: -- version number.
284: --
285: l_object_version_number :=
286: dt_api.get_object_version_number
287: (p_base_table_name => 'ben_per_cm_f',
288: p_base_key_column => 'per_cm_id',
289: p_base_key_value => p_base_key_value);
290: --
291: hr_utility.set_location(l_proc, 10);

Line 297: update ben_per_cm_f t

293: --
294: -- Update the specified datetrack row setting the effective
295: -- end date to the specified new effective end date.
296: --
297: update ben_per_cm_f t
298: set t.effective_end_date = p_new_effective_end_date,
299: t.object_version_number = l_object_version_number
300: where t.per_cm_id = p_base_key_value
301: and p_effective_date

Line 385: from ben_per_cm_f

381: program_application_id,
382: program_id,
383: program_update_date,
384: object_version_number
385: from ben_per_cm_f
386: where per_cm_id = p_per_cm_id
387: and p_effective_date
388: between effective_start_date and effective_end_date
389: for update nowait;

Line 444: p_base_table_name => 'ben_per_cm_f',

440: --
441: dt_api.validate_dt_mode
442: (p_effective_date => p_effective_date,
443: p_datetrack_mode => p_datetrack_mode,
444: p_base_table_name => 'ben_per_cm_f',
445: p_base_key_column => 'per_cm_id',
446: p_base_key_value => p_per_cm_id,
447: p_parent_table_name1 => 'ben_cm_typ_f',
448: p_parent_key_column1 => 'cm_typ_id',

Line 490: fnd_message.set_token('TABLE_NAME', 'ben_per_cm_f');

486: -- The object is locked therefore we need to supply a meaningful
487: -- error message.
488: --
489: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
490: fnd_message.set_token('TABLE_NAME', 'ben_per_cm_f');
491: fnd_message.raise_error;
492: When l_object_invalid then
493: --
494: -- The object doesn't exist or is invalid

Line 497: fnd_message.set_token('TABLE_NAME', 'ben_per_cm_f');

493: --
494: -- The object doesn't exist or is invalid
495: --
496: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
497: fnd_message.set_token('TABLE_NAME', 'ben_per_cm_f');
498: fnd_message.raise_error;
499: End lck;
500: --
501: -- ----------------------------------------------------------------------------