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_LER_SHD dependencies on BEN_LER_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_LER_FK1') Then
37: fnd_message.set_name('BEN', 'BEN_91000_INVALID_BUS_GROUP');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'BEN_LER_PK') Then
40: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

Line 129: from ben_ler_f

125: ler_attribute28,
126: ler_attribute29,
127: ler_attribute30,
128: object_version_number
129: from ben_ler_f
130: where ler_id = p_ler_id
131: and p_effective_date
132: between effective_start_date and effective_end_date;
133: --

Line 202: from ben_ler_f t

198: l_parent_key_value1 number;
199: --
200: Cursor C_Sel1 Is
201: select t.ler_eval_rl
202: from ben_ler_f t
203: where t.ler_id = p_base_key_value
204: and p_effective_date
205: between t.effective_start_date and t.effective_end_date;
206: --

Line 224: p_base_table_name => 'ben_ler_f',

220: -- Call the corresponding datetrack api
221: --
222: dt_api.find_dt_del_modes
223: (p_effective_date => p_effective_date,
224: p_base_table_name => 'ben_ler_f',
225: p_base_key_column => 'ler_id',
226: p_base_key_value => p_base_key_value,
227: p_parent_table_name1 => 'ff_formulas_f',
228: p_parent_key_column1 => 'formula_id',

Line 258: p_base_table_name => 'ben_ler_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_ler_f',
259: p_base_key_column => 'ler_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_ler_f',

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

Line 301: update ben_ler_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_ler_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.ler_id = p_base_key_value
305: and p_effective_date

Line 308: update ben_ler_f_tl t

304: where t.ler_id = p_base_key_value
305: and p_effective_date
306: between t.effective_start_date and t.effective_end_date;
307: --
308: update ben_ler_f_tl t
309: set t.effective_end_date = p_new_effective_end_date,
310: t.last_update_date = sysdate,
311: t.last_updated_by = fnd_global.user_id,
312: t.last_update_login = fnd_global.login_id

Line 410: from ben_ler_f

406: ler_attribute28,
407: ler_attribute29,
408: ler_attribute30,
409: object_version_number
410: from ben_ler_f
411: where ler_id = p_ler_id
412: and p_effective_date
413: between effective_start_date and effective_end_date
414: for update nowait;

Line 491: p_base_table_name => 'ben_ler_f',

487: --
488: dt_api.validate_dt_mode
489: (p_effective_date => p_effective_date,
490: p_datetrack_mode => p_datetrack_mode,
491: p_base_table_name => 'ben_ler_f',
492: p_base_key_column => 'ler_id',
493: p_base_key_value => p_ler_id,
494: p_parent_table_name1 => 'ff_formulas_f',
495: p_parent_key_column1 => 'formula_id',

Line 520: p_base_table_name => 'ben_ler_f',

516:
517: dt_api.validate_dt_mode
518: (p_effective_date => p_effective_date,
519: p_datetrack_mode => p_datetrack_mode,
520: p_base_table_name => 'ben_ler_f',
521: p_base_key_column => 'ler_id',
522: p_base_key_value => p_ler_id,
523: p_child_table_name1 => 'ben_ler_rltd_per_cs_ler_f',
524: p_child_key_column1 => 'ler_rltd_per_cs_ler_id',

Line 553: -- to parent ben_ler_f, we must manually lock the rows on the child

549: end if;
550:
551:
552: -- Since we have two foreign keys from child ben_css_rltd_per_per_in_ler_f
553: -- to parent ben_ler_f, we must manually lock the rows on the child
554: -- where the foreign key name is not ler_id.
555: --
556: begin -- special locking code
557: if p_datetrack_mode = hr_api.g_delete and p_ler_id is not null then

Line 618: fnd_message.set_token('TABLE_NAME', 'ben_ler_f');

614: -- The object is locked therefore we need to supply a meaningful
615: -- error message.
616: --
617: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
618: fnd_message.set_token('TABLE_NAME', 'ben_ler_f');
619: fnd_message.raise_error;
620: When l_object_invalid then
621: --
622: -- The object doesn't exist or is invalid

Line 625: fnd_message.set_token('TABLE_NAME', 'ben_ler_f');

621: --
622: -- The object doesn't exist or is invalid
623: --
624: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
625: fnd_message.set_token('TABLE_NAME', 'ben_ler_f');
626: fnd_message.raise_error;
627: End lck;
628: --
629: -- ----------------------------------------------------------------------------

Line 774: delete from ben_ler_f_tl t

770: -- ----------------------------------------------------------------------------
771: Procedure add_language
772: is
773: begin
774: delete from ben_ler_f_tl t
775: where not exists
776: (select null
777: from ben_ler_f_tl b
778: where b.ler_id = t.ler_id

Line 777: from ben_ler_f_tl b

773: begin
774: delete from ben_ler_f_tl t
775: where not exists
776: (select null
777: from ben_ler_f_tl b
778: where b.ler_id = t.ler_id
779: and b.effective_start_date = t.effective_start_date
780: );
781:

Line 782: update ben_ler_f_tl t set (

778: where b.ler_id = t.ler_id
779: and b.effective_start_date = t.effective_start_date
780: );
781:
782: update ben_ler_f_tl t set (
783: typ_cd,
784: name
785: ) = (select
786: b.typ_cd,

Line 788: from ben_ler_f_tl b

784: name
785: ) = (select
786: b.typ_cd,
787: b.name
788: from ben_ler_f_tl b
789: where b.ler_id = t.ler_id
790: and b.effective_start_date = t.effective_start_date
791: and b.language = t.source_lang)
792: where (

Line 800: from ben_ler_f_tl subb, ben_ler_f_tl subt

796: ) in (select
797: subt.ler_id,
798: subt.effective_start_date,
799: subt.language
800: from ben_ler_f_tl subb, ben_ler_f_tl subt
801: where subb.ler_id = subt.ler_id
802: and subb.effective_start_date = subt.effective_start_date
803: and subb.language = subt.source_lang
804: and (subb.name <> subt.name

Line 808: insert into ben_ler_f_tl (

804: and (subb.name <> subt.name
805: or subb.typ_cd <> subt.typ_cd
806: ));
807:
808: insert into ben_ler_f_tl (
809: ler_id,
810: effective_start_date,
811: effective_end_date,
812: typ_cd,

Line 836: from ben_ler_f_tl b, fnd_languages l

832: b.last_updated_by,
833: b.last_update_login,
834: b.created_by,
835: b.creation_date
836: from ben_ler_f_tl b, fnd_languages l
837: where l.installed_flag in ('I', 'B')
838: and b.language = userenv('LANG')
839: and not exists
840: (select null

Line 841: from ben_ler_f_tl t

837: where l.installed_flag in ('I', 'B')
838: and b.language = userenv('LANG')
839: and not exists
840: (select null
841: from ben_ler_f_tl t
842: where t.ler_id = b.ler_id
843: and t.effective_start_date = b.effective_start_date
844: and t.language = l.language_code);
845: end add_language;