APPS.BEN_PERSON_DELETE dependencies on BEN_PERSON_DELETE

Line 1: PACKAGE BODY ben_person_delete AS

1: PACKAGE BODY ben_person_delete AS
2: /* $Header: bepedchk.pkb 120.4.12020000.5 2013/02/25 06:41:39 amnaraya ship $ */
3: g_package varchar2(50) := 'ben_person_delete.';
4:
5: /* Bug 13067080; Procedure added to delete person related CWB table records */

Line 3: g_package varchar2(50) := 'ben_person_delete.';

1: PACKAGE BODY ben_person_delete AS
2: /* $Header: bepedchk.pkb 120.4.12020000.5 2013/02/25 06:41:39 amnaraya ship $ */
3: g_package varchar2(50) := 'ben_person_delete.';
4:
5: /* Bug 13067080; Procedure added to delete person related CWB table records */
6: PROCEDURE delete_missing_cwb_tables (
7: p_person_id NUMBER

Line 3122: l_proc varchar2(200) := 'ben_person_delete.check_ben_rows_before_delete' ;

3118: p_person_id number ,
3119: p_effective_date date
3120: ) is
3121: --
3122: l_proc varchar2(200) := 'ben_person_delete.check_ben_rows_before_delete' ;
3123: /* Bug 7339987 : Modified c_pil,c_pen,c_prv,c_ecd,c_ecdpn,c_plbnf cursors to
3124: Allow Delete when UnRestricted LE is in STRTD state
3125: Do Not Allow Delete when Other types of LE is in STRTD state
3126: Do Not Allow Delete when Other types of LE is in PROCD state

Line 3571: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);

3567: );
3568: end loop;
3569: ben_batch_utils.write(p_text => ' Done deleting element entries');
3570: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3571: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3573: end if;
3574: else
3575: close c_chk_ele_entries;

Line 3577: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);

3573: end if;
3574: else
3575: close c_chk_ele_entries;
3576: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3577: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3578: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3579: end if;
3580: else
3581: close c_get_pil;

Line 3620: END ben_person_delete;

3616: fnd_message.raise_error;
3617: end delete_unrestricted_le_enrts;
3618:
3619: --
3620: END ben_person_delete;