[Home] [Help]
PACKAGE: APPS.FND_FLEX_DIAGNOSE
Source
1 PACKAGE fnd_flex_diagnose AS
2 /* $Header: AFFFDGNS.pls 120.4.12010000.1 2008/07/25 14:13:54 appldev ship $ */
3
4
5 -- ***************************************************************************
6 -- * Common get_something() RETURN VARCHAR2; functions.
7 -- ***************************************************************************
8 -- ===========================================================================
9 -- Returns the database information.
10 --
11 FUNCTION get_db RETURN VARCHAR2;
12
13 -- ===========================================================================
14 -- Returns the release information.
15 --
16 FUNCTION get_rel RETURN VARCHAR2;
17
18 -- ===========================================================================
19 -- Returns the who information from the given table, and given rowid, or
20 -- concatenates the individual who columns.
21 --
22 -- Syntax : 'CD:<creation_date> CB:<created_by> LUD:<last_update_date>
23 -- LUB:<last_updated_by> LUL:<last_update_login>'
24 -- Example : 'CD:2000/01/01 CB:1 LUD:2000/01/02 LUB:1 LUL:123'
25 --
26 FUNCTION get_who(p_creation_date IN DATE,
27 p_created_by IN NUMBER,
28 p_last_update_date IN DATE,
29 p_last_updated_by IN NUMBER,
30 p_last_update_login IN NUMBER)
31 RETURN VARCHAR2;
32 --
33 FUNCTION get_who(p_table_name IN VARCHAR2,
34 p_rowid IN ROWID)
35 RETURN VARCHAR2;
36
37 -- ===========================================================================
38 -- Returns the application information.
39 --
40 -- Syntax : '<application_id>/<application_short_name>/<application_name>'
41 -- Example : '0/FND/Application Object Library'
42 --
43 FUNCTION get_app(p_application_id IN NUMBER)
44 RETURN VARCHAR2;
45
46 -- ===========================================================================
47 -- Returns the table information.
48 --
49 -- Syntax : '<table_owner>/<table_name>/<table_id>'
50 -- Example : 'GL/GL_CODE_COMBINATIONS/584'
51 --
52 FUNCTION get_tbl(p_application_id IN NUMBER,
53 p_table_name IN VARCHAR2)
54 RETURN VARCHAR2;
55
56 -- ===========================================================================
57 -- Returns the column information.
58 --
59 -- Syntax : '<column_name>/<column_id>/<column_type>/<column_size>/
60 -- <flexfield_usage_code>/<flexfield_application_id>/
61 -- <flexfield_name>'
62 -- Example : 'ATTRIBUTE_CATEGORY/6406/C/60/C/101/GL_CODE_COMBINATIONS'
63 --
64 FUNCTION get_col(p_application_id IN NUMBER,
65 p_table_name IN VARCHAR2,
66 p_column_name IN VARCHAR2)
67 RETURN VARCHAR2;
68
69 -- ===========================================================================
70 -- Returns the language information.
71 --
72 -- Syntax : '<language_code>/<installed_flag>/<nls_language>/<nls_territory>'
73 -- Example : 'TR/I/TURKISH/TURKEY'
74 --
75 FUNCTION get_lng(p_language_code IN VARCHAR2)
76 RETURN VARCHAR2;
77
78 -- ===========================================================================
79 -- Returns the responsibility information.
80 --
81 -- Syntax : '<responsibility_id>/<responsibility_key>/<responsibility_name>'
82 -- Example : 'APPLICATION_DEVELOPER/Application Developer'
83 --
84 FUNCTION get_rsp(p_application_id IN NUMBER,
85 p_responsibility_id IN NUMBER)
86 RETURN VARCHAR2;
87
88 -- ***************************************************************************
89 -- * FB get_fb_something() RETURN VARCHAR2; functions.
90 -- ***************************************************************************
91 -- ===========================================================================
92 -- Returns the flexbuilder function information.
93 --
94 -- Syntax : '<function_code>/<function_name>/<description>
95 -- Example: 'PO_REQ_VARIANCE_ACCOUNT/Requisition Variance Account/Desc'
96 --
97 FUNCTION get_fb_func(p_application_id IN NUMBER,
98 p_function_code IN VARCHAR2)
99 RETURN VARCHAR2;
100
101 -- ===========================================================================
102 -- Returns the kff application information for flexbuilder function.
103 --
104 -- Syntax : see get_app
105 -- Example :
106 --
107 FUNCTION get_fb_kapp(p_application_id IN NUMBER,
108 p_function_code IN VARCHAR2)
109 RETURN VARCHAR2;
110
111 -- ===========================================================================
112 -- Returns the kff information for flexbuilder function.
113 --
114 -- Syntax : see get_kff_flx
115 -- Example :
116 --
117 FUNCTION get_fb_kflx(p_application_id IN NUMBER,
118 p_function_code IN VARCHAR2)
119 RETURN VARCHAR2;
120
121 -- ===========================================================================
122 -- Returns the kff structure information for flexbuilder function.
123 --
124 -- Syntax : see get_kff_str.
125 -- Example :
126 --
127 FUNCTION get_fb_kstr(p_application_id IN NUMBER,
128 p_function_code IN VARCHAR2,
129 p_id_flex_num IN NUMBER)
130 RETURN VARCHAR2;
131
132
133 -- ***************************************************************************
134 -- * VST get_vst_something() RETURN VARCHAR2; functions.
135 -- ***************************************************************************
136 -- ===========================================================================
137 -- Returns the value set information.
138 --
139 -- Syntax : '<flex_value_set_id>/<flex_value_set_name>/<validation_type>/
140 -- <format_type>/<maximum_size>/<description>'
141 -- Example: '12345/FND_FLEX_TEST/I/C/10'
142 --
143 FUNCTION get_vst_set(p_flex_value_set_id IN NUMBER)
144 RETURN VARCHAR2;
145
146 -- ===========================================================================
147 -- Returns the value set table information.
148 --
149 -- Syntax : '<application_table_name>/
150 -- <value_column_name>/<value_column_type>/<value_column_size>/
151 -- <id_column_name>/<id_column_type>/<id_column_size>'
152 -- Example: 'FND_FLEX_TEST/VALUE/V/60/ID/N/22'
153 --
154 FUNCTION get_vst_tbl(p_flex_value_set_id IN NUMBER)
155 RETURN VARCHAR2;
156
157 -- ===========================================================================
158 -- Returns the value set event information.
159 --
160 -- Syntax : '<event_code>/<event_name>/<user_exit>'
161 -- Example: 'E/Edit/FND POPID ...'
162 --
163 FUNCTION get_vst_evt(p_flex_value_set_id IN NUMBER,
164 p_event_code IN VARCHAR2)
165 RETURN VARCHAR2;
166
167 -- ===========================================================================
168 -- Returns the security rule information.
169 --
170 -- Syntax : '<flex_value_rule_id>/<flex_value_rule_name>/
171 -- <parent_flex_value_low>/<error_message>'
172 -- Example : '1234/MySecurity/<NULL>/Value 1000 is secured.'
173 --
174 FUNCTION get_vst_scr(p_flex_value_set_id IN NUMBER,
175 p_flex_value_rule_id IN NUMBER)
176 RETURN VARCHAR2;
177
178 -- ===========================================================================
179 -- Returns the security rule line information.
180 --
181 -- Syntax : '<include_exclude_indicator>/<parent_flex_value_low>/
182 -- <flex_value_low>/<flex_value_high>'
183 -- Example : 'I/<NULL>/00/ZZ'
184 --
185 FUNCTION get_vst_scl(p_flex_value_set_id IN NUMBER,
186 p_flex_value_rule_id IN NUMBER,
187 p_include_exclude_indicator IN VARCHAR2,
188 p_flex_value_low IN VARCHAR2,
189 p_flex_value_high IN VARCHAR2)
190 RETURN VARCHAR2;
191
192 -- ===========================================================================
193 -- Returns the security rule usage information.
194 --
195 -- Syntax : '<flex_value_rule_id>/<application_id>/<responsibility_id>'
196 -- Example : '1234/0/100'
197 --
198 FUNCTION get_vst_scu(p_flex_value_set_id IN NUMBER,
199 p_flex_value_rule_id IN NUMBER,
200 p_application_id IN NUMBER,
201 p_responsibility_id IN NUMBER)
202 RETURN VARCHAR2;
203
204 -- ===========================================================================
205 -- Returns the flex value information.
206 --
207 -- Syntax : '<flex_value_id>/<parent_flex_value_low>/<flex_value>/
208 -- <enabled_flag>/<flex_value_meaning>/<description>'
209 -- Example : '1234/CA/SF/Y/{SF}/City of SF'
210 --
211 FUNCTION get_vst_val(p_flex_value_set_id IN NUMBER,
212 p_flex_value_id IN NUMBER)
213 RETURN VARCHAR2;
214
215 -- ===========================================================================
216 -- Returns the rollup group information.
217 --
218 -- Syntax : '<hierarchy_id>/<hierarchy_name>/<description>'
219 -- Example : '1234/MyHR/My hierarchy.'
220 --
221 FUNCTION get_vst_rlg(p_flex_value_set_id IN NUMBER,
222 p_hierarchy_id IN NUMBER)
223 RETURN VARCHAR2;
224
225 -- ===========================================================================
226 -- Returns the normalized value hierarchy information.
227 --
228 -- Syntax : '<parent_flex_value>/<range_attribute>/
229 -- <child_flex_value_low>/<child_flex_value_high>'
230 -- Example : 'CA/P/SF/SF'
231 --
232 FUNCTION get_vst_fvn(p_flex_value_set_id IN NUMBER,
233 p_parent_flex_value IN VARCHAR2,
234 p_range_attribute IN VARCHAR2,
235 p_child_flex_value_low IN VARCHAR2,
236 p_child_flex_value_high IN VARCHAR2)
237 RETURN VARCHAR2;
238
239 -- ===========================================================================
240 -- Returns the de-normalized value hierarchy information.
241 --
242 -- Syntax : '<parent_flex_value>/
243 -- <child_flex_value_low>/<child_flex_value_high>'
244 -- Example : 'CA/SF/SF'
245 --
246 FUNCTION get_vst_fvh(p_flex_value_set_id IN NUMBER,
247 p_parent_flex_value IN VARCHAR2,
248 p_child_flex_value_low IN VARCHAR2,
249 p_child_flex_value_high IN VARCHAR2)
250 RETURN VARCHAR2;
251
252
253 -- ===========================================================================
254 -- Returns the PL/SQL code to fix a problem.
255 -- pk's are primary keys for the specific rule.
256 --
257 FUNCTION get_vst_fix(p_rule IN VARCHAR2,
258 p_pk1 IN VARCHAR2 DEFAULT NULL,
259 p_pk2 IN VARCHAR2 DEFAULT NULL,
260 p_pk3 IN VARCHAR2 DEFAULT NULL,
261 p_pk4 IN VARCHAR2 DEFAULT NULL,
262 p_pk5 IN VARCHAR2 DEFAULT NULL,
263 p_pk6 IN VARCHAR2 DEFAULT NULL)
264 RETURN VARCHAR2;
265
266 -- ***************************************************************************
267 -- * VST validate_vst_something() functions
268 -- ***************************************************************************
269 -- ===========================================================================
270 -- Validates vset table definition
271 --
272 FUNCTION validate_vst_tbl(p_flex_value_set_id IN NUMBER)
273 RETURN VARCHAR2;
274
275 -- ***************************************************************************
276 -- * VST fix_vst_something(); procedures.
277 -- ***************************************************************************
278 -- ===========================================================================
279 -- Fixes the integrity problems reported in VST check script.
280 -- See $FND_TOP/sql/afffcvst.sql
281 --
282 -- ===========================================================================
283 -- Rules : A.01, A.02, A.03, A.04, A.05, B.01, B.02
284 --
285 PROCEDURE fix_vst_set(p_rule IN VARCHAR2,
286 p_flex_value_set_id IN NUMBER,
287 x_message OUT nocopy VARCHAR2);
288
289 -- ===========================================================================
290 -- Rules : C.01, C.02
291 --
292 PROCEDURE fix_vst_evt(p_rule IN VARCHAR2,
293 p_flex_value_set_id IN NUMBER,
294 p_event_code IN VARCHAR2,
295 x_message OUT nocopy VARCHAR2);
296
297 -- ===========================================================================
298 -- Rules : D.03
299 --
300 PROCEDURE fix_vst_scr(p_rule IN VARCHAR2,
301 p_flex_value_set_id IN NUMBER,
302 p_flex_value_rule_id IN NUMBER,
303 x_message OUT nocopy VARCHAR2);
304
305
306 -- ===========================================================================
307 -- Rules : E.01, E.02
308 --
309 PROCEDURE fix_vst_scl(p_rule IN VARCHAR2,
310 p_flex_value_set_id IN NUMBER,
311 p_flex_value_rule_id IN NUMBER,
312 p_include_exclude_indicator IN VARCHAR2,
313 p_flex_value_low IN VARCHAR2,
314 p_flex_value_high IN VARCHAR2,
315 x_message OUT nocopy VARCHAR2);
316
317
318 -- ===========================================================================
319 -- Rules : F.01, F.02, F.03
320 --
321 PROCEDURE fix_vst_scu(p_rule IN VARCHAR2,
322 p_flex_value_set_id IN NUMBER,
323 p_flex_value_rule_id IN NUMBER,
324 p_application_id IN NUMBER,
325 p_responsibility_id IN NUMBER,
326 x_message OUT nocopy VARCHAR2);
327
328
329 -- ===========================================================================
330 -- Rules : G.03, G.04
331 --
332 PROCEDURE fix_vst_val(p_rule IN VARCHAR2,
333 p_flex_value_set_id IN NUMBER,
334 p_flex_value_id IN NUMBER,
335 x_message OUT nocopy VARCHAR2);
336
337
338 -- ===========================================================================
339 -- Rules : H.03
340 --
341 PROCEDURE fix_vst_rlg(p_rule IN VARCHAR2,
342 p_flex_value_set_id IN NUMBER,
343 p_hierarchy_id IN NUMBER,
344 x_message OUT nocopy VARCHAR2);
345
346 -- ===========================================================================
347 -- Rules : I.01
348 --
349 PROCEDURE fix_vst_fvn(p_rule IN VARCHAR2,
350 p_flex_value_set_id IN NUMBER,
351 p_parent_flex_value IN VARCHAR2,
352 p_range_attribute IN VARCHAR2,
353 p_child_flex_value_low IN VARCHAR2,
354 p_child_flex_value_high IN VARCHAR2,
355 x_message OUT nocopy VARCHAR2);
356
357 -- ===========================================================================
361 p_flex_value_set_id IN NUMBER,
358 -- Rules : J.01
359 --
360 PROCEDURE fix_vst_fvh(p_rule IN VARCHAR2,
362 p_parent_flex_value IN VARCHAR2,
363 p_child_flex_value_low IN VARCHAR2,
364 p_child_flex_value_high IN VARCHAR2,
365 x_message OUT nocopy VARCHAR2);
366
367 -- ***************************************************************************
368 -- * DFF get_dff_something() RETURN VARCHAR2; functions.
369 -- ***************************************************************************
370 -- ===========================================================================
371 -- Returns the DFF information.
372 --
373 -- Syntax : '<descriptive_flexfield_name>/<title>'
374 -- Example : 'FND_FLEX_TEST/Test Descriptive Flexfields'
375 --
376 FUNCTION get_dff_flx(p_application_id IN NUMBER,
377 p_descriptive_flexfield_name IN VARCHAR2)
378 RETURN VARCHAR2;
379
380 -- ===========================================================================
381 -- Returns the DFF Context information.
382 --
383 -- Syntax : '<descriptive_flex_context_code>/<global_flag>/<enabled_flag>/
384 -- <descriptive_flex_context_name>/<description>'
385 -- Example : 'Global Data Elements/Y/Y/Global Data Elements/Global Desc.'
386 --
387 FUNCTION get_dff_ctx(p_application_id IN NUMBER,
388 p_descriptive_flexfield_name IN VARCHAR2,
389 p_descriptive_flex_context_cod IN VARCHAR2)
390 RETURN VARCHAR2;
391
392 -- ===========================================================================
393 -- Returns the DFF Segment information.
394 --
395 -- Syntax : '<application_column_name>/<enabled_flag>/<display_flag>/
396 -- <end_user_column_name>/<form_left_prompt>/<description>'
397 -- Example : 'ATTRIBUTE1/Y/Y/My Column/ColPrompt/Desc.'
398 --
399 FUNCTION get_dff_seg(p_application_id IN NUMBER,
400 p_descriptive_flexfield_name IN VARCHAR2,
401 p_descriptive_flex_context_cod IN VARCHAR2,
402 p_application_column_name IN VARCHAR2)
403 RETURN VARCHAR2;
404
405 -- ===========================================================================
406 -- Returns the DFF Table Application information. Similar to get_app.
407 --
408 -- Syntax : '<application_id>/<application_short_name>/<application_name>'
409 -- Example : '0/FND/Application Object Library'
410 --
411 FUNCTION get_dff_tap(p_application_id IN NUMBER,
412 p_descriptive_flexfield_name IN VARCHAR2)
413 RETURN VARCHAR2;
414
415 -- ===========================================================================
416 -- Returns the DFF Table information. Similar to get_tbl.
417 --
418 -- Syntax : '<table_owner>/<table_name>/<table_id>'
419 -- Example : 'GL/GL_CODE_COMBINATIONS/584'
420 --
421 FUNCTION get_dff_tbl(p_application_id IN NUMBER,
422 p_descriptive_flexfield_name IN VARCHAR2)
423 RETURN VARCHAR2;
424
425 -- ===========================================================================
426 -- Returns the DFF Segment Column information. Similar to get_col.
427 --
428 -- Syntax : '<column_name>/<column_id>/<column_type>/<column_size>/
429 -- <flexfield_usage_code>/<flexfield_application_id>/
430 -- <flexfield_name>'
431 -- Example : 'ATTRIBUTE1/6407/V/60/D/101/GL_CODE_COMBINATIONS'
432 --
433 --
434 FUNCTION get_dff_col(p_application_id IN NUMBER,
435 p_descriptive_flexfield_name IN VARCHAR2,
436 p_application_column_name IN VARCHAR2)
437 RETURN VARCHAR2;
438
439 -- ===========================================================================
440 -- Returns the PL/SQL code to fix a problem.
441 -- pk's are primary keys for the specific rule.
442 --
443 FUNCTION get_dff_fix(p_rule IN VARCHAR2,
444 p_pk1 IN VARCHAR2 DEFAULT NULL,
445 p_pk2 IN VARCHAR2 DEFAULT NULL,
446 p_pk3 IN VARCHAR2 DEFAULT NULL,
447 p_pk4 IN VARCHAR2 DEFAULT NULL,
448 p_pk5 IN VARCHAR2 DEFAULT NULL)
449 RETURN VARCHAR2;
450
451 -- ***************************************************************************
452 -- * DFF fix_dff_something(); procedures.
453 -- ***************************************************************************
454 -- ===========================================================================
455 -- Fixes the integrity problems reported in DFF check script.
456 -- See $FND_TOP/sql/afffcdff.sql
457 --
458 -- ===========================================================================
459 -- Rules : A.03, A.09, A.10, A.11, A.12, D.01
460 --
461 PROCEDURE fix_dff_flx(p_rule IN VARCHAR2,
462 p_application_id IN NUMBER,
463 p_descriptive_flexfield_name IN VARCHAR2,
464 x_message OUT nocopy VARCHAR2);
465
466 -- ===========================================================================
467 -- Rules : B.01
468 --
472 p_default_context_field_name IN VARCHAR2,
469 PROCEDURE fix_dff_ref(p_rule IN VARCHAR2,
470 p_application_id IN NUMBER,
471 p_descriptive_flexfield_name IN VARCHAR2,
473 x_message OUT nocopy VARCHAR2);
474
475 -- ===========================================================================
476 -- Rules : C.03, C.04, C.05, C.06
477 --
478 PROCEDURE fix_dff_ctx(p_rule IN VARCHAR2,
479 p_application_id IN NUMBER,
480 p_descriptive_flexfield_name IN VARCHAR2,
481 p_descriptive_flex_context_cod IN VARCHAR2,
482 x_message OUT nocopy VARCHAR2);
483
484 -- ===========================================================================
485 -- Rules : E.03, E.06, E.07, E.08
486 --
487 PROCEDURE fix_dff_seg(p_rule IN VARCHAR2,
488 p_application_id IN NUMBER,
489 p_descriptive_flexfield_name IN VARCHAR2,
490 p_descriptive_flex_context_cod IN VARCHAR2,
491 p_application_column_name IN VARCHAR2,
492 x_message OUT nocopy VARCHAR2);
493
494 -- ===========================================================================
495 -- Rules : F.01, F.02
496 --
497 PROCEDURE fix_dff_col(p_rule IN VARCHAR2,
498 p_application_id IN NUMBER,
499 p_table_name IN VARCHAR2,
500 p_column_name IN VARCHAR2,
501 x_message OUT nocopy VARCHAR2);
502
503 -- ***************************************************************************
504 -- * KFF get_kff_something() RETURN VARCHAR2; functions.
505 -- ***************************************************************************
506 -- ===========================================================================
507 -- Returns the KFF information.
508 --
509 -- Syntax : '<id_flex_code>/<id_flex_name>/<description>'
510 -- Example : 'GL#/Accounting Flexfield/Acct. Flex.'
511 --
512 FUNCTION get_kff_flx(p_application_id IN NUMBER,
513 p_id_flex_code IN VARCHAR2)
514 RETURN VARCHAR2;
515
516 -- ===========================================================================
517 -- Returns the KFF structure information.
518 --
519 -- Syntax : '<id_flex_num>/<enabled_flag>/
520 -- <freeze_flex_definition_flag>/<concatenated_segment_delimiter>/
521 -- <id_flex_structure_name>'
522 -- Example : '101/Y/Y/./Operations Accounting Flexfield'
523 --
524 FUNCTION get_kff_str(p_application_id IN NUMBER,
525 p_id_flex_code IN VARCHAR2,
526 p_id_flex_num IN NUMBER)
527 RETURN VARCHAR2;
528
529 -- ===========================================================================
530 -- Returns the KFF Segment information.
531 --
532 -- Syntax : '<application_column_name>/<enabled_flag>/<display_flag>/
533 -- <segment_name>/<form_left_prompt>/<description>'
534 -- Example : 'SEGMENT1/Y/Y/Company/Prompt/Desc'
535 --
536 FUNCTION get_kff_seg(p_application_id IN NUMBER,
537 p_id_flex_code IN VARCHAR2,
538 p_id_flex_num IN NUMBER,
539 p_application_column_name IN VARCHAR2)
540 RETURN VARCHAR2;
541
542 -- ===========================================================================
543 -- Returns the KFF Shorthand Alias information.
544 --
545 -- Syntax : '<alias_name>/<enabled_flag>/<concatenated_segments>/
546 -- <description>'
547 -- Example : 'Cash/Y/01.100/Cash Account'
548 --
549 FUNCTION get_kff_sha(p_application_id IN NUMBER,
550 p_id_flex_code IN VARCHAR2,
551 p_id_flex_num IN NUMBER,
552 p_alias_name IN VARCHAR2)
553 RETURN VARCHAR2;
554
555
556 -- ===========================================================================
557 -- Returns the KFF Cross Validation Rule information.
558 --
559 -- Syntax : '<flex_validation_rule_name>/<enabled_flag>/
560 -- <error_message_text>/<description>'
561 -- Example : 'My_CVR/Y/Enter valid comb./My Cross Val'
562 --
563 FUNCTION get_kff_cvr(p_application_id IN NUMBER,
564 p_id_flex_code IN VARCHAR2,
565 p_id_flex_num IN NUMBER,
566 p_flex_validation_rule_name IN VARCHAR2)
567 RETURN VARCHAR2;
568
569 -- ===========================================================================
570 -- Returns the KFF Cross Validation Line information.
571 --
572 -- Syntax : '<rule_line_id>/<enabled_flag>/<include_exclude_indicator>/
573 -- <concatenated_segments_low>/<concatenated_segments_high>'
574 -- Example : '1234/Y/I/0.0.0/9.9.9'
575 --
576 FUNCTION get_kff_cvl(p_application_id IN NUMBER,
577 p_id_flex_code IN VARCHAR2,
578 p_id_flex_num IN NUMBER,
582
579 p_flex_validation_rule_name IN VARCHAR2,
580 p_rule_line_id IN NUMBER)
581 RETURN VARCHAR2;
583 -- ===========================================================================
584 -- Returns the Flexfield Qualifier Information.
585 --
586 -- Syntax : '<segment_attribute_type>/<global_flag>/
587 -- <required_flag>/<unique_flag>/<segment_prompt>'
588 -- Example : 'GL_GLOBAL/Y/Y/N/GL_GLOBAL'
589 --
590 FUNCTION get_kff_flq(p_application_id IN NUMBER,
591 p_id_flex_code IN VARCHAR2,
592 p_segment_attribute_type IN VARCHAR2)
593 RETURN VARCHAR2;
594
595 -- ===========================================================================
596 -- Returns the Segment Qualifier Information.
597 --
598 -- Syntax : '<value_attribute_type>/<application_column_name>/
599 -- <lookup_type>/<default_value>/<prompt>'
600 -- Example : 'GL_ACCOUNT_TYPE/ACCOUNT_TYPE/ACCOUNT_TYPE/E/Account Type'
601 --
602 FUNCTION get_kff_sgq(p_application_id IN NUMBER,
603 p_id_flex_code IN VARCHAR2,
604 p_segment_attribute_type IN VARCHAR2,
605 p_value_attribute_type IN VARCHAR2)
606 RETURN VARCHAR2;
607
608 -- ===========================================================================
609 -- Returns the KFF Table Application information. Similar to get_app.
610 --
611 -- Syntax : '<application_id>/<application_short_name>/<application_name>'
612 -- Example : '101/SQLGL/Oracle General Ledger'
613 --
614 FUNCTION get_kff_tap(p_application_id IN NUMBER,
615 p_id_flex_code IN VARCHAR2)
616 RETURN VARCHAR2;
617
618 -- ===========================================================================
619 -- Returns the KFF Table information. Similar to get_tbl.
620 --
621 -- Syntax : '<table_owner>/<table_name>/<table_id>'
622 -- Example : 'GL/GL_CODE_COMBINATIONS/584'
623 --
624 FUNCTION get_kff_tbl(p_application_id IN NUMBER,
625 p_id_flex_code IN VARCHAR2)
626 RETURN VARCHAR2;
627
628 -- ===========================================================================
629 -- Returns the KFF Segment Column information. Similar to get_col.
630 --
631 -- Syntax : '<column_name>/<column_id>/<column_type>/<column_size>/
632 -- <flexfield_usage_code>/<flexfield_application_id>/
633 -- <flexfield_name>'
634 -- Example : 'ATTRIBUTE1/6407/V/60/D/101/GL_CODE_COMBINATIONS'
635 --
636 --
637 FUNCTION get_kff_col(p_application_id IN NUMBER,
638 p_id_flex_code IN VARCHAR2,
639 p_application_column_name IN VARCHAR2)
640 RETURN VARCHAR2;
641
642 -- ===========================================================================
643 -- Returns the AG/WF Process details.
644 --
645 -- Syntax : '<wf_item_type>/<wf_process_name>'
646 -- Example : 'POWFRQBA/DEFAULT_ACCOUNT_GENERATION'
647 --
648 FUNCTION get_kff_fwp(p_application_id IN NUMBER,
649 p_id_flex_code IN VARCHAR2,
650 p_id_flex_num IN NUMBER,
651 p_wf_item_type IN VARCHAR2)
652 RETURN VARCHAR2;
653
654 -- ===========================================================================
655 -- Returns the PL/SQL code to fix a problem.
656 --
657 FUNCTION get_kff_fix(p_rule IN VARCHAR2,
658 p_pk1 IN VARCHAR2 DEFAULT NULL,
659 p_pk2 IN VARCHAR2 DEFAULT NULL,
660 p_pk3 IN VARCHAR2 DEFAULT NULL,
661 p_pk4 IN VARCHAR2 DEFAULT NULL,
662 p_pk5 IN VARCHAR2 DEFAULT NULL,
663 p_pk6 IN VARCHAR2 DEFAULT NULL)
664 RETURN VARCHAR2;
665
666
667 -- ***************************************************************************
668 -- * KFF fix_kff_something(); procedures.
669 -- ***************************************************************************
670 -- Fixes the integrity problems reported in KFF check script.
671 -- See $FND_TOP/sql/afffckff.sql
672 --
673 -- ===========================================================================
674 -- Rules : A.01, A.07, A.10, A.11, A.12, D.01
675 --
676 PROCEDURE fix_kff_flx(p_rule IN VARCHAR2,
677 p_application_id IN NUMBER,
678 p_id_flex_code IN VARCHAR2,
679 x_message OUT nocopy VARCHAR2);
680
681 -- ===========================================================================
682 -- Rules : B.03, B.04, E.01, E.02, K.01, K.02
683 --
684 PROCEDURE fix_kff_str(p_rule IN VARCHAR2,
685 p_application_id IN NUMBER,
686 p_id_flex_code IN VARCHAR2,
687 p_id_flex_num IN NUMBER,
688 x_message OUT nocopy VARCHAR2);
689
693 PROCEDURE fix_kff_seg(p_rule IN VARCHAR2,
690 -- ===========================================================================
691 -- Rules : C.03, C.06, C.07, C.08
692 --
694 p_application_id IN NUMBER,
695 p_id_flex_code IN VARCHAR2,
696 p_id_flex_num IN NUMBER,
697 p_application_column_name IN VARCHAR2,
698 x_message OUT nocopy VARCHAR2);
699
700 -- ===========================================================================
701 -- Rules : F.01, F.02
702 --
703 PROCEDURE fix_kff_sha(p_rule IN VARCHAR2,
704 p_application_id IN NUMBER,
705 p_id_flex_code IN VARCHAR2,
706 p_id_flex_num IN NUMBER,
707 p_alias_name IN VARCHAR2,
708 x_message OUT nocopy VARCHAR2);
709
710 -- ===========================================================================
711 -- Rules : G.03, G.04, G.05, G.07
712 --
713 PROCEDURE fix_kff_cvr(p_rule IN VARCHAR2,
714 p_application_id IN NUMBER,
715 p_id_flex_code IN VARCHAR2,
716 p_id_flex_num IN NUMBER,
717 p_flex_validation_rule_name IN VARCHAR2,
718 x_message OUT nocopy VARCHAR2);
719
720 -- ===========================================================================
721 -- Rules : H.01, H.02, I.01, J.01
722 --
723 PROCEDURE fix_kff_cvl(p_rule IN VARCHAR2,
724 p_application_id IN NUMBER,
725 p_id_flex_code IN VARCHAR2,
726 p_id_flex_num IN NUMBER,
727 p_flex_validation_rule_name IN VARCHAR2,
728 p_rule_line_id IN NUMBER,
729 x_message OUT nocopy VARCHAR2);
730
731 -- ===========================================================================
732 -- Rules : G.06, H.03
733 --
734 PROCEDURE fix_kff_cvrls(p_rule IN VARCHAR2,
735 x_message OUT nocopy VARCHAR2);
736
737
738 -- ===========================================================================
739 -- Rules : L.01, L.02
740 --
741 PROCEDURE fix_kff_flq(p_rule IN VARCHAR2,
742 p_application_id IN NUMBER,
743 p_id_flex_code IN VARCHAR2,
744 p_segment_attribute_type IN VARCHAR2,
745 x_message OUT nocopy VARCHAR2);
746
747 -- ===========================================================================
748 -- Rules : M.01, M.02, M.03, M.04
749 --
750 PROCEDURE fix_kff_qlv(p_rule IN VARCHAR2,
751 p_application_id IN NUMBER,
752 p_id_flex_code IN VARCHAR2,
753 p_id_flex_num IN NUMBER,
754 p_application_column_name IN VARCHAR2,
755 p_segment_attribute_type IN VARCHAR2,
756 x_message OUT nocopy VARCHAR2);
757
758 -- ===========================================================================
759 -- Rules : N.03, N.06, N.07
760 --
761 PROCEDURE fix_kff_sgq(p_rule IN VARCHAR2,
762 p_application_id IN NUMBER,
763 p_id_flex_code IN VARCHAR2,
764 p_segment_attribute_type IN VARCHAR2,
765 p_value_attribute_type IN VARCHAR2,
766 x_message OUT nocopy VARCHAR2);
767
768 -- ===========================================================================
769 -- Rules : O.01, O.02
770 --
771 PROCEDURE fix_kff_fvq(p_rule IN VARCHAR2,
772 p_id_flex_application_id IN NUMBER,
773 p_id_flex_code IN VARCHAR2,
774 p_segment_attribute_type IN VARCHAR2,
775 p_value_attribute_type IN VARCHAR2,
776 p_flex_value_set_id IN NUMBER,
777 x_message OUT nocopy VARCHAR2);
778
779 -- ===========================================================================
780 -- Rules : P.01, P.02, P.03, P.04
781 --
782 PROCEDURE fix_kff_col(p_rule IN VARCHAR2,
783 p_application_id IN NUMBER,
784 p_table_name IN VARCHAR2,
785 p_column_name IN VARCHAR2,
786 x_message OUT nocopy VARCHAR2);
787
788 -- ===========================================================================
789 -- Rules : R.01, R.02
790 --
791 PROCEDURE fix_kff_fwp(p_rule IN VARCHAR2,
792 p_application_id IN NUMBER,
793 p_id_flex_code IN VARCHAR2,
794 p_id_flex_num IN NUMBER,
795 p_wf_item_type IN VARCHAR2,
796 x_message OUT nocopy VARCHAR2);
797
798 END fnd_flex_diagnose;