DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_DB_MEASURE_COLS_PKG

Line 912: BSC_DB_MEASURE_COLS_PKG.Update_Measure_Column_Help (

908: -- Update the measure column if a different source column
909: -- has been chosen from the LOV and
910:
911: IF (NOT isFormula(l_Dataset_Rec.Bsc_Measure_Col) AND l_Dataset_Rec.Bsc_Source = c_BSC) THEN
912: BSC_DB_MEASURE_COLS_PKG.Update_Measure_Column_Help (
913: p_Measure_Col => l_Dataset_Rec.Bsc_Measure_Col
914: , p_Help => l_Dataset_Rec.Bsc_Measure_Col_Help
915: , x_Return_Status => x_return_status
916: , x_Msg_Count => x_msg_count

Line 1053: bsc_db_measure_cols_pkg.insert_row(

1049: -- Bug#3817894 - Pass the source column values
1050: -- Aditya Rao relaxed creation of Measure Columns
1051: -- if (not isFormula(l_Dataset_Rec.Bsc_Measure_Col) and l_Dataset_Rec.Bsc_Source = c_BSC) then
1052: IF NOT (isFormula(l_Dataset_Rec.Bsc_Measure_Col) OR l_Dataset_Rec.Bsc_Source = c_CDS) THEN
1053: bsc_db_measure_cols_pkg.insert_row(
1054: l_Dataset_Rec.Bsc_Measure_Col
1055: ,p_measure_group_id
1056: ,l_Dataset_Rec.Bsc_Measure_Projection_Id
1057: ,p_Measure_Type

Line 1890: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.update_row');

1886: IF ((p_Measure_Col_Help IS NOT NULL) AND (p_Measure_Col_Help <> l_Measure_Col_Help)) THEN
1887: l_Measure_Col_Help := p_Measure_Col_Help;
1888: END IF;
1889:
1890: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.update_row');
1891: BSC_DB_MEASURE_COLS_PKG.Update_Row
1892: ( x_Measure_Col => l_Dataset_Rec.Bsc_Measure_Col
1893: , x_Measure_Group_Id => NVL(p_measure_group_id, l_measure_group_id)
1894: , x_Projection_Id => NVL(l_Dataset_Rec.Bsc_Measure_Projection_Id,l_projection_id)

Line 1891: BSC_DB_MEASURE_COLS_PKG.Update_Row

1887: l_Measure_Col_Help := p_Measure_Col_Help;
1888: END IF;
1889:
1890: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.update_row');
1891: BSC_DB_MEASURE_COLS_PKG.Update_Row
1892: ( x_Measure_Col => l_Dataset_Rec.Bsc_Measure_Col
1893: , x_Measure_Group_Id => NVL(p_measure_group_id, l_measure_group_id)
1894: , x_Projection_Id => NVL(l_Dataset_Rec.Bsc_Measure_Projection_Id,l_projection_id)
1895: , x_Measure_Type => NVL(p_Measure_Type, l_measure_type)

Line 1899: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.update_row');

1895: , x_Measure_Type => NVL(p_Measure_Type, l_measure_type)
1896: , x_Help => NVL(l_measure_col_help, l_Dataset_Rec.Bsc_Measure_Col)
1897: );
1898: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1899: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.update_row');
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: else
1903: IF NOT (isFormula(l_Dataset_Rec.Bsc_Measure_Col) OR l_Dataset_Rec.Bsc_Source = c_CDS) THEN

Line 1904: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.insert_row');

1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: else
1903: IF NOT (isFormula(l_Dataset_Rec.Bsc_Measure_Col) OR l_Dataset_Rec.Bsc_Source = c_CDS) THEN
1904: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.insert_row');
1905: bsc_db_measure_cols_pkg.insert_row(
1906: l_Dataset_Rec.Bsc_Measure_Col
1907: ,p_measure_group_id
1908: ,l_Dataset_Rec.Bsc_Measure_Projection_Id

Line 1905: bsc_db_measure_cols_pkg.insert_row(

1901: END IF;
1902: else
1903: IF NOT (isFormula(l_Dataset_Rec.Bsc_Measure_Col) OR l_Dataset_Rec.Bsc_Source = c_CDS) THEN
1904: --DBMS_OUTPUT.PUT_LINE('calling bsc_db_measure_cols_pkg.insert_row');
1905: bsc_db_measure_cols_pkg.insert_row(
1906: l_Dataset_Rec.Bsc_Measure_Col
1907: ,p_measure_group_id
1908: ,l_Dataset_Rec.Bsc_Measure_Projection_Id
1909: ,p_Measure_Type

Line 1912: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.insert_row');

1908: ,l_Dataset_Rec.Bsc_Measure_Projection_Id
1909: ,p_Measure_Type
1910: ,l_measure_col_help);
1911: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1912: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.insert_row');
1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914: END IF;
1915: end if;
1916: end if;