APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_CWB_PERSON_INFO

Line 28: BEN_CWB_PERSON_INFO,

24: clause for person rates cursor.
25: 25-Mar-04 rpgupta 115.7 Changed logic for person selection to work like
26: participation process.
27: 26-Mar-04 pbodla 115.8 Added code to delete
28: BEN_CWB_PERSON_INFO,
29: BEN_CWB_SUMMARY,
30: ben_cwb_pl_dsgn
31: 26-Mar-04 pbodla 115.9 l_ocrd_date need to be passed to
32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn

Line 39: 01-Feb-2005 steotia 115.16 cwb_delete_routine and ben_cwb_person_info API

35: ocrd date. Sometimes when one thread of benmngle
36: fails, theres a possibility that a few records in
37: person_rates exist with group_per_in_ler_id as -1
38: 27-Apr-04 rpgupta 115.14/15 Added online backout procedure/trace calls.
39: 01-Feb-2005 steotia 115.16 cwb_delete_routine and ben_cwb_person_info API
40: used to delete person_info record
41: 11-Feb-2005 pbodla 115.17 Bug 4021004 : when group per in ler
42: is backed out it is not backing out the
43: heirarchy data and not resetting

Line 1271: from ben_cwb_person_info inf

1267: --
1268: cursor c_broke_hier (cv_group_pl_id in number,
1269: cv_ocrd_date in date) is
1270: select inf.full_name, inf.person_id
1271: from ben_cwb_person_info inf
1272: ,ben_per_in_ler pil
1273: where pil.group_pl_id = cv_group_pl_id
1274: and pil.lf_evt_ocrd_dt = cv_ocrd_date
1275: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')

Line 1775: from ben_cwb_person_info

1771: --***************audit changes***************--
1772: --
1773: cursor c_cwb_person_info is
1774: select object_version_number
1775: from ben_cwb_person_info
1776: where group_per_in_ler_id = p_per_in_ler_id;
1777:
1778: --
1779: l_proc varchar2(50) := g_package||'.cwb_delete_routine';

Line 1927: elsif p_routine = 'BEN_CWB_PERSON_INFO' then

1923: --
1924: end loop;
1925: close c_cwb_person_rates;
1926:
1927: elsif p_routine = 'BEN_CWB_PERSON_INFO' then
1928:
1929: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'
1930: || l_proc, 500);
1931:

Line 1929: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'

1925: close c_cwb_person_rates;
1926:
1927: elsif p_routine = 'BEN_CWB_PERSON_INFO' then
1928:
1929: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'
1930: || l_proc, 500);
1931:
1932: open c_cwb_person_info;
1933: loop

Line 1937: BEN_CWB_PERSON_INFO_API.delete_person_info

1933: loop
1934: fetch c_cwb_person_info into l_object_version_number;
1935: exit when c_cwb_person_info%NOTFOUND ;
1936:
1937: BEN_CWB_PERSON_INFO_API.delete_person_info
1938: ( p_validate => false,
1939: p_group_per_in_ler_id => p_per_in_ler_id,
1940: p_object_version_number => l_object_version_number
1941: );

Line 1945: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'

1941: );
1942:
1943: end loop;
1944: close c_cwb_person_info;
1945: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'
1946: || l_proc, 600);
1947:
1948: end if;
1949: hr_utility.set_location( 'Leaving '||l_proc, 50);

Line 1990: p_object_version_number ben_cwb_person_info.object_version_number%type;

1986: ,p_update_summary in boolean default false
1987: ) is
1988:
1989: l_proc varchar2(50) := g_package||'.delete_cwb_data';
1990: p_object_version_number ben_cwb_person_info.object_version_number%type;
1991: begin
1992:
1993: hr_utility.set_location( 'Entering '||l_proc, 5);
1994:

Line 2025: --4. BEN_CWB_PERSON_INFO

2021: ,p_per_in_ler_id => p_per_in_ler_id
2022: ,p_update_summary => p_update_summary
2023: );
2024:
2025: --4. BEN_CWB_PERSON_INFO
2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine

Line 2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);

2022: ,p_update_summary => p_update_summary
2023: );
2024:
2025: --4. BEN_CWB_PERSON_INFO
2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine
2030: (p_routine => 'BEN_CWB_PERSON_INFO'

Line 2030: (p_routine => 'BEN_CWB_PERSON_INFO'

2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine
2030: (p_routine => 'BEN_CWB_PERSON_INFO'
2031: ,p_per_in_ler_id => p_per_in_ler_id
2032: ,p_update_summary => p_update_summary
2033: );
2034: --************************************************************ --