DBA Data[Home] [Help]

APPS.IEM_DB_CONNECTIONS_PVT dependencies on IEM_DB_SERVERS

Line 72: Select count(*) into l_grp_cnt from iem_db_servers

68: FROM dual;
69:
70: /*Check For Existing Server Group Id */
71: if p_db_server_id <> FND_API.G_MISS_NUM THEN
72: Select count(*) into l_grp_cnt from iem_db_servers
73: where db_server_id=p_db_server_id
74: and rownum=1;
75: IF l_grp_cnt = 0 then
76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');

Line 332: Select count(*) into l_grp_cnt from iem_db_servers

328: if p_db_server_id is not null then
329:
330: /*Check For Existing DB Server Id */
331:
332: Select count(*) into l_grp_cnt from iem_db_servers
333: where db_server_id=p_db_Server_id
334: and rownum=1;
335: IF l_grp_cnt = 0 then
336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');