APPS.BSC_BSC_ADAPTER dependencies on BSC_VARCHAR2_TABLE_TYPE

Line 6345: p_dim_list out nocopy bsc_varchar2_table_type,

6341: /*
6342: For PMV
6343: */
6344: procedure get_list_of_rec_dim(
6345: p_dim_list out nocopy bsc_varchar2_table_type,
6346: p_num_dim_list out nocopy number,
6347: p_error_message out nocopy varchar2) is
6348: --
6349: l_dbi_dim_data BSC_UPDATE_DIM.t_array_dbi_dim_data;

Line 6357: p_dim_list:=bsc_varchar2_table_type();

6353: --p_dim_list.delete;
6354: p_num_dim_list:=0;
6355: BSC_UPDATE_DIM.Get_All_Dbi_Dim_Data(l_dbi_dim_data);
6356: l_num_dbi_dim_data:=l_dbi_dim_data.count;
6357: p_dim_list:=bsc_varchar2_table_type();
6358: for i in 1..l_num_dbi_dim_data loop
6359: if l_dbi_dim_data(i).top_n_levels is not null and l_dbi_dim_data(i).top_n_levels>0 then
6360: p_num_dim_list:=p_num_dim_list+1;
6361: p_dim_list.extend;

Line 6397: p_dim_level_short_name bsc_varchar2_table_type,

6393: raise;
6394: End;
6395:
6396: procedure set_and_get_dim_sql(
6397: p_dim_level_short_name bsc_varchar2_table_type,
6398: p_dim_level_value bsc_varchar2_table_type,
6399: p_num_dim_level number,
6400: p_dim_level_sql out nocopy bsc_varchar2_table_type,
6401: p_error_message out nocopy varchar2

Line 6398: p_dim_level_value bsc_varchar2_table_type,

6394: End;
6395:
6396: procedure set_and_get_dim_sql(
6397: p_dim_level_short_name bsc_varchar2_table_type,
6398: p_dim_level_value bsc_varchar2_table_type,
6399: p_num_dim_level number,
6400: p_dim_level_sql out nocopy bsc_varchar2_table_type,
6401: p_error_message out nocopy varchar2
6402: ) is

Line 6400: p_dim_level_sql out nocopy bsc_varchar2_table_type,

6396: procedure set_and_get_dim_sql(
6397: p_dim_level_short_name bsc_varchar2_table_type,
6398: p_dim_level_value bsc_varchar2_table_type,
6399: p_num_dim_level number,
6400: p_dim_level_sql out nocopy bsc_varchar2_table_type,
6401: p_error_message out nocopy varchar2
6402: ) is
6403: --
6404: l_num_dim_level number;

Line 6416: p_dim_level_sql:=bsc_varchar2_table_type();

6412: if g_rec_dbi_dim.count=0 then --cache once
6413: get_list_of_rec_dim(g_rec_dbi_dim);
6414: end if;
6415: l_num_dim_level:=p_num_dim_level;
6416: p_dim_level_sql:=bsc_varchar2_table_type();
6417: if l_num_dim_level>0 then
6418: for i in 1..l_num_dim_level loop
6419: p_dim_level_sql.extend;
6420: p_dim_level_sql(i):=null;