APPS.BSC_UPDATE_DIM dependencies on BSC_AW_LOAD

Line 679: bsc_aw_load.load_dim(

675: -- AW API to re-load child dimension into AW world.
676: IF Dimension_Used_In_AW_Kpi(h_child_dim_table) THEN
677: h_dim_level_list.delete;
678: h_dim_level_list(1) := h_child_dim_table;
679: bsc_aw_load.load_dim(
680: p_dim_level_list => h_dim_level_list,
681: p_options => 'DEBUG LOG'
682: );
683: END IF;

Line 3384: bsc_aw_load.load_dim(

3380: h_dim_level_list dbms_sql.varchar2_table;
3381: BEGIN
3382: h_dim_level_list.delete;
3383: h_dim_level_list(1) := x_dim_table;
3384: bsc_aw_load.load_dim(
3385: p_dim_level_list => h_dim_level_list,
3386: p_options => 'DEBUG LOG'
3387: );
3388: commit;

Line 3730: bsc_aw_load.load_dim(

3726: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
3727: IF Dimension_Used_In_AW_Kpi(x_dim_table) THEN
3728: h_dim_level_list.delete;
3729: h_dim_level_list(1) := x_dim_table;
3730: bsc_aw_load.load_dim(
3731: p_dim_level_list => h_dim_level_list,
3732: p_options => 'DEBUG LOG'
3733: );
3734: END IF;

Line 3817: bsc_aw_load.load_dim(

3813: h_dim_level_list dbms_sql.varchar2_table;
3814: BEGIN
3815: h_dim_level_list.delete;
3816: h_dim_level_list(1) := 'TYPE';
3817: bsc_aw_load.load_dim(
3818: p_dim_level_list => h_dim_level_list,
3819: p_options => 'DEBUG LOG'
3820: );
3821: commit;

Line 4168: bsc_aw_load.dmp_dim_level_into_table(

4164: -- This procedure will insert into BSC_AW_DIM_DATA all the records
4165: -- existing in AW for the dimension
4166: l_dim_level_list.delete;
4167: l_dim_level_list(1) := l_level_table_name;
4168: bsc_aw_load.dmp_dim_level_into_table(
4169: p_dim_level_list => l_dim_level_list,
4170: p_options => 'DEBUG LOG'
4171: );
4172:

Line 4234: bsc_aw_load.load_dim(

4230: execute immediate l_sql using l_level_table_name, '0';
4231: commit;
4232: l_dim_level_list.delete;
4233: l_dim_level_list(1) := l_level_table_name;
4234: bsc_aw_load.load_dim(
4235: p_dim_level_list => l_dim_level_list,
4236: p_options => 'DEBUG LOG'
4237: );
4238: END IF;