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_ELIG_SCRE_WTG_API dependencies on BEN_ELIG_SCRE_WTG_F

Line 30: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;

26: l_proc varchar2(72) := g_package||'create_perf_score_weight';
27: --
28: -- Declare cursors and local variables
29: --
30: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;
32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --

Line 31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;

27: --
28: -- Declare cursors and local variables
29: --
30: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;
32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;

Line 32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;

28: -- Declare cursors and local variables
29: --
30: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;
32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;

Line 33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;

29: --
30: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;
32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;
37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;

Line 35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;

31: l_elig_scre_wtg_id ben_elig_scre_wtg_f.elig_per_opt_id%TYPE;
32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;
37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;
38: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;
39: --

Line 36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;

32: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;
37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;
38: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;
39: --
40: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;

Line 37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;

33: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;
37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;
38: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;
39: --
40: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
41:

Line 38: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;

34: --
35: l_created_by ben_elig_scre_wtg_f.created_by%TYPE;
36: l_creation_date ben_elig_scre_wtg_f.creation_date%TYPE;
37: l_last_update_date ben_elig_scre_wtg_f.last_update_date%TYPE;
38: l_last_updated_by ben_elig_scre_wtg_f.last_updated_by%TYPE;
39: --
40: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
41:
42: begin

Line 72: insert into ben_elig_scre_wtg_f

68: --
69: -- Insert the row into: ben_elig_per_f
70: --
71: hr_utility.set_location('Insert: '||l_proc, 5);
72: insert into ben_elig_scre_wtg_f
73: (elig_scre_wtg_id
74: ,elig_per_id
75: ,elig_per_opt_id
76: ,elig_rslt_id

Line 179: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;

175: --
176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_score_weight';
179: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
182: --
183: begin

Line 180: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;

176: -- Declare cursors and local variables
177: --
178: l_proc varchar2(72) := g_package||'update_score_weight';
179: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
182: --
183: begin
184: --

Line 181: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;

177: --
178: l_proc varchar2(72) := g_package||'update_score_weight';
179: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
180: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
181: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 265: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;

261: --
262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72) := g_package||'delete_score_weight';
265: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
266: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
267: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
268: --
269: begin

Line 266: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;

262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72) := g_package||'delete_score_weight';
265: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
266: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
267: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
268: --
269: begin
270: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 267: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;

263: --
264: l_proc varchar2(72) := g_package||'delete_score_weight';
265: l_object_version_number ben_elig_scre_wtg_f.object_version_number%TYPE;
266: l_effective_start_date ben_elig_scre_wtg_f.effective_start_date%TYPE;
267: l_effective_end_date ben_elig_scre_wtg_f.effective_end_date%TYPE;
268: --
269: begin
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271: --

Line 342: from ben_elig_scre_wtg_f

338: p_crit_tab_short_name varchar2,
339: p_crit_tab_pk_id number,
340: p_effective_date date) is
341: select *
342: from ben_elig_scre_wtg_f
343: where eligy_prfl_id = p_eligy_prfl_id
344: and crit_tab_short_name = p_crit_tab_short_name
345: and crit_tab_pk_id = p_crit_tab_pk_id
346: and nvl(elig_per_id,-1) = nvl(p_elig_per_id,-1)

Line 421: p_base_table_name => 'BEN_ELIG_SCRE_WTG_F',

417: ,p_object_version_number => l_object_version_number);
418: else
419: dt_api.find_dt_upd_modes
420: (p_effective_date => p_effective_date,
421: p_base_table_name => 'BEN_ELIG_SCRE_WTG_F',
422: p_base_key_column => 'elig_scre_wtg_id',
423: p_base_key_value => l_elig_scre_wtg_id,
424: p_correction => l_correction,
425: p_update => l_update,