APPS.BSC_UPDATE_UTIL dependencies on BSC_KPIS_B

Line 3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k

3219: ) RETURN NUMBER IS
3220:
3221: CURSOR c_kpis IS
3222: SELECT DISTINCT k.indicator, k.prototype_flag
3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k
3224: WHERE t.table_name = r.table_name AND
3225: t.indicator = k.indicator AND
3226: (t.table_name = x_table_name OR
3227: (r.source_table_name = x_table_name AND r.relation_type = 1));

Line 3263: FROM bsc_kpis_b

3259:
3260: BEGIN
3261: SELECT COUNT(indicator)
3262: INTO h_num_rows
3263: FROM bsc_kpis_b
3264: WHERE indicator = x_kpi
3265: AND prototype_flag IN (0,6,7);
3266:
3267: IF h_num_rows > 0 THEN

Line 3631: ' FROM bsc_kpi_data_tables t, bsc_kpis_b k'||

3627: /* TYPE t_cursor IS REF CURSOR;
3628:
3629: c_indicator t_cursor; -- x_table_name, 1
3630: c_indicator_sql VARCHAR2(2000) := 'SELECT t.indicator'||
3631: ' FROM bsc_kpi_data_tables t, bsc_kpis_b k'||
3632: ' WHERE t.indicator = k.indicator AND'||
3633: ' table_name = :1 AND NVL(k.edw_flag, 0) = :2';
3634: */
3635: cursor c_indicator (pTableName varchar2, pEDWFlag number ) is

Line 3637: FROM bsc_kpi_data_tables t, bsc_kpis_b k

3633: ' table_name = :1 AND NVL(k.edw_flag, 0) = :2';
3634: */
3635: cursor c_indicator (pTableName varchar2, pEDWFlag number ) is
3636: SELECT t.indicator
3637: FROM bsc_kpi_data_tables t, bsc_kpis_b k
3638: WHERE t.indicator = k.indicator AND
3639: table_name = pTableName AND NVL(k.edw_flag, 0) = pEDWFlag;
3640:
3641: h_indicator NUMBER;

Line 5065: ' FROM bsc_kpis_b'||

5061:
5062: BEGIN
5063: -- Get Kpi EDW Flag
5064: /* h_sql := 'SELECT NVL(edw_flag, 0)'||
5065: ' FROM bsc_kpis_b'||
5066: ' WHERE indicator = :1';
5067: OPEN h_cursor FOR h_sql USING x_indicator;
5068: FETCH h_cursor INTO h_edw_flag;
5069: CLOSE h_cursor; */

Line 5072: FROM bsc_kpis_b

5068: FETCH h_cursor INTO h_edw_flag;
5069: CLOSE h_cursor; */
5070: SELECT NVL(edw_flag, 0)
5071: INTO h_edw_flag
5072: FROM bsc_kpis_b
5073: WHERE indicator = x_indicator;
5074:
5075: IF h_edw_flag = 0 THEN
5076: -- BSC Kpi => BSC Periodicity

Line 5195: h_sql := 'UPDATE bsc_kpis_b'||

5191: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5192: h_user_id := BSC_APPS.fnd_global_user_id;
5193:
5194: /*
5195: h_sql := 'UPDATE bsc_kpis_b'||
5196: ' SET last_updated_by = :1,'||
5197: ' last_update_date = SYSDATE'||
5198: ' WHERE indicator = :2';
5199:

Line 5206: UPDATE bsc_kpis_b

5202: h_bind_vars_values(2) := x_indicator;
5203: h_num_bind_vars := 2;
5204: Execute_Immediate(h_sql, h_bind_vars_values, h_num_bind_vars);
5205: */
5206: UPDATE bsc_kpis_b
5207: SET last_updated_by = h_user_id,
5208: last_update_date = SYSDATE
5209: WHERE indicator = x_indicator;
5210:

Line 5243: h_sql := 'UPDATE bsc_kpis_b'||

5239: -- row and it will fail. AUDSID is not PK. After meeting with
5240: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5241: h_user_id := BSC_APPS.fnd_global_user_id;
5242:
5243: h_sql := 'UPDATE bsc_kpis_b'||
5244: ' SET last_updated_by = :1, last_update_date = SYSDATE'||
5245: ' WHERE '||x_condition;
5246:
5247: h_bind_vars_values.delete;

Line 5381: h_sql := 'UPDATE bsc_kpis_b'||

5377: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
5378: h_user_id := BSC_APPS.fnd_global_user_id;
5379:
5380: /*
5381: h_sql := 'UPDATE bsc_kpis_b'||
5382: ' SET last_updated_by = :1,'||
5383: ' last_update_date = SYSDATE'||
5384: ' WHERE indicator IN ('||
5385: ' SELECT indicator'||

Line 5391: UPDATE bsc_kpis_b

5387: ' WHERE table_name = :2)';
5388: EXECUTE IMMEDIATE h_sql USING h_user_id, x_table_name;
5389: */
5390:
5391: UPDATE bsc_kpis_b
5392: SET last_updated_by = h_user_id,
5393: last_update_date = SYSDATE
5394: WHERE indicator IN (
5395: SELECT indicator

Line 6162: from bsc_kpis_b k, bsc_kpi_properties p

6158: h_aw_kpi_type := 2;
6159:
6160: select count(k.indicator)
6161: into h_count
6162: from bsc_kpis_b k, bsc_kpi_properties p
6163: where k.indicator = p.indicator and
6164: k.prototype_flag in (0,6,7) and
6165: p.property_code = h_aw_impl_type_name and
6166: p.property_value = h_aw_kpi_type;

Line 6270: bsc_kpis_b obj

6266: bsc_kpi_analysis_measures_b anal_meas,
6267: bsc_sys_datasets_b ds,
6268: bsc_sys_measures m1,
6269: bsc_sys_measures m2,
6270: bsc_kpis_b obj
6271: WHERE anal_meas.dataset_id = ds.dataset_id
6272: AND ds.measure_id1 = m1.measure_id
6273: AND NVL(ds.measure_id2, ds.measure_id1) = m2.measure_id
6274: AND obj.indicator = anal_meas.indicator