APPS.IEM_ROUTE_PVT dependencies on FND_PROFILE

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

19:
20: -- Enter procedure, function bodies as shown below
21: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_PVT ';
22: G_ROUTE_ID varchar2(30) ;
23: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
24:
25: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
26:
27: PROCEDURE delete_acct_route_by_acct

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

21: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_PVT ';
22: G_ROUTE_ID varchar2(30) ;
23: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
24:
25: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
26:
27: PROCEDURE delete_acct_route_by_acct
28: (p_api_version_number IN NUMBER,
29: P_init_msg_list IN VARCHAR2 := null,

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

249: l_route_rule_id IEM_ROUTE_RULES.ROUTE_RULE_ID%TYPE;
250: l_return_type VARCHAR2(30);
251:
252:
253: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
254: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
255:
256: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
257: l_msg_count NUMBER := 0;

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

250: l_return_type VARCHAR2(30);
251:
252:
253: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
254: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
255:
256: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
257: l_msg_count NUMBER := 0;
258: l_msg_data VARCHAR2(2000);

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

1810: l_api_name VARCHAR2(255):='update_account_routes';
1811: l_api_version_number NUMBER:=1.0;
1812: l_route_cnt NUMBER;
1813: l_acct_cnt NUMBER;
1814: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1815: l_LAST_UPDATE_DATE DATE:=SYSDATE;
1816: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
1817:
1818: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;

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

1812: l_route_cnt NUMBER;
1813: l_acct_cnt NUMBER;
1814: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1815: l_LAST_UPDATE_DATE DATE:=SYSDATE;
1816: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
1817:
1818: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
1819:
1820: BEGIN