APPS.IEM_AGENT_ACT_PVT dependencies on IEM_AGENTS

Line 49: select iem_agents_s1.nextval into l_agent_account_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
50: from dual;
51: INSERT INTO IEM_AGENTS (
52: AGENT_ID ,
53: EMAIL_ACCOUNT_ID ,

Line 51: INSERT INTO IEM_AGENTS (

47: BEGIN
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: select iem_agents_s1.nextval into l_agent_account_id
50: from dual;
51: INSERT INTO IEM_AGENTS (
52: AGENT_ID ,
53: EMAIL_ACCOUNT_ID ,
54: RESOURCE_ID ,
55: SIGNATURE ,

Line 181: from IEM_AGENTS

177: END IF;
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: select agent_id into l_agent_id
181: from IEM_AGENTS
182: where resource_id=p_resource_id
183: and email_account_id=p_email_account_id;
184:
185: delete from IEM_AGENTS

Line 185: delete from IEM_AGENTS

181: from IEM_AGENTS
182: where resource_id=p_resource_id
183: and email_account_id=p_email_account_id;
184:
185: delete from IEM_AGENTS
186: where resource_id=p_resource_id
187: and email_account_id=p_email_account_id;
188:
189: --Insert into Comp_Rt-Stats for Client cache to update.

Line 295: select count(*) into l_agent_account_count from iem_agents where resource_id=p_in_resource_tbl(i)

291: WHERE RESOURCE_ID = p_in_resource_tbl(i);
292:
293:
294: -- Check if the agent account already exist. If exist, skip and fetch next resource id in the loop
295: select count(*) into l_agent_account_count from iem_agents where resource_id=p_in_resource_tbl(i)
296: and email_account_id=p_email_account_id;
297:
298: IF (l_agent_account_count = 0) THEN
299:

Line 496: select count(*) into l_agent_account_count from iem_agents where resource_id=p_out_resource_tbl(i)

492: WHERE RESOURCE_ID = p_out_resource_tbl(i);
493:
494:
495: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
496: select count(*) into l_agent_account_count from iem_agents where resource_id=p_out_resource_tbl(i)
497: and email_account_id=p_email_account_id;
498:
499: IF (l_agent_account_count <> 0) THEN
500:

Line 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;

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;
885:
886: IF (l_agent_account_count = 0) THEN
887:
888: l_data_change := true;

Line 1107: select count(*) into l_agent_account_count from iem_agents where email_account_id=p_out_email_account_tbl(i)

1103:
1104: l_agntacct:=TO_CHAR(l_user_id)||'-'||l_email_user;
1105:
1106: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
1107: select count(*) into l_agent_account_count from iem_agents where email_account_id=p_out_email_account_tbl(i)
1108: and resource_id=p_resource_id;
1109:
1110: IF (l_agent_account_count <> 0) THEN
1111:

Line 1482: from iem_agents

1478:
1479:
1480: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
1481: select count(*) into l_agent_account_count
1482: from iem_agents
1483: where resource_id=p_in_cherrypick_tbl(i)
1484: and email_account_id=p_email_account_id;
1485:
1486: IF (l_agent_account_count <> 0) THEN

Line 1491: UPDATE iem_agents set cherry_pick_flag = 'Y'

1487:
1488: l_data_change := true;
1489:
1490: BEGIN
1491: UPDATE iem_agents set cherry_pick_flag = 'Y'
1492: WHERE resource_id=p_in_cherrypick_tbl(i)
1493: and email_account_id=p_email_account_id;
1494:
1495: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ADDED');

Line 1524: from iem_agents

1520:
1521:
1522: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
1523: select count(*) into l_agent_account_count
1524: from iem_agents
1525: where resource_id=p_out_cherrypick_tbl(i)
1526: and email_account_id=p_email_account_id;
1527:
1528: IF (l_agent_account_count <> 0) THEN

Line 1533: UPDATE iem_agents set cherry_pick_flag = null

1529:
1530: l_data_change := true;
1531:
1532: BEGIN
1533: UPDATE iem_agents set cherry_pick_flag = null
1534: WHERE resource_id=p_out_cherrypick_tbl(i)
1535: and email_account_id=p_email_account_id;
1536:
1537: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ADDED');

Line 1669: from iem_agents

1665:
1666:
1667: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
1668: select count(*) into l_agent_account_count
1669: from iem_agents
1670: where resource_id=p_resource_id
1671: and email_account_id=p_in_acct_chrypick_tbl(i);
1672:
1673: IF (l_agent_account_count <> 0) THEN

Line 1678: UPDATE iem_agents set cherry_pick_flag = 'Y'

1674:
1675: l_data_change := true;
1676:
1677: BEGIN
1678: UPDATE iem_agents set cherry_pick_flag = 'Y'
1679: where resource_id=p_resource_id
1680: and email_account_id=p_in_acct_chrypick_tbl(i);
1681:
1682: FND_MESSAGE.SET_NAME('IEM','IEM_CHERRY_PICK_ACCT_ADDED');

Line 1711: from iem_agents

1707:
1708:
1709: -- Check if the agent account already non-exist. If non-exist, skip and fetch next resource id in the loop
1710: select count(*) into l_agent_account_count
1711: from iem_agents
1712: where resource_id=p_resource_id
1713: and email_account_id=p_out_acct_chrypick_tbl(i);
1714:
1715: IF (l_agent_account_count <> 0) THEN

Line 1720: UPDATE iem_agents set cherry_pick_flag = null

1716:
1717: l_data_change := true;
1718:
1719: BEGIN
1720: UPDATE iem_agents set cherry_pick_flag = null
1721: where resource_id=p_resource_id
1722: and email_account_id=p_out_acct_chrypick_tbl(i);
1723:
1724: FND_MESSAGE.SET_NAME('IEM','IEM_CHRYPICK_ACCT_DELETED');