15: -- Liang Xia 08/11/2003 Added Auto-Redirect Rule type
16: -- --------- ------ ------------------------------------------
17: G_PKG_NAME VARCHAR2(256) := 'IEM_EMAILPROC_PVT';
18: G_EMAILPROC_ID varchar2(30) ;
19: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
20:
21: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
22:
23: TYPE emailProc_rec is RECORD (
17: G_PKG_NAME VARCHAR2(256) := 'IEM_EMAILPROC_PVT';
18: G_EMAILPROC_ID varchar2(30) ;
19: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
20:
21: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
22:
23: TYPE emailProc_rec is RECORD (
24: emailProc_id number,
25: Name varchar2(256),