1 PACKAGE hxc_layouts_upload_pkg AUTHID CURRENT_USER AS
2 /* $Header: hxculaupl.pkh 115.6 2004/05/13 03:00:24 dragarwa noship $ */
3
4 -- global variable
5 g_force_ok BOOLEAN;
6
7 PROCEDURE load_layout_row(
8 p_layout_name IN VARCHAR2,
9 p_application_short_name IN VARCHAR2,
10 p_owner IN VARCHAR2,
11 p_display_layout_name IN VARCHAR2,
12 p_layout_type IN VARCHAR2,
13 p_modifier_level IN VARCHAR2 DEFAULT NULL,
14 p_modifier_value IN VARCHAR2 DEFAULT NULL,
15 p_top_level_region_code IN VARCHAR2 DEFAULT NULL,
16 p_custom_mode IN VARCHAR2 DEFAULT NULL,
17 p_last_update_date IN VARCHAR2
18 );
19
20 PROCEDURE translate_layout_row(
21 p_application_short_name IN VARCHAR2,
22 p_layout_name IN VARCHAR2,
23 p_owner IN VARCHAR2,
24 p_display_layout_name IN VARCHAR2,
25 p_custom_mode IN VARCHAR2 DEFAULT NULL,
26 p_last_update_date IN VARCHAR2
27 );
28
29 PROCEDURE load_definition_row(
30 p_component_type IN VARCHAR2,
31 p_owner IN VARCHAR2,
32 p_component_class IN VARCHAR2,
33 p_render_type IN VARCHAR2,
34 p_custom_mode IN VARCHAR2 DEFAULT NULL,
35 p_last_update_date IN VARCHAR2
36 );
37
38 PROCEDURE load_component_row(
39 p_layout_name IN VARCHAR2,
40 p_component_name IN VARCHAR2,
41 p_owner IN VARCHAR2,
42 p_component_value IN VARCHAR2,
43 p_region_code IN VARCHAR2,
44 p_region_code_app_short_name IN VARCHAR2,
45 p_attribute_code IN VARCHAR2,
46 p_attribute_code_app_short_n IN VARCHAR2,
47 p_name_value_string IN VARCHAR2,
48 p_sequence IN NUMBER,
49 p_component_definition IN VARCHAR2,
50 p_render_type IN VARCHAR2,
51 p_parent_component IN VARCHAR2,
52 p_component_alias IN VARCHAR2,
53 p_parent_bean IN VARCHAR2,
54 p_attribute1 IN VARCHAR2,
55 p_attribute2 IN VARCHAR2,
56 p_attribute3 IN VARCHAR2,
57 p_attribute4 IN VARCHAR2,
58 p_attribute5 IN VARCHAR2,
59 p_custom_mode IN VARCHAR2 DEFAULT NULL,
60 p_last_update_date IN VARCHAR2
61 );
62
63 PROCEDURE load_prompt_row(
64 p_component_name IN VARCHAR2,
65 p_prompt_alias IN VARCHAR2,
66 p_prompt_type IN VARCHAR2,
67 p_owner IN VARCHAR2,
68 p_region_code IN VARCHAR2,
69 p_region_app_short_name IN VARCHAR2,
70 p_attribute_code IN VARCHAR2,
71 p_attribute_app_short_name IN VARCHAR2,
72 p_layout_name IN VARCHAR2,
73 p_custom_mode IN VARCHAR2 DEFAULT NULL,
74 p_last_update_date IN VARCHAR2
75 );
76
77 PROCEDURE load_qualifier_row(
78 p_component_name IN VARCHAR2,
79 p_qualifier_name IN VARCHAR2,
80 p_owner IN VARCHAR2,
81 p_qualifier_attribute_category IN VARCHAR2,
82 p_qualifier_attribute1 IN VARCHAR2,
83 p_qualifier_attribute2 IN VARCHAR2,
84 p_qualifier_attribute3 IN VARCHAR2,
85 p_qualifier_attribute4 IN VARCHAR2,
86 p_qualifier_attribute5 IN VARCHAR2,
87 p_qualifier_attribute6 IN VARCHAR2,
88 p_qualifier_attribute7 IN VARCHAR2,
89 p_qualifier_attribute8 IN VARCHAR2,
90 p_qualifier_attribute9 IN VARCHAR2,
91 p_qualifier_attribute10 IN VARCHAR2,
92 p_qualifier_attribute11 IN VARCHAR2,
93 p_qualifier_attribute12 IN VARCHAR2,
94 p_qualifier_attribute13 IN VARCHAR2,
95 p_qualifier_attribute14 IN VARCHAR2,
96 p_qualifier_attribute15 IN VARCHAR2,
97 p_qualifier_attribute16 IN VARCHAR2,
98 p_qualifier_attribute17 IN VARCHAR2,
99 p_qualifier_attribute18 IN VARCHAR2,
100 p_qualifier_attribute19 IN VARCHAR2,
101 p_qualifier_attribute20 IN VARCHAR2,
102 p_qualifier_attribute21 IN VARCHAR2,
103 p_qualifier_attribute22 IN VARCHAR2,
104 p_qualifier_attribute23 IN VARCHAR2,
105 p_qualifier_attribute24 IN VARCHAR2,
106 p_qualifier_attribute25 IN VARCHAR2,
107 p_qualifier_attribute26 IN VARCHAR2,
108 p_qualifier_attribute27 IN VARCHAR2,
109 p_qualifier_attribute28 IN VARCHAR2,
110 p_qualifier_attribute29 IN VARCHAR2,
111 p_qualifier_attribute30 IN VARCHAR2,
112 p_layout_name IN VARCHAR2,
113 p_custom_mode IN VARCHAR2 DEFAULT NULL,
114 p_last_update_date IN VARCHAR2
115 );
116
117 PROCEDURE LOAD_LAYOUT_ROW
118 (P_LAYOUT_NAME IN VARCHAR2
119 ,P_APPLICATION_SHORT_NAME IN VARCHAR2
120 ,P_OWNER IN VARCHAR2
121 ,P_DISPLAY_LAYOUT_NAME IN VARCHAR2
122 ,P_LAYOUT_TYPE IN VARCHAR2
123 ,P_MODIFIER_LEVEL IN VARCHAR2 DEFAULT NULL
124 ,P_MODIFIER_VALUE IN VARCHAR2 DEFAULT NULL
125 ,P_TOP_LEVEL_REGION_CODE IN VARCHAR2 DEFAULT NULL
126 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
127 );
128
129 PROCEDURE TRANSLATE_LAYOUT_ROW
130 (P_APPLICATION_SHORT_NAME IN VARCHAR2
131 ,P_LAYOUT_NAME IN VARCHAR2
132 ,P_OWNER IN VARCHAR2
133 ,P_DISPLAY_LAYOUT_NAME IN VARCHAR2
134 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
135 );
136
137 PROCEDURE LOAD_DEFINITION_ROW
138 (P_COMPONENT_TYPE IN VARCHAR2
139 ,P_OWNER IN VARCHAR2
140 ,P_COMPONENT_CLASS IN VARCHAR2
141 ,P_RENDER_TYPE IN VARCHAR2
142 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
143 );
144
145 PROCEDURE LOAD_COMPONENT_ROW
146 (P_LAYOUT_NAME IN VARCHAR2
147 ,P_COMPONENT_NAME IN VARCHAR2
148 ,P_OWNER IN VARCHAR2
149 ,P_COMPONENT_VALUE IN VARCHAR2
150 ,P_REGION_CODE IN VARCHAR2
151 ,P_REGION_CODE_APP_SHORT_NAME IN VARCHAR2
152 ,P_ATTRIBUTE_CODE IN VARCHAR2
153 ,P_ATTRIBUTE_CODE_APP_SHORT_N IN VARCHAR2
154 ,P_NAME_VALUE_STRING IN VARCHAR2
155 ,P_SEQUENCE IN NUMBER
156 ,P_COMPONENT_DEFINITION IN VARCHAR2
157 ,P_RENDER_TYPE IN VARCHAR2
158 ,P_PARENT_COMPONENT IN VARCHAR2
159 ,P_COMPONENT_ALIAS IN VARCHAR2
160 ,P_PARENT_BEAN IN VARCHAR2
161 ,P_ATTRIBUTE1 IN VARCHAR2
162 ,P_ATTRIBUTE2 IN VARCHAR2
163 ,P_ATTRIBUTE3 IN VARCHAR2
164 ,P_ATTRIBUTE4 IN VARCHAR2
165 ,P_ATTRIBUTE5 IN VARCHAR2
166 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
167 );
168
169 PROCEDURE LOAD_PROMPT_ROW
170 (P_COMPONENT_NAME IN VARCHAR2
171 ,P_PROMPT_ALIAS IN VARCHAR2
172 ,P_PROMPT_TYPE IN VARCHAR2
173 ,P_OWNER IN VARCHAR2
174 ,P_REGION_CODE IN VARCHAR2
175 ,P_REGION_APP_SHORT_NAME IN VARCHAR2
176 ,P_ATTRIBUTE_CODE IN VARCHAR2
177 ,P_ATTRIBUTE_APP_SHORT_NAME IN VARCHAR2
178 ,p_layout_name IN VARCHAR2
179 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
180 );
181
182 PROCEDURE LOAD_QUALIFIER_ROW
183 (P_COMPONENT_NAME IN VARCHAR2
184 ,P_QUALIFIER_NAME IN VARCHAR2
185 ,P_OWNER IN VARCHAR2
186 ,P_QUALIFIER_ATTRIBUTE_CATEGORY IN VARCHAR2
187 ,P_QUALIFIER_ATTRIBUTE1 IN VARCHAR2
188 ,P_QUALIFIER_ATTRIBUTE2 IN VARCHAR2
189 ,P_QUALIFIER_ATTRIBUTE3 IN VARCHAR2
190 ,P_QUALIFIER_ATTRIBUTE4 IN VARCHAR2
191 ,P_QUALIFIER_ATTRIBUTE5 IN VARCHAR2
192 ,P_QUALIFIER_ATTRIBUTE6 IN VARCHAR2
193 ,P_QUALIFIER_ATTRIBUTE7 IN VARCHAR2
194 ,P_QUALIFIER_ATTRIBUTE8 IN VARCHAR2
195 ,P_QUALIFIER_ATTRIBUTE9 IN VARCHAR2
196 ,P_QUALIFIER_ATTRIBUTE10 IN VARCHAR2
197 ,P_QUALIFIER_ATTRIBUTE11 IN VARCHAR2
198 ,P_QUALIFIER_ATTRIBUTE12 IN VARCHAR2
199 ,P_QUALIFIER_ATTRIBUTE13 IN VARCHAR2
200 ,P_QUALIFIER_ATTRIBUTE14 IN VARCHAR2
201 ,P_QUALIFIER_ATTRIBUTE15 IN VARCHAR2
202 ,P_QUALIFIER_ATTRIBUTE16 IN VARCHAR2
203 ,P_QUALIFIER_ATTRIBUTE17 IN VARCHAR2
204 ,P_QUALIFIER_ATTRIBUTE18 IN VARCHAR2
205 ,P_QUALIFIER_ATTRIBUTE19 IN VARCHAR2
206 ,P_QUALIFIER_ATTRIBUTE20 IN VARCHAR2
207 ,P_QUALIFIER_ATTRIBUTE21 IN VARCHAR2
208 ,P_QUALIFIER_ATTRIBUTE22 IN VARCHAR2
209 ,P_QUALIFIER_ATTRIBUTE23 IN VARCHAR2
210 ,P_QUALIFIER_ATTRIBUTE24 IN VARCHAR2
211 ,P_QUALIFIER_ATTRIBUTE25 IN VARCHAR2
212 ,P_QUALIFIER_ATTRIBUTE26 IN VARCHAR2
213 ,P_QUALIFIER_ATTRIBUTE27 IN VARCHAR2
214 ,P_QUALIFIER_ATTRIBUTE28 IN VARCHAR2
215 ,P_QUALIFIER_ATTRIBUTE29 IN VARCHAR2
216 ,P_QUALIFIER_ATTRIBUTE30 IN VARCHAR2
217 ,p_layout_name IN VARCHAR2
218 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
219 );
220 /*
221 PROCEDURE LOAD_RULE_ROW
222 (P_QUALIFIER_NAME IN VARCHAR2
223 ,P_RULE_NAME IN VARCHAR2
224 ,P_OWNER IN VARCHAR2
225 ,P_RULE_TYPE IN VARCHAR2
226 ,P_RULE_DETAIL IN VARCHAR2
227 ,P_RULE_VALUE IN VARCHAR2
228 ,P_CUSTOM_MODE IN VARCHAR2 DEFAULT NULL
229 );
230 */
231 END hxc_layouts_upload_pkg;