DBA Data[Home] [Help]

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.38.12010000.3 2008/08/28 04:02:40 vkodedal 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 2025: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,

2021: hr_utility.set_location('Entering'||l_proc, 5);
2022: end if;
2023: --
2024: open c_prmy_svc_area;
2025: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,
2026: ben_ext_person.g_prim_addr_service_area;
2027: close c_prmy_svc_area;
2028: --
2029: if g_debug then

Line 2026: ben_ext_person.g_prim_addr_service_area;

2022: end if;
2023: --
2024: open c_prmy_svc_area;
2025: fetch c_prmy_svc_area into ben_ext_person.g_prim_addr_sva_id,
2026: ben_ext_person.g_prim_addr_service_area;
2027: close c_prmy_svc_area;
2028: --
2029: if g_debug then
2030: hr_utility.set_location('Exiting'||l_proc, 15);

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

4204: END IF; -- l_include = 'Y'
4205: --
4206: -- updating ben_per_cm_prvdd_f.sent_dt
4207: --
4208: if (ben_ext_person.g_cm_flag = 'Y' and
4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4210: ben_ext_person.g_per_cm_prvdd_id is not null and
4211: g_detail_extracted) then
4212: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then

Line 4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and

4205: --
4206: -- updating ben_per_cm_prvdd_f.sent_dt
4207: --
4208: if (ben_ext_person.g_cm_flag = 'Y' and
4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4210: ben_ext_person.g_per_cm_prvdd_id is not null and
4211: g_detail_extracted) then
4212: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4213: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD

Line 4210: ben_ext_person.g_per_cm_prvdd_id is not null and

4206: -- updating ben_per_cm_prvdd_f.sent_dt
4207: --
4208: if (ben_ext_person.g_cm_flag = 'Y' and
4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4210: ben_ext_person.g_per_cm_prvdd_id is not null and
4211: g_detail_extracted) then
4212: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4213: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4214: (p_validate => null,

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

4208: if (ben_ext_person.g_cm_flag = 'Y' and
4209: ben_ext_person.g_upd_cm_sent_dt_flag = 'Y' and
4210: ben_ext_person.g_per_cm_prvdd_id is not null and
4211: g_detail_extracted) then
4212: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4213: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4214: (p_validate => null,
4215: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4216: p_effective_start_date=> l_dummy_start_date,

Line 4215: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,

4211: g_detail_extracted) then
4212: if nvl(l_last_per_cm_prvdd_id,-1) <> ben_ext_person.g_per_cm_prvdd_id then
4213: ben_PER_CM_PRVDD_api.update_PER_CM_PRVDD
4214: (p_validate => null,
4215: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4216: p_effective_start_date=> l_dummy_start_date,
4217: p_effective_end_date => l_dummy_end_date,
4218: p_sent_dt => trunc(sysdate),
4219: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,

Line 4219: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,

4215: p_per_cm_prvdd_id => ben_ext_person.g_per_cm_prvdd_id,
4216: p_effective_start_date=> l_dummy_start_date,
4217: p_effective_end_date => l_dummy_end_date,
4218: p_sent_dt => trunc(sysdate),
4219: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4220: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4221: p_datetrack_mode => 'CORRECTION');
4222: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4223: end if;

Line 4220: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,

4216: p_effective_start_date=> l_dummy_start_date,
4217: p_effective_end_date => l_dummy_end_date,
4218: p_sent_dt => trunc(sysdate),
4219: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4220: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4221: p_datetrack_mode => 'CORRECTION');
4222: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4223: end if;
4224: end if;

Line 4222: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;

4218: p_sent_dt => trunc(sysdate),
4219: p_object_version_number=>ben_ext_person.g_per_cm_object_version_number,
4220: p_effective_date => ben_ext_person.g_cm_prvdd_eff_dt,
4221: p_datetrack_mode => 'CORRECTION');
4222: l_last_per_cm_prvdd_id:=ben_ext_person.g_per_cm_prvdd_id;
4223: end if;
4224: end if;
4225:
4226: END LOOP;

Line 5563: END ben_ext_person;

5559: end if;
5560: --
5561: end write_error;
5562: --
5563: END ben_ext_person;