APPS.BEN_CWB_PERSON_INFO_API dependencies on BEN_CWB_PERSON_INFO

Line 1: Package Body BEN_CWB_PERSON_INFO_API as

1: Package Body BEN_CWB_PERSON_INFO_API as
2: /* $Header: becpiapi.pkb 120.1 2005/06/29 04:25:24 steotia noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' BEN_CWB_PERSON_INFO_API.';

2: /* $Header: becpiapi.pkb 120.1 2005/06/29 04:25:24 steotia noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PERSON_INFO_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- ----------------------------------------------------------------------------

Line 25: (p_info_old ben_cwb_person_info%rowtype

21: -- CF1-30 Update CPI Flex 1-30
22: -- CU1-20 Update Custom Segment 1-20
23: --
24: procedure create_audit_record
25: (p_info_old ben_cwb_person_info%rowtype
26: ) is
27:
28: l_info_new ben_cwb_person_info%rowtype;
29: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;

Line 28: l_info_new ben_cwb_person_info%rowtype;

24: procedure create_audit_record
25: (p_info_old ben_cwb_person_info%rowtype
26: ) is
27:
28: l_info_new ben_cwb_person_info%rowtype;
29: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
30: l_object_version_number ben_cwb_audit.object_version_number%type;
31: l_cd_meaning_old hr_lookups.meaning%type;
32: l_cd_meaning_new hr_lookups.meaning%type;

Line 42: from ben_cwb_person_info

38:
39: begin
40:
41: select * into l_info_new
42: from ben_cwb_person_info
43: where group_per_in_ler_id = p_info_old.group_per_in_ler_id;
44:
45: select group_pl_id,lf_evt_ocrd_dt
46: into l_group_pl_id, l_lf_evt_ocrd_dt

Line 1395: ben_cwb_person_info_bk1.create_person_info_b

1391: --
1392: -- Call Before Process User Hook
1393: --
1394: begin
1395: ben_cwb_person_info_bk1.create_person_info_b
1396: (p_group_per_in_ler_id => p_group_per_in_ler_id
1397: ,p_assignment_id => p_assignment_id
1398: ,p_person_id => p_person_id
1399: ,p_supervisor_id => p_supervisor_id

Line 1721: ben_cwb_person_info_bk1.create_person_info_a

1717: -- Call After Process User Hook
1718: --
1719: --
1720: begin
1721: ben_cwb_person_info_bk1.create_person_info_a
1722: (p_group_per_in_ler_id => p_group_per_in_ler_id
1723: ,p_assignment_id => p_assignment_id
1724: ,p_person_id => p_person_id
1725: ,p_supervisor_id => p_supervisor_id

Line 2084: l_old_record ben_cwb_person_info%rowtype;

2080: --
2081: l_object_version_number number;
2082: --
2083: l_proc varchar2(72) := g_package||'update_person_info';
2084: l_old_record ben_cwb_person_info%rowtype;
2085: begin
2086: -- get old record
2087:
2088: select * into l_old_record

Line 2089: from ben_cwb_person_info

2085: begin
2086: -- get old record
2087:
2088: select * into l_old_record
2089: from ben_cwb_person_info
2090: where group_per_in_ler_id = p_group_per_in_ler_id;
2091:
2092: if g_debug then
2093: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2107: ben_cwb_person_info_bk2.update_person_info_b

2103: --
2104: -- Call Before Process User Hook
2105: --
2106: begin
2107: ben_cwb_person_info_bk2.update_person_info_b
2108: (p_group_per_in_ler_id => p_group_per_in_ler_id
2109: ,p_assignment_id => p_assignment_id
2110: ,p_person_id => p_person_id
2111: ,p_supervisor_id => p_supervisor_id

Line 2434: ben_cwb_person_info_bk2.update_person_info_a

2430: -- Call After Process User Hook
2431: --
2432: --
2433: begin
2434: ben_cwb_person_info_bk2.update_person_info_a
2435: (p_group_per_in_ler_id => p_group_per_in_ler_id
2436: ,p_assignment_id => p_assignment_id
2437: ,p_person_id => p_person_id
2438: ,p_supervisor_id => p_supervisor_id

Line 2664: ben_cwb_person_info_bk3.delete_person_info_b

2660: --
2661: -- Call Before Process User Hook
2662: --
2663: begin
2664: ben_cwb_person_info_bk3.delete_person_info_b
2665: (p_group_per_in_ler_id => p_group_per_in_ler_id
2666: ,p_object_version_number => p_object_version_number
2667: );
2668: exception

Line 2691: ben_cwb_person_info_bk3.delete_person_info_a

2687: -- Call After Process User Hook
2688: --
2689: --
2690: begin
2691: ben_cwb_person_info_bk3.delete_person_info_a
2692: (p_group_per_in_ler_id => p_group_per_in_ler_id
2693: ,p_object_version_number => p_object_version_number
2694: );
2695: exception

Line 2752: end ben_cwb_person_info_api;

2748: end if;
2749: raise;
2750: end delete_person_info;
2751: --
2752: end ben_cwb_person_info_api;