1 PACKAGE FND_IREP_LOADER_PRIVATE AS
2 /* $Header: AFIRLDRS.pls 120.2.12010000.2 2008/09/24 11:13:00 snalagan ship $ */
3 --
4 -- Procedure
5 -- UPLOAD_IREP_OBJECT
6 --
7 -- Purpose
8 -- Upload irep object
9 --
10 --
11 PROCEDURE UPLOAD_IREP_OBJECT( P_UPLOAD_MODE IN VARCHAR2,
12 P_OBJECT_NAME IN VARCHAR2,
13 P_DEST_TABLE IN VARCHAR2,
14 P_OWNER IN VARCHAR2,
15 P_API_NAME IN VARCHAR2,
16 P_OBJ_TYPE IN VARCHAR2,
17 P_PRODUCT IN VARCHAR2,
18 P_IMP_NAME IN VARCHAR2,
19 P_COMPATABILITY IN VARCHAR2,
20 P_SCOPE IN VARCHAR2,
21 P_LIFECYCLE IN VARCHAR2,
22 P_SOURCE_FILE_PRODUCT IN VARCHAR2,
23 P_SOURCE_FILE_PATH IN VARCHAR2,
24 P_SOURCE_FILE_NAME IN VARCHAR2,
25 P_SOURCE_FILE_VERSION IN VARCHAR2,
26 P_DESCRIPTION IN VARCHAR2,
27 P_STANDARD IN VARCHAR2,
28 P_STANDARD_VERSION IN VARCHAR2,
29 P_STANDARD_SPEC IN VARCHAR2,
30 P_DISPNAME IN VARCHAR2,
31 P_SHORTDISC IN VARCHAR2,
32 P_TIMESTAMP IN VARCHAR2,
33 P_OI_FLAG IN VARCHAR2,
34 P_MAPCODE IN VARCHAR2,
35 P_PARSER_VERSION IN VARCHAR2,
36 P_SDO_DEF_CLASS IN VARCHAR2,
37 P_SDO_CLASS_NAME IN VARCHAR2,
38 P_SDO_IS_FILTER IN VARCHAR2,
39 P_SDO_FILTER_REQUIRED IN VARCHAR2,
40 P_SDO_IS_EXPRESSION IN VARCHAR2,
41 P_SB_INTERFACE_CLASS IN VARCHAR2,
42 P_CRAWL_CRAWLABLE IN VARCHAR2,
43 P_CRAWL_VISIBILITY_LEVEL IN VARCHAR2,
44 P_CRAWL_SEARCH_PLUGIN IN VARCHAR2,
45 P_CRAWL_UI_FUNCTION IN VARCHAR2,
46 P_CRAWL_CHANGE_EVENT_NAME IN VARCHAR2,
47 P_CRAWL_CHANGE_NTF IN VARCHAR2,
48 P_CRAWL_DRIVING_TABLE IN VARCHAR2);
49
50 --
51 -- Procedure
52 -- UPLOAD_Parents
53 --
54 -- Purpose
55 -- Upload parents
56 --
57 --
58 PROCEDURE UPLOAD_PARENTS(P_UPLOAD_MODE IN VARCHAR2,
59 P_OBJECT_NAME IN VARCHAR2,
60 P_DEST_TABLE IN VARCHAR2,
61 P_PARENT_NAME IN VARCHAR2);
62
63
64
65 --
66 -- Procedure
67 -- UPLOAD_OBJECT_CATEGORY
68 --
69 -- Purpose
70 -- Upload Object Category
71 --
72 PROCEDURE UPLOAD_OBJECT_CATEGORY( P_UPLOAD_MODE IN VARCHAR2,
73 P_OBJECT_NAME IN VARCHAR2,
74 P_DEST_TABLE IN VARCHAR2,
75 P_TYPE IN VARCHAR2,
76 P_CODE IN VARCHAR2,
77 P_SEQUENCE IN VARCHAR2);
78
79
80 --
81 -- Procedure
82 -- UPLOAD_OBJ_CHILD_ANNOTATIONS
83 --
84 -- Purpose
85 -- Upload Object Child Annotations
86 --
87 PROCEDURE UPLOAD_OBJ_CHILD_ANNOTATIONS( P_UPLOAD_MODE IN VARCHAR2,
88 P_OBJECT_NAME IN VARCHAR2,
89 P_DEST_TABLE IN VARCHAR2,
90 P_CHILD_FLAG IN VARCHAR2,
91 P_VALUE IN VARCHAR2);
92
93
94 --
95 -- Procedure
96 -- UPLOAD_TYPE_MEMBERS
97 --
98 -- Purpose
99 -- Upload Type Members
100 --
101 PROCEDURE UPLOAD_TYPE_MEMBERS( P_UPLOAD_MODE IN VARCHAR2,
102 P_OBJECT_NAME IN VARCHAR2,
103 P_DEST_TABLE IN VARCHAR2,
104 P_SEQUENCE IN VARCHAR2,
105 P_INNERTYPE_SEQUENCE IN VARCHAR2,
106 P_MEMBER_NAME IN VARCHAR2,
107 P_TYPE IN VARCHAR2,
108 P_PRECISION IN VARCHAR2,
109 P_SIZE IN VARCHAR2,
110 P_SCALE IN VARCHAR2,
111 P_NULL_ALLOWED IN VARCHAR2,
112 P_DESCRIPTION IN VARCHAR2,
113 P_ATTR_SET IN VARCHAR2,
114 P_PRIMARY_KEY IN VARCHAR2,
115 P_TRANSLATABLE IN VARCHAR2,
116 P_COMPOSITE IN VARCHAR2,
117 P_DOMAIN_NAME IN VARCHAR2,
118 P_MEMBER_TYPE_NAME IN VARCHAR2,
119 P_SEARCH_CRITERIA_TYPE IN VARCHAR2,
120 P_ATTACHMENT IN VARCHAR2,
121 P_MIME_TYPE IN VARCHAR2,
122 P_DOMAIN_IMPLEMENTATION IN VARCHAR2,
123 P_IS_SORTABLE IN VARCHAR2,
124 P_CRAWL_IS_DATE_BASED IN VARCHAR2,
125 P_CRAWL_MEMBER_VIS_LVL IN VARCHAR2,
126 P_CRAWL_IS_DISPLAYED IN VARCHAR2,
127 P_CRAWL_UI_FPARAM_NAME IN VARCHAR2,
128 P_CRAWL_INDEXED IN VARCHAR2,
129 P_CRAWL_STORED IN VARCHAR2,
130 P_CRAWL_IS_SECURE IN VARCHAR2,
131 P_CRAWL_IS_TITLE IN VARCHAR2,
132 P_CRAWL_WEIGHT IN VARCHAR2);
133
134
135
136 --
137 -- Procedure
138 -- UPLOAD_USES_TABLE
139 --
140 -- Purpose
141 -- Upload Uses Table
142 --
143 PROCEDURE UPLOAD_USES_TABLE( P_UPLOAD_MODE IN VARCHAR2,
144 P_OBJECT_NAME IN VARCHAR2,
145 P_DEST_TABLE IN VARCHAR2,
146 P_TABLE_NAME IN VARCHAR2,
147 P_UT_SEQ IN VARCHAR2,
148 P_UT_DIRECTION IN VARCHAR2);
149
150
151
152 --
153 -- Procedure
154 -- UPLOAD_USES_MAP
155 --
156 -- Purpose
157 -- Upload Uses Map
158 --
159 PROCEDURE UPLOAD_USES_MAP( P_UPLOAD_MODE IN VARCHAR2,
160 P_OBJECT_NAME IN VARCHAR2,
161 P_DEST_TABLE IN VARCHAR2,
162 P_MAP_NAME IN VARCHAR2,
163 P_UM_SEQ IN VARCHAR2);
164
165
166 --
167 -- Procedure
168 -- UPLOAD_CLASS_DATASOURCES
169 --
170 -- Purpose
171 -- Upload Class Datasources
172 --
173 PROCEDURE UPLOAD_CLASS_DATASOURCES(P_UPLOAD_MODE IN VARCHAR2,
174 P_OBJECT_NAME IN VARCHAR2,
175 P_DEST_TABLE IN VARCHAR2,
176 P_DATASOURCE_NAME IN VARCHAR2,
177 P_DEF_CLASS IN VARCHAR2,
178 P_QUERYABLE IN VARCHAR2,
179 P_UPDATEABLE IN VARCHAR2,
180 P_INSERTABLE IN VARCHAR2,
181 P_MERGEABLE IN VARCHAR2,
182 P_DELETEABLE IN VARCHAR2,
183 P_PROCESS_QNAME IN VARCHAR2,
184 P_QUERY_QNAME IN VARCHAR2);
185
186
187 --
188 -- Procedure
189 -- UPLOAD_OBJ_KEY_SET
190 --
191 -- Purpose
192 -- Upload Object Key Set
193 --
194 PROCEDURE UPLOAD_OBJ_KEY_SET(P_UPLOAD_MODE IN VARCHAR2,
195 P_OBJECT_NAME IN VARCHAR2,
196 P_DEST_TABLE IN VARCHAR2,
197 P_KEY_SET_NAME IN VARCHAR2,
198 P_KEY_SET_SEQUENCE IN VARCHAR2,
199 P_KEY1_MBR_NAME IN VARCHAR2,
200 P_KEY2_MBR_NAME IN VARCHAR2,
201 P_KEY3_MBR_NAME IN VARCHAR2,
202 P_KEY4_MBR_NAME IN VARCHAR2,
203 P_KEY5_MBR_NAME IN VARCHAR2,
204 P_ALT1_MBR_NAME IN VARCHAR2,
205 P_ALT2_MBR_NAME IN VARCHAR2,
206 P_ALT3_MBR_NAME IN VARCHAR2,
207 P_ALT4_MBR_NAME IN VARCHAR2,
208 P_ALT5_MBR_NAME IN VARCHAR2);
209
210
211 --
212 -- Procedure
213 -- UPLOAD_IREP_METHOD
214 --
215 -- Purpose
216 -- Upload iRep Method
217 --
218 PROCEDURE UPLOAD_IREP_METHOD( P_UPLOAD_MODE IN VARCHAR2,
219 P_OBJECT_NAME IN VARCHAR2,
220 P_DEST_TABLE IN VARCHAR2,
221 P_FUNCTION_NAME IN VARCHAR2,
222 P_METHOD_NAME IN VARCHAR2,
223 P_OVERLOAD_SEQ IN VARCHAR2,
224 P_SCOPE IN VARCHAR2,
225 P_LIFECYCLE IN VARCHAR2,
226 P_DESCRIPTION IN VARCHAR2,
227 P_COMPATABILITY IN VARCHAR2,
228 P_SYNCHRO IN VARCHAR2,
229 P_DIRECTION IN VARCHAR2,
230 P_CTX_DEPENDENCE IN VARCHAR2,
231 P_USER_FN_NAME IN VARCHAR2,
232 P_SHORT_DESCRIPTION IN VARCHAR2,
233 P_PRIMARY_FLAG IN VARCHAR2,
234 P_INDIRECT_OP_FLAG IN VARCHAR2);
235
236
237 --
238 -- Procedure
239 -- UPLOAD_METHOD_CATEGORY
240 --
241 -- Purpose
242 -- Upload Method Category
243 --
244 PROCEDURE UPLOAD_METHOD_CATEGORY( P_UPLOAD_MODE IN VARCHAR2,
245 P_OBJECT_NAME IN VARCHAR2,
246 P_DEST_TABLE IN VARCHAR2,
247 P_FUNCTION_NAME IN VARCHAR2,
248 P_OVERLOAD_SEQ IN VARCHAR2,
249 P_TYPE IN VARCHAR2,
250 P_CODE IN VARCHAR2,
251 P_SEQUENCE IN VARCHAR2);
252
253 --
254 -- Procedure
255 -- UPLOAD_METHOD_CHILD_ANNOTATION
256 --
257 -- Purpose
258 -- Upload Method Child Annotation
259 --
260 PROCEDURE UPLOAD_METHOD_CHILD_ANNOTATION(P_UPLOAD_MODE IN VARCHAR2,
261 P_OBJECT_NAME IN VARCHAR2,
262 P_DEST_TABLE IN VARCHAR2,
263 P_FUNCTION_NAME IN VARCHAR2,
264 P_OVERLOAD_SEQ IN VARCHAR2,
265 P_CHILD_FLAG IN VARCHAR2,
266 P_VALUE IN VARCHAR2);
267
268
269 --
270 -- Procedure
271 -- UPLOAD_PARAMS
272 --
273 -- Purpose
277 P_OBJECT_NAME IN VARCHAR2,
274 -- Upload Parameters
275 --
276 PROCEDURE UPLOAD_PARAMS( P_UPLOAD_MODE IN VARCHAR2,
278 P_DEST_TABLE IN VARCHAR2,
279 P_FUNCTION_NAME IN VARCHAR2,
280 P_OVERLOAD_SEQ IN VARCHAR2,
281 P_SEQUENCE IN VARCHAR2,
282 P_INNERTYPE_SEQUENCE IN VARCHAR2,
283 P_NAME IN VARCHAR2,
284 P_DIRECTION IN VARCHAR2,
285 P_OPTIONAL IN VARCHAR2,
286 P_TYPE IN VARCHAR2,
287 P_PRECISION IN VARCHAR2,
288 P_SIZE IN VARCHAR2,
289 P_SCALE IN VARCHAR2,
290 P_NULL_ALLOWED IN VARCHAR2,
291 P_DESCRIPTION IN VARCHAR2,
292 P_DEFAULT_VALUE IN VARCHAR2,
293 P_DISPLAYED IN VARCHAR2,
294 P_ATTRIBUTE_SET IN VARCHAR2);
295
296
297 --
298 -- Function
299 -- COMPARE_VERSIONS
300 --
301 -- Purpose
302 -- Compare the version numbers of two files
303 --
304 -- Returns: The string "=" if p_version1 = p_version2
305 -- The string ">" if p_version1 > p_version2
306 -- The string "<" if p_version1 < p_version2
307
308 FUNCTION COMPARE_VERSIONS(p_version1 IN VARCHAR2,
309 p_version2 IN VARCHAR2)
310 RETURN VARCHAR2;
311
312
313
314 --
315 -- Procedure
316 -- iRepPostProcess
317 --
318 -- Purpose
319 -- Do various post processing to irep data. Currently just denormalizes
320 -- inherited methods into child classes. This is called from the post
321 -- processing java code which does various other post processing (such as
322 -- updating schema entries).
323 --
324
325 PROCEDURE iRepPostProcess;
326
327 --
328 -- Procedure
329 -- ADD_LANGUAGE
330 --
331 -- Purpose
332 -- This is a hack to support the mls procedure provided by mls table handlers.
333 -- Even though translations are not supported for these tables, for historical
334 -- reasons we utilize the _TL/_VL design.
335 --
336 -- In order to avoid missing data in a newly added language we need to provide
337 -- an add_language procedure (even though it is not attached to a traditional
338 -- table handler package).
339 --
340
341 PROCEDURE ADD_LANGUAGE;
342
343 -- Procedure
344 -- GET_DELETE_GRANTS
345 -- Purpose
346 --- Used to fetch and store menu entries and grants associated with a function
347 PROCEDURE GET_DELETE_GRANTS(key_id IN NUMBER);
348
349 -- Procedure
350 -- RESTORE_GRANTS
351 -- Purpose
352 --- Used to restore menus and grants for a function
353 PROCEDURE RESTORE_GRANTS(f_id IN NUMBER,f_name in varchar);
354
355 end FND_IREP_LOADER_PRIVATE;