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 1192: from ben_cwb_person_info inf

1188: --
1189: cursor c_broke_hier (cv_group_pl_id in number,
1190: cv_ocrd_date in date) is
1191: select inf.full_name, inf.person_id
1192: from ben_cwb_person_info inf
1193: ,ben_per_in_ler pil
1194: where pil.group_pl_id = cv_group_pl_id
1195: and pil.lf_evt_ocrd_dt = cv_ocrd_date
1196: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')

Line 1682: from ben_cwb_person_info

1678: --***************audit changes***************--
1679: --
1680: cursor c_cwb_person_info is
1681: select object_version_number
1682: from ben_cwb_person_info
1683: where group_per_in_ler_id = p_per_in_ler_id;
1684:
1685: --
1686: l_proc varchar2(50) := g_package||'.cwb_delete_routine';

Line 1833: elsif p_routine = 'BEN_CWB_PERSON_INFO' then

1829: --
1830: end loop;
1831: close c_cwb_person_rates;
1832:
1833: elsif p_routine = 'BEN_CWB_PERSON_INFO' then
1834:
1835: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'
1836: || l_proc, 500);
1837:

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

1831: close c_cwb_person_rates;
1832:
1833: elsif p_routine = 'BEN_CWB_PERSON_INFO' then
1834:
1835: hr_utility.set_location( 'in audit changes BEN_CWB_PERSON_INFO'
1836: || l_proc, 500);
1837:
1838: open c_cwb_person_info;
1839: loop

Line 1843: BEN_CWB_PERSON_INFO_API.delete_person_info

1839: loop
1840: fetch c_cwb_person_info into l_object_version_number;
1841: exit when c_cwb_person_info%NOTFOUND ;
1842:
1843: BEN_CWB_PERSON_INFO_API.delete_person_info
1844: ( p_validate => false,
1845: p_group_per_in_ler_id => p_per_in_ler_id,
1846: p_object_version_number => l_object_version_number
1847: );

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

1847: );
1848:
1849: end loop;
1850: close c_cwb_person_info;
1851: hr_utility.set_location( 'LEAVING audit changes BEN_CWB_PERSON_INFO'
1852: || l_proc, 600);
1853:
1854: end if;
1855: hr_utility.set_location( 'Leaving '||l_proc, 50);

Line 1896: p_object_version_number ben_cwb_person_info.object_version_number%type;

1892: ,p_update_summary in boolean default false
1893: ) is
1894:
1895: l_proc varchar2(50) := g_package||'.delete_cwb_data';
1896: p_object_version_number ben_cwb_person_info.object_version_number%type;
1897: begin
1898:
1899: hr_utility.set_location( 'Entering '||l_proc, 5);
1900:

Line 1931: --4. BEN_CWB_PERSON_INFO

1927: ,p_per_in_ler_id => p_per_in_ler_id
1928: ,p_update_summary => p_update_summary
1929: );
1930:
1931: --4. BEN_CWB_PERSON_INFO
1932: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
1933: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1934: fnd_message.set_token('PROC','delete_person_info');
1935: cwb_delete_routine

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

1928: ,p_update_summary => p_update_summary
1929: );
1930:
1931: --4. BEN_CWB_PERSON_INFO
1932: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
1933: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1934: fnd_message.set_token('PROC','delete_person_info');
1935: cwb_delete_routine
1936: (p_routine => 'BEN_CWB_PERSON_INFO'

Line 1936: (p_routine => 'BEN_CWB_PERSON_INFO'

1932: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
1933: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1934: fnd_message.set_token('PROC','delete_person_info');
1935: cwb_delete_routine
1936: (p_routine => 'BEN_CWB_PERSON_INFO'
1937: ,p_per_in_ler_id => p_per_in_ler_id
1938: ,p_update_summary => p_update_summary
1939: );
1940: --************************************************************ --