1 PACKAGE FEM_HIER_LOADER_PKG AS
2 /* $Header: femhierldr_pkh.pls 120.0 2005/06/06 21:00:57 appldev noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7
8 G_PKG_NAME constant varchar2(30) := 'FEM_HIER_LOADER_PKG';
9 G_FEM constant varchar2(3) := 'FEM';
10 G_BLOCK constant varchar2(80) := G_FEM||'.PLSQL.'||G_PKG_NAME;
11
12 ---------Exceptions---------------------
13 e_loader_error exception;
14 e_hierarchy_error exception;
15
16
17 ---------------------------------------------
18 -- Package Types
19 ---------------------------------------------
20 type cv_curs is ref cursor;
21 type rowid_type is table of rowid index by binary_integer;
22 type number_type is table of number index by binary_integer;
23 type pct_type is table of number(3,2) index by binary_integer;
24 type date_type is table of date index by binary_integer;
25 type varchar2_std_type is table of varchar2(30) index by binary_integer;
26 type varchar2_150_type is table of varchar2(150) index by binary_integer;
27 type flag_type is table of varchar2(1) index by binary_integer;
28 type lang_type is table of varchar2(4) index by binary_integer;
29 type varchar2_1000_type is table of varchar2(1000) index by binary_integer;
30
31
32 /*===========================================================================+
33 | PROCEDURE
34 | Main
35 |
36 | DESCRIPTION
37 | Main engine procedure for loading dimension hierarchies
38 | into FEM
39 |
40 | SCOPE - PUBLIC
41 |
42 +===========================================================================*/
43
44 PROCEDURE Main (
45 errbuf out nocopy varchar2
46 ,retcode out nocopy varchar2
47 ,p_object_definition_id in number
48 ,p_execution_mode in varchar2
49 ,p_dimension_varchar_label in varchar2
50 ,p_hierarchy_object_name in varchar2
51 ,p_hier_obj_def_display_name in varchar2
52 );
53
54
55
56 END FEM_HIER_LOADER_PKG;