APPS.BSC_AW_MD_WRAPPER dependencies on BSC_OLAP_OBJECT

Line 10: type bsc_olap_object_tb is table of bsc_olap_object%rowtype index by pls_integer;

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(

Line 11: type bsc_olap_object_relation_tb is table of bsc_olap_object_relation%rowtype index by pls_integer;

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,

Line 15: object bsc_olap_object.object%type,

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

Line 16: object_type bsc_olap_object.object_type%type,

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

Line 17: parent_object bsc_olap_object.parent_object%type,

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

Line 18: parent_object_type bsc_olap_object.parent_object_type%type,

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),

Line 37: procedure get_bsc_olap_object(

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,

Line 42: p_bsc_olap_object out nocopy bsc_olap_object_tb

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,

Line 44: procedure get_bsc_olap_object_relation(

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,

Line 50: p_bsc_olap_object_relation out nocopy bsc_olap_object_relation_tb

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(