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_EXT_CHLG dependencies on BEN_EXT_CHLG

Line 1: package body ben_ext_chlg as

1: package body ben_ext_chlg as
2: /* $Header: benxchlg.pkb 120.14.12010000.3 2008/08/05 14:56:26 ubhat ship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 141: l_proc varchar2(80) := 'ben_ext_chlg.change_exists_in_db';

137: WHERE a.person_id = p_person_id
138: AND a.chg_evt_cd = p_chg_evt_cd
139: AND trunc(a.chg_eff_dt) = trunc(p_chg_eff_dt);
140: --
141: l_proc varchar2(80) := 'ben_ext_chlg.change_exists_in_db';
142: l_dummy varchar2(30);
143: l_return boolean;
144: --
145: begin

Line 174: l_proc varchar2(80) := 'ben_ext_chlg.change_exists_in_mem';

170: ,p_chg_evt_cd in varchar2
171: ,p_chg_eff_dt in date
172: ) return boolean is
173: --
174: l_proc varchar2(80) := 'ben_ext_chlg.change_exists_in_mem';
175: l_counter number := 0;
176: l_return boolean := FALSE;
177: --
178: begin

Line 211: l_proc varchar2(80) := 'ben_ext_chlg.change_event_is_enabled';

207: AND h.enabled_flag = 'Y'
208: AND p_effective_date between nvl(start_date_active,p_effective_date)
209: and nvl(end_date_active,p_effective_date);
210: --
211: l_proc varchar2(80) := 'ben_ext_chlg.change_event_is_enabled';
212: l_dummy varchar2(30);
213: l_return boolean;
214: --
215: begin

Line 247: l_old_rec ben_ext_chlg.g_per_rec_type;

243: ,p_new_rec in per_per_shd.g_rec_type
244: -- ,p_mode in varchar2
245: )is
246:
247: l_old_rec ben_ext_chlg.g_per_rec_type;
248: l_new_rec ben_ext_chlg.g_per_rec_type;
249: l_event varchar2(10) ;
250: --
251: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';

Line 248: l_new_rec ben_ext_chlg.g_per_rec_type;

244: -- ,p_mode in varchar2
245: )is
246:
247: l_old_rec ben_ext_chlg.g_per_rec_type;
248: l_new_rec ben_ext_chlg.g_per_rec_type;
249: l_event varchar2(10) ;
250: --
251: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
252: begin

Line 251: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';

247: l_old_rec ben_ext_chlg.g_per_rec_type;
248: l_new_rec ben_ext_chlg.g_per_rec_type;
249: l_event varchar2(10) ;
250: --
251: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
252: begin
253:
254: hr_utility.set_location('Entering:'|| l_proc, 05);
255:

Line 514: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';

510: l_relationship per_all_people_f.person_id%type;
511: l_contact per_contact_relationships.contact_relationship_id%type;
512: l_person_type per_person_types.system_person_type%type ;
513: --
514: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
515: --
516: begin
517: --
518: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1816: l_proc varchar2(100) := 'ben_ext_chlg.log_cont_chg';

1812: p_old_rec in g_cont_rec_type
1813: ,p_new_rec in g_cont_rec_type
1814: ) is
1815: --
1816: l_proc varchar2(100) := 'ben_ext_chlg.log_cont_chg';
1817: l_tab_counter binary_integer := 0;
1818: l_old_contact_type varchar2(100) ;
1819: l_new_contact_type varchar2(100) ;
1820: l_person_type per_person_types.system_person_type%type;

Line 1986: l_proc varchar2(100) := 'ben_ext_chlg.log_add_chg';

1982: ,p_old_rec in g_add_rec_type
1983: ,p_new_rec in g_add_rec_type
1984: ) is
1985: --
1986: l_proc varchar2(100) := 'ben_ext_chlg.log_add_chg';
1987: --
1988: l_chg_evt_tab g_char_tab_type;
1989: l_chg_eff_tab g_date_tab_type;
1990: l_prmtr_01_tab g_char_tab_type;

Line 3150: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';

3146: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3147: l_old_grade_name per_grades.name%type;
3148: l_new_grade_name per_grades.name%type;
3149: --
3150: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';
3151: --
3152: begin
3153: --
3154: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3603: l_proc varchar2(80) := 'ben_ext_chlg.log_abs_chg';

3599: l_new_absence_type varchar2(100);
3600: l_old_absence_reason varchar2(100);
3601: l_new_absence_reason varchar2(100);
3602: --
3603: l_proc varchar2(80) := 'ben_ext_chlg.log_abs_chg';
3604: --
3605: -- cursor definitions
3606: --
3607: cursor c_absence_type(p_absence_attendance_type_id number)

Line 3843: l_proc varchar2(72) := 'ben_ext_chlg.log_benefit_chg';

3839: p_effective_date in date ) is
3840:
3841: -- Local variable declarations
3842: --
3843: l_proc varchar2(72) := 'ben_ext_chlg.log_benefit_chg';
3844:
3845: l_new_plan_name ben_pl_f.name%type;
3846: l_old_plan_name ben_pl_f.name%type;
3847: l_new_option_name ben_opt_f.name%type;

Line 4515: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';

4511: p_effective_date in date) is
4512:
4513: -- Local variable declarations
4514: --
4515: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4516:
4517: l_plan_name ben_pl_f.name%type;
4518: l_option_name ben_opt_f.name%type;
4519: l_dpnt_full_name per_all_people_f.full_name%type;

Line 4811: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';

4807: p_effective_date in date) is
4808: --
4809: -- Local variable declarations
4810: --
4811: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4812: l_relationship per_all_people_f.person_id%type;
4813: l_contact per_contact_relationships.contact_relationship_id%type;
4814: l_name per_all_people_f.full_name%type;
4815: --

Line 5204: l_proc varchar2(72) := 'ben_ext_chlg.log_pos_chg';

5200: l_count number;
5201: l_ext_chg_evt_log_id number;
5202: l_object_version_number number;
5203: --
5204: l_proc varchar2(72) := 'ben_ext_chlg.log_pos_chg';
5205: --
5206: begin
5207: --
5208: hr_utility.set_location('Entering:'||l_proc, 10);

Line 5380: l_proc varchar2(72) := 'ben_ext_chlg.log_apl_chg';

5376: l_count number;
5377: l_ext_chg_evt_log_id number;
5378: l_object_version_number number;
5379: --
5380: l_proc varchar2(72) := 'ben_ext_chlg.log_apl_chg';
5381: --
5382: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5383: is
5384: select hl.meaning

Line 5423: l_proc varchar2(72) := 'ben_ext_chlg.log_prem_mo_chg';

5419: ben_prtt_prem_f ppe
5420: where ppe.prtt_prem_id = p_prtt_prem_id
5421: and ppe.per_in_ler_id = pil.per_in_ler_id ;
5422: --
5423: l_proc varchar2(72) := 'ben_ext_chlg.log_prem_mo_chg';
5424: Begin
5425: hr_utility.set_location('Entering:'||l_proc, 10);
5426: open c_person(p_new_rec.prtt_prem_id) ;
5427: fetch c_person into l_person_id ;

Line 5486: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';

5482: select name from PER_ESTABLISHMENTS
5483: where establishment_id = p_establishment_id ;
5484:
5485: --
5486: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';
5487: Begin
5488: hr_utility.set_location('Entering:'||l_proc, 10);
5489: open c_name(p_old_rec.establishment_id) ;
5490: fetch c_name into l_old_name ;

Line 5538: l_proc varchar2(72) := 'ben_ext_chlg.log_per_pay_chg';

5534: l_count number;
5535: l_ext_chg_evt_log_id number;
5536: l_object_version_number number;
5537: --
5538: l_proc varchar2(72) := 'ben_ext_chlg.log_per_pay_chg';
5539: cursor c_person (p_assignment_id number)
5540: is
5541: select person_id ,business_group_id
5542: from per_all_Assignments_f asg

Line 5656: l_proc varchar2(72) := 'ben_ext_chlg.log_phn_chg';

5652: l_count number := 0;
5653: l_ext_chg_evt_log_id number;
5654: l_object_version_number number;
5655: --
5656: l_proc varchar2(72) := 'ben_ext_chlg.log_phn_chg';
5657: --
5658: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5659: is
5660: select meaning

Line 5916: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';

5912: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;
5913: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;
5914: -- Bug 4705814.
5915: --
5916: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';
5917: --
5918: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
5919: is
5920: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id

Line 6014: l_proc varchar2(72) := 'ben_ext_chlg.log_element_chg';

6010: p_effective_end_date in date default null,
6011: p_business_group_id in number,
6012: p_effective_date in date) is
6013: --
6014: l_proc varchar2(72) := 'ben_ext_chlg.log_element_chg';
6015: --
6016: l_object_version_number number;
6017: l_ext_chg_evt_log_id number;
6018: --

Line 6147: l_proc varchar2(100) := 'ben_ext_chlg.log_per_dis_chg';

6143: where hl.lookup_type = p_lookup_type
6144: and hl.lookup_code = p_lookup_code;
6145:
6146: --
6147: l_proc varchar2(100) := 'ben_ext_chlg.log_per_dis_chg';
6148: --
6149:
6150: --
6151: l_old_categoryname hr_lookups.meaning%type;

Line 7044: end ben_ext_chlg;

7040: hr_utility.set_location('Exiting:'|| l_proc, 99);
7041: --
7042: end log_per_dis_chg;
7043: --
7044: end ben_ext_chlg;