eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE dependencies on BSC_SYS_PERIODICITIES

Line 1015: -- Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl

1011:
1012: TYPE t_cursor IS REF CURSOR;
1013: h_cursor t_cursor;
1014:
1015: -- Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1016: CURSOR c_tables (p_table_type NUMBER, p_calendar_id NUMBER) IS
1017: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1018: FROM bsc_db_tables t, bsc_sys_periodicities p
1019: WHERE t.periodicity_id = p.periodicity_id AND

Line 1018: FROM bsc_db_tables t, bsc_sys_periodicities p

1014:
1015: -- Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1016: CURSOR c_tables (p_table_type NUMBER, p_calendar_id NUMBER) IS
1017: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1018: FROM bsc_db_tables t, bsc_sys_periodicities p
1019: WHERE t.periodicity_id = p.periodicity_id AND
1020: t.table_type = p_table_type AND p.calendar_id = p_calendar_id;
1021:
1022: CURSOR c_base_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,

Line 1025: FROM bsc_db_tables t, bsc_sys_periodicities p

1021:
1022: CURSOR c_base_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,
1023: p_calendar_id NUMBER, p_table_type0 NUMBER) IS
1024: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1025: FROM bsc_db_tables t, bsc_sys_periodicities p
1026: WHERE t.periodicity_id = p.periodicity_id AND
1027: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1028: p.calendar_id = p_calendar_id AND
1029: t.table_name IN (

Line 1041: FROM bsc_db_tables t, bsc_sys_periodicities_vl p

1037: /*
1038: CURSOR c_sum_tables_mv (p_table_type1 NUMBER, p_gen_type NUMBER,
1039: p_calendar_id NUMBER, p_table_type0 NUMBER) IS
1040: SELECT t.table_name, t.periodicity_id, t.current_period, p.yearly_flag
1041: FROM bsc_db_tables t, bsc_sys_periodicities_vl p
1042: WHERE t.periodicity_id = p.periodicity_id AND
1043: t.table_type = p_table_type1 AND t.generation_type <> p_gen_type AND
1044: p.calendar_id = p_calendar_id AND
1045: NOT (t.table_name IN (

Line 1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl

1047: FROM bsc_db_tables_rels r, bsc_db_tables b
1048: WHERE r.source_table_name = b.table_name and b.table_type = p_table_type0
1049: ));
1050: */
1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1052: CURSOR c_sum_tables_mv (p_calendar_id NUMBER) IS
1053: SELECT DISTINCT k.projection_data
1054: FROM bsc_kpi_data_tables k, bsc_sys_periodicities p
1055: WHERE k.periodicity_id = p.periodicity_id AND

Line 1054: FROM bsc_kpi_data_tables k, bsc_sys_periodicities p

1050: */
1051: --Fix perf bug#4924515 use bsc_sys_periodicities instead of bsc_sys_periodicities_vl
1052: CURSOR c_sum_tables_mv (p_calendar_id NUMBER) IS
1053: SELECT DISTINCT k.projection_data
1054: FROM bsc_kpi_data_tables k, bsc_sys_periodicities p
1055: WHERE k.periodicity_id = p.periodicity_id AND
1056: p.calendar_id = p_calendar_id AND
1057: projection_data IS NOT NULL;
1058:

Line 1062: FROM bsc_db_calculations c, bsc_sys_periodicities p

1058:
1059:
1060: CURSOR c_other_periodicities (p_table_name VARCHAR2, p_calc_type NUMBER) IS
1061: SELECT c.parameter1, p.yearly_flag
1062: FROM bsc_db_calculations c, bsc_sys_periodicities p
1063: WHERE c.table_name = p_table_name AND c.calculation_type = p_calc_type AND
1064: c.parameter1 = p.periodicity_id;
1065:
1066: TYPE t_tables IS RECORD (

Line 1070: yearly_flag bsc_sys_periodicities_vl.yearly_flag%TYPE

1066: TYPE t_tables IS RECORD (
1067: table_name bsc_db_tables.table_name%TYPE,
1068: periodicity_id bsc_db_tables.periodicity_id%TYPE,
1069: current_period bsc_db_tables.current_period%TYPE,
1070: yearly_flag bsc_sys_periodicities_vl.yearly_flag%TYPE
1071: );
1072:
1073: h_table_info t_tables;
1074:

Line 1214: --Fix perf bug#4924515: use bsc_sys_periodicities instead of bsc_sys_periodiicties_vl

1210: h_aw_indicators(h_num_aw_indicators) := h_indicator;
1211: END IF;
1212:
1213: -- Update indicator current period
1214: --Fix perf bug#4924515: use bsc_sys_periodicities instead of bsc_sys_periodiicties_vl
1215: UPDATE
1216: bsc_kpi_periodicities
1217: SET
1218: current_period = h_current_fy + 1

Line 1225: bsc_sys_periodicities

1221: periodicity_id IN (
1222: SELECT
1223: periodicity_id
1224: FROM
1225: bsc_sys_periodicities
1226: WHERE
1227: calendar_id = x_calendar_id AND
1228: yearly_flag = 1);
1229:

Line 1240: bsc_sys_periodicities

1236: periodicity_id IN (
1237: SELECT
1238: periodicity_id
1239: FROM
1240: bsc_sys_periodicities
1241: WHERE
1242: calendar_id = x_calendar_id AND
1243: yearly_flag = 0);
1244:

Line 1423: -- Fix perf bug#4924515 use bsc_sys_periodiicties instead of bsc_sys_periodicities_vl

1419: CLOSE c_tables;
1420: END IF;
1421:
1422: -- Update the current period of data tables
1423: -- Fix perf bug#4924515 use bsc_sys_periodiicties instead of bsc_sys_periodicities_vl
1424: UPDATE
1425: bsc_db_tables
1426: SET
1427: current_period = h_current_fy + 1,

Line 1435: bsc_sys_periodicities

1431: periodicity_id IN (
1432: SELECT
1433: periodicity_id
1434: FROM
1435: bsc_sys_periodicities
1436: WHERE
1437: calendar_id = x_calendar_id AND
1438: yearly_flag = 1);
1439:

Line 1452: bsc_sys_periodicities

1448: periodicity_id IN (
1449: SELECT
1450: periodicity_id
1451: FROM
1452: bsc_sys_periodicities
1453: WHERE
1454: calendar_id = x_calendar_id AND
1455: yearly_flag = 0);
1456:

Line 6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||

6136: /*
6137: c_tables t_cursor; -- g_process_id
6138: c_tables_sql VARCHAR2(2000) := 'SELECT lc.input_table_name, t.periodicity_id,'||
6139: ' p.name, t.current_period, t.current_subperiod'||
6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||
6141: ' WHERE lc.input_table_name = t.table_name AND'||
6142: ' lc.process_id = :1 AND t.periodicity_id = p.periodicity_id';
6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS

Line 6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p

6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS
6145: SELECT lc.input_table_name, t.periodicity_id,
6146: p.name, t.current_period, t.current_subperiod
6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p
6148: WHERE lc.input_table_name = t.table_name AND
6149: lc.process_id = p_process_id AND t.periodicity_id = p.periodicity_id;
6150:
6151: h_periodicity_id NUMBER;