APPS.IEM_DBLINK_PVT dependencies on STANDARD

Line 99: -- Standard Start of API savepoint

95: PRAGMA EXCEPTION_INIT(host_invalid1 , -12545);
96: PRAGMA EXCEPTION_INIT(db_conn_desc_invalid , -02019);
97:
98: BEGIN
99: -- Standard Start of API savepoint
100: -- SAVEPOINT CREATE_LINK_PVT;
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
103: p_api_version_number,

Line 101: -- Standard call to check for call compatibility.

97:
98: BEGIN
99: -- Standard Start of API savepoint
100: -- SAVEPOINT CREATE_LINK_PVT;
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
103: p_api_version_number,
104: l_api_name,
105: G_PKG_NAME)

Line 208: -- Standard Start of API savepoint

204: IF (l_glname IS NULL) THEN
205: l_glname:=p_db_glname;
206: END IF;
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:

Line 230: -- Standard Check Of p_commit.

226: x_return_status => x_return_status,
227: x_msg_data => x_msg_data);
228: end if;
229:
230: -- Standard Check Of p_commit.
231: IF FND_API.To_Boolean(p_commit) THEN
232: COMMIT WORK;
233: END IF;
234: -- Standard callto get message count and if count is 1, get message info.

Line 234: -- Standard callto get message count and if count is 1, get message info.

230: -- Standard Check Of p_commit.
231: IF FND_API.To_Boolean(p_commit) THEN
232: COMMIT WORK;
233: END IF;
234: -- Standard callto get message count and if count is 1, get message info.
235: FND_MSG_PUB.Count_And_Get
236: ( p_count => x_msg_count,
237: p_data => x_msg_data
238: );

Line 612: -- Standard Start of API savepoint

608: l_grp_cnt NUMBER;
609: l_link_cur LinkCur;
610: PRAGMA EXCEPTION_INIT(link_does_not_exist , -02024);
611: BEGIN
612: -- Standard Start of API savepoint
613: --SAVEPOINT delete_link_pvt;
614: -- Standard call to check for call compatibility.
615: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
616: p_api_version_number,

Line 614: -- Standard call to check for call compatibility.

610: PRAGMA EXCEPTION_INIT(link_does_not_exist , -02024);
611: BEGIN
612: -- Standard Start of API savepoint
613: --SAVEPOINT delete_link_pvt;
614: -- Standard call to check for call compatibility.
615: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
616: p_api_version_number,
617: l_api_name,
618: G_PKG_NAME)

Line 630: -- Standard Start of API savepoint

626: END IF;
627: -- Initialize API return status to SUCCESS
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 649: -- Standard Start of API savepoint

645:
646: DBMS_SQL.CLOSE_CURSOR(l_v_id);
647:
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,

Line 659: -- Standard Check Of p_commit.

655: x_msg_count => x_msg_count,
656: x_return_status => x_return_status,
657: x_msg_data => x_msg_data);
658:
659: -- Standard Check Of p_commit.
660: IF FND_API.To_Boolean(p_commit) THEN
661: COMMIT WORK;
662: END IF;
663: -- Standard callto get message count and if count is 1, get message info.

Line 663: -- Standard callto get message count and if count is 1, get message info.

659: -- Standard Check Of p_commit.
660: IF FND_API.To_Boolean(p_commit) THEN
661: COMMIT WORK;
662: END IF;
663: -- Standard callto get message count and if count is 1, get message info.
664: FND_MSG_PUB.Count_And_Get
665: ( p_count => x_msg_count,
666: p_data => x_msg_data
667: );

Line 680: -- Standard Check Of p_commit.

676: x_msg_count => x_msg_count,
677: x_return_status => x_return_status,
678: x_msg_data => x_msg_data);
679:
680: -- Standard Check Of p_commit.
681: IF FND_API.To_Boolean(p_commit) THEN
682: COMMIT WORK;
683: END IF;
684: --end bugfix1944746---------------------