[Home] [Help]
PACKAGE: APPS.AMS_CUST_SETUP_PVT
Source
1 PACKAGE AMS_Cust_Setup_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvcuss.pls 115.19 2003/10/10 05:23:13 vanbukum ship $ */
3
4 TYPE cust_setup_rec_type IS RECORD
5 (
6 CUSTOM_SETUP_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 ACTIVITY_TYPE_CODE VARCHAR2(30),
14 MEDIA_ID NUMBER,
15 ENABLED_FLAG VARCHAR2(1),
16 ALLOW_ESSENTIAL_GROUPING VARCHAR2(1),
17 USAGE VARCHAR2(30),
18 OBJECT_TYPE VARCHAR2(30),
19 SOURCE_CODE_SUFFIX VARCHAR2(10),
20 SETUP_NAME VARCHAR2(120),
21 DESCRIPTION VARCHAR2(4000),
22 APPLICATION_ID NUMBER
23 );
24
25
26 /****************************************************************************/
27 -- Procedure
28 -- create_cust_setup
29 -- Purpose
30 -- create rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
31 -- Parameters
32 -- IN:
33 -- p_api_version IN NUMBER
34 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
35 -- p_commit IN VARCHAR2 := FND_API.g_false
36 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
37 --
38 -- p_cust_setup_rec IN cust_setup_rec_type
39 --
40 -- OUT:
41 -- x_return_status OUT VARCHAR2
42 -- x_msg_count OUT NUMBER
43 -- x_msg_data OUT VARCHAR2
44 --
45 -- x_cust_setup_id OUT NUMBER
46 ------------------------------------------------------------------------------
47 PROCEDURE create_cust_setup
48 (
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51 p_commit IN VARCHAR2 := FND_API.g_false,
52 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
53
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57
58 p_cust_setup_rec IN cust_setup_rec_type,
59 x_cust_setup_id OUT NOCOPY NUMBER
60 );
61
62 /****************************************************************************/
63 -- Procedure
64 -- update_cust_setup
65 -- Purpose
66 -- update rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
67 -- Parameters
68 -- IN:
69 -- p_api_version IN NUMBER
70 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
71 -- p_commit IN VARCHAR2 := FND_API.g_false
72 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
73 --
74 -- p_cust_setup_rec IN cust_setup_rec_type
75 --
76 -- OUT:
77 -- x_return_status OUT VARCHAR2
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 ------------------------------------------------------------------------------
81 PROCEDURE update_cust_setup
82 (
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
85 p_commit IN VARCHAR2 := FND_API.g_false,
86 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
87
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91
92 p_cust_setup_rec IN cust_setup_rec_type
93 );
94
95 /****************************************************************************/
96 -- Procedure
97 -- delete_cust_setup
98 -- Purpose
99 -- delete rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
100 -- Parameters
101 -- IN:
102 -- p_api_version IN NUMBER
103 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
104 -- p_commit IN VARCHAR2 := FND_API.g_false
105 --
106 -- p_custom_setup_id IN NUMBER
107 -- p_object_version IN NUMBER
108 --
109 -- OUT:
110 -- x_return_status OUT VARCHAR2
111 -- x_msg_count OUT NUMBER
112 -- x_msg_data OUT VARCHAR2
113 ------------------------------------------------------------------------------
114 PROCEDURE delete_cust_setup
115 (
116 p_api_version IN NUMBER,
117 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
118 p_commit IN VARCHAR2 := FND_API.g_false,
119
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123
124 p_cust_setup_id IN NUMBER,
125 p_object_version IN NUMBER
126 );
127
128 /****************************************************************************/
129 -- Procedure
130 -- lock_cust_setup
131 -- Purpose
132 -- lock rows in AMS_CUSTOM_SETUPS_B AND AMS_CUSTOM_SETUPS_TL
133 -- Parameters
134 -- IN:
135 -- p_api_version IN NUMBER
136 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
137 --
138 -- p_custom_setup_id IN NUMBER
139 -- p_object_version IN NUMBER
140 --
141 -- OUT:
142 -- x_return_status OUT VARCHAR2
143 -- x_msg_count OUT NUMBER
144 -- x_msg_data OUT VARCHAR2
145 ------------------------------------------------------------------------------
146 PROCEDURE lock_cust_setup
147 (
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
150
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154
155 p_cust_setup_id IN NUMBER,
156 p_object_version IN NUMBER
157 );
158
159 /***************************************************************************/
160 -- Procedure
161 -- validate_cust_setup
162 -- Purpose
163 -- validate the record
164 -- Parameters
165 -- IN:
166 -- p_api_version IN NUMBER
167 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
168 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
169 --
170 -- p_cust_setup_rec IN cust_setup_rec_type
171 --
172 -- OUT:
173 -- x_return_status OUT VARCHAR2
174 -- x_msg_count OUT NUMBER
175 -- x_msg_data OUT VARCHAR2
176 ------------------------------------------------------------------------------
177 PROCEDURE validate_cust_setup
178 (
179 p_api_version IN NUMBER,
180 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
181 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185
186 p_cust_setup_rec IN cust_setup_rec_type
187 );
188
189 /****************************************************************************/
190 -- Procedure
191 -- check_items
192 -- Purpose
193 -- item_level validate
194 -- Parameters
195 -- IN:
196 -- p_validation_mode IN VARCHAR2
197 -- p_cust_setup_rec IN cust_setup_rec_type
198 -- OUT:
199 -- x_return_status OUT VARCHAR2
200 ------------------------------------------------------------------------------
201 PROCEDURE check_items
202 (
203 p_validation_mode IN VARCHAR2,
204 x_return_status OUT NOCOPY VARCHAR2,
205 p_cust_setup_rec IN cust_setup_rec_type
206 );
207
208 /****************************************************************************/
209 -- Procedure
210 -- check_cust_setup_req_items
211 -- Purpose
212 -- check if required items are miss
213 -- Parameters
214 -- IN:
215 -- p_validation_mode IN VARCHAR2
216 -- p_cust_setup_rec IN cust_setup_rec_type
217 -- OUT:
218 -- x_return_status OUT VARCHAR2
219 ------------------------------------------------------------------------------
220 PROCEDURE check_cust_setup_req_items
221 (
222 p_validation_mode IN VARCHAR2,
223 p_cust_setup_rec IN cust_setup_rec_type,
224 x_return_status OUT NOCOPY VARCHAR2
225 );
226
227 /****************************************************************************/
228 -- Procedure
229 -- check_cust_setup_uk_items
230 -- Purpose
231 -- check unique keys
232 -- Parameters
233 -- IN:
234 -- p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
235 -- p_cust_setup_rec IN cust_setup_rec_type
236 -- OUT:
237 -- x_return_status OUT VARCHAR2
238 ------------------------------------------------------------------------------
239 PROCEDURE check_cust_setup_uk_items
240 (
241 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
242 p_cust_setup_rec IN cust_setup_rec_type,
243 x_return_status OUT NOCOPY VARCHAR2
244 );
245
246 /****************************************************************************/
247 -- Procedure
248 -- check_cust_setup_fk_items
249 -- Purpose
250 -- check foreign key items
251 -- Parameters
252 -- IN:
253 -- p_cust_setup_rec IN cust_setup_rec_type
254 -- OUT:
255 -- x_return_status OUT VARCHAR2
256 ------------------------------------------------------------------------------
257 PROCEDURE check_cust_setup_fk_items
258 (
259 p_cust_setup_rec IN cust_setup_rec_type,
260 x_return_status OUT NOCOPY VARCHAR2
261 );
262
263 /****************************************************************************/
264 -- Procedure
265 -- check_cust_setup_flag_items
266 -- Purpose
267 -- check for flag items
268 -- Parameters
269 -- IN:
270 -- p_cust_setup_rec IN cust_setup_rec_type
271 -- OUT:
272 -- x_return_status OUT VARCHAR2
273 ------------------------------------------------------------------------------
274 PROCEDURE check_cust_setup_flag_items
275 (
276 p_cust_setup_rec IN cust_setup_rec_type,
277 x_return_status OUT NOCOPY VARCHAR2
278 );
279
280 /****************************************************************************/
281 -- Procedure
282 -- complete_cust_setup_rec
283 -- Purpose
284 -- replace "g_miss" or NULL values with current database values
285 -- Parameters
286 -- IN:
287 -- p_cust_setup_rec IN cust_setup_rec_type
288 -- OUT:
289 -- x_complete_rec OUT cust_setup_rec_type
290 ------------------------------------------------------------------------------
291 PROCEDURE complete_cust_setup_rec
292 (
293 p_cust_setup_rec IN cust_setup_rec_type,
294 x_complete_rec OUT NOCOPY cust_setup_rec_type
295 );
296
297 /****************************************************************************/
298 -- Procedure
299 -- init_rec
300 --
301 -- HISTORY
302 -- 12/19/1999 julou Created.
303 ------------------------------------------------------------------------------
304 PROCEDURE init_rec
305 (
306 x_cust_setup_rec OUT NOCOPY cust_setup_rec_type
307 );
308
309 END AMS_Cust_Setup_PVT;