APPS.IEM_AGENT_ACT_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 817: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;

813: l_api_version_number NUMBER:=1.0;
814: l_return_status varchar2(10);
815: l_msg_count number;
816: l_msg_data varchar2(255);
817: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
818: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
819: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
820: l_agntacct varchar2(160);
821: l_res_name varchar2(720);

Line 873: select count(*) into l_account_count FROM IEM_MSTEMAIL_ACCOUNTS

869: end if;
870:
871: FOR i in 1.. p_in_email_account_tbl.count() LOOP
872:
873: select count(*) into l_account_count FROM IEM_MSTEMAIL_ACCOUNTS
874: WHERE EMAIL_ACCOUNT_ID = p_in_email_account_tbl(i);
875:
876: if (l_account_count = 1) then
877:

Line 880: FROM IEM_MSTEMAIL_ACCOUNTS

876: if (l_account_count = 1) then
877:
878: SELECT USER_NAME
879: INTO l_email_user
880: FROM IEM_MSTEMAIL_ACCOUNTS
881: WHERE EMAIL_ACCOUNT_ID = p_in_email_account_tbl(i);
882:
883: -- Check if the agent account already exist. If exist, skip and fetch next resource id in the loop
884: select count(*) into l_agent_account_count from iem_agents where email_account_id= p_in_email_account_tbl(i) and resource_id=p_resource_id;

Line 1045: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;

1041: l_api_version_number NUMBER:=1.0;
1042: l_return_status varchar2(10);
1043: l_msg_count number;
1044: l_msg_data varchar2(255);
1045: l_email_user IEM_MSTEMAIL_ACCOUNTS.USER_NAME%TYPE;
1046: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
1047: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
1048: l_agntacct varchar2(160);
1049: l_res_name varchar2(720);

Line 1094: select count(*) into l_account_count FROM IEM_MSTEMAIL_ACCOUNTS

1090: WHERE RESOURCE_ID = p_resource_id;
1091:
1092: FOR i in 1..p_out_email_account_tbl.count() LOOP
1093:
1094: select count(*) into l_account_count FROM IEM_MSTEMAIL_ACCOUNTS
1095: WHERE EMAIL_ACCOUNT_ID = p_out_email_account_tbl(i);
1096:
1097: if (l_account_count = 1) then
1098:

Line 1101: FROM IEM_MSTEMAIL_ACCOUNTS

1097: if (l_account_count = 1) then
1098:
1099: SELECT USER_NAME
1100: INTO l_email_user
1101: FROM IEM_MSTEMAIL_ACCOUNTS
1102: WHERE EMAIL_ACCOUNT_ID = p_out_email_account_tbl(i);
1103:
1104: l_agntacct:=TO_CHAR(l_user_id)||'-'||l_email_user;
1105: