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_DATASETS_PVT dependencies on BSC_SYS_DATASETS_B

Line 57: | BSC_SYS_DATASETS_B.MEASURE_ID1/MEASURE_ID2 |

53: | in Delete_Measure API |
54: | 27-JUL-04 sawu Added logic to set WHO columns in create/update api |
55: | 28-JUL-04 adrao Bug#3781176 Added logic in Delete_Measures(), whenever |
56: | the same source column is referenced in both |
57: | BSC_SYS_DATASETS_B.MEASURE_ID1/MEASURE_ID2 |
58: | 17-AUG-04 visuri Bug#3681116 Added logic in Update_Dataset() API to ensure |
59: | that numeric format change of any measure also |
60: | updates the default format of indicators for |
61: | which that measure is a default measure. |

Line 769: FROM BSC_SYS_DATASETS_B

765: -- Only delete base measure if there are no datasets referencing it.
766: -- Delete the MEASURE_ID1 Measure
767: SELECT COUNT(DATASET_ID)
768: INTO l_Count
769: FROM BSC_SYS_DATASETS_B
770: WHERE MEASURE_ID1 = p_Dataset_Rec.Bsc_Measure_Id
771: OR MEASURE_ID2 = p_Dataset_Rec.Bsc_Measure_Id;
772:
773: IF l_Count = 0 THEN

Line 811: FROM BSC_SYS_DATASETS_B

807:
808: IF p_Dataset_Rec.Bsc_Measure_Id2 IS NOT NULL THEN
809: SELECT COUNT(DATASET_ID)
810: INTO l_Count
811: FROM BSC_SYS_DATASETS_B
812: WHERE MEASURE_ID1 = p_Dataset_Rec.Bsc_Measure_Id2
813: OR MEASURE_ID2 = p_Dataset_Rec.Bsc_Measure_Id2;
814:
815: -- Bug#3781176

Line 1004: from BSC_SYS_DATASETS_B

1000:
1001: -- Verify that dataset does not exist.
1002: select count(1)
1003: into l_count
1004: from BSC_SYS_DATASETS_B
1005: where dataset_id = l_Dataset_Rec.Bsc_Dataset_Id;
1006:
1007: -- If dataset does not exist then create it, else raise an error.
1008:

Line 1011: -- Insert the pertaining values into table bsc_sys_datasets_b.

1007: -- If dataset does not exist then create it, else raise an error.
1008:
1009: if l_count = 0 then
1010:
1011: -- Insert the pertaining values into table bsc_sys_datasets_b.
1012: insert into BSC_SYS_DATASETS_B( dataset_id
1013: ,measure_id1
1014: ,operation
1015: ,measure_id2

Line 1012: insert into BSC_SYS_DATASETS_B( dataset_id

1008:
1009: if l_count = 0 then
1010:
1011: -- Insert the pertaining values into table bsc_sys_datasets_b.
1012: insert into BSC_SYS_DATASETS_B( dataset_id
1013: ,measure_id1
1014: ,operation
1015: ,measure_id2
1016: ,format_id

Line 1225: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'

1221: l_color_Method_flag := false;
1222:
1223: -- Check that valid dataset id was entered.
1224: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1225: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1226: ,'dataset_id'
1227: ,p_Dataset_Rec.Bsc_Dataset_Id);
1228: if l_count = 0 then
1229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

Line 1380: update BSC_SYS_DATASETS_B

1376: -- PMD
1377: -- mdamle 03/12/2003 - PMD - Measure Definer
1378: -- Changed from Measure_operation to Dataset_Operation
1379: -- Added Measure_id1 and Measure_Id2
1380: update BSC_SYS_DATASETS_B
1381: set operation = l_Dataset_Rec.Bsc_Dataset_Operation
1382: ,format_id = l_Dataset_Rec.Bsc_Dataset_Format_Id
1383: ,color_method = l_Dataset_Rec.Bsc_Dataset_Color_Method
1384: ,projection_flag = l_Dataset_Rec.Bsc_Dataset_Projection_Flag

Line 1524: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'

1520: begin
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522: -- Check that a valid dataset id was entered.
1523: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1524: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1525: ,'dataset_id'
1526: ,p_Dataset_Rec.Bsc_Dataset_Id);
1527: if l_count = 0 then
1528: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

Line 1576: delete from BSC_SYS_DATASETS_B

1572: ,x_return_status => x_return_status
1573: ,x_msg_count => x_msg_count
1574: ,x_msg_data => x_msg_data);
1575:
1576: delete from BSC_SYS_DATASETS_B
1577: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;
1578:
1579: delete from BSC_SYS_DATASETS_TL
1580: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id;

Line 1636: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'

1632:
1633:
1634: -- Check that valid dataset id was entered.
1635: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1636: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1637: ,'dataset_id'
1638: ,p_Dataset_Rec.Bsc_Dataset_Id);
1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

Line 1764: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'

1760: begin
1761:
1762: -- Check that valid dataset id was entered.
1763: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1764: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1765: ,'dataset_id'
1766: ,p_Dataset_Rec.Bsc_Dataset_Id);
1767: if l_count = 0 then
1768: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

Line 1830: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'

1826:
1827: -- Check that valid dataset id was entered.
1828: if p_Dataset_Rec.Bsc_Dataset_Id is not null then
1829:
1830: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1831: ,'dataset_id'
1832: ,p_Dataset_Rec.Bsc_Dataset_Id);
1833:
1834: if l_count = 0 then