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_ELIGIBLE_PERSON_PERF_API dependencies on BEN_ELIG_PER_OPT_F

Line 2972: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;

2968: l_proc varchar2(72) := g_package||'create_perf_Elig_Person_Option';
2969: --
2970: -- Declare cursors and local variables
2971: --
2972: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --

Line 2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;

2969: --
2970: -- Declare cursors and local variables
2971: --
2972: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;

Line 2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;

2970: -- Declare cursors and local variables
2971: --
2972: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;

Line 2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;

2971: --
2972: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;

Line 2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;

2973: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;

Line 2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;

2974: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --

Line 2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;

2975: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --
2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;

Line 2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;

2976: --
2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --
2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
2984: --

Line 2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;

2977: l_created_by ben_elig_per_opt_f.created_by%TYPE;
2978: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --
2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
2984: --
2985: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

Line 2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;

2979: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
2980: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --
2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
2984: --
2985: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
2986: --
2987: begin

Line 3039: insert into ben_elig_per_opt_f

3035: -- Insert the row into: ben_elig_per_f
3036: --
3037: hr_utility.set_location('Insert: '||l_proc, 5);
3038: hr_utility.set_location('Ins EPO:'||l_proc, 5);
3039: insert into ben_elig_per_opt_f
3040: ( elig_per_opt_id,
3041: elig_per_id,
3042: effective_start_date,
3043: effective_end_date,

Line 3401: from ben_elig_per_opt_f

3397: program_application_id,
3398: program_id,
3399: program_update_date,
3400: object_version_number
3401: from ben_elig_per_opt_f
3402: where elig_per_opt_id = p_elig_per_opt_id
3403: and p_effective_date
3404: between effective_start_date and effective_end_date;
3405: --

Line 3457: p_base_table_name => 'ben_elig_per_opt_f',

3453: --
3454: dt_api.validate_dt_mode
3455: (p_effective_date => p_effective_date,
3456: p_datetrack_mode => p_datetrack_mode,
3457: p_base_table_name => 'ben_elig_per_opt_f',
3458: p_base_key_column => 'elig_per_opt_id',
3459: p_base_key_value => p_elig_per_opt_id,
3460: /*
3461: p_parent_table_name1 => 'ben_elig_per_f',

Line 3500: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');

3496: -- The object is locked therefore we need to supply a meaningful
3497: -- error message.
3498: --
3499: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
3500: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');
3501: fnd_message.raise_error;
3502: When l_object_invalid then
3503: --
3504: -- The object doesn't exist or is invalid

Line 3507: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');

3503: --
3504: -- The object doesn't exist or is invalid
3505: --
3506: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
3507: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');
3508: fnd_message.raise_error;
3509: End lck;
3510: -- ----------------------------------------------------------------------------
3511: -- |---------------------------< epo_convert_defs >---------------------------|

Line 3989: (p_base_table_name => 'ben_elig_per_opt_f',

3985: -- version number.
3986: --
3987: p_rec.object_version_number :=
3988: dt_api.get_object_version_number
3989: (p_base_table_name => 'ben_elig_per_opt_f',
3990: p_base_key_column => 'elig_per_opt_id',
3991: p_base_key_value => p_rec.elig_per_opt_id);
3992: --
3993: ben_epo_shd.g_api_dml := true; -- Set the api dml status

Line 3995: -- Update the ben_elig_per_opt_f Row

3991: p_base_key_value => p_rec.elig_per_opt_id);
3992: --
3993: ben_epo_shd.g_api_dml := true; -- Set the api dml status
3994: --
3995: -- Update the ben_elig_per_opt_f Row
3996: --
3997: update ben_elig_per_opt_f
3998: set
3999: elig_per_opt_id = p_rec.elig_per_opt_id,

Line 3997: update ben_elig_per_opt_f

3993: ben_epo_shd.g_api_dml := true; -- Set the api dml status
3994: --
3995: -- Update the ben_elig_per_opt_f Row
3996: --
3997: update ben_elig_per_opt_f
3998: set
3999: elig_per_opt_id = p_rec.elig_per_opt_id,
4000: elig_per_id = p_rec.elig_per_id,
4001: prtn_ovridn_flag = p_rec.prtn_ovridn_flag,

Line 4576: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;

4572: --
4573: -- Declare cursors and local variables
4574: --
4575: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4576: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4577: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4578: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4579: --
4580: begin

Line 4577: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;

4573: -- Declare cursors and local variables
4574: --
4575: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4576: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4577: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4578: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4579: --
4580: begin
4581: --

Line 4578: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;

4574: --
4575: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4576: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4577: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4578: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4579: --
4580: begin
4581: --
4582: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4953: from ben_elig_per_opt_f p

4949: --
4950: l_rows_processed number := 0 ;
4951: cursor csr_get_epo_ids is
4952: select distinct p.elig_per_opt_id
4953: from ben_elig_per_opt_f p
4954: where p.rowid
4955: between p_start_rowid and p_end_rowid
4956: and p.wait_perd_cmpltn_dt||'' is not null ;
4957: begin

Line 4971: update ben_elig_per_opt_f epo

4967: --
4968: l_rows_processed := l_rows_processed + t_epo_id.COUNT ;
4969: --
4970: forall i in t_epo_id.FIRST..t_epo_id.LAST
4971: update ben_elig_per_opt_f epo
4972: set wait_perd_cmpltn_date = fnd_date.string_to_date(wait_perd_cmpltn_dt,'DD-MON-RRRR')
4973: where epo.elig_per_opt_id = t_epo_id(i) ;
4974: --
4975: commit;