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_PERSON dependencies on BEN_EXT_PERSON

Line 1: Package Body ben_ext_person as

1: Package Body ben_ext_person as
2: /* $Header: benxpers.pkb 120.47 2011/11/03 19:46:07 pvelvano ship $ */
3: -- ----------------------------------------------------------------------------
4: -- | Private Global Definitions |
5: -- ----------------------------------------------------------------------------

Line 8: g_package varchar2(33) := ' ben_ext_person.'; -- Global package name

4: -- | Private Global Definitions |
5: -- ----------------------------------------------------------------------------
6: --
7: --
8: g_package varchar2(33) := ' ben_ext_person.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10:
11: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12: TYPE t_varchar2_30 IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 688: ben_ext_person.g_business_group_id := l_business_group_id ;

684: end if ;
685:
686:
687: if g_ext_global_flag = 'Y' then
688: ben_ext_person.g_business_group_id := l_business_group_id ;
689: ben_extract.g_business_group_name := l_business_group_name ;
690: end if ;
691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;
692:

Line 691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;

687: if g_ext_global_flag = 'Y' then
688: ben_ext_person.g_business_group_id := l_business_group_id ;
689: ben_extract.g_business_group_name := l_business_group_name ;
690: end if ;
691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;
692:
693: ---initalize the assignment_id as soon the person information avaialble
694: init_assignment_id(p_person_id =>p_person_id ,
695: p_effective_date =>p_effective_date );

Line 1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided

1413: if g_debug then
1414: hr_utility.set_location('entering to open flex credit ' ,160);
1415: end if;
1416: open flex_cred_info_c;
1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -

Line 1418: ,ben_ext_person.g_flex_credit_forfited

1414: hr_utility.set_location('entering to open flex credit ' ,160);
1415: end if;
1416: open flex_cred_info_c;
1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -

Line 1419: ,ben_ext_person.g_flex_credit_used;

1415: end if;
1416: open flex_cred_info_c;
1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);

Line 1420: ben_ext_person.g_flex_credit_excess :=

1416: open flex_cred_info_c;
1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;

Line 1421: nvl(ben_ext_person.g_flex_credit_provided,0) -

1417: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then

Line 1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -

1418: ,ben_ext_person.g_flex_credit_forfited
1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);

Line 1423: nvl(ben_ext_person.g_flex_credit_used,0);

1419: ,ben_ext_person.g_flex_credit_used;
1420: ben_ext_person.g_flex_credit_excess :=
1421: nvl(ben_ext_person.g_flex_credit_provided,0) -
1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);

Line 1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);

1422: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);
1428: hr_utility.set_location('Exiting'||l_proc, 15);
1429: end if;
1430:

Line 1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);

1423: nvl(ben_ext_person.g_flex_credit_used,0);
1424: close flex_cred_info_c;
1425: if g_debug then
1426: hr_utility.set_location('provided amount '|| ben_ext_person.g_flex_credit_provided ,160);
1427: hr_utility.set_location('used amount '|| ben_ext_person.g_flex_credit_used ,160);
1428: hr_utility.set_location('Exiting'||l_proc, 15);
1429: end if;
1430:
1431: end get_person_flex_credit;

Line 2059: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,

2055: hr_utility.set_location('Entering'||l_proc, 5);
2056: end if;
2057: --
2058: open c_prmy_svc_area;
2059: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,
2060: ben_ext_person.g_prim_addr_service_area;
2061: close c_prmy_svc_area;
2062: --
2063: if g_debug then

Line 2060: ben_ext_person.g_prim_addr_service_area;

2056: end if;
2057: --
2058: open c_prmy_svc_area;
2059: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,
2060: ben_ext_person.g_prim_addr_service_area;
2061: close c_prmy_svc_area;
2062: --
2063: if g_debug then
2064: hr_utility.set_location('Exiting'||l_proc, 15);

Line 4243: if (ben_ext_person.g_cm_flag = 'Y' and

4239: END IF; -- l_include = 'Y'
4240: --
4241: -- updating ben_per_cm_prvdd_f.sent_dt
4242: --
4243: if (ben_ext_person.g_cm_flag = 'Y' and
4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4245: ben_ext_person.g_per_cm_prvdd_id is not null and
4246: g_detail_extracted) then
4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then

Line 4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and

4240: --
4241: -- updating ben_per_cm_prvdd_f.sent_dt
4242: --
4243: if (ben_ext_person.g_cm_flag = 'Y' and
4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4245: ben_ext_person.g_per_cm_prvdd_id is not null and
4246: g_detail_extracted) then
4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4248: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD

Line 4245: ben_ext_person.g_per_cm_prvdd_id is not null and

4241: -- updating ben_per_cm_prvdd_f.sent_dt
4242: --
4243: if (ben_ext_person.g_cm_flag = 'Y' and
4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4245: ben_ext_person.g_per_cm_prvdd_id is not null and
4246: g_detail_extracted) then
4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4248: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4249: (p_validate => null,

Line 4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then

4243: if (ben_ext_person.g_cm_flag = 'Y' and
4244: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4245: ben_ext_person.g_per_cm_prvdd_id is not null and
4246: g_detail_extracted) then
4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4248: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4249: (p_validate => null,
4250: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4251: p_effective_start_date=> l_dummy_start_date,

Line 4250: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,

4246: g_detail_extracted) then
4247: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4248: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4249: (p_validate => null,
4250: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4251: p_effective_start_date=> l_dummy_start_date,
4252: p_effective_end_date => l_dummy_end_date,
4253: p_sent_dt => trunc(sysdate),
4254: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,

Line 4254: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,

4250: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4251: p_effective_start_date=> l_dummy_start_date,
4252: p_effective_end_date => l_dummy_end_date,
4253: p_sent_dt => trunc(sysdate),
4254: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4255: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4256: p_datetrack_mode => 'CORRECTION');
4257: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4258: end if;

Line 4255: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,

4251: p_effective_start_date=> l_dummy_start_date,
4252: p_effective_end_date => l_dummy_end_date,
4253: p_sent_dt => trunc(sysdate),
4254: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4255: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4256: p_datetrack_mode => 'CORRECTION');
4257: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4258: end if;
4259: end if;

Line 4257: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;

4253: p_sent_dt => trunc(sysdate),
4254: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4255: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4256: p_datetrack_mode => 'CORRECTION');
4257: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4258: end if;
4259: end if;
4260:
4261: END LOOP;

Line 5600: END ben_ext_person;

5596: end if;
5597: --
5598: end write_error;
5599: --
5600: END ben_ext_person;