1 PACKAGE WSH_CC_USERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: WSHUSTHS.pls 115.3 2002/06/03 12:32:34 pkm ship $ */
3
4 /*----------------------------------------------------------*/
5 /* Insert_Row Procedure */
6 /*--------------------------------------------------------_-*/
7 /* --
8 -- Purpose
9 -- Insert a row into WSH_CC_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_CC_USER_ID - Clear Cross 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 -- p_CC_USER_SEQUENCE_ID - Clear Cross sequence Id ( PK)
46
47 --*/
48
49 PROCEDURE Insert_Row
50 (
51 p_api_version IN NUMBER ,
52 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
53 p_commit IN VARCHAR2 := fnd_api.g_false ,
54 x_return_status OUT VARCHAR2 ,
55 x_msg_count OUT NUMBER ,
56 x_msg_data OUT VARCHAR2 ,
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_CC_USER_ID IN VARCHAR2,
62 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
63 p_CC_USER_SEQUENCE_ID OUT NUMBER
64 );
65
66 /*----------------------------------------------------------*/
67 /* Update_Row Procedure */
68 /*--------------------------------------------------------_-*/
69 /* --
70 -- Purpose
71 -- Update a row into wsh_cc_users entity
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_APPLICATION_ID --Application_id added.
87 -- p_MASTER_ORGANIZATION_ID - Master Org
88 -- p_ORGANIZATION_ID - Org
89 -- p_APPLICATION_USER_ID - Application User
90 -- p_CC_USER_ID - Clear Cross User
91 -- p_ENCRYPTED_USER_PASSWORD - Password
92 -- p_CC_USER_SEQUENCE_ID - Seq Id (PK)
93 --
94 --
95 -- Output Parameters
96 -- x_return_status
97 -- if the process succeeds, the value is
98 -- fnd_api.g_ret_sts_success;
99 -- if there is an expected error, the value is
100 -- fnd_api.g_ret_sts_error;
101 -- if there is an unexpected error, the value is
102 -- fnd_api.g_ret_sts_unexp_error;
103 -- x_msg_count
104 -- if there is one or more errors, the number of error messages
105 -- in the buffer
106 -- x_msg_data
107 -- if there is one and only one error, the error message
108 -- (See fnd_api package for more details about the above output parameters)
109 --*/
110
111 PROCEDURE Update_Row
112 (
113 p_api_version IN NUMBER ,
114 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
115 p_commit IN VARCHAR2 := fnd_api.g_false ,
116 x_return_status OUT VARCHAR2 ,
117 x_msg_count OUT NUMBER ,
118 x_msg_data OUT VARCHAR2 ,
119 p_APPLICATION_ID IN NUMBER,
120 p_MASTER_ORGANIZATION_ID IN NUMBER,
121 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
122 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
123 p_CC_USER_ID IN VARCHAR2,
124 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
125 p_CC_USER_SEQUENCE_ID IN NUMBER
126 ) ;
127 /*----------------------------------------------------------*/
128 /* Delete_Row Procedure */
129 /*--------------------------------------------------------_-*/
130 /* --
131 -- Purpose
132 -- Delete a row from wsh_cc_users entity
133 --
134 -- Input Parameters
135 -- p_api_version
136 -- API version number (current version is 1.0)
137 -- p_init_msg_list (optional, default FND_API.G_FALSE)
138 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
139 -- if set to FND_API.G_TRUE
140 -- initialize error message list
141 -- if set to FND_API.G_FALSE - not initialize error
142 -- message list
143 -- p_commit (optional, default FND_API.G_FALSE)
144 -- whether or not to commit the changes to database
145 --
146 -- Input parameters for Clear Cross Users Informations
147 -- p_CC_USER_SEQUENCE_ID - Seq Id (PK)
148 --
149 --
150 -- Output Parameters
151 -- x_return_status
152 -- if the process succeeds, the value is
153 -- fnd_api.g_ret_sts_success;
154 -- if there is an expected error, the value is
155 -- fnd_api.g_ret_sts_error;
156 -- if there is an unexpected error, the value is
157 -- fnd_api.g_ret_sts_unexp_error;
158 -- x_msg_count
159 -- if there is one or more errors, the number of error messages
160 -- in the buffer
161 -- x_msg_data
162 -- if there is one and only one error, the error message
163 -- (See fnd_api package for more details about the above output parameters)
164 --*/
165
166 PROCEDURE Delete_Row
167 (
168 p_api_version IN NUMBER ,
169 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
170 p_commit IN VARCHAR2 := fnd_api.g_false ,
171 x_return_status OUT VARCHAR2 ,
172 x_msg_count OUT NUMBER ,
173 x_msg_data OUT VARCHAR2 ,
174 p_CC_USER_SEQUENCE_ID IN NUMBER
175 );
176 /*----------------------------------------------------------*/
177 /* Lock_Row Procedure */
178 /*----------------------------------------------------------*/
179 /* --
180 -- Purpose
181 -- Lock a row into WSH_CC_USERS entity for the given cc seq id
182 --
183 -- Input Parameters
184 -- p_api_version
185 -- API version number (current version is 1.0)
186 -- p_init_msg_list (optional, default FND_API.G_FALSE)
187 -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
188 -- if set to FND_API.G_TRUE
189 -- initialize error message list
190 -- if set to FND_API.G_FALSE - not initialize error
191 -- message list
192 -- p_commit (optional, default FND_API.G_FALSE)
193 -- whether or not to commit the changes to database
194 --
195 -- Input parameters for clear cross users informations
196 -- p_APPLICATION_ID --Application ID added.
197 -- p_MASTER_ORGANIZATION_ID -- Master Org
198 -- p_ORGANIZATION_ID --Org
199 -- p_APPLICATION_USER_ID -- Application User
200 -- p_CC_USER_ID -- Clear Cross User
201 -- p_ENCRYPTED_USER_PASSWORD -- Password
202 -- p_CC_SEQUENCE_ID -- CC Seq Id
203 --
204 --
205 -- Output Parameters
206 -- x_return_status
207 -- if the process succeeds, the value is
208 -- fnd_api.g_ret_sts_success;
209 -- if there is an expected error, the value is
210 -- fnd_api.g_ret_sts_error;
211 -- if there is an unexpected error, the value is
212 -- fnd_api.g_ret_sts_unexp_error;
213 -- x_msg_count
214 -- if there is one or more errors, the number of error messages
215 -- in the buffer
216 -- x_msg_data
217 -- if there is one and only one error, the error message
218 -- (See fnd_api package for more details about the above output parameters)
219
220 --*/
221 PROCEDURE Lock_Row
222 (
223 p_api_version IN NUMBER ,
224 p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225 p_commit IN VARCHAR2 := fnd_api.g_false ,
226 x_return_status OUT VARCHAR2 ,
227 x_msg_count OUT NUMBER ,
228 x_msg_data OUT VARCHAR2 ,
229 p_APPLICATION_ID IN NUMBER,
230 p_MASTER_ORGANIZATION_ID IN NUMBER,
231 p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
232 p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
233 p_CC_USER_ID IN VARCHAR2,
234 p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
235 p_CC_USER_SEQUENCE_ID IN NUMBER,
236 p_rowid IN VARCHAR2
237 );
238 END WSH_CC_USERS_PKG;