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
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;
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
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')) ,
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,
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,
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')) ,
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,
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,