[Home] [Help]
PACKAGE: APPS.FND_FLEX_XML_PUBLISHER_APIS
Source
1 PACKAGE fnd_flex_xml_publisher_apis AS
2 /* $Header: AFFFXPAS.pls 120.0.12000000.1 2007/01/18 13:19:34 appldev ship $ */
3
4 --
5 -- metadata type constants
6 --
7 metadata_segments_above_prompt CONSTANT VARCHAR2(30) := 'ABOVE_PROMPT';
8 metadata_segments_left_prompt CONSTANT VARCHAR2(30) := 'LEFT_PROMPT';
9
10 --
11 -- kff_where: operator constants
12 --
13 operator_equal CONSTANT VARCHAR2(30) := '=';
14 operator_less_than CONSTANT VARCHAR2(30) := '<';
15 operator_greater_than CONSTANT VARCHAR2(30) := '>';
16 operator_less_than_or_equal CONSTANT VARCHAR2(30) := '<=';
17 operator_greater_than_or_equal CONSTANT VARCHAR2(30) := '>=';
18 operator_not_equal CONSTANT VARCHAR2(30) := '!=';
19 operator_concatenate CONSTANT VARCHAR2(30) := '||';
20 operator_between CONSTANT VARCHAR2(30) := 'BETWEEN';
21 operator_qbe CONSTANT VARCHAR2(30) := 'QBE';
22 operator_like CONSTANT VARCHAR2(30) := 'LIKE';
23
24 --
25 -- kff_select: output type constants
26 --
27 output_type_value CONSTANT VARCHAR2(30) := 'VALUE';
28 output_type_padded_value CONSTANT VARCHAR2(30) := 'PADDED_VALUE';
29 output_type_description CONSTANT VARCHAR2(30) := 'DESCRIPTION';
30 output_type_full_description CONSTANT VARCHAR2(30) := 'FULL_DESCRIPTION';
31 output_type_security CONSTANT VARCHAR2(30) := 'SECURITY';
32
33 --
34 -- kff_where: bind data type constants
35 --
36 bind_data_type_varchar2 CONSTANT VARCHAR2(30) := 'VARCHAR2';
37 bind_data_type_number CONSTANT VARCHAR2(30) := 'NUMBER';
38 bind_data_type_date CONSTANT VARCHAR2(30) := 'DATE';
39
40 TYPE bind_variable IS RECORD
41 (name VARCHAR2(30),
42 data_type VARCHAR2(30),
43 canonical_value VARCHAR2(32000),
44 varchar2_value VARCHAR2(32000),
45 number_value NUMBER,
46 date_value DATE);
47
48 TYPE bind_variables IS TABLE OF bind_variable INDEX BY BINARY_INTEGER;
49
50 --
51 -- Debug Modes
52 --
53 debug_mode_on CONSTANT VARCHAR2(30) := 'ON';
54 debug_mode_off CONSTANT VARCHAR2(30) := 'OFF';
55
56 -- ======================================================================
57 PROCEDURE set_debug_mode
58 (p_debug_mode IN VARCHAR2);
59
60 -- ======================================================================
61 PROCEDURE get_debug
62 (x_debug OUT nocopy VARCHAR2);
63
64 -- ======================================================================
65 PROCEDURE kff_flexfield_metadata
66 (p_lexical_name IN VARCHAR2,
67 p_application_short_name IN fnd_application.application_short_name%TYPE,
68 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
69 p_metadata_type IN VARCHAR2,
70 x_metadata OUT nocopy VARCHAR2);
71
72 -- ======================================================================
73 PROCEDURE kff_structure_metadata
74 (p_lexical_name IN VARCHAR2,
75 p_application_short_name IN fnd_application.application_short_name%TYPE,
76 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
77 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
78 p_metadata_type IN VARCHAR2,
79 x_metadata OUT nocopy VARCHAR2);
80
81 -- ======================================================================
82 PROCEDURE kff_segment_metadata
83 (p_lexical_name IN VARCHAR2,
84 p_application_short_name IN fnd_application.application_short_name%TYPE,
85 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
86 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
87 p_application_column_name IN fnd_id_flex_segments.application_column_name%TYPE,
88 p_metadata_type IN VARCHAR2,
89 x_metadata OUT nocopy VARCHAR2);
90
91 -- ======================================================================
92 PROCEDURE kff_segments_metadata
93 (p_lexical_name IN VARCHAR2,
94 p_application_short_name IN fnd_application.application_short_name%TYPE,
95 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
96 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
97 p_segments IN VARCHAR2,
98 p_show_parent_segments IN VARCHAR2,
99 p_metadata_type IN VARCHAR2,
100 x_metadata OUT nocopy VARCHAR2);
101
102 -- ======================================================================
103 PROCEDURE kff_select
104 (p_lexical_name IN VARCHAR2,
105 p_application_short_name IN fnd_application.application_short_name%TYPE,
106 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
107 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,
108 p_multiple_id_flex_num IN VARCHAR2 DEFAULT 'N',
109 p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
110 p_segments IN VARCHAR2 DEFAULT 'ALL',
111 p_show_parent_segments IN VARCHAR2 DEFAULT 'Y',
112 p_output_type IN VARCHAR2,
113 x_select_expression OUT nocopy VARCHAR2);
114
115 -- ======================================================================
116 PROCEDURE kff_where
117 (p_lexical_name IN VARCHAR2,
118 p_application_short_name IN fnd_application.application_short_name%TYPE,
119 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
120 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
121 p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
122 p_segments IN VARCHAR2 DEFAULT 'ALL',
123 p_operator IN VARCHAR2,
124 p_operand1 IN VARCHAR2,
125 p_operand2 IN VARCHAR2 DEFAULT NULL,
126 x_where_expression OUT nocopy VARCHAR2,
127 x_numof_bind_variables OUT nocopy NUMBER,
128 x_bind_variables OUT nocopy bind_variables);
129
130 -- ======================================================================
131 PROCEDURE kff_order_by
132 (p_lexical_name IN VARCHAR2,
133 p_application_short_name IN fnd_application.application_short_name%TYPE,
134 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
135 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE DEFAULT 101,
136 p_multiple_id_flex_num IN VARCHAR2 DEFAULT 'N',
137 p_code_combination_table_alias IN VARCHAR2 DEFAULT NULL,
138 p_segments IN VARCHAR2 DEFAULT 'ALL',
139 p_show_parent_segments IN VARCHAR2 DEFAULT 'Y',
140 x_order_by_expression OUT nocopy VARCHAR2);
141
142 -- ======================================================================
143 FUNCTION process_kff_combination_1
144 (p_lexical_name IN VARCHAR2,
145 p_application_short_name IN fnd_application.application_short_name%TYPE,
146 p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE,
147 p_id_flex_num IN fnd_id_flex_structures.id_flex_num%TYPE,
148 p_data_set IN fnd_id_flex_structures.id_flex_num%TYPE,
149 p_ccid IN NUMBER,
150 p_segments IN VARCHAR2,
151 p_show_parent_segments IN VARCHAR2,
152 p_output_type IN VARCHAR2)
153 RETURN VARCHAR2;
154
155 END fnd_flex_xml_publisher_apis;