DBA Data[Home] [Help]

APPS.IEM_AGENT_ACT_PVT dependencies on FND_PROFILE

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

39: l_stat varchar2(20);
40: l_count number;
41: l_data varchar2(300);
42: l_agent_account_id 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_count number;
41: l_data varchar2(300);
42: l_agent_account_id 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: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

41: l_data varchar2(300);
42: l_agent_account_id 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: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: select iem_agents_s1.nextval into l_agent_account_id

Line 324: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

320: p_commit=>'F' ,
321: p_resource_id=>p_in_resource_tbl(i),
322: p_email_account_id=>p_email_account_id,
323: p_signature=>null,
324: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
325: p_CREATION_DATE =>SYSDATE,
326: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
327: p_LAST_UPDATE_DATE =>SYSDATE,
328: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 326: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

322: p_email_account_id=>p_email_account_id,
323: p_signature=>null,
324: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
325: p_CREATION_DATE =>SYSDATE,
326: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
327: p_LAST_UPDATE_DATE =>SYSDATE,
328: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
329: p_ATTRIBUTE1 =>null,
330: p_ATTRIBUTE2 =>null,

Line 328: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

324: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
325: p_CREATION_DATE =>SYSDATE,
326: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
327: p_LAST_UPDATE_DATE =>SYSDATE,
328: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
329: p_ATTRIBUTE1 =>null,
330: p_ATTRIBUTE2 =>null,
331: p_ATTRIBUTE3 =>null,
332: p_ATTRIBUTE4 =>null,

Line 912: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

908: P_Commit => 'F',
909: p_resource_id=>p_resource_id,
910: p_email_account_id=> p_in_email_account_tbl(i),
911: p_signature=>null,
912: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
913: p_CREATION_DATE =>SYSDATE,
914: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
915: p_LAST_UPDATE_DATE =>SYSDATE,
916: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 914: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

910: p_email_account_id=> p_in_email_account_tbl(i),
911: p_signature=>null,
912: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
913: p_CREATION_DATE =>SYSDATE,
914: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
915: p_LAST_UPDATE_DATE =>SYSDATE,
916: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
917: p_ATTRIBUTE1 =>null,
918: p_ATTRIBUTE2 =>null,

Line 916: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

912: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
913: p_CREATION_DATE =>SYSDATE,
914: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
915: p_LAST_UPDATE_DATE =>SYSDATE,
916: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
917: p_ATTRIBUTE1 =>null,
918: p_ATTRIBUTE2 =>null,
919: p_ATTRIBUTE3 =>null,
920: p_ATTRIBUTE4 =>null,