APPS.IEM_DB_CONNECTIONS_PVT dependencies on IEM_DB_CONNECTIONS

Line 1: PACKAGE BODY IEM_DB_CONNECTIONS_PVT as

1: PACKAGE BODY IEM_DB_CONNECTIONS_PVT as
2: /* $Header: iemvdbcb.pls 115.4 2002/12/03 20:11:32 chtang ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DB_CONNECTIONS_PVT ';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DB_CONNECTIONS_PVT ';

1: PACKAGE BODY IEM_DB_CONNECTIONS_PVT as
2: /* $Header: iemvdbcb.pls 115.4 2002/12/03 20:11:32 chtang ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DB_CONNECTIONS_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 66: SELECT IEM_DB_CONNECTIONS_s1.nextval

62: END IF;
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: SELECT IEM_DB_CONNECTIONS_s1.nextval
67: INTO l_seq_id
68: FROM dual;
69:
70: /*Check For Existing Server Group Id */

Line 85: INSERT INTO IEM_DB_CONNECTIONS

81: APP_EXCEPTION.RAISE_EXCEPTION;
82: END IF;
83: end if;
84:
85: INSERT INTO IEM_DB_CONNECTIONS
86: (
87: DB_CONNECTION_ID,
88: DB_LINK,
89: DB_USERNAME,

Line 220: delete from IEM_DB_CONNECTIONS

216: END IF;
217: -- Initialize API return status to SUCCESS
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: if p_db_conn_id = FND_API.G_MISS_NUM then
220: delete from IEM_DB_CONNECTIONS
221: where db_username=p_db_username and db_server_id=p_db_server_id ;
222: else
223: delete from IEM_DB_CONNECTIONS
224: where db_connection_id=p_db_conn_id;

Line 223: delete from IEM_DB_CONNECTIONS

219: if p_db_conn_id = FND_API.G_MISS_NUM then
220: delete from IEM_DB_CONNECTIONS
221: where db_username=p_db_username and db_server_id=p_db_server_id ;
222: else
223: delete from IEM_DB_CONNECTIONS
224: where db_connection_id=p_db_conn_id;
225: end if;
226:
227: -- Standard Check Of p_commit.

Line 345: update IEM_DB_CONNECTIONS

341: APP_EXCEPTION.RAISE_EXCEPTION;
342: END IF;
343: end if;
344: if p_db_conn_id is null then
345: update IEM_DB_CONNECTIONS
346: set db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL, db_link,p_db_link),
347: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,is_admin),
348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
349: LAST_UPDATE_DATE = sysdate,

Line 370: update IEM_DB_CONNECTIONS

366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
367: where db_username=p_db_username and db_server_id=p_db_server_id;
368:
369: else
370: update IEM_DB_CONNECTIONS
371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),

Line 473: FROM IEM_DB_CONNECTIONS

469: -- Initialize API return status to SUCCESS
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471: BEGIN
472: SELECT DB_LINK into x_db_link
473: FROM IEM_DB_CONNECTIONS
474: where db_server_id=p_db_server_id
475: and is_admin=p_is_admin;
476: EXCEPTION WHEN NO_DATA_FOUND THEN
477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');

Line 530: END IEM_DB_CONNECTIONS_PVT ;

526: p_data => x_msg_data
527: );
528: END select_item;
529:
530: END IEM_DB_CONNECTIONS_PVT ;