[Home] [Help]
1392: l_Dataset_Rec.Bsc_Measure_Last_Update_Login := fnd_global.LOGIN_ID;
1393: end if;
1394:
1395:
1396: BSC_DATASETS_PVT.Create_Measures(
1397: p_commit
1398: ,l_Dataset_Rec
1399: ,x_return_status
1400: ,x_msg_count
1752: /*
1753: The following logic ensures that no dangling entries in bsc_sys_measures
1754: remains within the system. When one Measure (bsc_sys_datasets_b) has its datasource
1755: changed, then we need to delete it during update and ensure that it is not orphened
1756: i.e its achieved using the Delete_Measures from the Private datasets package (BSC_DATASETS_PVT)
1757: */
1758:
1759: l_Delete_Source := FALSE;
1760:
1847: -- Delete the source columns that may no more be used and are dangling
1848: -- This is called after update, since the API checks if the passed measure_id is being used or not.
1849: IF (l_Delete_Source = TRUE) THEN
1850: -- this API deletes only the source columns (bsc_sys_measures) and not the actual measure itself.
1851: BSC_DATASETS_PVT.Delete_Measures(
1852: p_commit => p_commit
1853: ,p_Dataset_Rec => l_Del_Dataset_Rec
1854: ,x_return_status => x_return_status
1855: ,x_msg_count => x_msg_count
2388:
2389: if p_disabled_calc_table is not null then
2390: for i in 1..p_disabled_calc_table.count loop
2391: l_Dataset_Rec.Bsc_Disabled_Calc_Id := p_disabled_calc_table(i);
2392: BSC_DATASETS_PVT.Create_Dataset_Calc(
2393: p_commit => p_commit
2394: ,p_Dataset_Rec => l_Dataset_Rec
2395: ,x_return_status => x_return_status
2396: ,x_msg_count => x_msg_count
3734: -- raise fnd_api.g_exc_error;
3735: end if;
3736:
3737: if((upper(p_formula) <> upper(l_formula)) and (p_formula is not null)) then
3738: IF (BSC_DATASETS_PVT.Is_Structure_change(upper(p_formula), upper(l_formula))) THEN
3739: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3740: fnd_message.set_token('INDICATORS', l_kpis);
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;