1 PACKAGE IEM_DBLINK_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvdbls.pls 115.15 2002/12/05 20:14:07 chtang shipped $*/
3
4 -- Start of Comments
5 -- API name : create_link
6 -- Type : Private
7 -- Function : This procedure create a record in the table IEM_DB_CONNECTIONS
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_db_link IN VARCHAR2,
15 -- p_db_username IN VARCHAR2,
16 -- p_db_password IN VARCHAR2,
17 -- p_db_server_id IN NUMBER,
18 -- p_is_admin IN VARCHAR2
19 --
20 -- OUT
21 -- x_return_status OUT VARCHAR2
22 -- x_msg_count OUT NUMBER
23 -- x_msg_data OUT VARCHAR2
24 --
25 -- Version : 1.0
26 -- Notes :
27 --
28 -- End of comments
29 -- **********************************************************
30
31 PROCEDURE create_link (p_api_version_number IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_db_server_id IN NUMBER,
35 p_db_glname IN VARCHAR2,
36 p_db_username IN VARCHAR2,
37 p_db_password IN VARCHAR2,
38 p_is_admin IN VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2
42 );
43
44 -- Start of Comments
45 -- API name : delete_link
46 -- Type : Private
47 -- Function : This procedure delete a record in the table IEM_DB_CONNECTIONS
48 -- Pre-reqs : None.
49 -- Parameters :
50 -- IN
51 -- p_api_version_number IN NUMBER Required
52 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
53 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
54 -- p_db_connection_id in number:=FND_API.G_MISS_NUM,
55 --
56 -- OUT
57 -- x_return_status OUT VARCHAR2
58 -- x_msg_count OUT NUMBER
59 -- x_msg_data OUT VARCHAR2
60 --
61 -- Version : 1.0
62 -- Notes :
63 --
64 -- End of comments
65 -- **********************************************************
66
67 PROCEDURE delete_link (p_api_version_number IN NUMBER,
68 p_init_msg_list IN VARCHAR2,
69 p_commit IN VARCHAR2,
70 p_db_connection_id IN NUMBER,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 );
75
76 END IEM_DBLINK_PVT;