PACKAGE: APPS.BSC_AW_MD_WRAPPER

Source

1 package BSC_AW_MD_WRAPPER AS
2 /*$Header: BSCAWMWS.pls 120.4 2006/01/14 21:02 vsurendr noship $*/
3 --program runtime parameters
4 g_debug boolean;
5 g_stmt varchar2(32000);
6 g_context varchar2(40);
7 --g_context varchar2(40):='AW'; --AW or MODEL etc. olap metadata may store many types of metadata
8 g_who number;
9 ------types--------------------------------------------------------
10 type bsc_olap_object_tb is table of bsc_olap_object%rowtype index by pls_integer;
11 type bsc_olap_object_relation_tb is table of bsc_olap_object_relation%rowtype index by pls_integer;
12 --
13 --use property9 column of bsc olap metadata to hold runtime values like when load started, ended, lock etc
14 type bsc_runtime_r is record(
15 object bsc_olap_object.object%type,
16 object_type bsc_olap_object.object_type%type,
17 parent_object bsc_olap_object.parent_object%type,
18 parent_object_type bsc_olap_object.parent_object_type%type,
19 operation varchar2(300), --load,aggregation,lock
20 operation_type varchar2(100),--initial, inc
21 start_time varchar2(100), --MM/DD/YYYY HH24:MI:SS
22 end_time varchar2(100),
23 sid number,
24 spid number,
25 property varchar2(8000)
26 );
27 type bsc_runtime_tb is table of bsc_runtime_r index by pls_integer;
28 --procedures-------------------------------------------------------
29 procedure set_context(p_context varchar2);
30 procedure mark_kpi_recreate(
31 p_kpi varchar2
32 );
33 procedure drop_dim(p_dim_name varchar2);
34 procedure create_dim(p_dimension bsc_aw_adapter_dim.dimension_r);
35 procedure drop_kpi(p_kpi varchar2);
36 procedure create_calendar(p_calendar bsc_aw_calendar.calendar_r);
37 procedure get_bsc_olap_object(
38 p_object varchar2,
39 p_type varchar2,
40 p_parent_object varchar2,
41 p_parent_type varchar2,
42 p_bsc_olap_object out nocopy bsc_olap_object_tb
43 );
44 procedure get_bsc_olap_object_relation(
45 p_object varchar2,
46 p_object_type varchar2,
47 p_relation_type varchar2,
48 p_parent_object varchar2,
49 p_parent_object_type varchar2,
50 p_bsc_olap_object_relation out nocopy bsc_olap_object_relation_tb
51 );
52 procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r) ;
53 procedure create_kpi(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);
54 procedure insert_olap_object(
55 p_object varchar2,
56 p_object_type varchar2,
57 p_olap_object varchar2,
58 p_olap_object_type varchar2,
59 p_parent_object varchar2,
60 p_parent_object_type varchar2,
61 p_property1 varchar2
62 );
63 procedure insert_olap_object_relation(
64 p_object varchar2,
65 p_object_type varchar2,
66 p_relation_object varchar2,
67 p_relation_object_type varchar2,
68 p_relation_type varchar2,
69 p_parent_object varchar2,
70 p_parent_object_type varchar2,
71 p_property1 varchar2
72 );
73 procedure update_olap_object_relation(
74 p_object varchar2,
75 p_object_type varchar2,
76 p_relation_type varchar2,
77 p_parent_object varchar2,
78 p_parent_object_type varchar2,
79 p_match_columns dbms_sql.varchar2_table,
80 p_match_values dbms_sql.varchar2_table,
81 p_set_columns dbms_sql.varchar2_table,
82 p_set_values dbms_sql.varchar2_table
83 );
84 procedure update_olap_object(
85 p_object varchar2,
86 p_object_type varchar2,
87 p_parent_object varchar2,
88 p_parent_object_type varchar2,
89 p_match_columns dbms_sql.varchar2_table,
90 p_match_values dbms_sql.varchar2_table,
91 p_set_columns dbms_sql.varchar2_table,
92 p_set_values dbms_sql.varchar2_table
93 );
94 procedure create_workspace(p_name varchar2);
95 procedure drop_workspace(p_name varchar2) ;
96 procedure default_context_if_null;
97 procedure delete_olap_object_relation(
98 p_object varchar2,
99 p_object_type varchar2,
100 p_relation_type varchar2,
101 p_relation_object varchar2,
102 p_relation_object_type varchar2,
103 p_parent_object varchar2,
104 p_parent_object_type varchar2);
105 procedure delete_olap_object(
106 p_object varchar2,
107 p_object_type varchar2,
108 p_olap_object varchar2,
109 p_olap_object_type varchar2,
110 p_parent_object varchar2,
111 p_parent_object_type varchar2);
112 procedure merge_olap_object(
113 p_object varchar2,
114 p_object_type varchar2,
115 p_olap_object varchar2,
116 p_olap_object_type varchar2,
117 p_parent_object varchar2,
118 p_parent_object_type varchar2,
119 p_property1 varchar2
120 );
121 procedure merge_olap_object_relation(
122 p_object varchar2,
123 p_object_type varchar2,
124 p_relation_object varchar2,
125 p_relation_object_type varchar2,
126 p_relation_type varchar2,
127 p_parent_object varchar2,
128 p_parent_object_type varchar2,
129 p_property1 varchar2
130 );
131 procedure analyze_md_tables;
132 --procedures-------------------------------------------------------
133 procedure init_all;
134 procedure log(p_message varchar2);
135 procedure log_n(p_message varchar2);
136 -------------------------------------------------------------------
137 
138 END BSC_AW_MD_WRAPPER;