eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CCT_SHD dependencies on BEN_CM_TYP_F

Line 41: ElsIf (p_constraint_name = 'BEN_CM_TYP_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;
41: ElsIf (p_constraint_name = 'BEN_CM_TYP_F_PK') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;

Line 121: from ben_cm_typ_f

117: cct_attribute7,
118: cct_attribute8,
119: cct_attribute9,
120: object_version_number
121: from ben_cm_typ_f
122: where cm_typ_id = p_cm_typ_id
123: and p_effective_date
124: between effective_start_date and effective_end_date;
125: --

Line 194: from ben_cm_typ_f t

190: l_parent_key_value1 number;
191: --
192: Cursor C_Sel1 Is
193: select t.parnt_cm_typ_id
194: from ben_cm_typ_f t
195: where t.cm_typ_id = p_base_key_value
196: and p_effective_date
197: between t.effective_start_date and t.effective_end_date;
198: --

Line 216: p_base_table_name => 'ben_cm_typ_f',

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

Line 219: p_parent_table_name1 => 'ben_cm_typ_f',

215: (p_effective_date => p_effective_date,
216: p_base_table_name => 'ben_cm_typ_f',
217: p_base_key_column => 'cm_typ_id',
218: p_base_key_value => p_base_key_value,
219: p_parent_table_name1 => 'ben_cm_typ_f',
220: p_parent_key_column1 => 'cm_typ_id',
221: p_parent_key_value1 => l_parent_key_value1,
222: p_zap => p_zap,
223: p_delete => p_delete,

Line 250: p_base_table_name => 'ben_cm_typ_f',

246: -- Call the corresponding datetrack api
247: --
248: dt_api.find_dt_upd_modes
249: (p_effective_date => p_effective_date,
250: p_base_table_name => 'ben_cm_typ_f',
251: p_base_key_column => 'cm_typ_id',
252: p_base_key_value => p_base_key_value,
253: p_correction => p_correction,
254: p_update => p_update,

Line 283: (p_base_table_name => 'ben_cm_typ_f',

279: -- version number.
280: --
281: l_object_version_number :=
282: dt_api.get_object_version_number
283: (p_base_table_name => 'ben_cm_typ_f',
284: p_base_key_column => 'cm_typ_id',
285: p_base_key_value => p_base_key_value);
286: --
287: hr_utility.set_location(l_proc, 10);

Line 293: update ben_cm_typ_f t

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

Line 300: update ben_cm_typ_f_tl t

296: where t.cm_typ_id = p_base_key_value
297: and p_effective_date
298: between t.effective_start_date and t.effective_end_date;
299: --
300: update ben_cm_typ_f_tl t
301: set t.effective_end_date = p_new_effective_end_date,
302: t.last_update_date = sysdate,
303: t.last_updated_by = fnd_global.user_id,
304: t.last_update_login = fnd_global.login_id

Line 392: from ben_cm_typ_f

388: cct_attribute7,
389: cct_attribute8,
390: cct_attribute9,
391: object_version_number
392: from ben_cm_typ_f
393: where cm_typ_id = p_cm_typ_id
394: and p_effective_date
395: between effective_start_date and effective_end_date
396: for update nowait;

Line 451: p_base_table_name => 'ben_cm_typ_f',

447: --
448: dt_api.validate_dt_mode
449: (p_effective_date => p_effective_date,
450: p_datetrack_mode => p_datetrack_mode,
451: p_base_table_name => 'ben_cm_typ_f',
452: p_base_key_column => 'cm_typ_id',
453: p_base_key_value => p_cm_typ_id,
454: p_parent_table_name1 => 'ben_cm_typ_f',
455: p_parent_key_column1 => 'cm_typ_id',

Line 454: p_parent_table_name1 => 'ben_cm_typ_f',

450: p_datetrack_mode => p_datetrack_mode,
451: p_base_table_name => 'ben_cm_typ_f',
452: p_base_key_column => 'cm_typ_id',
453: p_base_key_value => p_cm_typ_id,
454: p_parent_table_name1 => 'ben_cm_typ_f',
455: p_parent_key_column1 => 'cm_typ_id',
456: p_parent_key_value1 => g_old_rec.parnt_cm_typ_id,
457: -- p_child_table_name1 => 'ben_cm_typ_f',
458: -- p_child_key_column1 => 'parnt_cm_typ_id',

Line 457: -- p_child_table_name1 => 'ben_cm_typ_f',

453: p_base_key_value => p_cm_typ_id,
454: p_parent_table_name1 => 'ben_cm_typ_f',
455: p_parent_key_column1 => 'cm_typ_id',
456: p_parent_key_value1 => g_old_rec.parnt_cm_typ_id,
457: -- p_child_table_name1 => 'ben_cm_typ_f',
458: -- p_child_key_column1 => 'parnt_cm_typ_id',
459: -- p_child_table_name2 => 'ben_cm_typ_trgr_f',
460: -- p_child_key_column2 => 'cm_typ_trgr_id',
461: -- p_child_table_name3 => 'ben_cm_typ_usg_f',

Line 496: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_f');

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

Line 503: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_f');

499: --
500: -- The object doesn't exist or is invalid
501: --
502: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
503: hr_utility.set_message_token('TABLE_NAME', 'ben_cm_typ_f');
504: hr_utility.raise_error;
505: End lck;
506: --
507: -- ----------------------------------------------------------------------------

Line 641: delete from ben_cm_typ_f_tl t

637: -- ----------------------------------------------------------------------------
638: Procedure add_language
639: is
640: begin
641: delete from ben_cm_typ_f_tl t
642: where not exists
643: (select null
644: from ben_cm_typ_f_tl b
645: where b.cm_typ_id = t.cm_typ_id

Line 644: from ben_cm_typ_f_tl b

640: begin
641: delete from ben_cm_typ_f_tl t
642: where not exists
643: (select null
644: from ben_cm_typ_f_tl b
645: where b.cm_typ_id = t.cm_typ_id
646: and b.effective_start_date = t.effective_start_date
647: );
648:

Line 649: update ben_cm_typ_f_tl t set (

645: where b.cm_typ_id = t.cm_typ_id
646: and b.effective_start_date = t.effective_start_date
647: );
648:
649: update ben_cm_typ_f_tl t set (
650: shrt_name,
651: name
652: ) = (select
653: b.shrt_name,

Line 655: from ben_cm_typ_f_tl b

651: name
652: ) = (select
653: b.shrt_name,
654: b.name
655: from ben_cm_typ_f_tl b
656: where b.cm_typ_id = t.cm_typ_id
657: and b.effective_start_date = t.effective_start_date
658: and b.language = t.source_lang)
659: where (

Line 667: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt

663: ) in (select
664: subt.cm_typ_id,
665: subt.effective_start_date,
666: subt.language
667: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt
668: where subb.cm_typ_id = subt.cm_typ_id
669: and subb.effective_start_date = subt.effective_start_date
670: and subb.language = subt.source_lang
671: and (subb.name <> subt.name

Line 675: insert into ben_cm_typ_f_tl (

671: and (subb.name <> subt.name
672: or subb.shrt_name <> subt.shrt_name
673: ));
674: --
675: insert into ben_cm_typ_f_tl (
676: cm_typ_id,
677: effective_start_date,
678: effective_end_date,
679: shrt_name,

Line 701: from ben_cm_typ_f_tl b, fnd_languages l

697: b.last_updated_by,
698: b.last_update_login,
699: b.created_by,
700: b.creation_date
701: from ben_cm_typ_f_tl b, fnd_languages l
702: where l.installed_flag in ('I', 'B')
703: and b.language = userenv('LANG')
704: and not exists
705: (select null

Line 706: from ben_cm_typ_f_tl t

702: where l.installed_flag in ('I', 'B')
703: and b.language = userenv('LANG')
704: and not exists
705: (select null
706: from ben_cm_typ_f_tl t
707: where t.cm_typ_id = b.cm_typ_id
708: and t.effective_start_date = b.effective_start_date
709: and t.language = l.language_code);
710: end add_language;