APPS.BEN_CTU_SHD dependencies on BEN_CM_TYP_USG_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_CM_TYP_USG_F_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;

Line 111: from ben_cm_typ_usg_f

107: ctu_attribute28,
108: ctu_attribute29,
109: ctu_attribute30,
110: object_version_number
111: from ben_cm_typ_usg_f
112: where cm_typ_usg_id = p_cm_typ_usg_id
113: and p_effective_date
114: between effective_start_date and effective_end_date;
115: --

Line 190: from ben_cm_typ_usg_f t

186: select t.pgm_id,
187: t.cm_typ_id,
188: t.pl_id,
189: t.pl_typ_id
190: from ben_cm_typ_usg_f t
191: where t.cm_typ_usg_id = p_base_key_value
192: and p_effective_date
193: between t.effective_start_date and t.effective_end_date;
194: --

Line 215: p_base_table_name => 'ben_cm_typ_usg_f',

211: -- Call the corresponding datetrack api
212: --
213: dt_api.find_dt_del_modes
214: (p_effective_date => p_effective_date,
215: p_base_table_name => 'ben_cm_typ_usg_f',
216: p_base_key_column => 'cm_typ_usg_id',
217: p_base_key_value => p_base_key_value,
218: p_parent_table_name1 => 'ben_pgm_f',
219: p_parent_key_column1 => 'pgm_id',

Line 258: p_base_table_name => 'ben_cm_typ_usg_f',

254: -- Call the corresponding datetrack api
255: --
256: dt_api.find_dt_upd_modes
257: (p_effective_date => p_effective_date,
258: p_base_table_name => 'ben_cm_typ_usg_f',
259: p_base_key_column => 'cm_typ_usg_id',
260: p_base_key_value => p_base_key_value,
261: p_correction => p_correction,
262: p_update => p_update,

Line 291: (p_base_table_name => 'ben_cm_typ_usg_f',

287: -- version number.
288: --
289: l_object_version_number :=
290: dt_api.get_object_version_number
291: (p_base_table_name => 'ben_cm_typ_usg_f',
292: p_base_key_column => 'cm_typ_usg_id',
293: p_base_key_value => p_base_key_value);
294: --
295: hr_utility.set_location(l_proc, 10);

Line 301: update ben_cm_typ_usg_f t

297: --
298: -- Update the specified datetrack row setting the effective
299: -- end date to the specified new effective end date.
300: --
301: update ben_cm_typ_usg_f t
302: set t.effective_end_date = p_new_effective_end_date,
303: t.object_version_number = l_object_version_number
304: where t.cm_typ_usg_id = p_base_key_value
305: and p_effective_date

Line 386: from ben_cm_typ_usg_f

382: ctu_attribute28,
383: ctu_attribute29,
384: ctu_attribute30,
385: object_version_number
386: from ben_cm_typ_usg_f
387: where cm_typ_usg_id = p_cm_typ_usg_id
388: and p_effective_date
389: between effective_start_date and effective_end_date
390: for update nowait;

Line 445: p_base_table_name => 'ben_cm_typ_usg_f',

441: --
442: dt_api.validate_dt_mode
443: (p_effective_date => p_effective_date,
444: p_datetrack_mode => p_datetrack_mode,
445: p_base_table_name => 'ben_cm_typ_usg_f',
446: p_base_key_column => 'cm_typ_usg_id',
447: p_base_key_value => p_cm_typ_usg_id,
448: p_parent_table_name1 => 'ben_pgm_f',
449: p_parent_key_column1 => 'pgm_id',

Line 493: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_usg_f');

489: -- The object is locked therefore we need to supply a meaningful
490: -- error message.
491: --
492: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
493: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_usg_f');
494: hr_utility.raise_error;
495: When l_object_invalid then
496: --
497: -- The object doesn't exist or is invalid

Line 500: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_usg_f');

496: --
497: -- The object doesn't exist or is invalid
498: --
499: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
500: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_usg_f');
501: hr_utility.raise_error;
502: End lck;
503: --
504: -- ----------------------------------------------------------------------------