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_PEP_SHD dependencies on BEN_ELIG_PER_F

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ELIG_PER_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;

Line 41: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK2') 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_ELIG_PER_FK2') 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 51: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_LER') Then

47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_LER') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;

Line 56: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PL') Then

52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PL') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;

Line 61: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PGM') Then

57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PGM') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;

Line 66: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PERSON') Then

62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_ELIG_PER_FK_PERSON') Then
67: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('STEP','35');
70: fnd_message.raise_error;

Line 196: from ben_elig_per_f

192: program_application_id,
193: program_id,
194: program_update_date,
195: object_version_number
196: from ben_elig_per_f
197: where elig_per_id = p_elig_per_id
198: and p_effective_date
199: between effective_start_date and effective_end_date;
200: --

Line 286: from ben_elig_per_f t

282: t.pgm_id,
283: t.pl_id,
284: t.plip_id,
285: t.ptip_id
286: from ben_elig_per_f t
287: where t.elig_per_id = p_base_key_value
288: and p_effective_date between t.effective_start_date
289: and t.effective_end_date;
290: --

Line 312: p_base_table_name => 'ben_elig_per_f',

308: -- Call the corresponding datetrack api
309: --
310: dt_api.find_dt_del_modes
311: (p_effective_date => p_effective_date,
312: p_base_table_name => 'ben_elig_per_f',
313: p_base_key_column => 'elig_per_id',
314: p_base_key_value => p_base_key_value,
315: p_parent_table_name1 => 'ben_ler_f',
316: p_parent_key_column1 => 'ler_id',

Line 358: p_base_table_name => 'ben_elig_per_f',

354: -- Call the corresponding datetrack api
355: --
356: dt_api.find_dt_upd_modes
357: (p_effective_date => p_effective_date,
358: p_base_table_name => 'ben_elig_per_f',
359: p_base_key_column => 'elig_per_id',
360: p_base_key_value => p_base_key_value,
361: p_correction => p_correction,
362: p_update => p_update,

Line 391: (p_base_table_name => 'ben_elig_per_f',

387: -- version number.
388: --
389: l_object_version_number :=
390: dt_api.get_object_version_number
391: (p_base_table_name => 'ben_elig_per_f',
392: p_base_key_column => 'elig_per_id',
393: p_base_key_value => p_base_key_value);
394: --
395: hr_utility.set_location(l_proc, 10);

Line 401: update ben_elig_per_f t

397: --
398: -- Update the specified datetrack row setting the effective
399: -- end date to the specified new effective end date.
400: --
401: update ben_elig_per_f t
402: set t.effective_end_date = p_new_effective_end_date,
403: t.object_version_number = l_object_version_number
404: where t.elig_per_id = p_base_key_value
405: and p_effective_date

Line 541: from ben_elig_per_f

537: program_application_id,
538: program_id,
539: program_update_date,
540: object_version_number
541: from ben_elig_per_f
542: where elig_per_id = p_elig_per_id
543: and p_effective_date
544: between effective_start_date and effective_end_date
545: for update nowait;

Line 599: p_base_table_name => 'ben_elig_per_f',

595: --
596: dt_api.validate_dt_mode
597: (p_effective_date => p_effective_date,
598: p_datetrack_mode => p_datetrack_mode,
599: p_base_table_name => 'ben_elig_per_f',
600: p_base_key_column => 'elig_per_id',
601: p_base_key_value => p_elig_per_id,
602: p_parent_table_name1 => 'ben_ler_f',
603: p_parent_key_column1 => 'ler_id',

Line 654: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');

650: -- The object is locked therefore we need to supply a meaningful
651: -- error message.
652: --
653: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
654: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');
655: fnd_message.raise_error;
656: When l_object_invalid then
657: --
658: -- The object doesn't exist or is invalid

Line 661: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');

657: --
658: -- The object doesn't exist or is invalid
659: --
660: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
661: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');
662: fnd_message.raise_error;
663: End lck;
664: --
665: -- ----------------------------------------------------------------------------