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_EOU_INS dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 84: from ben_elig_org_unit_prte_f t

80: --
81: Cursor C_Sel1 Is
82: select t.created_by,
83: t.creation_date
84: from ben_elig_org_unit_prte_f t
85: where t.elig_org_unit_prte_id = p_rec.elig_org_unit_prte_id
86: and t.effective_start_date =
87: ben_eou_shd.g_old_rec.effective_start_date
88: and t.effective_end_date = (p_validation_start_date - 1);

Line 91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;

87: ben_eou_shd.g_old_rec.effective_start_date
88: and t.effective_end_date = (p_validation_start_date - 1);
89: --
90: l_proc varchar2(72) := g_package||'dt_insert_dml';
91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;
93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;
94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;
95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;

Line 92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;

88: and t.effective_end_date = (p_validation_start_date - 1);
89: --
90: l_proc varchar2(72) := g_package||'dt_insert_dml';
91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;
93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;
94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;
95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;
96: --

Line 93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;

89: --
90: l_proc varchar2(72) := g_package||'dt_insert_dml';
91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;
93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;
94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;
95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;
96: --
97: Begin

Line 94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;

90: l_proc varchar2(72) := g_package||'dt_insert_dml';
91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;
93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;
94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;
95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;
96: --
97: Begin
98: hr_utility.set_location('Entering:'||l_proc, 5);

Line 95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;

91: l_created_by ben_elig_org_unit_prte_f.created_by%TYPE;
92: l_creation_date ben_elig_org_unit_prte_f.creation_date%TYPE;
93: l_last_update_date ben_elig_org_unit_prte_f.last_update_date%TYPE;
94: l_last_updated_by ben_elig_org_unit_prte_f.last_updated_by%TYPE;
95: l_last_update_login ben_elig_org_unit_prte_f.last_update_login%TYPE;
96: --
97: Begin
98: hr_utility.set_location('Entering:'||l_proc, 5);
99: --

Line 104: (p_base_table_name => 'ben_elig_org_unit_prte_f',

100: -- Get the object version number for the insert
101: --
102: p_rec.object_version_number :=
103: dt_api.get_object_version_number
104: (p_base_table_name => 'ben_elig_org_unit_prte_f',
105: p_base_key_column => 'elig_org_unit_prte_id',
106: p_base_key_value => p_rec.elig_org_unit_prte_id);
107: --
108: -- Set the effective start and end dates to the corresponding

Line 146: -- Insert the row into: ben_elig_org_unit_prte_f

142: End If;
143: --
144: ben_eou_shd.g_api_dml := true; -- Set the api dml status
145: --
146: -- Insert the row into: ben_elig_org_unit_prte_f
147: --
148: insert into ben_elig_org_unit_prte_f
149: ( elig_org_unit_prte_id,
150: effective_start_date,

Line 148: insert into ben_elig_org_unit_prte_f

144: ben_eou_shd.g_api_dml := true; -- Set the api dml status
145: --
146: -- Insert the row into: ben_elig_org_unit_prte_f
147: --
148: insert into ben_elig_org_unit_prte_f
149: ( elig_org_unit_prte_id,
150: effective_start_date,
151: effective_end_date,
152: business_group_id,

Line 338: select ben_elig_org_unit_prte_f_s.nextval

334: p_validation_end_date in date) is
335: --
336: --
337: cursor c1 is
338: select ben_elig_org_unit_prte_f_s.nextval
339: from sys.dual;
340: --
341: Cursor C_Sel2 is
342: Select null

Line 343: from ben_elig_org_unit_prte_f

339: from sys.dual;
340: --
341: Cursor C_Sel2 is
342: Select null
343: from ben_elig_org_unit_prte_f
344: where elig_org_unit_prte_id = ben_eou_ins.g_elig_org_unit_prte_id_i;
345: --
346: l_proc varchar2(72) := g_package||'pre_insert';
347: l_exists varchar2(1);

Line 364: fnd_message.set_token('TABLE_NAME','ben_elig_org_unit_prte_f');

360: --
361: -- The primary key values are already in use.
362: --
363: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
364: fnd_message.set_token('TABLE_NAME','ben_elig_org_unit_prte_f');
365: fnd_message.raise_error;
366: End If;
367: Close C_Sel2;
368: --

Line 487: (p_module_name => 'ben_elig_org_unit_prte_f'

483: --
484: when hr_api.cannot_find_prog_unit then
485: --
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'ben_elig_org_unit_prte_f'
488: ,p_hook_type => 'AI');
489: --
490: end;
491: --

Line 555: p_base_table_name => 'ben_elig_org_unit_prte_f',

551: --
552: dt_api.validate_dt_mode
553: (p_effective_date => p_effective_date,
554: p_datetrack_mode => p_datetrack_mode,
555: p_base_table_name => 'ben_elig_org_unit_prte_f',
556: p_base_key_column => 'elig_org_unit_prte_id',
557: p_base_key_value => p_rec.elig_org_unit_prte_id,
558: p_parent_table_name1 => 'ben_eligy_prfl_f',
559: p_parent_key_column1 => 'eligy_prfl_id',