1 package AK_FLOW_GRP as
2 /* $Header: akdgflos.pls 120.2 2005/09/15 22:26:34 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_GRP';
8
9 /* Procedure specs */
10
11 --=======================================================
12 -- Procedure CREATE_FLOW
13 --
14 -- Usage Group API for creating a flow
15 --
16 -- Desc Calls the private API to create a flow
17 -- using the given info
18 --
19 -- Results The API returns the standard p_return_status parameter
20 -- indicating one of the standard return statuses :
21 -- * Unexpected error
22 -- * Error
23 -- * Success
24 -- Parameters Flow columns except primary_page_appl_id and
25 -- primary_page_code since there are no
26 -- flow pages for this flow at this time.
27 --
28 -- Version Initial version number = 1.0
29 -- History Current version number = 1.0
30 --=======================================================
31 procedure CREATE_FLOW (
32 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
33 p_api_version_number IN NUMBER,
34 p_init_msg_tbl IN BOOLEAN := FALSE,
35 p_msg_count OUT NOCOPY NUMBER,
36 p_msg_data OUT NOCOPY VARCHAR2,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_flow_application_id IN NUMBER,
39 p_flow_code IN VARCHAR2,
40 p_name IN VARCHAR2,
41 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
42 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
43 p_creation_date IN DATE := FND_API.G_MISS_DATE,
44 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
45 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
46 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
47 );
48
49
50 --=======================================================
51 -- Procedure CREATE_PAGE
52 --
53 -- Usage Group API for creating a flow page
54 --
55 -- Desc Calls the private API to create a flow page
56 -- using the given info
57 --
58 -- Results The API returns the standard p_return_status parameter
59 -- indicating one of the standard return statuses :
60 -- * Unexpected error
61 -- * Error
62 -- * Success
63 -- Parameters Flow Page columns except primary_region_appl_id and
64 -- primary_region_code since there are no
65 -- flow page regions for this flow page at this time.
66 -- p_set_primary_page : IN optional
67 -- Set the current page as the primary page of
68 -- the flow if this flag is 'Y'.
69 --
70 -- Version Initial version number = 1.0
71 -- History Current version number = 1.0
72 --=======================================================
73 procedure CREATE_PAGE (
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 p_api_version_number IN NUMBER,
76 p_init_msg_tbl IN BOOLEAN := FALSE,
77 p_msg_count OUT NOCOPY NUMBER,
78 p_msg_data OUT NOCOPY VARCHAR2,
79 p_return_status OUT NOCOPY VARCHAR2,
80 p_flow_application_id IN NUMBER,
81 p_flow_code IN VARCHAR2,
82 p_page_application_id IN NUMBER,
83 p_page_code IN VARCHAR2,
84 p_name IN VARCHAR2,
85 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
88 p_creation_date IN DATE := FND_API.G_MISS_DATE,
89 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
90 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
91 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
92 );
93
94 --=======================================================
95 -- Procedure CREATE_PAGE_REGION
96 --
97 -- Usage Group API for creating a flow page region
98 --
99 -- Desc Calls the private API to create a flow page region
100 -- using the given info
101 --
102 -- Results The API returns the standard p_return_status parameter
103 -- indicating one of the standard return statuses :
104 -- * Unexpected error
105 -- * Error
106 -- * Success
107 -- Parameters Flow Page Region columns
108 -- p_foreign_key_name : IN optional
109 -- If a foreign key name is passed, and that this page
110 -- region has a parent region, then this API will
111 -- create an intrapage flow region relation connecting
112 -- this page region with the parent region using the
113 -- foreign key name. If there is already an intrapage
114 -- flow region relation exists connecting these two
115 -- page regions, it will be replaced by a new one using
116 -- this foreign key.
117 -- p_set_primary_region : IN optional
118 -- Set the current page region as the primary region of
119 -- the flow page if this flag is 'Y'.
120 --
121 -- Version Initial version number = 1.0
122 -- History Current version number = 1.0
123 --=======================================================
124 procedure CREATE_PAGE_REGION (
125 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126 p_api_version_number IN NUMBER,
127 p_init_msg_tbl IN BOOLEAN := FALSE,
128 p_msg_count OUT NOCOPY NUMBER,
129 p_msg_data OUT NOCOPY VARCHAR2,
130 p_return_status OUT NOCOPY VARCHAR2,
131 p_flow_application_id IN NUMBER,
132 p_flow_code IN VARCHAR2,
133 p_page_application_id IN NUMBER,
134 p_page_code IN VARCHAR2,
135 p_region_application_id IN NUMBER,
136 p_region_code IN VARCHAR2,
137 p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
138 p_region_style IN VARCHAR2,
139 p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
140 p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
142 p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
143 p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
145 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
146 p_creation_date IN DATE := FND_API.G_MISS_DATE,
147 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
148 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
149 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
150 );
151
152 --=======================================================
153 -- Procedure CREATE_PAGE_REGION_ITEM
154 --
155 -- Usage Group API for creating a page region item
156 --
157 -- Desc Calls the private API to create a page region
158 -- item using the given info
159 --
160 -- Results The API returns the standard p_return_status parameter
161 -- indicating one of the standard return statuses :
162 -- * Unexpected error
163 -- * Error
164 -- * Success
165 -- Parameters Page Region Item columns
166 --
167 -- Version Initial version number = 1.0
168 -- History Current version number = 1.0
169 --=======================================================
170 procedure CREATE_PAGE_REGION_ITEM (
171 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172 p_api_version_number IN NUMBER,
173 p_init_msg_tbl IN BOOLEAN := FALSE,
174 p_msg_count OUT NOCOPY NUMBER,
175 p_msg_data OUT NOCOPY VARCHAR2,
176 p_return_status OUT NOCOPY VARCHAR2,
177 p_flow_application_id IN NUMBER,
178 p_flow_code IN VARCHAR2,
179 p_page_application_id IN NUMBER,
180 p_page_code IN VARCHAR2,
181 p_region_application_id IN NUMBER,
182 p_region_code IN VARCHAR2,
183 p_attribute_application_id IN NUMBER,
184 p_attribute_code IN VARCHAR2,
185 p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
186 p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
187 p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
188 p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
189 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
190 p_creation_date IN DATE := FND_API.G_MISS_DATE,
191 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
192 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
193 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
194 );
195
196 --=======================================================
197 -- Procedure CREATE_REGION_RELATION
198 --
199 -- Usage Group API for creating a flow region relation
200 --
201 -- Desc Calls the private API to create a flow region
202 -- relation using the given info
203 --
204 -- Results The API returns the standard p_return_status parameter
205 -- indicating one of the standard return statuses :
206 -- * Unexpected error
207 -- * Error
208 -- * Success
209 -- Parameters Flow Region Relation columns
210 --
211 -- Version Initial version number = 1.0
212 -- History Current version number = 1.0
213 --=======================================================
214 procedure CREATE_REGION_RELATION (
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216 p_api_version_number IN NUMBER,
217 p_init_msg_tbl IN BOOLEAN := FALSE,
218 p_msg_count OUT NOCOPY NUMBER,
219 p_msg_data OUT NOCOPY VARCHAR2,
220 p_return_status OUT NOCOPY VARCHAR2,
221 p_flow_application_id IN NUMBER,
222 p_flow_code IN VARCHAR2,
223 p_foreign_key_name IN VARCHAR2,
224 p_from_page_appl_id IN NUMBER,
225 p_from_page_code IN VARCHAR2,
226 p_from_region_appl_id IN NUMBER,
227 p_from_region_code IN VARCHAR2,
228 p_to_page_appl_id IN NUMBER,
229 p_to_page_code IN VARCHAR2,
230 p_to_region_appl_id IN NUMBER,
231 p_to_region_code IN VARCHAR2,
232 p_application_id IN NUMBER,
233 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
234 p_creation_date IN DATE := FND_API.G_MISS_DATE,
235 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
236 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
237 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
238 );
239
240 --=======================================================
241 -- Procedure DELETE_FLOW
242 --
243 -- Usage Group API for deleting a flow
244 --
245 -- Desc Calls the private API to delete a flow
246 -- with the given key value.
247 --
248 -- Results The API returns the standard p_return_status parameter
249 -- indicating one of the standard return statuses :
250 -- * Unexpected error
251 -- * Error
252 -- * Success
253 -- Parameters p_flow_application_id : IN required
254 -- p_flow_code : IN required
255 -- Key value of the flow to be deleted.
256 -- p_delete_cascade : IN required
257 -- If p_delete_cascade flag is 'Y', also delete all
258 -- rows in other tables that references this record.
259 -- Otherwise, this record will not be deleted if there
260 -- are any other rows referencing it.
261 --
262 -- Version Initial version number = 1.0
263 -- History Current version number = 1.0
264 --=======================================================
265 procedure DELETE_FLOW (
266 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
267 p_api_version_number IN NUMBER,
268 p_init_msg_tbl IN BOOLEAN := FALSE,
269 p_msg_count OUT NOCOPY NUMBER,
270 p_msg_data OUT NOCOPY VARCHAR2,
271 p_return_status OUT NOCOPY VARCHAR2,
272 p_flow_application_id IN NUMBER,
273 p_flow_code IN VARCHAR2,
274 p_delete_cascade IN VARCHAR2 := 'N'
275 );
276
277 --=======================================================
278 -- Procedure DELETE_PAGE
279 --
280 -- Usage Group API for deleting a flow page
281 --
282 -- Desc Calls the private API to delete a flow page
283 -- with the given key value.
284 --
285 -- Results The API returns the standard p_return_status parameter
286 -- indicating one of the standard return statuses :
287 -- * Unexpected error
288 -- * Error
289 -- * Success
290 -- Parameters p_flow_application_id : IN required
291 -- p_flow_code : IN required
292 -- p_page_application_id : IN required
293 -- p_page_code : IN required
294 -- Key value of the flow page to be deleted.
295 -- p_delete_cascade : IN required
296 -- If p_delete_cascade flag is 'Y', also delete all
297 -- rows in other tables that references this record.
298 -- Otherwise, this record will not be deleted if there
299 -- are any other rows referencing it.
300 --
301 -- Version Initial version number = 1.0
302 -- History Current version number = 1.0
303 --=======================================================
304 procedure DELETE_PAGE (
305 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306 p_api_version_number IN NUMBER,
307 p_init_msg_tbl IN BOOLEAN := FALSE,
308 p_msg_count OUT NOCOPY NUMBER,
309 p_msg_data OUT NOCOPY VARCHAR2,
310 p_return_status OUT NOCOPY VARCHAR2,
311 p_flow_application_id IN NUMBER,
312 p_flow_code IN VARCHAR2,
313 p_page_application_id IN NUMBER,
314 p_page_code IN VARCHAR2,
315 p_delete_cascade IN VARCHAR2 := 'N'
316 );
317
318 --=======================================================
319 -- Procedure DELETE_PAGE_REGION
320 --
321 -- Usage Group API for deleting a flow page region
322 --
323 -- Desc Calls the private API to delete a flow page
324 -- region with the given key value.
325 --
326 -- Results The API returns the standard p_return_status parameter
327 -- indicating one of the standard return statuses :
328 -- * Unexpected error
329 -- * Error
330 -- * Success
331 -- Parameters p_flow_application_id : IN required
332 -- p_flow_code : IN required
333 -- p_page_application_id : IN required
334 -- p_page_code : IN required
335 -- p_region_application_id : IN required
336 -- p_region_code : IN required
337 -- Key value of the flow page region to be deleted.
338 -- p_delete_cascade : IN required
339 -- If p_delete_cascade flag is 'Y', also delete all
340 -- rows in other tables that references this record.
341 -- Otherwise, this record will not be deleted if there
342 -- are any other rows referencing it.
343 --
344 -- Version Initial version number = 1.0
345 -- History Current version number = 1.0
346 --=======================================================
347 procedure DELETE_PAGE_REGION (
351 p_msg_count OUT NOCOPY NUMBER,
348 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
349 p_api_version_number IN NUMBER,
350 p_init_msg_tbl IN BOOLEAN := FALSE,
352 p_msg_data OUT NOCOPY VARCHAR2,
353 p_return_status OUT NOCOPY VARCHAR2,
354 p_flow_application_id IN NUMBER,
355 p_flow_code IN VARCHAR2,
356 p_page_application_id IN NUMBER,
357 p_page_code IN VARCHAR2,
358 p_region_application_id IN NUMBER,
359 p_region_code IN VARCHAR2,
360 p_delete_cascade IN VARCHAR2 := 'N'
361 );
362
363 --=======================================================
364 -- Procedure DELETE_PAGE_REGION_ITEM
365 --
366 -- Usage Group API for deleting a flow page region item
367 --
368 -- Desc Calls the private API to delete a flow page
369 -- region item with the given key value.
370 --
371 -- Results The API returns the standard p_return_status parameter
372 -- indicating one of the standard return statuses :
373 -- * Unexpected error
374 -- * Error
375 -- * Success
376 -- Parameters p_flow_application_id : IN required
377 -- p_flow_code : IN required
378 -- p_page_application_id : IN required
379 -- p_page_code : IN required
380 -- p_region_application_id : IN required
381 -- p_region_code : IN required
382 -- p_attribute_application_id : IN required
383 -- p_attribute_code : IN required
384 -- Key value of the flow page region item to be deleted.
385 -- p_delete_cascade : IN required
386 -- If p_delete_cascade flag is 'Y', also delete all
387 -- rows in other tables that references this record.
388 -- Otherwise, this record will not be deleted if there
389 -- are any other rows referencing it.
390 --
391 -- Version Initial version number = 1.0
392 -- History Current version number = 1.0
393 --=======================================================
394 procedure DELETE_PAGE_REGION_ITEM (
395 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
396 p_api_version_number IN NUMBER,
397 p_init_msg_tbl IN BOOLEAN := FALSE,
398 p_msg_count OUT NOCOPY NUMBER,
399 p_msg_data OUT NOCOPY VARCHAR2,
400 p_return_status OUT NOCOPY VARCHAR2,
401 p_flow_application_id IN NUMBER,
402 p_flow_code IN VARCHAR2,
403 p_page_application_id IN NUMBER,
404 p_page_code IN VARCHAR2,
405 p_region_application_id IN NUMBER,
406 p_region_code IN VARCHAR2,
407 p_attribute_application_id IN NUMBER,
408 p_attribute_code IN VARCHAR2,
409 p_delete_cascade IN VARCHAR2 := 'N'
410 );
411
412 --=======================================================
413 -- Procedure DELETE_REGION_RELATION
414 --
415 -- Usage Group API for deleting a flow region relation
416 --
417 -- Desc Calls the private API to delete a flow region
418 -- relation with the given key value.
419 --
420 -- Results The API returns the standard p_return_status parameter
421 -- indicating one of the standard return statuses :
422 -- * Unexpected error
423 -- * Error
424 -- * Success
425 -- Parameters p_flow_application_id : IN required
426 -- p_flow_code : IN required
427 -- p_foreign_key_name : IN required
428 -- p_from_page_appl_id : IN required
429 -- p_from_page_code : IN required
430 -- p_from_region_appl_id : IN required
431 -- p_from_region_code : IN required
432 -- p_to_page_appl_id : IN required
433 -- p_to_page_code : IN required
434 -- p_to_region_appl_id : IN required
435 -- p_to_region_code : IN required
436 -- Key value of the flow page region item to be deleted.
437 -- p_delete_cascade : IN required
438 -- If p_delete_cascade flag is 'Y', also delete all
439 -- rows in other tables that references this record.
440 -- Otherwise, this record will not be deleted if there
441 -- are any other rows referencing it.
442 --
443 -- Version Initial version number = 1.0
444 -- History Current version number = 1.0
445 --=======================================================
446 procedure DELETE_REGION_RELATION (
447 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448 p_api_version_number IN NUMBER,
449 p_init_msg_tbl IN BOOLEAN := FALSE,
450 p_msg_count OUT NOCOPY NUMBER,
451 p_msg_data OUT NOCOPY VARCHAR2,
452 p_return_status OUT NOCOPY VARCHAR2,
453 p_flow_application_id IN NUMBER,
454 p_flow_code IN VARCHAR2,
455 p_foreign_key_name IN VARCHAR2,
456 p_from_page_appl_id IN NUMBER,
457 p_from_page_code IN VARCHAR2,
458 p_from_region_appl_id IN NUMBER,
459 p_from_region_code IN VARCHAR2,
463 p_to_region_code IN VARCHAR2,
460 p_to_page_appl_id IN NUMBER,
461 p_to_page_code IN VARCHAR2,
462 p_to_region_appl_id IN NUMBER,
464 p_delete_cascade IN VARCHAR2 := 'N'
465 );
466
467 --===========================================================
468 -- Procedure DOWNLOAD_FLOW
469 --
470 -- Usage Group API for downloading flows
471 --
472 -- Desc This API first write out standard loader
473 -- file header for flows to a flat file.
474 -- Then it calls the private API to extract the
475 -- flows selected by application ID or by
476 -- key values from the database to the output file.
477 -- If a flow is selected for writing to the loader
478 -- file, all its children records (including flow
479 -- pages, flow page regions, flow page region items,
480 -- and flow region relations) will also be written.
481 --
482 -- Results The API returns the standard p_return_status parameter
483 -- indicating one of the standard return statuses :
484 -- * Unexpected error
485 -- * Error
486 -- * Success
487 -- Parameters
488 -- p_nls_language : IN optional
489 -- NLS language for database. If none if given,
490 -- the current NLS language will be used.
491 --
492 -- One of the following parameters must be provided:
493 --
494 -- p_application_id : IN optional
495 -- If given, all attributes for this application ID
496 -- will be written to the output file.
497 -- p_application_short_name : IN optional
498 -- If given, all attributes for this application short
499 -- name will be written to the output file.
500 -- Application short name will be ignored if an
501 -- application ID is given.
502 -- p_flow_pk_tbl : IN optional
503 -- If given, only flows whose key values are
504 -- included in this table will be written to the
505 -- output file.
506 --
507 --
508 -- Version Initial version number = 1.0
509 -- History Current version number = 1.0
510 --===========================================================
511 procedure DOWNLOAD_FLOW (
512 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
513 p_api_version_number IN NUMBER,
514 p_init_msg_tbl IN BOOLEAN := FALSE,
515 p_msg_count OUT NOCOPY NUMBER,
516 p_msg_data OUT NOCOPY VARCHAR2,
517 p_return_status OUT NOCOPY VARCHAR2,
518 p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
519 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
520 p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
521 p_flow_pk_tbl IN AK_FLOW_PUB.Flow_PK_Tbl_Type
522 := AK_FLOW_PUB.G_MISS_FLOW_PK_TBL
523 );
524
525 --=======================================================
526 -- Procedure UPDATE_FLOW
527 --
528 -- Usage Group API for updating a flow
529 --
530 -- Desc This API calls the private API to update
531 -- a flow using the given info
532 --
533 -- Results The API returns the standard p_return_status parameter
534 -- indicating one of the standard return statuses :
535 -- * Unexpected error
536 -- * Error
537 -- * Success
538 -- Parameters Flow columns
539 --
540 -- Version Initial version number = 1.0
541 -- History Current version number = 1.0
542 --=======================================================
543 procedure UPDATE_FLOW (
544 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
545 p_api_version_number IN NUMBER,
546 p_init_msg_tbl IN BOOLEAN := FALSE,
547 p_msg_count OUT NOCOPY NUMBER,
548 p_msg_data OUT NOCOPY VARCHAR2,
549 p_return_status OUT NOCOPY VARCHAR2,
550 p_flow_application_id IN NUMBER,
551 p_flow_code IN VARCHAR2,
552 p_primary_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
553 p_primary_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
554 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
555 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
556 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
557 p_creation_date IN DATE := FND_API.G_MISS_DATE,
558 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
559 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
560 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
561 );
562
563 --=======================================================
564 -- Procedure UPDATE_PAGE
565 --
566 -- Usage Group API for updating a flow page
567 --
568 -- Desc This API calls the private API to update
569 -- a flow page using the given info
570 --
571 -- Results The API returns the standard p_return_status parameter
572 -- indicating one of the standard return statuses :
573 -- * Unexpected error
574 -- * Error
575 -- * Success
579 -- the flow if this flag is 'Y'.
576 -- Parameters Flow Page columns
577 -- p_set_primary_page : IN optional
578 -- Set the current page as the primary page of
580 --
581 -- Version Initial version number = 1.0
582 -- History Current version number = 1.0
583 --=======================================================
584 procedure UPDATE_PAGE (
585 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
586 p_api_version_number IN NUMBER,
587 p_init_msg_tbl IN BOOLEAN := FALSE,
588 p_msg_count OUT NOCOPY NUMBER,
589 p_msg_data OUT NOCOPY VARCHAR2,
590 p_return_status OUT NOCOPY VARCHAR2,
591 p_flow_application_id IN NUMBER,
592 p_flow_code IN VARCHAR2,
593 p_page_application_id IN NUMBER,
594 p_page_code IN VARCHAR2,
595 p_primary_region_appl_id IN NUMBER := FND_API.G_MISS_NUM,
596 p_primary_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
597 p_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
598 p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
599 p_set_primary_page IN VARCHAR2 := FND_API.G_MISS_CHAR,
600 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
601 p_creation_date IN DATE := FND_API.G_MISS_DATE,
602 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
603 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
604 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
605 );
606
607 --=======================================================
608 -- Procedure UPDATE_PAGE_REGION
609 --
610 -- Usage Group API for updating a flow page region
611 --
612 -- Desc This API calls the private API to update
613 -- a flow page region using the given info
614 --
615 -- Results The API returns the standard p_return_status parameter
616 -- indicating one of the standard return statuses :
617 -- * Unexpected error
618 -- * Error
619 -- * Success
620 -- Parameters Flow Page Region columns
621 -- p_foreign_key_name : IN optional
622 -- If a foreign key name is passed, and that this page
623 -- region has a parent region, then this API will
624 -- create an intrapage flow region relation connecting
625 -- this page region with the parent region using the
626 -- foreign key name. If there is already an intrapage
627 -- flow region relation exists connecting these two
628 -- page regions, it will be replaced by a new one using
629 -- this foreign key.
630 -- p_set_primary_region : IN optional
631 -- Set the current page region as the primary region of
632 -- the flow page if this flag is 'Y'.
633 --
634 -- Version Initial version number = 1.0
635 -- History Current version number = 1.0
636 --=======================================================
637 procedure UPDATE_PAGE_REGION (
638 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
639 p_api_version_number IN NUMBER,
640 p_init_msg_tbl IN BOOLEAN := FALSE,
641 p_msg_count OUT NOCOPY NUMBER,
642 p_msg_data OUT NOCOPY VARCHAR2,
643 p_return_status OUT NOCOPY VARCHAR2,
644 p_flow_application_id IN NUMBER,
645 p_flow_code IN VARCHAR2,
646 p_page_application_id IN NUMBER,
647 p_page_code IN VARCHAR2,
648 p_region_application_id IN NUMBER,
649 p_region_code IN VARCHAR2,
650 p_display_sequence IN NUMBER := FND_API.G_MISS_NUM,
651 p_region_style IN VARCHAR2 := FND_API.G_MISS_CHAR,
652 p_num_columns IN NUMBER := FND_API.G_MISS_NUM,
653 p_icx_custom_call IN VARCHAR2 := FND_API.G_MISS_CHAR,
654 p_parent_region_application_id IN NUMBER := FND_API.G_MISS_NUM,
655 p_parent_region_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
656 p_foreign_key_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
657 p_set_primary_region IN VARCHAR2 := FND_API.G_MISS_CHAR,
658 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
659 p_creation_date IN DATE := FND_API.G_MISS_DATE,
660 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
661 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
662 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
663 );
664
665 --=======================================================
666 -- Procedure UPDATE_PAGE_REGION_ITEM
667 --
668 -- Usage Group API for updating a flow page region item
669 --
670 -- Desc This API calls the private API to update
671 -- a flow page region item using the given info
672 --
673 -- Results The API returns the standard p_return_status parameter
674 -- indicating one of the standard return statuses :
675 -- * Unexpected error
676 -- * Error
677 -- * Success
678 -- Parameters Flow Page Region Item columns
679 --
680 -- Version Initial version number = 1.0
681 -- History Current version number = 1.0
682 --=======================================================
686 p_init_msg_tbl IN BOOLEAN := FALSE,
683 procedure UPDATE_PAGE_REGION_ITEM (
684 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
685 p_api_version_number IN NUMBER,
687 p_msg_count OUT NOCOPY NUMBER,
688 p_msg_data OUT NOCOPY VARCHAR2,
689 p_return_status OUT NOCOPY VARCHAR2,
690 p_flow_application_id IN NUMBER,
691 p_flow_code IN VARCHAR2,
692 p_page_application_id IN NUMBER,
693 p_page_code IN VARCHAR2,
694 p_region_application_id IN NUMBER,
695 p_region_code IN VARCHAR2,
696 p_attribute_application_id IN NUMBER,
697 p_attribute_code IN VARCHAR2,
698 p_to_page_appl_id IN NUMBER := FND_API.G_MISS_NUM,
699 p_to_page_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
700 p_to_url_attribute_appl_id IN NUMBER := FND_API.G_MISS_NUM,
701 p_to_url_attribute_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
702 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
703 p_creation_date IN DATE := FND_API.G_MISS_DATE,
704 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
705 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
706 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
707 );
708
709 --=======================================================
710 -- Procedure UPDATE_REGION_RELATION
711 --
712 -- Usage Group API for updating a flow region relation
713 --
714 -- Desc This API calls the private API to update
715 -- a flow region relation using the given info
716 --
717 -- Results The API returns the standard p_return_status parameter
718 -- indicating one of the standard return statuses :
719 -- * Unexpected error
720 -- * Error
721 -- * Success
722 -- Parameters Flow Region Relation columns
723 --
724 -- Version Initial version number = 1.0
725 -- History Current version number = 1.0
726 --=======================================================
727 procedure UPDATE_REGION_RELATION (
728 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729 p_api_version_number IN NUMBER,
730 p_init_msg_tbl IN BOOLEAN := FALSE,
731 p_msg_count OUT NOCOPY NUMBER,
732 p_msg_data OUT NOCOPY VARCHAR2,
733 p_return_status OUT NOCOPY VARCHAR2,
734 p_flow_application_id IN NUMBER,
735 p_flow_code IN VARCHAR2,
736 p_foreign_key_name IN VARCHAR2,
737 p_from_page_appl_id IN NUMBER,
738 p_from_page_code IN VARCHAR2,
739 p_from_region_appl_id IN NUMBER,
740 p_from_region_code IN VARCHAR2,
741 p_to_page_appl_id IN NUMBER,
742 p_to_page_code IN VARCHAR2,
743 p_to_region_appl_id IN NUMBER,
744 p_to_region_code IN VARCHAR2,
745 p_application_id IN NUMBER := FND_API.G_MISS_NUM,
746 p_created_by IN NUMBER := FND_API.G_MISS_NUM,
747 p_creation_date IN DATE := FND_API.G_MISS_DATE,
748 p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
749 p_last_update_date IN DATE := FND_API.G_MISS_DATE,
750 p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
751 );
752
753 end AK_FLOW_GRP;