APPS.IEM_DB_CONNECTIONS_PVT dependencies on FND_PROFILE

Line 43: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));

39: l_api_name VARCHAR2(255):='create_item';
40: l_api_version_number NUMBER:=1.0;
41: l_seq_id number;
42: l_grp_cnt number;
43: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
44: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
45: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
46:
47: BEGIN

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

40: l_api_version_number NUMBER:=1.0;
41: l_seq_id number;
42: l_grp_cnt number;
43: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
44: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
45: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
46:
47: BEGIN
48: -- Standard Start of API savepoint

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

41: l_seq_id number;
42: l_grp_cnt number;
43: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
44: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
45: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
46:
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_item_PVT;

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

302: ) is
303: l_api_name VARCHAR2(255):='update_item';
304: l_api_version_number NUMBER:=1.0;
305: l_grp_cnt NUMBER;
306: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
307: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
308:
309: BEGIN
310: -- Standard Start of API savepoint

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

303: l_api_name VARCHAR2(255):='update_item';
304: l_api_version_number NUMBER:=1.0;
305: l_grp_cnt NUMBER;
306: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
307: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
308:
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT update_item_PVT;