APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_CALENDARS_B

Line 1845: ' FROM bsc_sys_calendars_b'||

1841: END IF;
1842: END IF;
1843:
1844: /* h_sql := 'SELECT edw_flag'||
1845: ' FROM bsc_sys_calendars_b'||
1846: ' WHERE calendar_id = :1';
1847: OPEN h_cursor FOR h_sql USING x_calendar_id;
1848: FETCH h_cursor INTO h_edw_flag;
1849: CLOSE h_cursor; */

Line 1853: FROM bsc_sys_calendars_b

1849: CLOSE h_cursor; */
1850: begin
1851: SELECT edw_flag
1852: into h_edw_flag
1853: FROM bsc_sys_calendars_b
1854: where calendar_id = x_calendar_id;
1855: exception when no_data_found then h_edw_flag := null;
1856: end;
1857:

Line 1887: FROM bsc_sys_calendars_b

1883:
1884: begin
1885: SELECT decode(nvl(edw_calendar_type_id, 0), 1, 'PMF', 'BSC')
1886: INTO h_calendar_source
1887: FROM bsc_sys_calendars_b
1888: where calendar_id = x_calendar_id;
1889: exception when no_data_found then h_calendar_source := null;
1890: end;
1891:

Line 1923: ' FROM bsc_sys_calendars_b'||

1919: END IF;
1920:
1921: /*
1922: h_sql := 'SELECT fiscal_year'||
1923: ' FROM bsc_sys_calendars_b'||
1924: ' WHERE calendar_id = :1';
1925: OPEN h_cursor FOR h_sql USING x_calendar_id;
1926: FETCH h_cursor INTO h_fiscal_year;
1927: CLOSE h_cursor;

Line 1931: FROM bsc_sys_calendars_b

1927: CLOSE h_cursor;
1928: */
1929: SELECT fiscal_year
1930: INTO h_fiscal_year
1931: FROM bsc_sys_calendars_b
1932: WHERE calendar_id = x_calendar_id;
1933:
1934: g_array_calendars(x_calendar_id).fiscal_year := h_fiscal_year;
1935:

Line 2041: ' FROM bsc_sys_calendars_b'||

2037: END IF;
2038:
2039: /*
2040: h_sql := 'SELECT current_year, start_month, start_day'||
2041: ' FROM bsc_sys_calendars_b'||
2042: ' WHERE calendar_id = :1';
2043: OPEN h_cursor FOR h_sql USING x_calendar_id;
2044: FETCH h_cursor INTO x_start_year, x_start_month, x_start_day;
2045: CLOSE h_cursor;

Line 2049: FROM bsc_sys_calendars_b

2045: CLOSE h_cursor;
2046: */
2047: SELECT current_year, start_month, start_day
2048: INTO x_start_year, x_start_month, x_start_day
2049: FROM bsc_sys_calendars_b
2050: WHERE calendar_id = x_calendar_id;
2051:
2052: -- Fix the start year
2053: IF x_start_month = 1 THEN

Line 2059: UPDATE bsc_sys_calendars_b

2055: ELSE
2056: x_start_year := x_current_fy - 1;
2057: END IF;
2058:
2059: UPDATE bsc_sys_calendars_b
2060: SET current_year = x_start_year
2061: WHERE calendar_id = x_calendar_id;
2062:
2063: g_array_calendars(x_calendar_id).start_year := x_start_year;

Line 4744: h_sql := 'UPDATE bsc_sys_calendars_b'||

4740: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
4741: h_user_id := BSC_APPS.fnd_global_user_id;
4742:
4743: /*
4744: h_sql := 'UPDATE bsc_sys_calendars_b'||
4745: ' SET fiscal_year = :1, last_updated_by = :2, last_update_date = SYSDATE'||
4746: ' WHERE calendar_id = :3';
4747: EXECUTE IMMEDIATE h_sql USING x_fiscal_year, h_user_id, x_calendar_id;
4748: */

Line 4749: UPDATE bsc_sys_calendars_b

4745: ' SET fiscal_year = :1, last_updated_by = :2, last_update_date = SYSDATE'||
4746: ' WHERE calendar_id = :3';
4747: EXECUTE IMMEDIATE h_sql USING x_fiscal_year, h_user_id, x_calendar_id;
4748: */
4749: UPDATE bsc_sys_calendars_b
4750: SET fiscal_year = x_fiscal_year, last_updated_by = h_user_id, last_update_date = SYSDATE
4751: WHERE calendar_id = x_calendar_id;
4752:
4753: -- Fix bug#3636273 No need this commit here

Line 5102: BSC_SYS_CALENDARS_B C

5098: ))
5099: FROM
5100: BSC_DB_COLOR_KPI_V K,
5101: BSC_SYS_PERIODICITIES P,
5102: BSC_SYS_CALENDARS_B C
5103: WHERE
5104: K.TAB_ID = D.TAB_ID AND
5105: K.INDICATOR = D.INDICATOR AND
5106: K.PERIODICITY_ID = P.PERIODICITY_ID AND

Line 5143: BSC_SYS_CALENDARS_B C

5139: ))
5140: FROM
5141: BSC_DB_COLOR_KPI_V K,
5142: BSC_SYS_PERIODICITIES P,
5143: BSC_SYS_CALENDARS_B C
5144: WHERE
5145: K.TAB_ID = D.TAB_ID AND
5146: K.INDICATOR = D.INDICATOR AND
5147: K.PERIODICITY_ID = P.PERIODICITY_ID AND

Line 5473: FROM bsc_sys_calendars_b

5469: SELECT DISTINCT year
5470: FROM bsc_sys_periods
5471: WHERE periodicity_id = p_periodicity_id AND
5472: year = (SELECT fiscal_year
5473: FROM bsc_sys_calendars_b
5474: WHERE calendar_id = p_calendar_id);
5475:
5476: h_model_year NUMBER;
5477: