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_BIS_MEASURE_PUB dependencies on BSC_BIS_LOCKS_PUB

Line 864: BSC_BIS_LOCKS_PUB.LOCK_DATASOURCE(

860: -- you would not want someone to delete it whenever
861: -- it is being assigned to the datasets/
862: -- Lock the first Data Source
863: if (l_Dataset_Rec.Bsc_Measure_Id is not null) then
864: BSC_BIS_LOCKS_PUB.LOCK_DATASOURCE(
865: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id
866: ,p_time_stamp => NULL
867: ,x_return_status => x_return_status
868: ,x_msg_count => x_msg_count

Line 879: BSC_BIS_LOCKS_PUB.LOCK_DATASOURCE(

875: end if;
876:
877: -- Lock the second Data Source
878: if (l_Dataset_Rec.Bsc_Measure_Id2 is not null) then
879: BSC_BIS_LOCKS_PUB.LOCK_DATASOURCE(
880: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id2
881: ,p_time_stamp => NULL
882: ,x_return_status => x_return_status
883: ,x_msg_count => x_msg_count

Line 928: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(

924: -- START Granular Locking
925:
926: -- Change the time stamp of the Current Datasource (1)
927: IF (l_Dataset_Rec.Bsc_Measure_Id is not null) THEN
928: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
929: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id
930: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
931: ,x_return_status => x_return_status
932: ,x_msg_count => x_msg_count

Line 943: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(

939: END IF;
940:
941: -- Change the time stamp of the Current Datasource (2)
942: IF (l_Dataset_Rec.Bsc_Measure_Id2 is not null) THEN
943: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
944: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id2
945: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
946: ,x_return_status => x_return_status
947: ,x_msg_count => x_msg_count

Line 1734: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');

1730: END IF;
1731: END IF ;
1732:
1733: -- START Granular Locking
1734: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');
1735: BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE(
1736: p_dataset_id => l_Dataset_Rec.Bsc_dataset_id
1737: ,p_time_stamp => p_time_stamp
1738: ,x_return_status => x_return_status

Line 1735: BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE(

1731: END IF ;
1732:
1733: -- START Granular Locking
1734: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');
1735: BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE(
1736: p_dataset_id => l_Dataset_Rec.Bsc_dataset_id
1737: ,p_time_stamp => p_time_stamp
1738: ,x_return_status => x_return_status
1739: ,x_msg_count => x_msg_count

Line 1746: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');

1742:
1743: -- The APIs should check for return status ...
1744: -- Raising an unexpected error.
1745: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1746: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748: END IF;
1749: -- END Granular Locking
1750:

Line 2031: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');

2027:
2028:
2029: -- Change the time stamp of the Current Dataset (Measure)
2030: IF (l_Dataset_Rec.Bsc_dataset_id is not null) THEN
2031: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');
2032: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(
2033: p_dataset_id => l_Dataset_Rec.Bsc_dataset_id
2034: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2035: ,x_return_status => x_return_status

Line 2032: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(

2028:
2029: -- Change the time stamp of the Current Dataset (Measure)
2030: IF (l_Dataset_Rec.Bsc_dataset_id is not null) THEN
2031: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');
2032: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(
2033: p_dataset_id => l_Dataset_Rec.Bsc_dataset_id
2034: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2035: ,x_return_status => x_return_status
2036: ,x_msg_count => x_msg_count

Line 2041: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');

2037: ,x_msg_data => x_msg_data
2038: ) ;
2039:
2040: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2041: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;
2044: END IF;
2045: -- Change the time stamp of the Current Datasource (1)

Line 2047: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2043: END IF;
2044: END IF;
2045: -- Change the time stamp of the Current Datasource (1)
2046: IF (l_Dataset_Rec.Bsc_Measure_Id is not null) THEN
2047: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2048: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
2049: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id
2050: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2051: ,x_return_status => x_return_status

Line 2048: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(

2044: END IF;
2045: -- Change the time stamp of the Current Datasource (1)
2046: IF (l_Dataset_Rec.Bsc_Measure_Id is not null) THEN
2047: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2048: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
2049: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id
2050: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2051: ,x_return_status => x_return_status
2052: ,x_msg_count => x_msg_count

Line 2057: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2053: ,x_msg_data => x_msg_data
2054: ) ;
2055:
2056: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2057: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060: END IF;
2061: -- Change the time stamp of the Current Datasource (2)

Line 2063: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2059: END IF;
2060: END IF;
2061: -- Change the time stamp of the Current Datasource (2)
2062: IF (l_Dataset_Rec.Bsc_Measure_Id2 is not null) THEN
2063: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2064: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
2065: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id2
2066: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2067: ,x_return_status => x_return_status

Line 2064: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(

2060: END IF;
2061: -- Change the time stamp of the Current Datasource (2)
2062: IF (l_Dataset_Rec.Bsc_Measure_Id2 is not null) THEN
2063: --DBMS_OUTPUT.PUT_LINE('calling BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2064: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE(
2065: p_measure_id => l_Dataset_Rec.Bsc_Measure_Id2
2066: ,p_lud => l_Dataset_Rec.Bsc_Dataset_Last_Update_Date
2067: ,x_return_status => x_return_status
2068: ,x_msg_count => x_msg_count

Line 2072: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2068: ,x_msg_count => x_msg_count
2069: ,x_msg_data => x_msg_data
2070: ) ;
2071: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2072: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: END IF;
2075: END IF;
2076: -- END Granular Locking

Line 2173: BSC_BIS_LOCKS_PUB.LOCK_DELETE_MEASURE(

2169:
2170: l_Dataset_Rec.Bsc_dataset_id := p_dataset_id;
2171:
2172: -- START : Granular Locking Needs do come on the top.- Fixed by ADRAO
2173: BSC_BIS_LOCKS_PUB.LOCK_DELETE_MEASURE(
2174: p_dataset_id => l_Dataset_Rec.Bsc_dataset_id
2175: ,p_time_stamp => p_time_stamp
2176: ,x_return_status => x_return_status
2177: ,x_msg_count => x_msg_count

Line 2415: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(

2411: end if;
2412:
2413: -- Change the time stamp of the Current Dataset (Measure)
2414: IF (p_dataset_id is not null) THEN
2415: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(
2416: p_dataset_id => p_dataset_id
2417: ,x_return_status => x_return_status
2418: ,x_msg_count => x_msg_count
2419: ,x_msg_data => x_msg_data

Line 2617: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(

2613: end if;
2614:
2615: -- Change the time stamp of the Current Dataset (Measure)
2616: IF (p_dataset_id is not null) THEN
2617: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET(
2618: p_dataset_id => p_dataset_id
2619: ,x_return_status => x_return_status
2620: ,x_msg_count => x_msg_count
2621: ,x_msg_data => x_msg_data

Line 3086: l_time_stamp := BSC_BIS_LOCKS_PUB.GET_TIME_STAMP_DATASET(

3082: -- Get the time stamp using the dataset id so that it can be passed back
3083: -- to the update API
3084: -- Use the db record that is retrieved before for this.
3085:
3086: l_time_stamp := BSC_BIS_LOCKS_PUB.GET_TIME_STAMP_DATASET(
3087: p_dataset_id => l_dataset_rec.bsc_dataset_id);
3088: -- Use BSC_DATASETS_PUB.Retrieve_Measures to get the measure details
3089: -- Previously l_dataset_rec has got all properties related to datasets
3090: -- Now measures properties are populated.