APPS.IEM_DBLINK_PVT dependencies on IEM_DB_CONNECTIONS

Line 9: -- Function : This procedure create a record in the table IEM_DB_CONNECTIONS

5:
6: -- Start of Comments
7: -- API name : create_link
8: -- Type : Private
9: -- Function : This procedure create a record in the table IEM_DB_CONNECTIONS
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- IN
13: -- p_api_version_number IN NUMBER Required

Line 123: select count(*) into l_dblink_count from iem_db_connections where db_username=p_db_username and db_server_id=p_db_server_id;

119: END IF;
120:
121: select oracle_username into l_schema_owner from fnd_oracle_userid where read_only_flag = 'U';
122:
123: select count(*) into l_dblink_count from iem_db_connections where db_username=p_db_username and db_server_id=p_db_server_id;
124:
125: if (l_dblink_count <> 0) then
126: raise db_link_exist;
127: end if;

Line 211: select count(*) into l_count from iem_db_connections where UPPER(db_link) = UPPER(l_glname) and db_server_id = p_db_server_id;

207:
208: -- Standard Start of API savepoint
209: SAVEPOINT CREATE_LINK_PVT;
210:
211: select count(*) into l_count from iem_db_connections where UPPER(db_link) = UPPER(l_glname) and db_server_id = p_db_server_id;
212:
213: if lower(l_global_name) <> lower(l_iem_server_rec.service_name) then
214: raise link_not_correct;
215: elsif l_count > 0 then

Line 218: IEM_DB_CONNECTIONS_PVT.create_item(

214: raise link_not_correct;
215: elsif l_count > 0 then
216: raise duplicate_db_link;
217: else
218: IEM_DB_CONNECTIONS_PVT.create_item(
219: p_api_version_number => 1.0,
220: p_db_link => l_glname,
221: p_db_username => p_db_username,
222: p_db_password => l_db_password,

Line 571: -- Function : This procedure delete a record in the table IEM_DB_CONNECTIONS

567:
568: -- Start of Comments
569: -- API name : delete_link
570: -- Type : Private
571: -- Function : This procedure delete a record in the table IEM_DB_CONNECTIONS
572: -- Pre-reqs : None.
573: -- Parameters :
574: -- IN
575: -- p_api_version_number IN NUMBER Required

Line 603: l_iem_dbconn_rec IEM_DB_CONNECTIONS%ROWTYPE;

599: TYPE LinkCur Is REF CURSOR;
600: l_api_name VARCHAR2(255):='delete_link';
601: l_api_version_number NUMBER:=1.0;
602: l_dblink VARCHAR2(128);
603: l_iem_dbconn_rec IEM_DB_CONNECTIONS%ROWTYPE;
604: l_v_id NUMBER;
605: l_num NUMBER;
606: l_statement VARCHAR2(2000);
607: link_does_not_exist EXCEPTION;

Line 633: select * INTO l_iem_dbconn_rec from IEM_DB_CONNECTIONS where DB_CONNECTION_ID = p_db_connection_id;

629:
630: -- Standard Start of API savepoint
631: -- SAVEPOINT delete_link_pvt;
632:
633: select * INTO l_iem_dbconn_rec from IEM_DB_CONNECTIONS where DB_CONNECTION_ID = p_db_connection_id;
634: -- select db_link into l_dblink from iem_db_connections where db_connection_id = p_db_connection_id;
635:
636: IF (l_iem_dbconn_rec.is_admin <> 'O') then
637:

Line 634: -- select db_link into l_dblink from iem_db_connections where db_connection_id = p_db_connection_id;

630: -- Standard Start of API savepoint
631: -- SAVEPOINT delete_link_pvt;
632:
633: select * INTO l_iem_dbconn_rec from IEM_DB_CONNECTIONS where DB_CONNECTION_ID = p_db_connection_id;
634: -- select db_link into l_dblink from iem_db_connections where db_connection_id = p_db_connection_id;
635:
636: IF (l_iem_dbconn_rec.is_admin <> 'O') then
637:
638: l_v_id := DBMS_SQL.OPEN_CURSOR;

Line 652: IEM_DB_CONNECTIONS_PVT.delete_item(

648: END IF;
649: -- Standard Start of API savepoint
650: SAVEPOINT delete_link_pvt;
651: -- check if db link dropped successfully
652: IEM_DB_CONNECTIONS_PVT.delete_item(
653: p_api_version_number => 1.0,
654: p_db_conn_id => p_db_connection_id,
655: x_msg_count => x_msg_count,
656: x_return_status => x_return_status,

Line 673: IEM_DB_CONNECTIONS_PVT.delete_item(

669: WHEN link_does_not_exist THEN
670: --bugfix 1944746-----------
671: -- If the link does not exist, remove from iem_db_connection directly to avoid garbage data
672:
673: IEM_DB_CONNECTIONS_PVT.delete_item(
674: p_api_version_number => 1.0,
675: p_db_conn_id => p_db_connection_id,
676: x_msg_count => x_msg_count,
677: x_return_status => x_return_status,