1 PACKAGE FND_FLEX_APIS AUTHID CURRENT_USER AS
2 /* $Header: AFFFAPIS.pls 120.2 2010/05/25 17:10:40 tebarnes ship $ */
3
4 -- ------------------------------------------------------------------------
5 -- Gets the segment number corresponding to the **UNIQUE** qualifier
6 -- name entered. Segment number is the display order of the segment
7 -- not to be confused with the SEGMENT_NUM column of the
8 -- FND_ID_FLEX_SEGMENTS table. Returns TRUE segment_number if ok,
9 -- or FALSE and sets error using FND_MESSAGES on error.
10 -- ------------------------------------------------------------------------
11 FUNCTION get_qualifier_segnum(appl_id IN NUMBER,
12 key_flex_code IN VARCHAR2,
13 structure_number IN NUMBER,
14 flex_qual_name IN VARCHAR2,
15 segment_number OUT nocopy NUMBER)
16 RETURN BOOLEAN;
17 PRAGMA RESTRICT_REFERENCES(get_qualifier_segnum, WNDS, WNPS);
18
19
20 -- ----------------------------------------------------------------------
21 FUNCTION get_segment_column(x_application_id in NUMBER,
22 x_id_flex_code in VARCHAR2,
23 x_id_flex_num in NUMBER,
24 x_seg_attr_type in VARCHAR2,
25 x_app_column_name in out nocopy VARCHAR2)
26 RETURN BOOLEAN;
27 PRAGMA RESTRICT_REFERENCES(get_segment_column, WNDS, WNPS);
28
29 -- ----------------------------------------------------------------------
30 FUNCTION get_segment_info(x_application_id in NUMBER,
31 x_id_flex_code in VARCHAR2,
32 x_id_flex_num in NUMBER,
33 x_seg_num in NUMBER,
34 x_appcol_name out nocopy VARCHAR2,
35 x_seg_name out nocopy VARCHAR2,
36 x_prompt out nocopy VARCHAR2,
37 x_value_set_name out nocopy VARCHAR2)
38 RETURN BOOLEAN;
39 PRAGMA RESTRICT_REFERENCES(get_segment_info, WNDS, WNPS);
40
41
42 -- ----------------------------------------------------------------------
43 FUNCTION get_enabled_segment_num(x_application_id in NUMBER,
44 x_conc_prog_name in VARCHAR2,
45 x_num_of_segments out nocopy NUMBER)
46 return BOOLEAN;
47 PRAGMA RESTRICT_REFERENCES(get_enabled_segment_num, WNDS, WNPS);
48
49 -- ----------------------------------------------------------------------
50 FUNCTION get_segment_delimiter(x_application_id in NUMBER,
51 x_id_flex_code in VARCHAR2,
52 x_id_flex_num in NUMBER)
53 return VARCHAR2;
54 PRAGMA RESTRICT_REFERENCES(get_segment_delimiter, WNDS, WNPS);
55
56 -- ----------------------------------------------------------------------
57 FUNCTION gbl_get_segment_delimiter(x_application_id in NUMBER,
58 x_id_flex_code in VARCHAR2,
59 x_id_flex_num in NUMBER)
60 return VARCHAR2;
61 PRAGMA RESTRICT_REFERENCES(gbl_get_segment_delimiter, WNDS, WNPS);
62
63 -- ----------------------------------------------------------------------
64 FUNCTION is_descr_setup(x_application_id in NUMBER,
65 x_desc_flex_name in VARCHAR2)
66 return BOOLEAN;
67 PRAGMA RESTRICT_REFERENCES(is_descr_setup, WNDS, WNPS);
68
69 -- ----------------------------------------------------------------------
70 FUNCTION gbl_is_descr_setup(x_application_id in NUMBER,
71 x_desc_flex_name in VARCHAR2)
72 return BOOLEAN;
73 PRAGMA RESTRICT_REFERENCES(gbl_is_descr_setup, WNDS, WNPS);
74
75 -- ----------------------------------------------------------------------
76 FUNCTION is_descr_required(x_application_id in NUMBER,
77 x_desc_flex_name in VARCHAR2)
78 return BOOLEAN;
79 PRAGMA RESTRICT_REFERENCES(is_descr_required, WNDS, WNPS);
80
81 -- ----------------------------------------------------------------------
82 FUNCTION gbl_is_descr_required(x_application_id in NUMBER,
83 x_desc_flex_name in VARCHAR2)
84 return BOOLEAN;
85 PRAGMA RESTRICT_REFERENCES(gbl_is_descr_required, WNDS, WNPS);
86
87 -- ----------------------------------------------------------------------
88 PROCEDURE descr_setup_or_required(x_application_id IN NUMBER,
89 x_desc_flex_name IN VARCHAR2,
90 enabled_flag OUT nocopy VARCHAR2,
91 required_flag OUT nocopy VARCHAR2);
92 PRAGMA RESTRICT_REFERENCES(descr_setup_or_required, WNDS, WNPS);
93
94 -- ----------------------------------------------------------------------
95 PROCEDURE gbl_descr_setup_or_required(x_application_id IN NUMBER,
96 x_desc_flex_name IN VARCHAR2,
97 enabled_flag OUT nocopy VARCHAR2,
98 required_flag OUT nocopy VARCHAR2);
99 PRAGMA RESTRICT_REFERENCES(gbl_descr_setup_or_required, WNDS, WNPS);
100
101 -- ----------------------------------------------------------------------
102 TYPE varchar2_table IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER;
103
104 --
105 -- Stores the count and the names of required segments of a given DFF context.
106 -- Segment names are stored in 1 based array. (1 <= i <= required_segment_count)
107 --
108 TYPE dff_required_segments_info IS RECORD
109 (context_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE,
110 required_segment_names varchar2_table,
111 required_segment_count NUMBER);
112
113 -- ----------------------------------------------------------------------
114 -- Gets the required segment information for global segments of a given descriptive flexfield.
115 --
116 -- p_application_id - Application id of the DFF.
117 -- p_flexfield_name - Name of the DFF.
118 -- x_is_context_segment_required - Whether or not the context segment is required.
119 -- x_global_req_segs_info - Information about global required segments.
120 -- ----------------------------------------------------------------------
121 PROCEDURE get_dff_global_req_segs_info(p_application_id IN NUMBER,
122 p_flexfield_name IN VARCHAR2,
123 x_is_context_segment_required OUT nocopy BOOLEAN,
124 x_global_req_segs_info OUT nocopy dff_required_segments_info);
125
126 -- ----------------------------------------------------------------------
127 -- Gets the required segment information for a context of a given descriptive flexfield.
128 --
129 -- p_application_id - Application id of the DFF.
130 -- p_flexfield_name - Name of the DFF.
131 -- p_context_code - Internal code of the context value.
132 -- x_context_req_segs_info - Information about context sensitive required segments.
133 -- ----------------------------------------------------------------------
134 PROCEDURE get_dff_context_req_segs_info(p_application_id IN NUMBER,
135 p_flexfield_name IN VARCHAR2,
136 p_context_code IN VARCHAR2,
137 x_context_req_segs_info OUT nocopy dff_required_segments_info);
138
139 END FND_FLEX_APIS;