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 3002: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;

2998: l_proc varchar2(72) := g_package||'create_perf_Elig_Person_Option';
2999: --
3000: -- Declare cursors and local variables
3001: --
3002: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --

Line 3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;

2999: --
3000: -- Declare cursors and local variables
3001: --
3002: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;

Line 3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;

3000: -- Declare cursors and local variables
3001: --
3002: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;

Line 3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;

3001: --
3002: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;

Line 3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;

3003: l_elig_per_opt_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;

Line 3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;

3004: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --

Line 3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;

3005: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --
3013: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;

Line 3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;

3006: --
3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --
3013: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
3014: --

Line 3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;

3007: l_created_by ben_elig_per_opt_f.created_by%TYPE;
3008: l_creation_date ben_elig_per_opt_f.creation_date%TYPE;
3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --
3013: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
3014: --
3015: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

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

3009: l_last_update_date ben_elig_per_opt_f.last_update_date%TYPE;
3010: l_last_updated_by ben_elig_per_opt_f.last_updated_by%TYPE;
3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --
3013: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
3014: --
3015: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
3016: --
3017: begin

Line 3069: insert into ben_elig_per_opt_f

3065: -- Insert the row into: ben_elig_per_f
3066: --
3067: hr_utility.set_location('Insert: '||l_proc, 5);
3068: hr_utility.set_location('Ins EPO:'||l_proc, 5);
3069: insert into ben_elig_per_opt_f
3070: ( elig_per_opt_id,
3071: elig_per_id,
3072: effective_start_date,
3073: effective_end_date,

Line 3431: from ben_elig_per_opt_f

3427: program_application_id,
3428: program_id,
3429: program_update_date,
3430: object_version_number
3431: from ben_elig_per_opt_f
3432: where elig_per_opt_id = p_elig_per_opt_id
3433: and p_effective_date
3434: between effective_start_date and effective_end_date;
3435: --

Line 3487: p_base_table_name => 'ben_elig_per_opt_f',

3483: --
3484: dt_api.validate_dt_mode
3485: (p_effective_date => p_effective_date,
3486: p_datetrack_mode => p_datetrack_mode,
3487: p_base_table_name => 'ben_elig_per_opt_f',
3488: p_base_key_column => 'elig_per_opt_id',
3489: p_base_key_value => p_elig_per_opt_id,
3490: /*
3491: p_parent_table_name1 => 'ben_elig_per_f',

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

3526: -- The object is locked therefore we need to supply a meaningful
3527: -- error message.
3528: --
3529: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
3530: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');
3531: fnd_message.raise_error;
3532: When l_object_invalid then
3533: --
3534: -- The object doesn't exist or is invalid

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

3533: --
3534: -- The object doesn't exist or is invalid
3535: --
3536: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
3537: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_opt_f');
3538: fnd_message.raise_error;
3539: End lck;
3540: -- ----------------------------------------------------------------------------
3541: -- |---------------------------< epo_convert_defs >---------------------------|

Line 4019: (p_base_table_name => 'ben_elig_per_opt_f',

4015: -- version number.
4016: --
4017: p_rec.object_version_number :=
4018: dt_api.get_object_version_number
4019: (p_base_table_name => 'ben_elig_per_opt_f',
4020: p_base_key_column => 'elig_per_opt_id',
4021: p_base_key_value => p_rec.elig_per_opt_id);
4022: --
4023: ben_epo_shd.g_api_dml := true; -- Set the api dml status

Line 4025: -- Update the ben_elig_per_opt_f Row

4021: p_base_key_value => p_rec.elig_per_opt_id);
4022: --
4023: ben_epo_shd.g_api_dml := true; -- Set the api dml status
4024: --
4025: -- Update the ben_elig_per_opt_f Row
4026: --
4027: update ben_elig_per_opt_f
4028: set
4029: elig_per_opt_id = p_rec.elig_per_opt_id,

Line 4027: update ben_elig_per_opt_f

4023: ben_epo_shd.g_api_dml := true; -- Set the api dml status
4024: --
4025: -- Update the ben_elig_per_opt_f Row
4026: --
4027: update ben_elig_per_opt_f
4028: set
4029: elig_per_opt_id = p_rec.elig_per_opt_id,
4030: elig_per_id = p_rec.elig_per_id,
4031: prtn_ovridn_flag = p_rec.prtn_ovridn_flag,

Line 4607: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;

4603: --
4604: -- Declare cursors and local variables
4605: --
4606: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4607: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4608: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4609: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4610: --
4611: begin

Line 4608: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;

4604: -- Declare cursors and local variables
4605: --
4606: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4607: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4608: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4609: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4610: --
4611: begin
4612: --

Line 4609: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;

4605: --
4606: l_proc varchar2(72) := g_package||'update_perf_Elig_Person_Option';
4607: l_object_version_number ben_elig_per_opt_f.object_version_number%TYPE;
4608: l_effective_start_date ben_elig_per_opt_f.effective_start_date%TYPE;
4609: l_effective_end_date ben_elig_per_opt_f.effective_end_date%TYPE;
4610: --
4611: begin
4612: --
4613: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 4984: from ben_elig_per_opt_f p

4980: --
4981: l_rows_processed number := 0 ;
4982: cursor csr_get_epo_ids is
4983: select distinct p.elig_per_opt_id
4984: from ben_elig_per_opt_f p
4985: where p.rowid
4986: between p_start_rowid and p_end_rowid
4987: and p.wait_perd_cmpltn_dt||'' is not null ;
4988: begin

Line 5002: update ben_elig_per_opt_f epo

4998: --
4999: l_rows_processed := l_rows_processed + t_epo_id.COUNT ;
5000: --
5001: forall i in t_epo_id.FIRST..t_epo_id.LAST
5002: update ben_elig_per_opt_f epo
5003: set wait_perd_cmpltn_date = fnd_date.string_to_date(wait_perd_cmpltn_dt,'DD-MON-RRRR')
5004: where epo.elig_per_opt_id = t_epo_id(i) ;
5005: --
5006: commit;