[Home] [Help]
PACKAGE: APPS.IEM_DB_CONNECTIONS_PVT
Source
1 PACKAGE IEM_DB_CONNECTIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvdbcs.pls 115.5 2002/12/03 20:03:24 chtang ship $ */
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table IEM_DB_CONNECTIONS
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_db_link IN VARCHAR2,
14 -- p_db_username IN VARCHAR2,
15 -- p_db_password IN VARCHAR2,
16 -- p_db_server_id IN NUMBER,
17 -- p_is_admin IN VARCHAR2,
18 -- p_conn_desc IN VARCHAR2:=FND_API.G_MISS_CHAR,
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_item (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_link IN VARCHAR2,
35 p_db_username IN VARCHAR2,
36 p_db_password IN VARCHAR2,
37 p_db_server_id IN NUMBER,
38 p_is_admin IN VARCHAR2,
39 p_conn_desc IN VARCHAR2:=null,
40 p_CREATED_BY NUMBER:=null,
41 p_CREATION_DATE DATE:=null,
42 p_LAST_UPDATED_BY NUMBER:=null,
43 p_LAST_UPDATE_DATE DATE:=null,
44 p_LAST_UPDATE_LOGIN NUMBER:=null,
45 p_ATTRIBUTE1 VARCHAR2:=null,
46 p_ATTRIBUTE2 VARCHAR2:=null,
47 p_ATTRIBUTE3 VARCHAR2:=null,
48 p_ATTRIBUTE4 VARCHAR2:=null,
49 p_ATTRIBUTE5 VARCHAR2:=null,
50 p_ATTRIBUTE6 VARCHAR2:=null,
51 p_ATTRIBUTE7 VARCHAR2:=null,
52 p_ATTRIBUTE8 VARCHAR2:=null,
53 p_ATTRIBUTE9 VARCHAR2:=null,
54 p_ATTRIBUTE10 VARCHAR2:=null,
55 p_ATTRIBUTE11 VARCHAR2:=null,
56 p_ATTRIBUTE12 VARCHAR2:=null,
57 p_ATTRIBUTE13 VARCHAR2:=null,
58 p_ATTRIBUTE14 VARCHAR2:=null,
59 p_ATTRIBUTE15 VARCHAR2:=null,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 -- Start of Comments
66 -- API name : delete_item
67 -- Type : Private
68 -- Function : This procedure delete a record in the table IEM_DB_CONNECTIONS
69 -- Pre-reqs : None.
70 -- Parameters :
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75 -- p_db_conn_id in number:=null,
76 -- p_db_username IN VARCHAR2 :=null,
77 -- p_db_server_id IN NUMBER:=null,
78
79 -- OUT
80 -- x_return_status OUT VARCHAR2
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2
83 --
84 -- Version : 1.0
85 -- Notes :
86 --
87 -- End of comments
88 -- **********************************************************
89
90 PROCEDURE delete_item (p_api_version_number IN NUMBER,
91 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
92 p_commit IN VARCHAR2 := FND_API.G_FALSE,
93 p_db_conn_id in number:=null,
94 p_db_username IN VARCHAR2 :=null,
95 p_db_server_id IN NUMBER:=null,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100 -- Start of Comments
101 -- API name : update_item
102 -- Type : Private
103 -- Function : This procedure update a record in the table IEM_DB_CONNECTIONS
104 -- Pre-reqs : None.
105 -- Parameters :
106 -- IN
107 -- p_api_version_number IN NUMBER Required
108 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
109 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
110 -- p_db_conn_id IN NUMBER:=NULL,
111 -- p_db_link IN VARCHAR2:=NULL,
112 -- p_db_username IN VARCHAR2:=NULL,
113 -- p_db_password IN VARCHAR2:=NULL,
114 -- p_db_server_id IN NUMBER:=NULL,
115 -- p_is_admin IN VARCHAR2:=NULL,
116 -- p_conn_desc IN VARCHAR2:=NULL,
117 --
118 -- OUT
119 -- x_return_status OUT VARCHAR2
120 -- x_msg_count OUT NUMBER
121 -- x_msg_data OUT VARCHAR2
122 --
123 -- Version : 1.0
124 -- Notes :
125 --
126 -- End of comments
127 -- **********************************************************
128
129 PROCEDURE update_item (p_api_version_number IN NUMBER,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132 p_db_conn_id IN NUMBER:=null,
133 p_db_link IN VARCHAR2:=null,
134 p_db_username IN VARCHAR2:=null,
135 p_db_password IN VARCHAR2:=null,
136 p_db_server_id IN NUMBER:=null,
137 p_is_admin IN VARCHAR2:=null,
138 p_conn_desc IN VARCHAR2:=null,
139 p_CREATED_BY NUMBER:=null,
140 p_CREATION_DATE DATE:=null,
141 p_LAST_UPDATED_BY NUMBER:=null ,
142 p_LAST_UPDATE_DATE DATE:=null,
143 p_LAST_UPDATE_LOGIN NUMBER:=null,
144 p_ATTRIBUTE1 VARCHAR2:=null,
145 p_ATTRIBUTE2 VARCHAR2:=null,
146 p_ATTRIBUTE3 VARCHAR2:=null,
147 p_ATTRIBUTE4 VARCHAR2:=null,
148 p_ATTRIBUTE5 VARCHAR2:=null,
149 p_ATTRIBUTE6 VARCHAR2:=null,
150 p_ATTRIBUTE7 VARCHAR2:=null,
151 p_ATTRIBUTE8 VARCHAR2:=null,
152 p_ATTRIBUTE9 VARCHAR2:=null,
153 p_ATTRIBUTE10 VARCHAR2:=null,
154 p_ATTRIBUTE11 VARCHAR2:=null,
155 p_ATTRIBUTE12 VARCHAR2:=null,
156 p_ATTRIBUTE13 VARCHAR2:=null,
157 p_ATTRIBUTE14 VARCHAR2:=null,
158 p_ATTRIBUTE15 VARCHAR2:=null,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2
162 );
163
164 -- Start of Comments
165 -- API name : select_item
166 -- Type : Private
167 -- Function : This procedure returns the db_link name
168 -- Pre-reqs : None.
169 -- Parameters :
170 -- IN
171 -- p_api_version_number IN NUMBER Required
172 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
173 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
174 -- p_email_account_id in number:=null,
175 -- p_is_admin IN VARCHAR2 :=null,
176
177 -- OUT
178 -- x_db_link OUT VARCHAR2
179 -- x_return_status OUT VARCHAR2
180 -- x_msg_count OUT NUMBER
181 -- x_msg_data OUT VARCHAR2
182 --
183 -- Version : 1.0
184 -- Notes :
185 --
186 -- End of comments
187 -- **********************************************************
188 PROCEDURE select_item (p_api_version_number IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_db_server_id in number:=null,
192 p_is_admin IN VARCHAR2 :=null,
193 x_db_link OUT NOCOPY VARCHAR2,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199 END IEM_DB_CONNECTIONS_PVT;