APPS.BSC_MIGRATION dependencies on BSC_SYS_CALENDARS_B

Line 3079: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_CALENDARS_B';

3075: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3076: g_metadata_tables(g_num_metadata_tables).lang_flag := FALSE;
3077:
3078: g_num_metadata_tables := g_num_metadata_tables + 1;
3079: g_metadata_tables(g_num_metadata_tables).table_name := 'BSC_SYS_CALENDARS_B';
3080: g_metadata_tables(g_num_metadata_tables).level := 0;
3081: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3082: g_metadata_tables(g_num_metadata_tables).level_condition := 'NVL(EDW_FLAG, 0) = 0';
3083: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;

Line 3092: ' FROM BSC_SYS_CALENDARS_B@'||g_db_link||

3088: g_metadata_tables(g_num_metadata_tables).level := 0;
3089: g_metadata_tables(g_num_metadata_tables).level_column := NULL;
3090: g_metadata_tables(g_num_metadata_tables).level_condition := 'CALENDAR_ID IN ('||
3091: ' SELECT CALENDAR_ID'||
3092: ' FROM BSC_SYS_CALENDARS_B@'||g_db_link||
3093: ' WHERE NVL(EDW_FLAG,0) = 0)';
3094: g_metadata_tables(g_num_metadata_tables).copy_flag := TRUE;
3095: g_metadata_tables(g_num_metadata_tables).lang_flag := TRUE;
3096:

Line 5931: ' from bsc_sys_calendars_b';

5927: END IF;
5928:
5929: --Fix bug#4873669: Populate bsc_reporting_calendar fro all the calendars
5930: h_sql := 'select calendar_id'||
5931: ' from bsc_sys_calendars_b';
5932: OPEN h_cursor FOR h_sql;
5933: LOOP
5934: FETCH h_cursor INTO h_calendar_id;
5935: EXIT WHEN h_cursor%NOTFOUND;

Line 8951: l_Calendar_Sht_Name bsc_sys_calendars_b.short_name%TYPE;

8947: ,x_msg_data OUT NOCOPY VARCHAR2
8948: ) IS
8949: l_Id NUMBER;
8950:
8951: l_Calendar_Sht_Name bsc_sys_calendars_b.short_name%TYPE;
8952: l_Dim_Group_Id bsc_sys_dim_groups_vl.dim_group_Id%TYPE;
8953: l_Dim_Lev_Sht_Name bsc_sys_dim_levels_vl.short_name%TYPE;
8954: l_Dim_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;

Line 9133: bsc_sys_calendars_b

9129: short_name
9130: INTO
9131: l_Calendar_Sht_Name
9132: FROM
9133: bsc_sys_calendars_b
9134: WHERE
9135: calendar_id = p_Target_Calendar;
9136:
9137: l_Retain_Dim_Att2 := BIS_STRING_ARRAY();