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.18 2011/02/09 07:09:06 vkodedal noship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

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

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

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

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

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

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

Line 248: l_old_rec ben_ext_chlg.g_per_rec_type;

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

Line 249: l_new_rec ben_ext_chlg.g_per_rec_type;

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

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

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

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

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

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

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

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

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

Line 3070: l_old_rec ben_ext_chlg.g_asg_rec_type;

3066: ,p_old_rec in per_asg_shd.g_rec_type
3067: ,p_new_rec in per_asg_shd.g_rec_type
3068: ) is
3069:
3070: l_old_rec ben_ext_chlg.g_asg_rec_type;
3071: l_new_rec ben_ext_chlg.g_asg_rec_type;
3072: l_event varchar2(10) ;
3073: --
3074: l_proc varchar2(100) := 'ben_ext_chlg.log_asg_chg';

Line 3071: l_new_rec ben_ext_chlg.g_asg_rec_type;

3067: ,p_new_rec in per_asg_shd.g_rec_type
3068: ) is
3069:
3070: l_old_rec ben_ext_chlg.g_asg_rec_type;
3071: l_new_rec ben_ext_chlg.g_asg_rec_type;
3072: l_event varchar2(10) ;
3073: --
3074: l_proc varchar2(100) := 'ben_ext_chlg.log_asg_chg';
3075: begin

Line 3074: l_proc varchar2(100) := 'ben_ext_chlg.log_asg_chg';

3070: l_old_rec ben_ext_chlg.g_asg_rec_type;
3071: l_new_rec ben_ext_chlg.g_asg_rec_type;
3072: l_event varchar2(10) ;
3073: --
3074: l_proc varchar2(100) := 'ben_ext_chlg.log_asg_chg';
3075: begin
3076:
3077: hr_utility.set_location('Entering:'|| l_proc, 05);
3078: -------------

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

3240: l_new_payroll_name pay_all_payrolls_f.payroll_name%type; --UTF Change Bug 2254683
3241: l_old_grade_name per_grades.name%type;
3242: l_new_grade_name per_grades.name%type;
3243: --
3244: l_proc varchar2(80) := 'ben_ext_chlg.log_asg_chg';
3245: --
3246: begin
3247: --
3248: hr_utility.set_location('Entering:'|| l_proc, 10);

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

3695: l_new_absence_type varchar2(100);
3696: l_old_absence_reason varchar2(100);
3697: l_new_absence_reason varchar2(100);
3698: --
3699: l_proc varchar2(80) := 'ben_ext_chlg.log_abs_chg';
3700: --
3701: -- cursor definitions
3702: --
3703: cursor c_absence_type(p_absence_attendance_type_id number)

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

3935: p_effective_date in date ) is
3936:
3937: -- Local variable declarations
3938: --
3939: l_proc varchar2(72) := 'ben_ext_chlg.log_benefit_chg';
3940:
3941: l_new_plan_name ben_pl_f.name%type;
3942: l_old_plan_name ben_pl_f.name%type;
3943: l_new_option_name ben_opt_f.name%type;

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

4607: p_effective_date in date) is
4608:
4609: -- Local variable declarations
4610: --
4611: l_proc varchar2(72) := 'ben_ext_chlg.log_dependent_chg';
4612:
4613: l_plan_name ben_pl_f.name%type;
4614: l_option_name ben_opt_f.name%type;
4615: l_dpnt_full_name per_all_people_f.full_name%type;

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

4903: p_effective_date in date) is
4904: --
4905: -- Local variable declarations
4906: --
4907: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4908: l_relationship per_all_people_f.person_id%type;
4909: l_contact per_contact_relationships.contact_relationship_id%type;
4910: l_name per_all_people_f.full_name%type;
4911: --

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

5296: l_count number;
5297: l_ext_chg_evt_log_id number;
5298: l_object_version_number number;
5299: --
5300: l_proc varchar2(72) := 'ben_ext_chlg.log_pos_chg';
5301: --
5302: begin
5303: --
5304: hr_utility.set_location('Entering:'||l_proc, 10);

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

5472: l_count number;
5473: l_ext_chg_evt_log_id number;
5474: l_object_version_number number;
5475: --
5476: l_proc varchar2(72) := 'ben_ext_chlg.log_apl_chg';
5477: --
5478: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5479: is
5480: select hl.meaning

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

5515: ben_prtt_prem_f ppe
5516: where ppe.prtt_prem_id = p_prtt_prem_id
5517: and ppe.per_in_ler_id = pil.per_in_ler_id ;
5518: --
5519: l_proc varchar2(72) := 'ben_ext_chlg.log_prem_mo_chg';
5520: Begin
5521: hr_utility.set_location('Entering:'||l_proc, 10);
5522: open c_person(p_new_rec.prtt_prem_id) ;
5523: fetch c_person into l_person_id ;

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

5578: select name from PER_ESTABLISHMENTS
5579: where establishment_id = p_establishment_id ;
5580:
5581: --
5582: l_proc varchar2(72) := 'ben_ext_chlg.log_school_chg';
5583: Begin
5584: hr_utility.set_location('Entering:'||l_proc, 10);
5585: open c_name(p_old_rec.establishment_id) ;
5586: fetch c_name into l_old_name ;

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

5630: l_count number;
5631: l_ext_chg_evt_log_id number;
5632: l_object_version_number number;
5633: --
5634: l_proc varchar2(72) := 'ben_ext_chlg.log_per_pay_chg';
5635: cursor c_person (p_assignment_id number)
5636: is
5637: select person_id ,business_group_id
5638: from per_all_Assignments_f asg

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

5748: l_count number := 0;
5749: l_ext_chg_evt_log_id number;
5750: l_object_version_number number;
5751: --
5752: l_proc varchar2(72) := 'ben_ext_chlg.log_phn_chg';
5753: --
5754: cursor c_termination_reason (p_termination_reason per_applications.termination_reason%type)
5755: is
5756: select meaning

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

6008: l_old_person_typ ben_ext_chg_evt_log.old_val1%TYPE;
6009: l_new_user_person_type ben_ext_chg_evt_log.new_val1%TYPE;
6010: -- Bug 4705814.
6011: --
6012: l_proc varchar2(72) := 'ben_ext_chlg.log_ptu_chg';
6013: --
6014: cursor c_person_type(p_person_type_id per_person_types.person_type_id%type)
6015: is
6016: select ppt.system_person_type, ppt.user_person_type, ppt.business_group_id

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

6106: p_effective_end_date in date default null,
6107: p_business_group_id in number,
6108: p_effective_date in date) is
6109: --
6110: l_proc varchar2(72) := 'ben_ext_chlg.log_element_chg';
6111: --
6112: l_object_version_number number;
6113: l_ext_chg_evt_log_id number;
6114: --

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

6239: where hl.lookup_type = p_lookup_type
6240: and hl.lookup_code = p_lookup_code;
6241:
6242: --
6243: l_proc varchar2(100) := 'ben_ext_chlg.log_per_dis_chg';
6244: --
6245:
6246: --
6247: l_old_categoryname hr_lookups.meaning%type;

Line 7140: end ben_ext_chlg;

7136: hr_utility.set_location('Exiting:'|| l_proc, 99);
7137: --
7138: end log_per_dis_chg;
7139: --
7140: end ben_ext_chlg;