1 package msd_AW_LOADER_PVT AUTHID CURRENT_USER as
2 /* $Header: msdawloaders.pls 120.0 2005/05/25 19:21:44 appldev noship $ */
3
4 type DIM_VALUES is table of VARCHAR2(32) index by BINARY_INTEGER;
5 type PROP_VALUES is table of VARCHAR2(32) index by VARCHAR2(32);
6
7 -------------------------------------------------------------------------------
8 -- ATTACH_AW: Attaches the AW rw
9 --
10 -- IN: p_schema (varchar2) - Schema of the AW to attach
11 -- p_aw (varchar2) - Name of the AW
12 -------------------------------------------------------------------------------
13 procedure ATTACH_AW(p_schema in varchar2,
14 p_aw in varchar2);
15
16 -------------------------------------------------------------------------------
17 -- CREATE_OBJECT - Creates the object of specified name, type and attribute
18 --
19 -- IN: p_object_name (varchar2) - Name of the object to create
20 -- p_object_type (varchar2) - Type of the object (ie. VARIABLE)
21 -- p_object_attributes (varchar2) - Attributes of object (ie. <DIM1, DIM2>)
22 -- p_object_ld (varchar2) - The LD (description) of the object
23 --
24 -------------------------------------------------------------------------------
25 procedure CREATE_OBJECT(p_object_name in varchar2,
26 p_object_type in varchar2,
27 p_object_attributes in varchar2,
28 p_object_ld in varchar2);
29
30 -------------------------------------------------------------------------------
31 -- LOAD_DIMENSION_INT
32 --
33 -- IN: p_dimension_size (number) - The size of the integer dimension
34 -------------------------------------------------------------------------------
35 procedure LOAD_DIMENSION_INT(p_dimension_size in number);
36
37 -------------------------------------------------------------------------------
38 -- LOAD_DIMENSION_VALUES - Loads values of a text dimension
39 --
40 -- IN: p_dimension_values - Hash of index/value pairs
41 --
42 -------------------------------------------------------------------------------
43 procedure LOAD_DIMENSION_VALUES(p_dimension_values in DIM_VALUES);
44
45 -------------------------------------------------------------------------------
46 -- LOAD_FORMULA - Builds a formula
47 --
48 -- IN: p_formula - The formula body
49 --
50 -------------------------------------------------------------------------------
51 procedure LOAD_FORMULA(p_formula in varchar2);
52
53 -------------------------------------------------------------------------------
54 -- LOAD_MODEL - Builds a model
55 --
56 -- IN: p_model - The model body
57 --
58 -------------------------------------------------------------------------------
59 procedure LOAD_MODEL(p_model in varchar2);
60
61 -------------------------------------------------------------------------------
62 -- LOAD_PROGRAM - Builds a program
63 --
64 -- IN: p_program - The program body
65 --
66 -------------------------------------------------------------------------------
67 procedure LOAD_PROGRAM(p_program in CLOB);
68
69 -------------------------------------------------------------------------------
70 -- LOAD_PROPERTIES - Loads the properties of an object
71 --
72 -- IN: p_properties - Hash of property index/value pairs
73 --
74 -------------------------------------------------------------------------------
75 procedure LOAD_PROPERTIES(p_properties in PROP_VALUES);
76
77 -------------------------------------------------------------------------------
78 -- LOAD_VALUESET - Loads the values of a valueset object
79 --
80 -- IN: p_dim_values - Hash of dimension values
81 --
82 -------------------------------------------------------------------------------
83 procedure LOAD_VALUESET(p_dimension_values in DIM_VALUES);
84
85 -------------------------------------------------------------------------------
86 -- UPDATE_AW - Updates the AW
87 --
88 -------------------------------------------------------------------------------
89 procedure UPDATE_AW;
90
91 end msd_AW_LOADER_PVT;
[Home] [Help]