DBA Data[Home] [Help]

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.1.12010000.3 2008/08/29 11:04:03 pvelvano ship $ */
3: g_package varchar2(50) := 'ben_person_delete.';
4: PROCEDURE perform_ri_check (
5: p_person_id IN NUMBER

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

1: PACKAGE BODY ben_person_delete AS
2: /* $Header: bepedchk.pkb 120.1.12010000.3 2008/08/29 11:04:03 pvelvano ship $ */
3: g_package varchar2(50) := 'ben_person_delete.';
4: PROCEDURE perform_ri_check (
5: p_person_id IN NUMBER
6: ) IS
7: CURSOR c1 (

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

2980: p_person_id number ,
2981: p_effective_date date
2982: ) is
2983: --
2984: l_proc varchar2(200) := 'ben_person_delete.check_ben_rows_before_delete' ;
2985: /* Bug 7339987 : Modified c_pil,c_pen,c_prv,c_ecd,c_ecdpn,c_plbnf cursors to
2986: Allow Delete when UnRestricted LE is in STRTD state
2987: Do Not Allow Delete when Other types of LE is in STRTD state
2988: Do Not Allow Delete when Other types of LE is in PROCD state

Line 3220: END ben_person_delete;

3216: WHEN OTHERS THEN
3217: RAISE;
3218: END check_ben_rows_before_delete ;
3219: --
3220: END ben_person_delete;