1 PACKAGE fnd_dflex AS
2 /* $Header: AFFFDDUS.pls 120.2.12010000.1 2008/07/25 14:13:44 appldev ship $ */
3
4
5 /* private */
6 /* unique identifier of a dflexfield: */
7 TYPE dflex_r IS RECORD (application_id fnd_application.application_id%TYPE,
8 flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE);
9
10 /* public */
11 TYPE dflex_dr IS RECORD (title fnd_descriptive_flexs_vl.title%TYPE,
12 table_name fnd_descriptive_flexs_vl.application_table_name%TYPE,
13 table_app fnd_application.application_short_name%TYPE,
14 description fnd_descriptive_flexs_vl.description%TYPE,
15 segment_delimeter fnd_descriptive_flexs_vl.concatenated_segment_delimiter%TYPE,
16 default_context_field fnd_descriptive_flexs_vl.default_context_field_name%TYPE,
17 default_context_value fnd_descriptive_flexs_vl.default_context_value%TYPE,
18 protected_flag fnd_descriptive_flexs_vl.protected_flag%TYPE,
19 form_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE,
20 context_column_name fnd_descriptive_flexs_vl.context_column_name%TYPE);
21
22 TYPE context_code_a IS TABLE OF fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE INDEX BY BINARY_INTEGER;
23 TYPE context_name_a IS TABLE OF fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE INDEX BY BINARY_INTEGER;
24 TYPE context_description_a IS TABLE OF fnd_descr_flex_contexts_vl.description%TYPE INDEX BY BINARY_INTEGER;
25 TYPE boolean_a IS TABLE OF BOOLEAN INDEX BY BINARY_INTEGER;
26
27 /* private */
28 /* unique identifier of a context: */
29 TYPE context_r IS RECORD (flexfield dflex_r,
30 context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE);
31
32 /* public */
33 TYPE contexts_dr IS RECORD (ncontexts BINARY_INTEGER,
34 global_context BINARY_INTEGER,
35 context_code context_code_a,
36 context_name context_name_a,
37 context_description context_description_a,
38 is_enabled boolean_a,
39 is_global boolean_a);
40
41 TYPE segment_description_a IS TABLE OF fnd_descr_flex_col_usage_vl.description%TYPE INDEX BY BINARY_INTEGER;
42 TYPE application_column_name_a IS TABLE OF fnd_descr_flex_col_usage_vl.application_column_name%TYPE INDEX BY BINARY_INTEGER;
43 TYPE segment_name_a IS TABLE OF fnd_descr_flex_col_usage_vl.end_user_column_name%TYPE INDEX BY BINARY_INTEGER;
44 TYPE sequence_a IS TABLE OF fnd_descr_flex_col_usage_vl.column_seq_num%TYPE INDEX BY BINARY_INTEGER;
45 TYPE display_size_a IS TABLE OF fnd_descr_flex_col_usage_vl.display_size%TYPE INDEX BY BINARY_INTEGER;
46 TYPE row_prompt_a IS TABLE OF fnd_descr_flex_col_usage_vl.form_left_prompt%TYPE INDEX BY BINARY_INTEGER;
47 TYPE column_prompt_a IS TABLE OF fnd_descr_flex_col_usage_vl.form_above_prompt%TYPE INDEX BY BINARY_INTEGER;
48 TYPE value_set_a IS TABLE OF fnd_descr_flex_col_usage_vl.flex_value_set_id%TYPE INDEX BY BINARY_INTEGER;
49 TYPE default_type_a IS TABLE OF fnd_descr_flex_col_usage_vl.default_type%TYPE INDEX BY BINARY_INTEGER;
50 TYPE default_value_a IS TABLE OF fnd_descr_flex_col_usage_vl.default_value%TYPE INDEX BY BINARY_INTEGER;
51
52 TYPE segments_dr IS RECORD (nsegments BINARY_INTEGER,
53 application_column_name application_column_name_a,
54 segment_name segment_name_a,
55 sequence sequence_a,
56 is_displayed boolean_a,
57 display_size display_size_a,
58 row_prompt row_prompt_a,
59 column_prompt column_prompt_a,
60 is_enabled boolean_a,
61 is_required boolean_a,
62 description segment_description_a,
63 value_set value_set_a,
64 default_type default_type_a,
65 default_value default_value_a);
66
67
68
69 /* returns information about the flexfield */
70 PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
71 flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
72 flexfield OUT nocopy dflex_r,
73 flexinfo OUT nocopy dflex_dr);
74
75 /* returns the contexts in a flexfield */
76 PROCEDURE get_contexts(flexfield IN dflex_r,
77 contexts OUT nocopy contexts_dr);
78
79 FUNCTION make_context(flexfield IN dflex_r,
80 context_code IN fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE)
81 RETURN context_r;
82
83 /* returns information about all the segments in a particular context */
84 PROCEDURE get_segments(context IN context_r,
85 segments OUT nocopy segments_dr,
86 enabled_only IN BOOLEAN);
87
88 -- for back support purposes
89 -- this procedure originally was defined without enabled_only flag
90
91 PROCEDURE get_segments(context IN context_r,
92 segments OUT nocopy segments_dr);
93
94
95
96 PROCEDURE test;
97
98 END fnd_dflex; /* end package */