1 package AK_FLOW_PVT as
2 /* $Header: akdvflos.pls 120.2 2005/09/15 22:26:53 tshort ship $ */
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AK_FLOW_PVT';
8
9 -- Procedure specs
10
11 --=======================================================
12 -- Procedure CREATE_FLOW
13 --
14 -- Usage Private API for creating a flow. This
15 -- API should only be called by other APIs that are
16 -- owned by the Core Modules Team (AK).
17 --
18 -- Desc Creates a flow using the given info. This
19 -- API should only be called by other APIs that are
20 -- owned by the Core Modules Team (AK).
21 --
22 -- Results The API returns the standard p_return_status parameter
23 -- indicating one of the standard return statuses :
24 -- * Unexpected error
25 -- * Error
26 -- * Success
27 -- Parameters Flow columns except primary_page_appl_id and
28 -- primary_page_code since there are no
29 -- flow pages for this flow at this time.
30 -- p_loader_timestamp : IN optional
31 -- If a timestamp is passed, the API will create the
32 -- record using this timestamp. Only the upload API
33 -- should call with this parameter loaded.
34 --
35 -- Version Initial version number = 1.0
36 -- History Current version number = 1.0
37 --=======================================================
38 procedure CREATE_FLOW (
39 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
40 p_api_version_number IN NUMBER,
41 p_init_msg_tbl IN BOOLEAN := FALSE,
42 p_msg_count OUT NOCOPY NUMBER,
43 p_msg_data OUT NOCOPY VARCHAR2,
44 p_return_status OUT NOCOPY VARCHAR2,
45 p_flow_application_id IN NUMBER,
46 p_flow_code IN VARCHAR2,
47 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
63 p_name IN VARCHAR2,
64 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
65 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
66 p_creation_date IN DATE := FND_API.G_MISS_DATE,
67 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
68 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
69 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
70 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
71 p_pass IN NUMBER,
72 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
73 );
74
75 --=======================================================
76 -- Procedure CREATE_PAGE
77 --
78 -- Usage Private API for creating a flow page. This
79 -- API should only be called by other APIs that are
80 -- owned by the Core Modules Team (AK).
81 --
82 -- Desc Creates a flow page using the given info. This
83 -- API should only be called by other APIs that are
84 -- owned by the Core Modules Team (AK).
85 --
86 -- Results The API returns the standard p_return_status parameter
87 -- indicating one of the standard return statuses :
88 -- * Unexpected error
89 -- * Error
90 -- * Success
91 -- Parameters Flow Page columns except primary_region_appl_id and
92 -- primary_region_code since there are no
93 -- flow page regions for this flow page at this time.
94 -- p_set_primary_page : IN optional
95 -- Set the current page as the primary page of
96 -- the flow if this flag is 'Y'.
97 -- p_loader_timestamp : IN optional
98 -- If a timestamp is passed, the API will create the
99 -- record using this timestamp. Only the upload API
100 -- should call with this parameter loaded.
101 --
102 -- Version Initial version number = 1.0
103 -- History Current version number = 1.0
104 --=======================================================
105 procedure CREATE_PAGE (
106 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107 p_api_version_number IN NUMBER,
108 p_init_msg_tbl IN BOOLEAN := FALSE,
109 p_msg_count OUT NOCOPY NUMBER,
110 p_msg_data OUT NOCOPY VARCHAR2,
111 p_return_status OUT NOCOPY VARCHAR2,
112 p_flow_application_id IN NUMBER,
113 p_flow_code IN VARCHAR2,
114 p_page_application_id IN NUMBER,
115 p_page_code IN VARCHAR2,
116 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
129 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
130 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
131 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_name IN VARCHAR2,
133 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
136 p_creation_date IN DATE := FND_API.G_MISS_DATE,
137 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
138 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
139 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
140 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
141 p_pass IN NUMBER,
142 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
143 );
144
145 --=======================================================
146 -- Procedure CREATE_PAGE_REGION
147 --
148 -- Usage Private API for creating a flow page region. This
149 -- API should only be called by other APIs that are
150 -- owned by the Core Modules Team (AK).
151 --
152 -- Desc Creates a flow page region using the given info. This
153 -- API should only be called by other APIs that are
154 -- owned by the Core Modules Team (AK).
155 --
156 -- Results The API returns the standard p_return_status parameter
157 -- indicating one of the standard return statuses :
158 -- * Unexpected error
159 -- * Error
160 -- * Success
161 -- Parameters Flow Page Region columns
162 -- p_set_primary_region : IN optional
163 -- Set the current page region as the primary region of
164 -- the flow page if this flag is 'Y'.
165 -- p_loader_timestamp : IN optional
166 -- If a timestamp is passed, the API will create the
167 -- record using this timestamp. Only the upload API
168 -- should call with this parameter loaded.
169 --
170 -- Version Initial version number = 1.0
171 -- History Current version number = 1.0
172 --=======================================================
173 procedure CREATE_PAGE_REGION (
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 p_api_version_number IN NUMBER,
176 p_init_msg_tbl IN BOOLEAN := FALSE,
177 p_msg_count OUT NOCOPY NUMBER,
178 p_msg_data OUT NOCOPY VARCHAR2,
179 p_return_status OUT NOCOPY VARCHAR2,
180 p_flow_application_id IN NUMBER,
181 p_flow_code IN VARCHAR2,
182 p_page_application_id IN NUMBER,
183 p_page_code IN VARCHAR2,
184 p_region_application_id IN NUMBER,
185 p_region_code IN VARCHAR2,
186 p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
187 p_region_style IN VARCHAR2,
188 p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
189 p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
190 p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
191 p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
192 p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
193 p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
194 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
195 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
196 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
197 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
198 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
199 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
200 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
201 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
202 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
203 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
204 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
205 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
206 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
207 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
208 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
209 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
210 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
211 p_creation_date IN DATE := FND_API.G_MISS_DATE,
212 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
213 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
214 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
215 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
216 p_pass IN NUMBER,
217 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
218 );
219
220 --=======================================================
221 -- Procedure CREATE_PAGE_REGION_ITEM
222 --
223 -- Usage Private API for creating a flow page region item. This
224 -- API should only be called by other APIs that are
225 -- owned by the Core Modules Team (AK).
226 --
227 -- Desc Creates a flow page region item using the given info.
228 -- This API should only be called by other APIs that are
229 -- owned by the Core Modules Team (AK).
230 --
231 -- Results The API returns the standard p_return_status parameter
232 -- indicating one of the standard return statuses :
233 -- * Unexpected error
234 -- * Error
235 -- * Success
236 -- Parameters Flow Page Region Item columns
237 -- p_loader_timestamp : IN optional
238 -- If a timestamp is passed, the API will create the
239 -- record using this timestamp. Only the upload API
240 -- should call with this parameter loaded.
241 --
242 -- Version Initial version number = 1.0
243 -- History Current version number = 1.0
244 --=======================================================
245 procedure CREATE_PAGE_REGION_ITEM (
246 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
247 p_api_version_number IN NUMBER,
248 p_init_msg_tbl IN BOOLEAN := FALSE,
249 p_msg_count OUT NOCOPY NUMBER,
250 p_msg_data OUT NOCOPY VARCHAR2,
251 p_return_status OUT NOCOPY VARCHAR2,
252 p_flow_application_id IN NUMBER,
253 p_flow_code IN VARCHAR2,
254 p_page_application_id IN NUMBER,
255 p_page_code IN VARCHAR2,
256 p_region_application_id IN NUMBER,
257 p_region_code IN VARCHAR2,
258 p_attribute_application_id IN NUMBER,
259 p_attribute_code IN VARCHAR2,
260 p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
261 p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
262 p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
263 p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
264 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
265 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
266 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
267 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
270 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
271 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
272 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
273 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
274 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
275 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
276 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
281 p_creation_date IN DATE := FND_API.G_MISS_DATE,
282 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
283 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
284 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
285 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
286 p_pass IN NUMBER,
287 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
288 );
289
290 --=======================================================
291 -- Procedure CREATE_REGION_RELATIONS
292 --
293 -- Usage Private API for creating a flow region relation. This
294 -- API should only be called by other APIs that are
295 -- owned by the Core Modules Team (AK).
296 --
297 -- Desc Creates a flow region relation using the given info.
301 -- Results The API returns the standard p_return_status parameter
298 -- This API should only be called by other APIs that are
299 -- owned by the Core Modules Team (AK).
300 --
302 -- indicating one of the standard return statuses :
303 -- * Unexpected error
304 -- * Error
305 -- * Success
306 -- Parameters Flow Region Relation columns
307 -- p_loader_timestamp : IN optional
308 -- If a timestamp is passed, the API will create the
309 -- record using this timestamp. Only the upload API
310 -- should call with this parameter loaded.
311 --
312 -- Version Initial version number = 1.0
313 -- History Current version number = 1.0
314 --=======================================================
315 procedure CREATE_REGION_RELATION (
316 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317 p_api_version_number IN NUMBER,
318 p_init_msg_tbl IN BOOLEAN := FALSE,
319 p_msg_count OUT NOCOPY NUMBER,
320 p_msg_data OUT NOCOPY VARCHAR2,
321 p_return_status OUT NOCOPY VARCHAR2,
322 p_flow_application_id IN NUMBER,
323 p_flow_code IN VARCHAR2,
324 p_foreign_key_name IN VARCHAR2,
325 p_from_page_appl_id IN NUMBER,
326 p_from_page_code IN VARCHAR2,
327 p_from_region_appl_id IN NUMBER,
328 p_from_region_code IN VARCHAR2,
329 p_to_page_appl_id IN NUMBER,
330 p_to_page_code IN VARCHAR2,
331 p_to_region_appl_id IN NUMBER,
332 p_to_region_code IN VARCHAR2,
333 p_application_id IN NUMBER,
334 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
335 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
336 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
337 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
338 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
339 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
340 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
341 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
342 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
343 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
344 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
345 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
346 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
347 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
348 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
349 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
350 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
351 p_creation_date IN DATE := FND_API.G_MISS_DATE,
352 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
353 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
354 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
355 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
356 p_pass IN NUMBER,
357 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
358 );
359
360 --=======================================================
361 -- Procedure DELETE_FLOW
362 --
363 -- Usage Private API for deleting a flow. This
364 -- API should only be called by other APIs that are
365 -- owned by the Core Modules Team (AK).
366 --
367 -- Desc Deletes a flow with the given key value.
368 --
369 -- Results The API returns the standard p_return_status parameter
370 -- indicating one of the standard return statuses :
371 -- * Unexpected error
372 -- * Error
373 -- * Success
374 -- Parameters p_flow_application_id : IN required
375 -- p_flow_code : IN required
376 -- Key value of the flow to be deleted.
377 -- p_delete_cascade : IN required
378 -- If p_delete_cascade flag is 'Y', also delete all
379 -- rows in other tables that references this record.
380 -- Otherwise, this record will not be deleted if there
381 -- are any other rows referencing it.
382 --
383 -- Version Initial version number = 1.0
384 -- History Current version number = 1.0
385 --=======================================================
386 procedure DELETE_FLOW (
387 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
388 p_api_version_number IN NUMBER,
389 p_init_msg_tbl IN BOOLEAN := FALSE,
390 p_msg_count OUT NOCOPY NUMBER,
391 p_msg_data OUT NOCOPY VARCHAR2,
392 p_return_status OUT NOCOPY VARCHAR2,
393 p_flow_application_id IN NUMBER,
394 p_flow_code IN VARCHAR2,
395 p_delete_cascade IN VARCHAR2
396 );
397
398 --=======================================================
399 -- Procedure DELETE_PAGE
400 --
401 -- Usage Private API for deleting a flow page. This
402 -- API should only be called by other APIs that are
403 -- owned by the Core Modules Team (AK).
404 --
408 -- indicating one of the standard return statuses :
405 -- Desc Deletes a flow page with the given key value.
406 --
407 -- Results The API returns the standard p_return_status parameter
409 -- * Unexpected error
410 -- * Error
411 -- * Success
412 -- Parameters p_flow_application_id : IN required
413 -- p_flow_code : IN required
414 -- p_page_application_id : IN required
415 -- p_page_code : IN required
416 -- Key value of the flow page to be deleted.
417 -- p_delete_cascade : IN required
418 -- If p_delete_cascade flag is 'Y', also delete all
419 -- rows in other tables that references this record.
420 -- Otherwise, this record will not be deleted if there
421 -- are any other rows referencing it.
422 --
423 -- Version Initial version number = 1.0
424 -- History Current version number = 1.0
425 --=======================================================
426 procedure DELETE_PAGE (
427 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
428 p_api_version_number IN NUMBER,
429 p_init_msg_tbl IN BOOLEAN := FALSE,
430 p_msg_count OUT NOCOPY NUMBER,
431 p_msg_data OUT NOCOPY VARCHAR2,
432 p_return_status OUT NOCOPY VARCHAR2,
433 p_flow_application_id IN NUMBER,
434 p_flow_code IN VARCHAR2,
435 p_page_application_id IN NUMBER,
436 p_page_code IN VARCHAR2,
437 p_delete_cascade IN VARCHAR2
438 );
439
440 --=======================================================
441 -- Procedure DELETE_PAGE_REGION
442 --
443 -- Usage Private API for deleting a flow page region. This
444 -- API should only be called by other APIs that are
445 -- owned by the Core Modules Team (AK).
446 --
447 -- Desc Deletes a flow page region with the given key value.
448 --
449 -- Results The API returns the standard p_return_status parameter
450 -- indicating one of the standard return statuses :
451 -- * Unexpected error
452 -- * Error
453 -- * Success
454 -- Parameters p_flow_application_id : IN required
455 -- p_flow_code : IN required
456 -- p_page_application_id : IN required
457 -- p_page_code : IN required
458 -- p_region_application_id : IN required
459 -- p_region_code : IN required
460 -- Key value of the flow page region to be deleted.
461 -- p_delete_cascade : IN required
462 -- If p_delete_cascade flag is 'Y', also delete all
463 -- rows in other tables that references this record.
464 -- Otherwise, this record will not be deleted if there
465 -- are any other rows referencing it.
466 --
467 -- Version Initial version number = 1.0
468 -- History Current version number = 1.0
469 --=======================================================
470 procedure DELETE_PAGE_REGION (
471 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
472 p_api_version_number IN NUMBER,
473 p_init_msg_tbl IN BOOLEAN := FALSE,
474 p_msg_count OUT NOCOPY NUMBER,
475 p_msg_data OUT NOCOPY VARCHAR2,
476 p_return_status OUT NOCOPY VARCHAR2,
477 p_flow_application_id IN NUMBER,
478 p_flow_code IN VARCHAR2,
479 p_page_application_id IN NUMBER,
480 p_page_code IN VARCHAR2,
481 p_region_application_id IN NUMBER,
482 p_region_code IN VARCHAR2,
483 p_delete_cascade IN VARCHAR2
484 );
485
486 --=======================================================
487 -- Procedure DELETE_PAGE_REGION_ITEM
488 --
489 -- Usage Private API for deleting a flow page region item.
490 -- This API should only be called by other APIs that are
491 -- owned by the Core Modules Team (AK).
492 --
493 -- Desc Deletes a flow page region item with the given key value.
494 --
495 -- Results The API returns the standard p_return_status parameter
496 -- indicating one of the standard return statuses :
497 -- * Unexpected error
498 -- * Error
499 -- * Success
500 -- Parameters p_flow_application_id : IN required
501 -- p_flow_code : IN required
502 -- p_page_application_id : IN required
503 -- p_page_code : IN required
504 -- p_region_application_id : IN required
505 -- p_region_code : IN required
506 -- p_attribute_application_id : IN required
507 -- p_attribute_code : IN required
508 -- Key value of the flow page region item to be deleted.
509 -- p_delete_cascade : IN required
510 -- If p_delete_cascade flag is 'Y', also delete all
511 -- rows in other tables that references this record.
512 -- Otherwise, this record will not be deleted if there
513 -- are any other rows referencing it.
514 --
515 -- Version Initial version number = 1.0
519 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
516 -- History Current version number = 1.0
517 --=======================================================
518 procedure DELETE_PAGE_REGION_ITEM (
520 p_api_version_number IN NUMBER,
521 p_init_msg_tbl IN BOOLEAN := FALSE,
522 p_msg_count OUT NOCOPY NUMBER,
523 p_msg_data OUT NOCOPY VARCHAR2,
524 p_return_status OUT NOCOPY VARCHAR2,
525 p_flow_application_id IN NUMBER,
526 p_flow_code IN VARCHAR2,
527 p_page_application_id IN NUMBER,
528 p_page_code IN VARCHAR2,
529 p_region_application_id IN NUMBER,
530 p_region_code IN VARCHAR2,
531 p_attribute_application_id IN NUMBER,
532 p_attribute_code IN VARCHAR2,
533 p_delete_cascade IN VARCHAR2
534 );
535
536 --=======================================================
537 -- Procedure DELETE_REGION_RELATION
538 --
539 -- Usage Private API for deleting a flow region relation.
540 -- This API should only be called by other APIs that are
541 -- owned by the Core Modules Team (AK).
542 --
543 -- Desc Deletes a flow region relation with the given key value.
544 --
545 -- Results The API returns the standard p_return_status parameter
546 -- indicating one of the standard return statuses :
547 -- * Unexpected error
548 -- * Error
549 -- * Success
550 -- Parameters p_flow_application_id : IN required
551 -- p_flow_code : IN required
552 -- p_foreign_key_name : IN required
553 -- p_from_page_appl_id : IN required
554 -- p_from_page_code : IN required
555 -- p_from_region_appl_id : IN required
556 -- p_from_region_code : IN required
557 -- p_to_page_appl_id : IN required
558 -- p_to_page_code : IN required
559 -- p_to_region_appl_id : IN required
560 -- p_to_region_code : IN required
561 -- Key value of the flow region relation to be deleted.
562 -- p_delete_cascade : IN required
563 -- If p_delete_cascade flag is 'Y', also delete all
564 -- rows in other tables that references this record.
565 -- Otherwise, this record will not be deleted if there
566 -- are any other rows referencing it.
567 --
568 -- Version Initial version number = 1.0
569 -- History Current version number = 1.0
570 --=======================================================
571 procedure DELETE_REGION_RELATION (
572 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
573 p_api_version_number IN NUMBER,
574 p_init_msg_tbl IN BOOLEAN := FALSE,
575 p_msg_count OUT NOCOPY NUMBER,
576 p_msg_data OUT NOCOPY VARCHAR2,
577 p_return_status OUT NOCOPY VARCHAR2,
578 p_flow_application_id IN NUMBER,
579 p_flow_code IN VARCHAR2,
580 p_foreign_key_name IN VARCHAR2,
581 p_from_page_appl_id IN NUMBER,
582 p_from_page_code IN VARCHAR2,
583 p_from_region_appl_id IN NUMBER,
584 p_from_region_code IN VARCHAR2,
585 p_to_page_appl_id IN NUMBER,
586 p_to_page_code IN VARCHAR2,
587 p_to_region_appl_id IN NUMBER,
588 p_to_region_code IN VARCHAR2,
589 p_delete_cascade IN VARCHAR2
590 );
591
592 --=======================================================
593 -- Function FLOW_EXISTS
594 --
595 -- Usage Private API for checking for the existence of
596 -- a flow with the given key values. This
597 -- API should only be called by other APIs that are
598 -- owned by the Core Modules Team (AK).
599 --
600 -- Desc This API check to see if a flow record
601 -- exists with the given key values.
602 --
603 -- Results The API returns the standard p_return_status parameter
604 -- indicating one of the standard return statuses :
605 -- * Unexpected error
606 -- * Error
607 -- * Success
608 -- This function will return TRUE if such a flow
609 -- exists, or FALSE otherwise.
610 -- Parameters Flow key columns
611 --
612 -- Version Initial version number = 1.0
613 -- History Current version number = 1.0
614 --=======================================================
615 function FLOW_EXISTS (
616 p_api_version_number IN NUMBER,
617 p_return_status OUT NOCOPY VARCHAR2,
618 p_flow_application_id IN NUMBER,
619 p_flow_code IN VARCHAR2
620 ) return BOOLEAN;
621
622 --=======================================================
623 -- Function PAGE_EXISTS
624 --
625 -- Usage Private API for checking for the existence of
626 -- a flow page with the given key values. This
627 -- API should only be called by other APIs that are
628 -- owned by the Core Modules Team (AK).
629 --
630 -- Desc This API check to see if a flow page record
631 -- exists with the given key values.
632 --
636 -- * Error
633 -- Results The API returns the standard p_return_status parameter
634 -- indicating one of the standard return statuses :
635 -- * Unexpected error
637 -- * Success
638 -- This function will return TRUE if such a flow
639 -- exists, or FALSE otherwise.
640 -- Parameters Flow Page key columns
641 --
642 -- Version Initial version number = 1.0
643 -- History Current version number = 1.0
644 --=======================================================
645 function PAGE_EXISTS (
646 p_api_version_number IN NUMBER,
647 p_return_status OUT NOCOPY VARCHAR2,
648 p_flow_application_id IN NUMBER,
649 p_flow_code IN VARCHAR2,
650 p_page_application_id IN NUMBER,
651 p_page_code IN VARCHAR2
652 ) return BOOLEAN;
653
654 --=======================================================
655 -- Function PAGE_REGION_EXISTS
656 --
657 -- Usage Private API for checking for the existence of
658 -- a flow page region with the given key values. This
659 -- API should only be called by other APIs that are
660 -- owned by the Core Modules Team (AK).
661 --
662 -- Desc This API check to see if a flow page region record
663 -- exists with the given key values.
664 --
665 -- Results The API returns the standard p_return_status parameter
666 -- indicating one of the standard return statuses :
667 -- * Unexpected error
668 -- * Error
669 -- * Success
670 -- This function will return TRUE if such a flow
671 -- exists, or FALSE otherwise.
672 -- Parameters Flow Page Region key columns
673 --
674 -- Version Initial version number = 1.0
675 -- History Current version number = 1.0
676 --=======================================================
677 function PAGE_REGION_EXISTS (
678 p_api_version_number IN NUMBER,
679 p_return_status OUT NOCOPY VARCHAR2,
680 p_flow_application_id IN NUMBER,
681 p_flow_code IN VARCHAR2,
682 p_page_application_id IN NUMBER,
683 p_page_code IN VARCHAR2,
684 p_region_application_id IN NUMBER,
685 p_region_code IN VARCHAR2
686 ) return BOOLEAN;
687
688 --=======================================================
689 -- Function PAGE_REGION_ITEM_EXISTS
690 --
691 -- Usage Private API for checking for the existence of
692 -- a flow page region item with the given key values.
693 -- This API should only be called by other APIs that are
694 -- owned by the Core Modules Team (AK).
695 --
696 -- Desc This API check to see if a flow page region item record
697 -- exists with the given key values.
698 --
699 -- Results The API returns the standard p_return_status parameter
700 -- indicating one of the standard return statuses :
701 -- * Unexpected error
702 -- * Error
703 -- * Success
704 -- This function will return TRUE if such a flow
705 -- exists, or FALSE otherwise.
706 -- Parameters Flow Page Region Item key columns
707 --
708 -- Version Initial version number = 1.0
709 -- History Current version number = 1.0
710 --=======================================================
711 function PAGE_REGION_ITEM_EXISTS (
712 p_api_version_number IN NUMBER,
713 p_return_status OUT NOCOPY VARCHAR2,
714 p_flow_application_id IN NUMBER,
715 p_flow_code IN VARCHAR2,
716 p_page_application_id IN NUMBER,
717 p_page_code IN VARCHAR2,
718 p_region_application_id IN NUMBER,
719 p_region_code IN VARCHAR2,
720 p_attribute_application_id IN NUMBER,
721 p_attribute_code IN VARCHAR2
722 ) return BOOLEAN;
723
724 --=======================================================
725 -- Function REGION_RELATION_EXISTS
726 --
727 -- Usage Private API for checking for the existence of
728 -- a flow region relation with the given key values.
729 -- This API should only be called by other APIs that are
730 -- owned by the Core Modules Team (AK).
731 --
732 -- Desc This API check to see if a flow region relation record
733 -- exists with the given key values.
734 --
735 -- Results The API returns the standard p_return_status parameter
736 -- indicating one of the standard return statuses :
737 -- * Unexpected error
738 -- * Error
739 -- * Success
740 -- This function will return TRUE if such a flow
741 -- exists, or FALSE otherwise.
742 -- Parameters Flow Region Relation key columns
743 --
744 -- Version Initial version number = 1.0
745 -- History Current version number = 1.0
746 --=======================================================
747 function REGION_RELATION_EXISTS (
748 p_api_version_number IN NUMBER,
749 p_return_status OUT NOCOPY VARCHAR2,
750 p_flow_application_id IN NUMBER,
751 p_flow_code IN VARCHAR2,
755 p_from_region_appl_id IN NUMBER,
752 p_foreign_key_name IN VARCHAR2,
753 p_from_page_appl_id IN NUMBER,
754 p_from_page_code IN VARCHAR2,
756 p_from_region_code IN VARCHAR2,
757 p_to_page_appl_id IN NUMBER,
758 p_to_page_code IN VARCHAR2,
759 p_to_region_appl_id IN NUMBER,
760 p_to_region_code IN VARCHAR2
761 ) return BOOLEAN;
762
763 --=======================================================
764 -- Procedure UPDATE_FLOW
765 --
766 -- Usage Private API for updating a flow.
767 -- This API should only be called by other APIs
768 -- that are owned by the Core Modules Team (AK).
769 --
770 -- Desc This API updates a flow using the given info
771 --
772 -- Results The API returns the standard p_return_status parameter
773 -- indicating one of the standard return statuses :
774 -- * Unexpected error
775 -- * Error
776 -- * Success
777 -- Parameters Flow columns
778 -- p_loader_timestamp : IN optional
779 -- If a timestamp is passed, the API will update the
780 -- record using this timestamp. Only the upload API
781 -- should call with this parameter loaded.
782 --
783 -- Version Initial version number = 1.0
784 -- History Current version number = 1.0
785 --=======================================================
786 procedure UPDATE_FLOW (
787 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
788 p_api_version_number IN NUMBER,
789 p_init_msg_tbl IN BOOLEAN := FALSE,
790 p_msg_count OUT NOCOPY NUMBER,
791 p_msg_data OUT NOCOPY VARCHAR2,
792 p_return_status OUT NOCOPY VARCHAR2,
793 p_flow_application_id IN NUMBER,
794 p_flow_code IN VARCHAR2,
795 p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
796 p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
797 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
798 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
799 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
800 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
801 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
802 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
803 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
804 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
805 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
806 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
807 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
808 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
809 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
810 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
811 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
812 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
813 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
814 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
815 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
816 p_creation_date IN DATE := FND_API.G_MISS_DATE,
817 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
818 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
819 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
820 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
821 p_pass IN NUMBER,
822 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
823 );
824
825 --=======================================================
826 -- Procedure UPDATE_PAGE
827 --
828 -- Usage Private API for updating a flow page.
829 -- This API should only be called by other APIs
830 -- that are owned by the Core Modules Team (AK).
831 --
832 -- Desc This API updates a flow page using the given info
833 --
834 -- Results The API returns the standard p_return_status parameter
835 -- indicating one of the standard return statuses :
836 -- * Unexpected error
837 -- * Error
838 -- * Success
839 -- Parameters Flow Page columns
840 -- p_set_primary_page : IN optional
841 -- Set the current page as the primary page of
842 -- the flow if this flag is 'Y'.
843 -- p_loader_timestamp : IN optional
844 -- If a timestamp is passed, the API will update the
845 -- record using this timestamp. Only the upload API
846 -- should call with this parameter loaded.
847 --
848 -- Version Initial version number = 1.0
849 -- History Current version number = 1.0
850 --=======================================================
851 procedure UPDATE_PAGE (
852 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
853 p_api_version_number IN NUMBER,
854 p_init_msg_tbl IN BOOLEAN := FALSE,
855 p_msg_count OUT NOCOPY NUMBER,
856 p_msg_data OUT NOCOPY VARCHAR2,
857 p_return_status OUT NOCOPY VARCHAR2,
858 p_flow_application_id IN NUMBER,
862 p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
859 p_flow_code IN VARCHAR2,
860 p_page_application_id IN NUMBER,
861 p_page_code IN VARCHAR2,
863 p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
864 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
865 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
866 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
867 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
868 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
869 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
870 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
871 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
872 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
873 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
874 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
875 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
876 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
877 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
878 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
879 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
880 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
881 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
882 p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
883 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
884 p_creation_date IN DATE := FND_API.G_MISS_DATE,
885 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
886 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
887 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
888 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
889 p_pass IN NUMBER,
890 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
891 );
892
893 --=======================================================
894 -- Procedure UPDATE_PAGE_REGION
895 --
896 -- Usage Private API for updating a flow page region.
897 -- This API should only be called by other APIs
898 -- that are owned by the Core Modules Team (AK).
899 --
900 -- Desc This API updates a flow page region using the given info
901 --
902 -- Results The API returns the standard p_return_status parameter
903 -- indicating one of the standard return statuses :
904 -- * Unexpected error
905 -- * Error
906 -- * Success
907 -- Parameters Flow Page Region columns
908 -- p_set_primary_region : IN optional
909 -- Set the current page region as the primary region of
910 -- the flow page if this flag is 'Y'.
911 -- p_loader_timestamp : IN optional
912 -- If a timestamp is passed, the API will update the
913 -- record using this timestamp. Only the upload API
914 -- should call with this parameter loaded.
915 --
916 -- Version Initial version number = 1.0
917 -- History Current version number = 1.0
918 --=======================================================
919 procedure UPDATE_PAGE_REGION (
920 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
921 p_api_version_number IN NUMBER,
922 p_init_msg_tbl IN BOOLEAN := FALSE,
923 p_msg_count OUT NOCOPY NUMBER,
924 p_msg_data OUT NOCOPY VARCHAR2,
925 p_return_status OUT NOCOPY VARCHAR2,
926 p_flow_application_id IN NUMBER,
927 p_flow_code IN VARCHAR2,
928 p_page_application_id IN NUMBER,
929 p_page_code IN VARCHAR2,
930 p_region_application_id IN NUMBER,
931 p_region_code IN VARCHAR2,
932 p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
933 p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
934 p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
935 p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
936 p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
937 p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
938 p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
939 p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
940 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
942 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
945 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
955 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
957 p_creation_date IN DATE := FND_API.G_MISS_DATE,
959 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
960 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
961 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
962 p_pass IN NUMBER,
963 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
964 );
965
966 --=======================================================
967 -- Procedure UPDATE_PAGE_REGION_ITEM
968 --
969 -- Usage Private API for updating a flow page region item.
970 -- This API should only be called by other APIs
971 -- that are owned by the Core Modules Team (AK).
972 --
973 -- Desc This API updates a flow page region item using the
974 -- given info
975 --
976 -- Results The API returns the standard p_return_status parameter
977 -- indicating one of the standard return statuses :
978 -- * Unexpected error
979 -- * Error
980 -- * Success
981 -- Parameters Flow Page Region Item columns
982 -- p_loader_timestamp : IN optional
983 -- If a timestamp is passed, the API will update the
984 -- record using this timestamp. Only the upload API
985 -- should call with this parameter loaded.
986 --
987 -- Version Initial version number = 1.0
988 -- History Current version number = 1.0
989 --=======================================================
990 procedure UPDATE_PAGE_REGION_ITEM (
991 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
992 p_api_version_number IN NUMBER,
993 p_init_msg_tbl IN BOOLEAN := FALSE,
994 p_msg_count OUT NOCOPY NUMBER,
995 p_msg_data OUT NOCOPY VARCHAR2,
996 p_return_status OUT NOCOPY VARCHAR2,
997 p_flow_application_id IN NUMBER,
998 p_flow_code IN VARCHAR2,
999 p_page_application_id IN NUMBER,
1000 p_page_code IN VARCHAR2,
1001 p_region_application_id IN NUMBER,
1002 p_region_code IN VARCHAR2,
1003 p_attribute_application_id IN NUMBER,
1004 p_attribute_code IN VARCHAR2,
1005 p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1006 p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1007 p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
1008 p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1009 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1010 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1011 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1012 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1013 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1014 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1015 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1016 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1017 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1018 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1019 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1020 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1021 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1022 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1023 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1024 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1025 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1026 p_creation_date IN DATE := FND_API.G_MISS_DATE,
1027 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1028 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1029 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1030 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1031 p_pass IN NUMBER,
1032 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1033 );
1034
1035 --=======================================================
1036 -- Procedure UPDATE_REGION_RELATION
1037 --
1038 -- Usage Private API for updating a flow region relation.
1039 -- This API should only be called by other APIs
1040 -- that are owned by the Core Modules Team (AK).
1041 --
1042 -- Desc This API updates a flow region relation using the
1043 -- given info
1044 --
1045 -- Results The API returns the standard p_return_status parameter
1046 -- indicating one of the standard return statuses :
1047 -- * Unexpected error
1048 -- * Error
1049 -- * Success
1050 -- Parameters Flow Region Relation columns
1051 -- p_loader_timestamp : IN optional
1052 -- If a timestamp is passed, the API will update the
1053 -- record using this timestamp. Only the upload API
1054 -- should call with this parameter loaded.
1055 --
1056 -- Version Initial version number = 1.0
1057 -- History Current version number = 1.0
1058 --=======================================================
1059 procedure UPDATE_REGION_RELATION (
1060 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1064 p_msg_data OUT NOCOPY VARCHAR2,
1061 p_api_version_number IN NUMBER,
1062 p_init_msg_tbl IN BOOLEAN := FALSE,
1063 p_msg_count OUT NOCOPY NUMBER,
1065 p_return_status OUT NOCOPY VARCHAR2,
1066 p_flow_application_id IN NUMBER,
1067 p_flow_code IN VARCHAR2,
1068 p_foreign_key_name IN VARCHAR2,
1069 p_from_page_appl_id IN NUMBER,
1070 p_from_page_code IN VARCHAR2,
1071 p_from_region_appl_id IN NUMBER,
1072 p_from_region_code IN VARCHAR2,
1073 p_to_page_appl_id IN NUMBER,
1074 p_to_page_code IN VARCHAR2,
1075 p_to_region_appl_id IN NUMBER,
1076 p_to_region_code IN VARCHAR2,
1077 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1078 p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
1079 p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1080 p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1081 p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1082 p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1083 p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1084 p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1085 p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1086 p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1087 p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1088 p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1089 p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1090 p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1091 p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1092 p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1093 p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
1094 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
1095 p_creation_date IN DATE := FND_API.G_MISS_DATE,
1096 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
1097 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
1098 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
1099 p_loader_timestamp IN DATE := FND_API.G_MISS_DATE,
1100 p_pass IN NUMBER,
1101 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1102 );
1103
1104 procedure CHECK_DISPLAY_SEQUENCE (
1105 p_validation_level IN NUMBER,
1106 p_flow_code IN VARCHAR2,
1107 p_flow_application_id IN NUMBER,
1108 p_page_code IN VARCHAR2,
1109 p_page_application_id IN NUMBER,
1110 p_region_code IN VARCHAR2,
1111 p_region_application_id IN NUMBER,
1112 p_display_sequence IN NUMBER,
1113 p_return_status OUT NOCOPY VARCHAR2,
1114 p_msg_count OUT NOCOPY NUMBER,
1115 p_msg_data OUT NOCOPY VARCHAR2,
1116 p_pass IN NUMBER,
1117 p_copy_redo_flag IN OUT NOCOPY BOOLEAN
1118 );
1119
1120 end AK_FLOW_PVT;
[Home] [Help]