255: )return boolean;
256: function get_level(
257: p_dim_name varchar2,
258: p_apps_origin varchar2,
259: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
260: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
261: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
262: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
263: p_number_levels out nocopy number
256: function get_level(
257: p_dim_name varchar2,
258: p_apps_origin varchar2,
259: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
260: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
261: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
262: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
263: p_number_levels out nocopy number
264: )return boolean;
257: p_dim_name varchar2,
258: p_apps_origin varchar2,
259: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
260: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
261: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
262: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
263: p_number_levels out nocopy number
264: )return boolean;
265: function get_dim_for_level(
258: p_apps_origin varchar2,
259: p_level_name out nocopy BSC_IM_UTILS.varchar_tabletype,
260: p_number_children out nocopy BSC_IM_UTILS.number_tabletype,
261: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
262: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
263: p_number_levels out nocopy number
264: )return boolean;
265: function get_dim_for_level(
266: p_level varchar2,
268: p_dim_name out nocopy varchar2) return boolean;
269: function get_column(
270: p_parent_name varchar2,
271: p_apps_origin varchar2,
272: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
269: function get_column(
270: p_parent_name varchar2,
271: p_apps_origin varchar2,
272: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
270: p_parent_name varchar2,
271: p_apps_origin varchar2,
272: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
278: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
271: p_apps_origin varchar2,
272: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
278: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
279: p_number_columns out nocopy number
272: p_column_name out nocopy BSC_IM_UTILS.varchar_tabletype,
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
278: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
279: p_number_columns out nocopy number
280: )return boolean;
273: p_column_type out nocopy BSC_IM_UTILS.varchar_tabletype,
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
278: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
279: p_number_columns out nocopy number
280: )return boolean;
281: function get_level_relation(
274: p_column_data_type out nocopy BSC_IM_UTILS.varchar_tabletype,
275: p_column_origin out nocopy BSC_IM_UTILS.varchar_tabletype,
276: p_aggregation_type out nocopy BSC_IM_UTILS.varchar_tabletype,
277: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
278: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
279: p_number_columns out nocopy number
280: )return boolean;
281: function get_level_relation(
282: p_dim_name varchar2,
280: )return boolean;
281: function get_level_relation(
282: p_dim_name varchar2,
283: p_apps_origin varchar2,
284: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
281: function get_level_relation(
282: p_dim_name varchar2,
283: p_apps_origin varchar2,
284: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
289: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
282: p_dim_name varchar2,
283: p_apps_origin varchar2,
284: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
289: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
290: p_number_level_relations out nocopy number
283: p_apps_origin varchar2,
284: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
289: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
290: p_number_level_relations out nocopy number
291: )return boolean;
284: p_child_level out nocopy BSC_IM_UTILS.varchar_tabletype,
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
289: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
290: p_number_level_relations out nocopy number
291: )return boolean;
292: function get_hierarchy(
285: p_parent_level out nocopy BSC_IM_UTILS.varchar_tabletype,
286: p_child_fk out nocopy BSC_IM_UTILS.varchar_tabletype,
287: p_parent_pk out nocopy BSC_IM_UTILS.varchar_tabletype,
288: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
289: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
290: p_number_level_relations out nocopy number
291: )return boolean;
292: function get_hierarchy(
293: p_dim_name varchar2,
291: )return boolean;
292: function get_hierarchy(
293: p_dim_name varchar2,
294: p_apps_origin varchar2,
295: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
296: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
297: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
298: p_number_hierarchy out nocopy number
299: )return boolean;
292: function get_hierarchy(
293: p_dim_name varchar2,
294: p_apps_origin varchar2,
295: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
296: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
297: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
298: p_number_hierarchy out nocopy number
299: )return boolean;
300: function get_mapping(
293: p_dim_name varchar2,
294: p_apps_origin varchar2,
295: p_hier_name out nocopy BSC_IM_UTILS.varchar_tabletype,
296: p_description out nocopy BSC_im_UTILS.varchar_tabletype,
297: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
298: p_number_hierarchy out nocopy number
299: )return boolean;
300: function get_mapping(
301: p_owner_name varchar2,
299: )return boolean;
300: function get_mapping(
301: p_owner_name varchar2,
302: p_apps_origin varchar2,
303: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
304: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
305: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
306: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
307: p_number_mapping out nocopy number
300: function get_mapping(
301: p_owner_name varchar2,
302: p_apps_origin varchar2,
303: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
304: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
305: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
306: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
307: p_number_mapping out nocopy number
308: )return boolean;
301: p_owner_name varchar2,
302: p_apps_origin varchar2,
303: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
304: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
305: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
306: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
307: p_number_mapping out nocopy number
308: )return boolean;
309: function get_mapping_detail(
302: p_apps_origin varchar2,
303: p_map_name out nocopy BSC_IM_UTILS.varchar_tabletype,
304: p_map_type out nocopy BSC_IM_UTILS.varchar_tabletype,
305: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
306: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
307: p_number_mapping out nocopy number
308: )return boolean;
309: function get_mapping_detail(
310: p_map_name varchar2,
308: )return boolean;
309: function get_mapping_detail(
310: p_map_name varchar2,
311: p_apps_origin varchar2,
312: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
313: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
314: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
315: p_number_map_detail out nocopy number
316: )return boolean;
309: function get_mapping_detail(
310: p_map_name varchar2,
311: p_apps_origin varchar2,
312: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
313: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
314: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
315: p_number_map_detail out nocopy number
316: )return boolean;
317: function get_cube(
310: p_map_name varchar2,
311: p_apps_origin varchar2,
312: p_line out nocopy BSC_IM_UTILS.varchar_tabletype,
313: p_line_type out nocopy BSC_IM_UTILS.varchar_tabletype,
314: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
315: p_number_map_detail out nocopy number
316: )return boolean;
317: function get_cube(
318: p_cube_name varchar2,
324: )return boolean;
325: function get_fk(
326: p_owner_name varchar2,
327: p_apps_origin varchar2,
328: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
325: function get_fk(
326: p_owner_name varchar2,
327: p_apps_origin varchar2,
328: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
333: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
326: p_owner_name varchar2,
327: p_apps_origin varchar2,
328: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
333: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
334: p_number_fk out nocopy number
327: p_apps_origin varchar2,
328: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
333: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
334: p_number_fk out nocopy number
335: )return boolean;
328: p_fk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
333: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
334: p_number_fk out nocopy number
335: )return boolean;
336: function get_uk(
329: p_fk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
330: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
331: p_uk_parent_name out nocopy BSC_IM_UTILS.varchar_tabletype,
332: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
333: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
334: p_number_fk out nocopy number
335: )return boolean;
336: function get_uk(
337: p_owner_name varchar2,
335: )return boolean;
336: function get_uk(
337: p_owner_name varchar2,
338: p_apps_origin varchar2,
339: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
340: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
341: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
342: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
343: p_number_uk out nocopy number
336: function get_uk(
337: p_owner_name varchar2,
338: p_apps_origin varchar2,
339: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
340: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
341: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
342: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
343: p_number_uk out nocopy number
344: )return boolean;
337: p_owner_name varchar2,
338: p_apps_origin varchar2,
339: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
340: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
341: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
342: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
343: p_number_uk out nocopy number
344: )return boolean;
345: function get_object(
338: p_apps_origin varchar2,
339: p_uk_name out nocopy BSC_IM_UTILS.varchar_tabletype,
340: p_uk_type out nocopy BSC_IM_UTILS.varchar_tabletype,
341: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
342: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
343: p_number_uk out nocopy number
344: )return boolean;
345: function get_object(
346: p_parent_name varchar2,
344: )return boolean;
345: function get_object(
346: p_parent_name varchar2,
347: p_apps_origin varchar2,
348: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
349: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
350: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
351: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
352: p_number_object out nocopy number
345: function get_object(
346: p_parent_name varchar2,
347: p_apps_origin varchar2,
348: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
349: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
350: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
351: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
352: p_number_object out nocopy number
353: )return boolean;
346: p_parent_name varchar2,
347: p_apps_origin varchar2,
348: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
349: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
350: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
351: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
352: p_number_object out nocopy number
353: )return boolean;
354: function get_object(
347: p_apps_origin varchar2,
348: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
349: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
350: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
351: p_property out nocopy BSC_IM_UTILS.varchar_tabletype,
352: p_number_object out nocopy number
353: )return boolean;
354: function get_object(
355: p_parent_name varchar2,
354: function get_object(
355: p_parent_name varchar2,
356: p_apps_origin varchar2,
357: p_property varchar2,
358: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
359: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
360: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
361: p_number_object out nocopy number
362: )return boolean;
355: p_parent_name varchar2,
356: p_apps_origin varchar2,
357: p_property varchar2,
358: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
359: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
360: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
361: p_number_object out nocopy number
362: )return boolean;
363: function get_object(
356: p_apps_origin varchar2,
357: p_property varchar2,
358: p_object_name out nocopy BSC_IM_UTILS.varchar_tabletype,
359: p_object_type out nocopy BSC_IM_UTILS.varchar_tabletype,
360: p_description out nocopy BSC_IM_UTILS.varchar_tabletype,
361: p_number_object out nocopy number
362: )return boolean;
363: function get_object(
364: p_object_name varchar2,