APPS.IEM_ROUTE_CLASS_PVT dependencies on FND_PROFILE

Line 34: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

30: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_CLASS_PVT ';
31:
32: G_CLASS_ID varchar2(30) ;
33:
34: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
35:
36: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
37:
38: TYPE t_AcctIdTable is TABLE of iem_account_route_class.email_account_id%TYPE INDEX BY BINARY_INTEGER;

Line 36: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;

32: G_CLASS_ID varchar2(30) ;
33:
34: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
35:
36: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
37:
38: TYPE t_AcctIdTable is TABLE of iem_account_route_class.email_account_id%TYPE INDEX BY BINARY_INTEGER;
39:
40:

Line 337: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

333: l_class_id IEM_ROUTE_CLASSIFICATIONS.ROUTE_CLASSIFICATION_ID%TYPE;
334: l_class_rule_id IEM_ROUTE_CLASS_RULES.ROUTE_CLASS_RULE_ID%TYPE;
335: l_return_type VARCHAR2(30);
336:
337: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
338: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
339:
340: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
341: l_msg_count NUMBER := 0;

Line 338: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;

334: l_class_rule_id IEM_ROUTE_CLASS_RULES.ROUTE_CLASS_RULE_ID%TYPE;
335: l_return_type VARCHAR2(30);
336:
337: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
338: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
339:
340: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
341: l_msg_count NUMBER := 0;
342:

Line 2184: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

2180: l_api_version_number NUMBER:=1.0;
2181: l_class_cnt NUMBER;
2182: l_acct_cnt NUMBER;
2183:
2184: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
2185: l_LAST_UPDATE_DATE DATE:=SYSDATE;
2186: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
2187:
2188: IEM_RT_CLASS_NO_DATA EXCEPTION;

Line 2186: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

2182: l_acct_cnt NUMBER;
2183:
2184: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
2185: l_LAST_UPDATE_DATE DATE:=SYSDATE;
2186: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
2187:
2188: IEM_RT_CLASS_NO_DATA EXCEPTION;
2189:
2190: IEM_ADMIN_ACCOUNT_NOT_EXIST EXCEPTION;