APPS.BSC_AW_MD_API dependencies on DBMS_SQL

Line 22: p_kpi_list out nocopy dbms_sql.varchar2_table

18: End;
19:
20: procedure get_kpi_for_dim(
21: p_dim_name varchar2,
22: p_kpi_list out nocopy dbms_sql.varchar2_table
23: ) is
24: Begin
25: g_olap_object_relation.delete;
26: get_bsc_olap_object_relation(null,null,'dimension kpi',p_dim_name,'dimension',g_olap_object_relation);

Line 79: p_dim_list out nocopy dbms_sql.varchar2_table

75: so we need to get the list of all cc dim for the levels that are now part of p_dimension
76: */
77: procedure get_ccdim_for_levels(
78: p_dimension bsc_aw_adapter_dim.dimension_r,
79: p_dim_list out nocopy dbms_sql.varchar2_table
80: ) is
81: --
82: l_dim dbms_sql.varchar2_table;
83: --

Line 82: l_dim dbms_sql.varchar2_table;

78: p_dimension bsc_aw_adapter_dim.dimension_r,
79: p_dim_list out nocopy dbms_sql.varchar2_table
80: ) is
81: --
82: l_dim dbms_sql.varchar2_table;
83: --
84: Begin
85: p_dim_list.delete;
86: if g_debug then

Line 129: procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table) is

125:
126: /*
127: given a dim level, find all CC dims
128: */
129: procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table) is
130: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
131: Begin
132: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
133: --there can multiple dim in l_oo_level. only 1 is un-corrected

Line 495: p_dim_list out nocopy dbms_sql.varchar2_table

491: will be used in the ui module
492: */
493: procedure get_dim_for_kpi(
494: p_kpi varchar2,
495: p_dim_list out nocopy dbms_sql.varchar2_table
496: ) is
497: Begin
498: g_olap_object_relation.delete;
499: get_bsc_olap_object_relation(p_kpi,'kpi','kpi dimension',p_kpi,'kpi',g_olap_object_relation);

Line 514: l_periodicity dbms_sql.varchar2_table;

510: p_kpi bsc_aw_adapter_kpi.kpi_r,
511: p_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r
512: ) is
513: --
514: l_periodicity dbms_sql.varchar2_table;
515: l_periodicity_type dbms_sql.varchar2_table;
516: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
518: Begin

Line 515: l_periodicity_type dbms_sql.varchar2_table;

511: p_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r
512: ) is
513: --
514: l_periodicity dbms_sql.varchar2_table;
515: l_periodicity_type dbms_sql.varchar2_table;
516: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
518: Begin
519: --get the relation name

Line 1260: l_match_columns dbms_sql.varchar2_table;

1256: p_set_columns varchar2, --comma separated
1257: p_set_values varchar2 --^ separated. since values can contain , inside
1258: ) is
1259: --
1260: l_match_columns dbms_sql.varchar2_table;
1261: l_match_values dbms_sql.varchar2_table;
1262: l_set_columns dbms_sql.varchar2_table;
1263: l_set_values dbms_sql.varchar2_table;
1264: Begin

Line 1261: l_match_values dbms_sql.varchar2_table;

1257: p_set_values varchar2 --^ separated. since values can contain , inside
1258: ) is
1259: --
1260: l_match_columns dbms_sql.varchar2_table;
1261: l_match_values dbms_sql.varchar2_table;
1262: l_set_columns dbms_sql.varchar2_table;
1263: l_set_values dbms_sql.varchar2_table;
1264: Begin
1265: clear_all_cache;

Line 1262: l_set_columns dbms_sql.varchar2_table;

1258: ) is
1259: --
1260: l_match_columns dbms_sql.varchar2_table;
1261: l_match_values dbms_sql.varchar2_table;
1262: l_set_columns dbms_sql.varchar2_table;
1263: l_set_values dbms_sql.varchar2_table;
1264: Begin
1265: clear_all_cache;
1266: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);

Line 1263: l_set_values dbms_sql.varchar2_table;

1259: --
1260: l_match_columns dbms_sql.varchar2_table;
1261: l_match_values dbms_sql.varchar2_table;
1262: l_set_columns dbms_sql.varchar2_table;
1263: l_set_values dbms_sql.varchar2_table;
1264: Begin
1265: clear_all_cache;
1266: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);
1267: bsc_aw_utility.parse_parameter_values(p_match_values,',',l_match_values);

Line 1301: l_match_columns dbms_sql.varchar2_table;

1297: p_set_columns varchar2, --comma separated
1298: p_set_values varchar2 --^ separated
1299: ) is
1300: --
1301: l_match_columns dbms_sql.varchar2_table;
1302: l_match_values dbms_sql.varchar2_table;
1303: l_set_columns dbms_sql.varchar2_table;
1304: l_set_values dbms_sql.varchar2_table;
1305: Begin

Line 1302: l_match_values dbms_sql.varchar2_table;

1298: p_set_values varchar2 --^ separated
1299: ) is
1300: --
1301: l_match_columns dbms_sql.varchar2_table;
1302: l_match_values dbms_sql.varchar2_table;
1303: l_set_columns dbms_sql.varchar2_table;
1304: l_set_values dbms_sql.varchar2_table;
1305: Begin
1306: clear_all_cache;

Line 1303: l_set_columns dbms_sql.varchar2_table;

1299: ) is
1300: --
1301: l_match_columns dbms_sql.varchar2_table;
1302: l_match_values dbms_sql.varchar2_table;
1303: l_set_columns dbms_sql.varchar2_table;
1304: l_set_values dbms_sql.varchar2_table;
1305: Begin
1306: clear_all_cache;
1307: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);

Line 1304: l_set_values dbms_sql.varchar2_table;

1300: --
1301: l_match_columns dbms_sql.varchar2_table;
1302: l_match_values dbms_sql.varchar2_table;
1303: l_set_columns dbms_sql.varchar2_table;
1304: l_set_values dbms_sql.varchar2_table;
1305: Begin
1306: clear_all_cache;
1307: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);
1308: bsc_aw_utility.parse_parameter_values(p_match_values,',',l_match_values);

Line 1443: p_relation_object in out nocopy dbms_sql.varchar2_table

1439: */
1440: procedure get_relation_object(
1441: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,
1442: p_relation_type varchar2,
1443: p_relation_object in out nocopy dbms_sql.varchar2_table
1444: ) is
1445: Begin
1446: for i in 1..p_olap_object_relation.count loop
1447: if p_olap_object_relation(i).relation_type=p_relation_type then