1 PACKAGE fnd_flex_loader_apis AUTHID CURRENT_USER AS
2 /* $Header: AFFFLDRS.pls 120.7 2012/02/19 23:29:30 jvalenti ship $ */
3
4 --
5 -- Who record, used to honor customization.
6 --
7 TYPE who_type IS RECORD
8 (
9 created_by NUMBER,
10 creation_date DATE,
11 last_updated_by NUMBER,
12 last_update_date DATE,
13 last_update_login NUMBER
14 );
15
16 PROCEDURE set_context
17 (p_name IN VARCHAR2,
18 p_value IN VARCHAR2);
19
20 PROCEDURE set_debugging
21 (p_debug_flag IN VARCHAR2);
22
23 -- ==================================================
24 -- VALUE_SET
25 -- ==================================================
26 PROCEDURE up_value_set
27 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
28 p_upload_mode IN VARCHAR2,
29 p_custom_mode IN VARCHAR2 DEFAULT NULL,
30 p_flex_value_set_name IN VARCHAR2,
31 p_owner IN VARCHAR2,
32 p_last_update_date IN VARCHAR2 DEFAULT NULL,
33 p_validation_type IN VARCHAR2,
34 p_protected_flag IN VARCHAR2,
35 p_security_enabled_flag IN VARCHAR2,
36 p_longlist_flag IN VARCHAR2,
37 p_format_type IN VARCHAR2,
38 p_maximum_size IN VARCHAR2,
39 p_number_precision IN VARCHAR2,
40 p_alphanumeric_allowed_flag IN VARCHAR2,
41 p_uppercase_only_flag IN VARCHAR2,
42 p_numeric_mode_enabled_flag IN VARCHAR2,
43 p_minimum_value IN VARCHAR2,
44 p_maximum_value IN VARCHAR2,
45 p_parent_flex_value_set_name IN VARCHAR2,
46 p_dependant_default_value IN VARCHAR2,
47 p_dependant_default_meaning IN VARCHAR2,
48 p_description IN VARCHAR2);
49
50 PROCEDURE up_vset_depends_on
51 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
52 p_upload_mode IN VARCHAR2,
53 p_custom_mode IN VARCHAR2 DEFAULT NULL,
54 p_flex_value_set_name IN VARCHAR2,
55 p_ind_flex_value_set_name IN VARCHAR2,
56 p_owner IN VARCHAR2,
57 p_last_update_date IN VARCHAR2 DEFAULT NULL,
58 p_ind_validation_type IN VARCHAR2,
59 p_dep_validation_type IN VARCHAR2);
60
61 PROCEDURE up_vset_table
62 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
63 p_upload_mode IN VARCHAR2,
64 p_custom_mode IN VARCHAR2 DEFAULT NULL,
65 p_flex_value_set_name IN VARCHAR2,
66 p_owner IN VARCHAR2,
67 p_last_update_date IN VARCHAR2 DEFAULT NULL,
68 p_table_application_short_name IN VARCHAR2,
69 p_application_table_name IN VARCHAR2,
70 p_summary_allowed_flag IN VARCHAR2,
71 p_value_column_name IN VARCHAR2,
72 p_value_column_type IN VARCHAR2,
73 p_value_column_size IN VARCHAR2,
74 p_id_column_name IN VARCHAR2,
75 p_id_column_type IN VARCHAR2,
76 p_id_column_size IN VARCHAR2,
77 p_meaning_column_name IN VARCHAR2,
78 p_meaning_column_type IN VARCHAR2,
79 p_meaning_column_size IN VARCHAR2,
80 p_enabled_column_name IN VARCHAR2,
81 p_compiled_attribute_column_na IN VARCHAR2,
82 p_hierarchy_level_column_name IN VARCHAR2,
83 p_start_date_column_name IN VARCHAR2,
84 p_end_date_column_name IN VARCHAR2,
85 p_summary_column_name IN VARCHAR2,
86 p_additional_where_clause IN VARCHAR2,
87 p_additional_quickpick_columns IN VARCHAR2);
88
89 PROCEDURE up_vset_event
90 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
91 p_upload_mode IN VARCHAR2,
92 p_custom_mode IN VARCHAR2 DEFAULT NULL,
93 p_flex_value_set_name IN VARCHAR2,
94 p_event_code IN VARCHAR2,
95 p_owner IN VARCHAR2,
96 p_last_update_date IN VARCHAR2 DEFAULT NULL,
97 p_user_exit IN VARCHAR2);
98
99 PROCEDURE up_vset_security_rule
100 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
101 p_upload_mode IN VARCHAR2,
102 p_custom_mode IN VARCHAR2 DEFAULT NULL,
103 p_flex_value_set_name IN VARCHAR2,
104 p_flex_value_rule_name IN VARCHAR2,
105 p_parent_flex_value_low IN VARCHAR2,
106 p_owner IN VARCHAR2,
107 p_last_update_date IN VARCHAR2 DEFAULT NULL,
108 p_parent_flex_value_high IN VARCHAR2,
109 p_error_message IN VARCHAR2,
110 p_description IN VARCHAR2);
111
112 PROCEDURE up_vset_security_line
113 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
114 p_upload_mode IN VARCHAR2,
115 p_custom_mode IN VARCHAR2 DEFAULT NULL,
116 p_flex_value_set_name IN VARCHAR2,
117 p_flex_value_rule_name IN VARCHAR2,
118 p_parent_flex_value_low IN VARCHAR2,
119 p_include_exclude_indicator IN VARCHAR2,
120 p_flex_value_low IN VARCHAR2,
121 p_flex_value_high IN VARCHAR2,
122 p_owner IN VARCHAR2,
123 p_last_update_date IN VARCHAR2 DEFAULT NULL,
124 p_parent_flex_value_high IN VARCHAR2);
125
126 PROCEDURE up_vset_security_usage
127 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
128 p_upload_mode IN VARCHAR2,
129 p_custom_mode IN VARCHAR2 DEFAULT NULL,
130 p_flex_value_set_name IN VARCHAR2,
131 p_flex_value_rule_name IN VARCHAR2,
132 p_parent_flex_value_low IN VARCHAR2,
133 p_application_short_name IN VARCHAR2,
134 p_responsibility_key IN VARCHAR2,
135 p_owner IN VARCHAR2,
136 p_last_update_date IN VARCHAR2 DEFAULT NULL,
137 p_parent_flex_value_high IN VARCHAR2);
138
139 PROCEDURE up_vset_rollup_group
140 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
141 p_upload_mode IN VARCHAR2,
142 p_custom_mode IN VARCHAR2 DEFAULT NULL,
143 p_flex_value_set_name IN VARCHAR2,
144 p_hierarchy_code IN VARCHAR2,
145 p_owner IN VARCHAR2,
146 p_last_update_date IN VARCHAR2 DEFAULT NULL,
147 p_hierarchy_name IN VARCHAR2,
148 p_description IN VARCHAR2);
149
150 PROCEDURE up_vset_qualifier
151 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
152 p_upload_mode IN VARCHAR2,
153 p_custom_mode IN VARCHAR2 DEFAULT NULL,
154 p_flex_value_set_name IN VARCHAR2,
155 p_id_flex_application_short_na IN VARCHAR2,
156 p_id_flex_code IN VARCHAR2,
157 p_segment_attribute_type IN VARCHAR2,
158 p_value_attribute_type IN VARCHAR2,
159 p_owner IN VARCHAR2,
160 p_last_update_date IN VARCHAR2 DEFAULT NULL,
161 p_assignment_order IN VARCHAR2,
162 p_assignment_date IN VARCHAR2);
163
164 PROCEDURE up_vset_value
165 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
166 p_upload_mode IN VARCHAR2,
167 p_custom_mode IN VARCHAR2 DEFAULT NULL,
168 p_flex_value_set_name IN VARCHAR2,
169 p_parent_flex_value_low IN VARCHAR2,
170 p_flex_value IN VARCHAR2,
171 p_owner IN VARCHAR2,
172 p_last_update_date IN VARCHAR2 DEFAULT NULL,
173 p_enabled_flag IN VARCHAR2,
174 p_summary_flag IN VARCHAR2,
175 p_start_date_active IN VARCHAR2,
176 p_end_date_active IN VARCHAR2,
177 p_parent_flex_value_high IN VARCHAR2,
178 p_rollup_hierarchy_code IN VARCHAR2,
179 p_hierarchy_level IN VARCHAR2,
180 p_compiled_value_attributes IN VARCHAR2,
181 p_value_category IN VARCHAR2,
182 p_attribute1 IN VARCHAR2,
183 p_attribute2 IN VARCHAR2,
184 p_attribute3 IN VARCHAR2,
185 p_attribute4 IN VARCHAR2,
186 p_attribute5 IN VARCHAR2,
187 p_attribute6 IN VARCHAR2,
188 p_attribute7 IN VARCHAR2,
189 p_attribute8 IN VARCHAR2,
190 p_attribute9 IN VARCHAR2,
191 p_attribute10 IN VARCHAR2,
192 p_attribute11 IN VARCHAR2,
193 p_attribute12 IN VARCHAR2,
194 p_attribute13 IN VARCHAR2,
195 p_attribute14 IN VARCHAR2,
196 p_attribute15 IN VARCHAR2,
197 p_attribute16 IN VARCHAR2,
198 p_attribute17 IN VARCHAR2,
199 p_attribute18 IN VARCHAR2,
200 p_attribute19 IN VARCHAR2,
201 p_attribute20 IN VARCHAR2,
202 p_attribute21 IN VARCHAR2,
203 p_attribute22 IN VARCHAR2,
204 p_attribute23 IN VARCHAR2,
205 p_attribute24 IN VARCHAR2,
206 p_attribute25 IN VARCHAR2,
207 p_attribute26 IN VARCHAR2,
208 p_attribute27 IN VARCHAR2,
209 p_attribute28 IN VARCHAR2,
210 p_attribute29 IN VARCHAR2,
211 p_attribute30 IN VARCHAR2,
212 p_attribute31 IN VARCHAR2,
213 p_attribute32 IN VARCHAR2,
214 p_attribute33 IN VARCHAR2,
215 p_attribute34 IN VARCHAR2,
216 p_attribute35 IN VARCHAR2,
217 p_attribute36 IN VARCHAR2,
218 p_attribute37 IN VARCHAR2,
219 p_attribute38 IN VARCHAR2,
220 p_attribute39 IN VARCHAR2,
221 p_attribute40 IN VARCHAR2,
222 p_attribute41 IN VARCHAR2,
223 p_attribute42 IN VARCHAR2,
224 p_attribute43 IN VARCHAR2,
225 p_attribute44 IN VARCHAR2,
226 p_attribute45 IN VARCHAR2,
227 p_attribute46 IN VARCHAR2,
228 p_attribute47 IN VARCHAR2,
229 p_attribute48 IN VARCHAR2,
230 p_attribute49 IN VARCHAR2,
231 p_attribute50 IN VARCHAR2,
232 p_attribute_sort_order IN VARCHAR2 DEFAULT NULL,
233 p_flex_value_meaning IN VARCHAR2,
234 p_description IN VARCHAR2);
235
236 PROCEDURE up_vset_value_hierarchy
237 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
238 p_upload_mode IN VARCHAR2,
239 p_custom_mode IN VARCHAR2 DEFAULT NULL,
240 p_flex_value_set_name IN VARCHAR2,
241 p_parent_flex_value IN VARCHAR2,
242 p_range_attribute IN VARCHAR2,
243 p_child_flex_value_low IN VARCHAR2,
244 p_child_flex_value_high IN VARCHAR2,
245 p_owner IN VARCHAR2,
246 p_last_update_date IN VARCHAR2 DEFAULT NULL,
247 p_start_date_active IN VARCHAR2,
248 p_end_date_active IN VARCHAR2);
249
250 PROCEDURE up_vset_value_qual_value
251 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
252 p_upload_mode IN VARCHAR2,
253 p_custom_mode IN VARCHAR2 DEFAULT NULL,
254 p_flex_value_set_name IN VARCHAR2,
255 p_parent_flex_value_low IN VARCHAR2,
256 p_flex_value IN VARCHAR2,
257 p_id_flex_application_short_na IN VARCHAR2,
258 p_id_flex_code IN VARCHAR2,
259 p_segment_attribute_type IN VARCHAR2,
260 p_value_attribute_type IN VARCHAR2,
261 p_owner IN VARCHAR2,
262 p_last_update_date IN VARCHAR2 DEFAULT NULL,
263 p_compiled_value_attribute_val IN VARCHAR2);
264
265 -- ==================================================
266 -- DESC_FLEX
267 -- ==================================================
268 PROCEDURE up_desc_flex
269 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
270 p_upload_mode IN VARCHAR2,
271 p_custom_mode IN VARCHAR2 DEFAULT NULL,
272 p_application_short_name IN VARCHAR2,
273 p_descriptive_flexfield_name IN VARCHAR2,
274 p_owner IN VARCHAR2,
275 p_last_update_date IN VARCHAR2 DEFAULT NULL,
276 p_table_application_short_name IN VARCHAR2,
277 p_application_table_name IN VARCHAR2,
278 p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
279 p_context_column_name IN VARCHAR2,
280 p_context_required_flag IN VARCHAR2,
281 p_context_user_override_flag IN VARCHAR2,
282 p_concatenated_segment_delimit IN VARCHAR2,
283 p_freeze_flex_definition_flag IN VARCHAR2,
284 p_protected_flag IN VARCHAR2,
285 p_default_context_field_name IN VARCHAR2,
286 p_default_context_value IN VARCHAR2,
287 p_context_default_type IN VARCHAR2 DEFAULT NULL,
288 p_context_default_value IN VARCHAR2 DEFAULT NULL,
289 p_context_override_value_set_n IN VARCHAR2 DEFAULT NULL,
290 p_context_runtime_property_fun IN VARCHAR2 DEFAULT NULL,
291 p_context_synchronization_flag IN VARCHAR2 DEFAULT NULL,
292 p_title IN VARCHAR2,
293 p_form_context_prompt IN VARCHAR2,
294 p_description IN VARCHAR2);
295
296 PROCEDURE up_dff_column
297 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
298 p_upload_mode IN VARCHAR2,
299 p_custom_mode IN VARCHAR2 DEFAULT NULL,
300 p_application_short_name IN VARCHAR2,
301 p_descriptive_flexfield_name IN VARCHAR2,
302 p_column_name IN VARCHAR2,
303 p_owner IN VARCHAR2,
307 PROCEDURE up_dff_ref_field
304 p_last_update_date IN VARCHAR2 DEFAULT NULL,
305 p_flexfield_usage_code IN VARCHAR2);
306
308 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
309 p_upload_mode IN VARCHAR2,
310 p_custom_mode IN VARCHAR2 DEFAULT NULL,
311 p_application_short_name IN VARCHAR2,
312 p_descriptive_flexfield_name IN VARCHAR2,
313 p_default_context_field_name IN VARCHAR2,
314 p_owner IN VARCHAR2,
315 p_last_update_date IN VARCHAR2 DEFAULT NULL,
316 p_description IN VARCHAR2);
317
318 PROCEDURE up_dff_context
319 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
320 p_upload_mode IN VARCHAR2,
321 p_custom_mode IN VARCHAR2 DEFAULT NULL,
322 p_application_short_name IN VARCHAR2,
323 p_descriptive_flexfield_name IN VARCHAR2,
324 p_descriptive_flex_context_cod IN VARCHAR2,
325 p_owner IN VARCHAR2,
326 p_last_update_date IN VARCHAR2 DEFAULT NULL,
327 p_enabled_flag IN VARCHAR2,
328 p_global_flag IN VARCHAR2,
329 p_descriptive_flex_context_nam IN VARCHAR2,
330 p_description IN VARCHAR2);
331
332 PROCEDURE up_dff_segment
333 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
334 p_upload_mode IN VARCHAR2,
335 p_custom_mode IN VARCHAR2 DEFAULT NULL,
336 p_application_short_name IN VARCHAR2,
337 p_descriptive_flexfield_name IN VARCHAR2,
338 p_descriptive_flex_context_cod IN VARCHAR2,
339 p_end_user_column_name IN VARCHAR2,
340 p_application_column_name IN VARCHAR2,
341 p_owner IN VARCHAR2,
342 p_last_update_date IN VARCHAR2 DEFAULT NULL,
343 p_column_seq_num IN VARCHAR2,
344 p_enabled_flag IN VARCHAR2,
345 p_display_flag IN VARCHAR2,
346 p_required_flag IN VARCHAR2,
347 p_security_enabled_flag IN VARCHAR2,
348 p_flex_value_set_name IN VARCHAR2,
349 p_display_size IN VARCHAR2,
350 p_maximum_description_len IN VARCHAR2,
351 p_concatenation_description_le IN VARCHAR2,
352 p_range_code IN VARCHAR2,
353 p_default_type IN VARCHAR2,
354 p_default_value IN VARCHAR2,
355 p_runtime_property_function IN VARCHAR2 DEFAULT NULL,
356 p_srw_param IN VARCHAR2,
357 p_form_left_prompt IN VARCHAR2,
358 p_form_above_prompt IN VARCHAR2,
359 p_description IN VARCHAR2);
360
361 -- ==================================================
362 -- KEY_FLEX
363 -- ==================================================
364 PROCEDURE up_key_flex
365 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
366 p_upload_mode IN VARCHAR2,
367 p_custom_mode IN VARCHAR2 DEFAULT NULL,
368 p_application_short_name IN VARCHAR2,
369 p_id_flex_code IN VARCHAR2,
370 p_owner IN VARCHAR2,
371 p_last_update_date IN VARCHAR2 DEFAULT NULL,
372 p_table_application_short_name IN VARCHAR2,
373 p_application_table_name IN VARCHAR2,
374 p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
375 p_allow_id_valuesets IN VARCHAR2,
376 p_dynamic_inserts_feasible_fla IN VARCHAR2,
377 p_index_flag IN VARCHAR2,
378 p_unique_id_column_name IN VARCHAR2,
379 p_application_table_type IN VARCHAR2,
380 p_set_defining_column_name IN VARCHAR2,
381 p_maximum_concatenation_len IN VARCHAR2,
382 p_concatenation_len_warning IN VARCHAR2,
383 p_id_flex_name IN VARCHAR2,
384 p_description IN VARCHAR2);
385
386 PROCEDURE up_kff_column
387 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
388 p_upload_mode IN VARCHAR2,
389 p_custom_mode IN VARCHAR2 DEFAULT NULL,
390 p_application_short_name IN VARCHAR2,
391 p_id_flex_code IN VARCHAR2,
392 p_column_name IN VARCHAR2,
393 p_owner IN VARCHAR2,
394 p_last_update_date IN VARCHAR2 DEFAULT NULL,
395 p_flexfield_usage_code IN VARCHAR2);
396
397 PROCEDURE up_kff_flex_qual
398 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
399 p_upload_mode IN VARCHAR2,
400 p_custom_mode IN VARCHAR2 DEFAULT NULL,
401 p_application_short_name IN VARCHAR2,
402 p_id_flex_code IN VARCHAR2,
403 p_segment_attribute_type IN VARCHAR2,
404 p_owner IN VARCHAR2,
405 p_last_update_date IN VARCHAR2 DEFAULT NULL,
406 p_global_flag IN VARCHAR2,
407 p_required_flag IN VARCHAR2,
408 p_unique_flag IN VARCHAR2,
409 p_segment_prompt IN VARCHAR2,
410 p_description IN VARCHAR2);
411
412 PROCEDURE up_kff_segment_qual
413 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
414 p_upload_mode IN VARCHAR2,
415 p_custom_mode IN VARCHAR2 DEFAULT NULL,
416 p_application_short_name IN VARCHAR2,
420 p_owner IN VARCHAR2,
417 p_id_flex_code IN VARCHAR2,
418 p_segment_attribute_type IN VARCHAR2,
419 p_value_attribute_type IN VARCHAR2,
421 p_last_update_date IN VARCHAR2 DEFAULT NULL,
422 p_required_flag IN VARCHAR2,
423 p_application_column_name IN VARCHAR2,
424 p_default_value IN VARCHAR2,
425 p_lookup_type IN VARCHAR2,
426 p_derivation_rule_code IN VARCHAR2,
427 p_derivation_rule_value1 IN VARCHAR2,
428 p_derivation_rule_value2 IN VARCHAR2,
429 p_prompt IN VARCHAR2,
430 p_description IN VARCHAR2);
431
432 PROCEDURE up_kff_structure
433 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
434 p_upload_mode IN VARCHAR2,
435 p_custom_mode IN VARCHAR2 DEFAULT NULL,
436 p_application_short_name IN VARCHAR2,
437 p_id_flex_code IN VARCHAR2,
438 p_id_flex_structure_code IN VARCHAR2,
439 p_owner IN VARCHAR2,
440 p_last_update_date IN VARCHAR2 DEFAULT NULL,
441 p_concatenated_segment_delimit IN VARCHAR2,
442 p_cross_segment_validation_fla IN VARCHAR2,
443 p_dynamic_inserts_allowed_flag IN VARCHAR2,
444 p_enabled_flag IN VARCHAR2,
445 p_freeze_flex_definition_flag IN VARCHAR2,
446 p_freeze_structured_hier_flag IN VARCHAR2,
447 p_shorthand_enabled_flag IN VARCHAR2,
448 p_shorthand_length IN VARCHAR2,
449 p_structure_view_name IN VARCHAR2,
450 p_id_flex_structure_name IN VARCHAR2,
451 p_description IN VARCHAR2,
452 p_shorthand_prompt IN VARCHAR2);
453
454 PROCEDURE up_kff_wf_process
455 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
456 p_upload_mode IN VARCHAR2,
457 p_custom_mode IN VARCHAR2 DEFAULT NULL,
458 p_application_short_name IN VARCHAR2,
459 p_id_flex_code IN VARCHAR2,
460 p_id_flex_structure_code IN VARCHAR2,
461 p_wf_item_type IN VARCHAR2,
462 p_owner IN VARCHAR2,
463 p_last_update_date IN VARCHAR2 DEFAULT NULL,
464 p_wf_process_name IN VARCHAR2);
465
466 PROCEDURE up_kff_sh_alias
467 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
468 p_upload_mode IN VARCHAR2,
469 p_custom_mode IN VARCHAR2 DEFAULT NULL,
470 p_application_short_name IN VARCHAR2,
471 p_id_flex_code IN VARCHAR2,
472 p_id_flex_structure_code IN VARCHAR2,
473 p_alias_name IN VARCHAR2,
474 p_owner IN VARCHAR2,
475 p_last_update_date IN VARCHAR2 DEFAULT NULL,
476 p_concatenated_segments IN VARCHAR2,
477 p_enabled_flag IN VARCHAR2,
478 p_start_date_active IN VARCHAR2,
479 p_end_date_active IN VARCHAR2,
480 p_attribute_category IN VARCHAR2,
481 p_attribute1 IN VARCHAR2,
482 p_attribute2 IN VARCHAR2,
486 p_attribute6 IN VARCHAR2,
483 p_attribute3 IN VARCHAR2,
484 p_attribute4 IN VARCHAR2,
485 p_attribute5 IN VARCHAR2,
487 p_attribute7 IN VARCHAR2,
488 p_attribute8 IN VARCHAR2,
489 p_attribute9 IN VARCHAR2,
490 p_attribute10 IN VARCHAR2,
491 p_attribute11 IN VARCHAR2,
492 p_attribute12 IN VARCHAR2,
493 p_attribute13 IN VARCHAR2,
494 p_attribute14 IN VARCHAR2,
495 p_attribute15 IN VARCHAR2,
496 p_description IN VARCHAR2);
497
498 PROCEDURE up_kff_cvr_rule
499 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
500 p_upload_mode IN VARCHAR2,
501 p_custom_mode IN VARCHAR2 DEFAULT NULL,
502 p_application_short_name IN VARCHAR2,
503 p_id_flex_code IN VARCHAR2,
504 p_id_flex_structure_code IN VARCHAR2,
505 p_flex_validation_rule_name IN VARCHAR2,
506 p_owner IN VARCHAR2,
507 p_last_update_date IN VARCHAR2 DEFAULT NULL,
508 p_enabled_flag IN VARCHAR2,
509 p_error_segment_column_name IN VARCHAR2,
510 p_start_date_active IN VARCHAR2,
511 p_end_date_active IN VARCHAR2,
512 p_error_message_text IN VARCHAR2,
513 p_description IN VARCHAR2);
514
515 PROCEDURE up_kff_cvr_line
516 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
517 p_upload_mode IN VARCHAR2,
518 p_custom_mode IN VARCHAR2 DEFAULT NULL,
519 p_application_short_name IN VARCHAR2,
520 p_id_flex_code IN VARCHAR2,
521 p_id_flex_structure_code IN VARCHAR2,
522 p_flex_validation_rule_name IN VARCHAR2,
523 p_include_exclude_indicator IN VARCHAR2,
524 p_concatenated_segments_low IN VARCHAR2,
525 p_concatenated_segments_high IN VARCHAR2,
526 p_owner IN VARCHAR2,
527 p_last_update_date IN VARCHAR2 DEFAULT NULL,
528 p_enabled_flag IN VARCHAR2,
529 p_description IN VARCHAR2);
530
531 PROCEDURE up_kff_segment
532 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
533 p_upload_mode IN VARCHAR2,
534 p_custom_mode IN VARCHAR2 DEFAULT NULL,
535 p_application_short_name IN VARCHAR2,
536 p_id_flex_code IN VARCHAR2,
537 p_id_flex_structure_code IN VARCHAR2,
538 p_segment_name IN VARCHAR2,
539 p_application_column_name IN VARCHAR2,
540 p_owner IN VARCHAR2,
541 p_last_update_date IN VARCHAR2 DEFAULT NULL,
542 p_segment_num IN VARCHAR2,
543 p_application_column_index_fla IN VARCHAR2,
544 p_enabled_flag IN VARCHAR2,
545 p_required_flag IN VARCHAR2,
546 p_display_flag IN VARCHAR2,
547 p_display_size IN VARCHAR2,
548 p_security_enabled_flag IN VARCHAR2,
549 p_maximum_description_len IN VARCHAR2,
550 p_concatenation_description_le IN VARCHAR2,
551 p_flex_value_set_name IN VARCHAR2,
552 p_range_code IN VARCHAR2,
553 p_default_type IN VARCHAR2,
554 p_default_value IN VARCHAR2,
555 p_runtime_property_function IN VARCHAR2 DEFAULT NULL,
556 p_additional_where_clause IN VARCHAR2 DEFAULT NULL,
557 p_form_left_prompt IN VARCHAR2,
558 p_form_above_prompt IN VARCHAR2,
559 p_description IN VARCHAR2);
560
561 PROCEDURE up_kff_flexq_assign
562 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
563 p_upload_mode IN VARCHAR2,
564 p_custom_mode IN VARCHAR2 DEFAULT NULL,
565 p_application_short_name IN VARCHAR2,
566 p_id_flex_code IN VARCHAR2,
567 p_id_flex_structure_code IN VARCHAR2,
568 p_application_column_name IN VARCHAR2,
569 p_segment_attribute_type IN VARCHAR2,
570 p_owner IN VARCHAR2,
571 p_last_update_date IN VARCHAR2 DEFAULT NULL,
572 p_attribute_value IN VARCHAR2);
573
574 PROCEDURE up_kff_segq_assign
575 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
576 p_upload_mode IN VARCHAR2,
577 p_custom_mode IN VARCHAR2 DEFAULT NULL,
578 p_application_short_name IN VARCHAR2,
579 p_id_flex_code IN VARCHAR2,
580 p_id_flex_structure_code IN VARCHAR2,
581 p_application_column_name IN VARCHAR2,
582 p_segment_attribute_type IN VARCHAR2,
583 p_value_attribute_type IN VARCHAR2,
584 p_owner IN VARCHAR2 DEFAULT NULL,
585 p_last_update_date IN VARCHAR2 DEFAULT NULL,
586 p_assignment_order IN VARCHAR2,
587 p_assignment_date IN VARCHAR2);
588
589 PROCEDURE up_kff_qualifier
590 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
591 p_upload_mode IN VARCHAR2,
592 p_custom_mode IN VARCHAR2 DEFAULT NULL,
593 p_application_short_name IN VARCHAR2,
594 p_id_flex_code IN VARCHAR2,
598 p_owner IN VARCHAR2,
595 p_flex_value_set_name IN VARCHAR2,
596 p_segment_attribute_type IN VARCHAR2,
597 p_value_attribute_type IN VARCHAR2,
599 p_last_update_date IN VARCHAR2 DEFAULT NULL,
600 p_assignment_order IN VARCHAR2,
601 p_assignment_date IN VARCHAR2);
602
603 PROCEDURE up_kff_qualifier_value
604 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
605 p_upload_mode IN VARCHAR2,
606 p_custom_mode IN VARCHAR2 DEFAULT NULL,
607 p_application_short_name IN VARCHAR2,
608 p_id_flex_code IN VARCHAR2,
609 p_flex_value_set_name IN VARCHAR2,
610 p_segment_attribute_type IN VARCHAR2,
611 p_value_attribute_type IN VARCHAR2,
612 p_parent_flex_value_low IN VARCHAR2,
613 p_flex_value IN VARCHAR2,
614 p_owner IN VARCHAR2,
615 p_last_update_date IN VARCHAR2 DEFAULT NULL,
616 p_compiled_value_attribute_val IN VARCHAR2);
617
618 FUNCTION get_qualifier_value
619 (p_compiled_value_attributes IN VARCHAR2,
620 p_assignment_order IN VARCHAR2)
621 RETURN VARCHAR2;
622 PRAGMA restrict_references(get_qualifier_value, WNDS, WNPS, RNPS);
623
624 /****** Should be removed later - begin ******/
625 -- ==================================================
626 -- VALUE_SECURITY_RULE
627 -- ==================================================
628 PROCEDURE up_value_security_rule
629 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
630 p_upload_mode IN VARCHAR2,
631 p_custom_mode IN VARCHAR2 DEFAULT NULL,
632 p_flex_value_set_name IN VARCHAR2,
633 p_flex_value_rule_name IN VARCHAR2,
634 p_parent_flex_value_low IN VARCHAR2,
635 p_owner IN VARCHAR2,
636 p_last_update_date IN VARCHAR2 DEFAULT NULL,
637 p_parent_flex_value_high IN VARCHAR2,
638 p_error_message IN VARCHAR2,
639 p_description IN VARCHAR2);
640
641 PROCEDURE up_vsec_line
642 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
643 p_upload_mode IN VARCHAR2,
644 p_custom_mode IN VARCHAR2 DEFAULT NULL,
645 p_flex_value_set_name IN VARCHAR2,
646 p_flex_value_rule_name IN VARCHAR2,
647 p_parent_flex_value_low IN VARCHAR2,
648 p_include_exclude_indicator IN VARCHAR2,
649 p_flex_value_low IN VARCHAR2,
650 p_flex_value_high IN VARCHAR2,
651 p_owner IN VARCHAR2,
652 p_last_update_date IN VARCHAR2 DEFAULT NULL,
653 p_parent_flex_value_high IN VARCHAR2);
654
655 PROCEDURE up_vsec_usage
656 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
657 p_upload_mode IN VARCHAR2,
658 p_custom_mode IN VARCHAR2 DEFAULT NULL,
659 p_flex_value_set_name IN VARCHAR2,
660 p_flex_value_rule_name IN VARCHAR2,
661 p_parent_flex_value_low IN VARCHAR2,
662 p_application_short_name IN VARCHAR2,
663 p_responsibility_key IN VARCHAR2,
664 p_owner IN VARCHAR2,
665 p_last_update_date IN VARCHAR2 DEFAULT NULL,
666 p_parent_flex_value_high IN VARCHAR2);
667
668 -- ==================================================
669 -- VALUE_ROLLUP_GROUP
670 -- ==================================================
671 PROCEDURE up_value_rollup_group
672 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
673 p_upload_mode IN VARCHAR2,
674 p_custom_mode IN VARCHAR2 DEFAULT NULL,
675 p_flex_value_set_name IN VARCHAR2,
676 p_hierarchy_code IN VARCHAR2,
677 p_owner IN VARCHAR2,
678 p_last_update_date IN VARCHAR2 DEFAULT NULL,
679 p_hierarchy_name IN VARCHAR2,
680 p_description IN VARCHAR2);
681
682 -- ==================================================
683 -- VALUE_SET_VALUE
684 -- ==================================================
685 PROCEDURE up_value_set_value
686 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
687 p_upload_mode IN VARCHAR2,
688 p_custom_mode IN VARCHAR2 DEFAULT NULL,
689 p_flex_value_set_name IN VARCHAR2,
690 p_parent_flex_value_low IN VARCHAR2,
691 p_flex_value IN VARCHAR2,
692 p_owner IN VARCHAR2,
693 p_last_update_date IN VARCHAR2 DEFAULT NULL,
694 p_enabled_flag IN VARCHAR2,
695 p_summary_flag IN VARCHAR2,
696 p_start_date_active IN VARCHAR2,
697 p_end_date_active IN VARCHAR2,
698 p_parent_flex_value_high IN VARCHAR2,
699 p_rollup_flex_value_set_name IN VARCHAR2,
700 p_rollup_hierarchy_code IN VARCHAR2,
701 p_hierarchy_level IN VARCHAR2,
702 p_compiled_value_attributes IN VARCHAR2,
703 p_value_category IN VARCHAR2,
704 p_attribute1 IN VARCHAR2,
705 p_attribute2 IN VARCHAR2,
706 p_attribute3 IN VARCHAR2,
707 p_attribute4 IN VARCHAR2,
708 p_attribute5 IN VARCHAR2,
709 p_attribute6 IN VARCHAR2,
710 p_attribute7 IN VARCHAR2,
711 p_attribute8 IN VARCHAR2,
712 p_attribute9 IN VARCHAR2,
713 p_attribute10 IN VARCHAR2,
714 p_attribute11 IN VARCHAR2,
715 p_attribute12 IN VARCHAR2,
716 p_attribute13 IN VARCHAR2,
717 p_attribute14 IN VARCHAR2,
718 p_attribute15 IN VARCHAR2,
719 p_attribute16 IN VARCHAR2,
720 p_attribute17 IN VARCHAR2,
721 p_attribute18 IN VARCHAR2,
722 p_attribute19 IN VARCHAR2,
723 p_attribute20 IN VARCHAR2,
724 p_attribute21 IN VARCHAR2,
725 p_attribute22 IN VARCHAR2,
726 p_attribute23 IN VARCHAR2,
727 p_attribute24 IN VARCHAR2,
728 p_attribute25 IN VARCHAR2,
729 p_attribute26 IN VARCHAR2,
730 p_attribute27 IN VARCHAR2,
731 p_attribute28 IN VARCHAR2,
732 p_attribute29 IN VARCHAR2,
733 p_attribute30 IN VARCHAR2,
734 p_attribute31 IN VARCHAR2,
735 p_attribute32 IN VARCHAR2,
736 p_attribute33 IN VARCHAR2,
737 p_attribute34 IN VARCHAR2,
738 p_attribute35 IN VARCHAR2,
739 p_attribute36 IN VARCHAR2,
740 p_attribute37 IN VARCHAR2,
741 p_attribute38 IN VARCHAR2,
742 p_attribute39 IN VARCHAR2,
743 p_attribute40 IN VARCHAR2,
744 p_attribute41 IN VARCHAR2,
745 p_attribute42 IN VARCHAR2,
746 p_attribute43 IN VARCHAR2,
747 p_attribute44 IN VARCHAR2,
748 p_attribute45 IN VARCHAR2,
749 p_attribute46 IN VARCHAR2,
750 p_attribute47 IN VARCHAR2,
751 p_attribute48 IN VARCHAR2,
752 p_attribute49 IN VARCHAR2,
753 p_attribute50 IN VARCHAR2,
754 p_flex_value_meaning IN VARCHAR2,
755 p_description IN VARCHAR2);
756
757 PROCEDURE up_val_norm_hierarchy
758 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
759 p_upload_mode IN VARCHAR2,
760 p_custom_mode IN VARCHAR2 DEFAULT NULL,
761 p_flex_value_set_name IN VARCHAR2,
762 p_parent_flex_value IN VARCHAR2,
763 p_range_attribute IN VARCHAR2,
764 p_child_flex_value_low IN VARCHAR2,
765 p_child_flex_value_high IN VARCHAR2,
766 p_owner IN VARCHAR2,
767 p_last_update_date IN VARCHAR2 DEFAULT NULL,
768 p_start_date_active IN VARCHAR2,
769 p_end_date_active IN VARCHAR2);
770
771 PROCEDURE up_val_qual_value
772 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
773 p_upload_mode IN VARCHAR2,
774 p_custom_mode IN VARCHAR2 DEFAULT NULL,
775 p_flex_value_set_name IN VARCHAR2,
776 p_parent_flex_value_low IN VARCHAR2,
777 p_flex_value IN VARCHAR2,
778 p_id_flex_application_short_na IN VARCHAR2,
779 p_id_flex_code IN VARCHAR2,
780 p_segment_attribute_type IN VARCHAR2,
781 p_value_attribute_type IN VARCHAR2,
782 p_owner IN VARCHAR2,
783 p_last_update_date IN VARCHAR2 DEFAULT NULL,
784 p_assignment_order IN VARCHAR2,
785 p_assignment_date IN VARCHAR2,
786 p_compiled_value_attribute_val IN VARCHAR2);
787
788 PROCEDURE up_desc_flex_nls
789 (p_upload_phase IN VARCHAR2 DEFAULT NULL,
790 p_upload_mode IN VARCHAR2,
791 p_custom_mode IN VARCHAR2 DEFAULT NULL,
792 p_application_short_name IN VARCHAR2,
793 p_descriptive_flexfield_name IN VARCHAR2,
794 p_owner IN VARCHAR2,
795 p_last_update_date IN VARCHAR2 DEFAULT NULL,
796 p_table_application_short_name IN VARCHAR2,
797 p_application_table_name IN VARCHAR2,
798 p_concatenated_segs_view_name IN VARCHAR2 DEFAULT NULL,
799 p_context_column_name IN VARCHAR2,
800 p_context_required_flag IN VARCHAR2,
801 p_context_user_override_flag IN VARCHAR2,
802 p_concatenated_segment_delimit IN VARCHAR2,
803 p_freeze_flex_definition_flag IN VARCHAR2,
804 p_protected_flag IN VARCHAR2,
805 p_default_context_field_name IN VARCHAR2,
806 p_default_context_value IN VARCHAR2,
807 p_context_default_type IN VARCHAR2 DEFAULT NULL,
808 p_context_default_value IN VARCHAR2 DEFAULT NULL,
809 p_context_override_value_set_n IN VARCHAR2 DEFAULT NULL,
810 p_context_runtime_property_fun IN VARCHAR2 DEFAULT NULL,
811 p_context_synchronization_flag IN VARCHAR2 DEFAULT NULL,
812 p_title IN VARCHAR2,
813 p_form_context_prompt IN VARCHAR2,
814 p_description IN VARCHAR2);
815
816
817 /****** Should be removed later - end ******/
818
819 END fnd_flex_loader_apis;