1 PACKAGE WSH_ITM_USERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHITUTS.pls 115.3 2002/12/12 12:07:35 bradha ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Insert_Row Procedure */
6 /*--------------------------------------------------------_-*/
7 /* --
8 -- Purpose
9 -- Insert a row into WSH_ITM_USERS entity
10 --
11 -- Input Parameters
12 -- p_api_version
13 -- API version number (current version is 1.0)
14 -- p_init_msg_list (optional, default FND_API.G_FALSE)
15 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16 -- if set to FND_API.G_TRUE
17 -- initialize error message list
18 -- if set to FND_API.G_FALSE - not initialize error
19 -- message list
20 -- p_commit (optional, default FND_API.G_FALSE)
21 -- whether or not to commit the changes to database
22 --
23 -- Input parameters for clear cross users informations
24 -- p_APPLICATION_ID --Application ID added
25 -- p_MASTER_ORGANIZATION_ID - Master Org
26 -- p_ORGANIZATION_ID - Org
27 -- p_APPLICATION_USER_ID - Application User
28 -- p_USER_ID - User
29 -- p_ENCRYPTED_USER_PASSWORD - Password
30 --
31 -- Output Parameters
32 -- x_return_status
33 -- if the process succeeds, the value is
34 -- fnd_api.g_ret_sts_success;
35 -- if there is an expected error, the value is
36 -- fnd_api.g_ret_sts_error;
37 -- if there is an unexpected error, the value is
38 -- fnd_api.g_ret_sts_unexp_error;
39 -- x_msg_count
40 -- if there is one or more errors, the number of error messages
41 -- in the buffer
42 -- x_msg_data
43 -- if there is one and only one error, the error message
44 -- (See fnd_api package for more details about the above output parameters)
45
46 --*/
47
48 PROCEDURE Insert_Row
49 (
50 p_api_version IN NUMBER ,
51 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
52 p_commit IN VARCHAR2 := fnd_api.g_false ,
53 x_return_status OUT NOCOPY VARCHAR2 ,
54 x_msg_count OUT NOCOPY NUMBER ,
55 x_msg_data OUT NOCOPY VARCHAR2 ,
56 p_VENDOR_ID IN NUMBER,
57 p_APPLICATION_ID IN NUMBER,
58 p_MASTER_ORGANIZATION_ID IN NUMBER,
59 p_ORGANIZATION_ID IN NUMBER default null,
60 p_APPLICATION_USER_ID IN NUMBER default null,
61 p_USER_ID IN VARCHAR2,
62 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
63 p_ITM_USER_SEQUENCE_ID OUT NOCOPY NUMBER
64 );
65
66 /*----------------------------------------------------------*/
67 /* Update_Row Procedure */
68 /*----------------------------------------------------------*/
69 /* --
70 -- Purpose
71 -- Update a row into WS_ITM_USERS entity for the given cc seq id
72 --
73 -- Input Parameters
74 -- p_api_version
75 -- API version number (current version is 1.0)
76 -- p_init_msg_list (optional, default FND_API.G_FALSE)
77 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
78 -- if set to FND_API.G_TRUE
79 -- initialize error message list
80 -- if set to FND_API.G_FALSE - not initialize error
81 -- message list
82 -- p_commit (optional, default FND_API.G_FALSE)
83 -- whether or not to commit the changes to database
84 --
85 -- Input parameters for clear cross users informations
86 -- p_VENDOR_ID
87 -- p_APPLICATION_ID --Application added
88 -- p_MASTER_ORGANIZATION_ID -- Master Org
89 -- p_ORGANIZATION_ID --Org
90 -- p_APPLICATION_USER_ID -- Application User
91 -- p_USER_ID -- User
92 -- p_ENCRYPTED_USER_PASSWORD -- Password
93 -- p_ITM_USER_SEQUENCE_ID -- Seq Id
94 --
95 --
96 -- Output Parameters
97 -- x_return_status
98 -- if the process succeeds, the value is
99 -- fnd_api.g_ret_sts_success;
100 -- if there is an expected error, the value is
101 -- fnd_api.g_ret_sts_error;
102 -- if there is an unexpected error, the value is
103 -- fnd_api.g_ret_sts_unexp_error;
104 -- x_msg_count
105 -- if there is one or more errors, the number of error messages
106 -- in the buffer
107 -- x_msg_data
108 -- if there is one and only one error, the error message
109 -- (See fnd_api package for more details about the above output parameters)
110
111 --*/
112 PROCEDURE Update_Row
113 (
114 p_api_version IN NUMBER ,
115 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
116 p_commit IN VARCHAR2 := fnd_api.g_false ,
117 x_return_status OUT NOCOPY VARCHAR2 ,
118 x_msg_count OUT NOCOPY NUMBER ,
119 x_msg_data OUT NOCOPY VARCHAR2 ,
120 p_VENDOR_ID IN NUMBER,
121 p_APPLICATION_ID IN NUMBER,
122 p_MASTER_ORGANIZATION_ID IN NUMBER,
123 p_ORGANIZATION_ID IN NUMBER ,
124 p_APPLICATION_USER_ID IN NUMBER ,
125 p_USER_ID IN VARCHAR2,
126 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
127 p_ITM_USER_SEQUENCE_ID IN NUMBER
128 );
129
130 /*----------------------------------------------------------*/
131 /* Delete_Row Procedure */
132 /*----------------------------------------------------------*/
133 /* --
134 -- Purpose
135 -- Delete a row from WSH_ITM_USERS entity for the given cc seq id
136 --
137 -- Input Parameters
138 -- p_api_version
139 -- API version number (current version is 1.0)
140 -- p_init_msg_list (optional, default FND_API.G_FALSE)
141 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
142 -- if set to FND_API.G_TRUE
143 -- initialize error message list
144 -- if set to FND_API.G_FALSE - not initialize error
145 -- message list
146 -- p_commit (optional, default FND_API.G_FALSE)
147 -- whether or not to commit the changes to database
148 --
149 -- Input parameters for clear cross users informations
150 -- p_ITM_USER_SEQUENCE_ID -- ITM Seq Id
151 --
152 --
153 -- Output Parameters
154 -- x_return_status
155 -- if the process succeeds, the value is
156 -- fnd_api.g_ret_sts_success;
157 -- if there is an expected error, the value is
158 -- fnd_api.g_ret_sts_error;
159 -- if there is an unexpected error, the value is
160 -- fnd_api.g_ret_sts_unexp_error;
161 -- x_msg_count
162 -- if there is one or more errors, the number of error messages
163 -- in the buffer
164 -- x_msg_data
165 -- if there is one and only one error, the error message
166 -- (See fnd_api package for more details about the above output parameters)
167
168 --*/
169 PROCEDURE Delete_Row
170 (
171 p_api_version IN NUMBER ,
172 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
173 p_commit IN VARCHAR2 := fnd_api.g_false ,
174 x_return_status OUT NOCOPY VARCHAR2 ,
175 x_msg_count OUT NOCOPY NUMBER ,
176 x_msg_data OUT NOCOPY VARCHAR2 ,
177 p_ITM_USER_SEQUENCE_ID IN NUMBER
178 );
179
180 /*----------------------------------------------------------*/
181 /*----------------------------------------------------------*/
182 /* Lock_Row Procedure */
183 /*----------------------------------------------------------*/
184 /* --
185 -- Purpose
186 -- Lock a row into WSH_ITM_USERS entity for the given cc seq id
187 --
188 -- Input Parameters
189 -- p_api_version
190 -- API version number (current version is 1.0)
191 -- p_init_msg_list (optional, default FND_API.G_FALSE)
192 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
193 -- if set to FND_API.G_TRUE
194 -- initialize error message list
195 -- if set to FND_API.G_FALSE - not initialize error
196 -- message list
197 -- p_commit (optional, default FND_API.G_FALSE)
198 -- whether or not to commit the changes to database
199 --
200 -- Input parameters for clear cross users informations
201 -- p_VENDOR_ID --Vendor Id
202 -- p_MASTER_ORGANIZATION_ID -- Master Org
203 -- p_APPLICATION_ID --Application_id added.
204 -- p_ORGANIZATION_ID --Org
205 -- p_APPLICATION_USER_ID -- Application User
206 -- p_ITM_USER_ID -- ITM User ID
207 -- p_ENCRYPTED_USER_PASSWORD -- Password
208 -- p_ITM_SEQUENCE_ID -- ITM Seq Id
209 --
210 --
211 -- Output Parameters
212 -- x_return_status
213 -- if the process succeeds, the value is
214 -- fnd_api.g_ret_sts_success;
215 -- if there is an expected error, the value is
216 -- fnd_api.g_ret_sts_error;
217 -- if there is an unexpected error, the value is
218 -- fnd_api.g_ret_sts_unexp_error;
219 -- x_msg_count
220 -- if there is one or more errors, the number of error messages
221 -- in the buffer
222 -- x_msg_data
223 -- if there is one and only one error, the error message
224 -- (See fnd_api package for more details about the above output parameters)
225
226 --*/
227 PROCEDURE Lock_Row
228 (
229 p_api_version IN NUMBER ,
230 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
231 p_commit IN VARCHAR2 := fnd_api.g_false ,
232 x_return_status OUT NOCOPY VARCHAR2 ,
233 x_msg_count OUT NOCOPY NUMBER ,
234 x_msg_data OUT NOCOPY VARCHAR2 ,
235 p_VENDOR_ID IN NUMBER,
236 p_APPLICATION_ID IN NUMBER,
237 p_MASTER_ORGANIZATION_ID IN NUMBER,
238 p_ORGANIZATION_ID IN NUMBER ,
239 p_APPLICATION_USER_ID IN NUMBER ,
240 p_USER_ID IN VARCHAR2,
241 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
242 p_ITM_USER_SEQUENCE_ID IN NUMBER,
243 p_rowid IN VARCHAR2
244 );
245
246 END WSH_ITM_USERS_PKG;