1 package ZPB_AW_LOADER_PVT as
2 /* $Header: zpbawloader.pls 120.0.12010.2 2005/12/23 06:16:11 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_app_name (varchar2) - The application short name
11 -- p_aw (varchar2) - Name of the AW
12 -------------------------------------------------------------------------------
13 procedure ATTACH_AW(p_app_name 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 -- DELETE_OBJECT - Deletes the object of specified name
32 --
33 -- IN: p_object_name (varchar2) - Name of the object to delete
34 --
35 -------------------------------------------------------------------------------
36 procedure DELETE_OBJECT(p_object_name in varchar2);
37
38 -------------------------------------------------------------------------------
39 -- LOAD_DIMENSION_INT
40 --
41 -- IN: p_dimension_size (number) - The size of the integer dimension
42 -------------------------------------------------------------------------------
43 procedure LOAD_DIMENSION_INT(p_dimension_size in number);
44
45 -------------------------------------------------------------------------------
46 -- LOAD_DIMENSION_VALUES - Loads values of a text dimension
47 --
48 -- IN: p_dimension_values - Hash of index/value pairs
49 --
50 -------------------------------------------------------------------------------
51 procedure LOAD_DIMENSION_VALUES(p_dimension_values in DIM_VALUES);
52
53 -------------------------------------------------------------------------------
54 -- LOAD_FORMULA - Builds a formula
55 --
56 -- IN: p_formula - The formula body
57 --
58 -------------------------------------------------------------------------------
59 procedure LOAD_FORMULA(p_formula in varchar2);
60
61 -------------------------------------------------------------------------------
62 -- LOAD_MODEL - Builds a model
63 --
64 -- IN: p_model - The model body
65 --
66 -------------------------------------------------------------------------------
67 procedure LOAD_MODEL(p_model in varchar2);
68
69 -------------------------------------------------------------------------------
70 -- LOAD_PROGRAM - Builds a program
71 --
72 -- IN: p_program - The program body
73 --
74 -------------------------------------------------------------------------------
75 procedure LOAD_PROGRAM(p_program in CLOB);
76
77 -------------------------------------------------------------------------------
78 -- LOAD_PROPERTIES - Loads the properties of an object
79 --
80 -- IN: p_properties - Hash of property index/value pairs
81 --
82 -------------------------------------------------------------------------------
83 procedure LOAD_PROPERTIES(p_properties in PROP_VALUES);
84
85 -------------------------------------------------------------------------------
86 -- LOAD_VALUESET - Loads the values of a valueset object
87 --
88 -- IN: p_dim_values - Hash of dimension values
89 --
90 -------------------------------------------------------------------------------
91 procedure LOAD_VALUESET(p_dimension_values in DIM_VALUES);
92
93 -------------------------------------------------------------------------------
94 -- UPDATE_AW - Updates the AW
95 --
96 -------------------------------------------------------------------------------
97 procedure UPDATE_AW;
98
99 end ZPB_AW_LOADER_PVT;
[Home] [Help]