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_LOCKS_PUB dependencies on BSC_BIS_LOCKS_PVT

Line 13: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DATASET (p_dataset_id );

9: Function GET_TIME_STAMP_DATASET (
10: p_dataset_id IN number
11: ) return varchar2 is
12: Begin
13: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DATASET (p_dataset_id );
14: EXCEPTION
15: WHEN OTHERS THEN
16: return NULL;
17: end GET_TIME_STAMP_DATASET;

Line 25: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DATASOURCE (p_measure_id);

21: Function GET_TIME_STAMP_DATASOURCE (
22: p_measure_id IN number
23: ) return varchar2 is
24: Begin
25: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DATASOURCE (p_measure_id);
26: EXCEPTION
27: WHEN OTHERS THEN
28: return NULL;
29: end GET_TIME_STAMP_DATASOURCE;

Line 97: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (

93:
94: SAVEPOINT BSCSetTimeDataSetPUB;
95:
96: /* change time stamp for current dataset */
97: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (
98: p_dataset_id
99: ,p_lud
100: ,x_return_status
101: ,x_msg_count

Line 134: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (

130: fetch l_cursor into l_dataset_id;
131: EXIT WHEN l_cursor%NOTFOUND;
132: --dbms_output.put_line(' l_dataset_id = ' || l_dataset_id );
133: if l_dataset_id <> p_dataset_id then
134: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (
135: l_dataset_id
136: ,p_lud
137: ,x_return_status
138: ,x_msg_count

Line 224: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASOURCE (

220:
221: SAVEPOINT BSCSetTimeDataSrcPUB;
222:
223:
224: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASOURCE (
225: p_measure_id
226: ,p_lud
227: ,x_return_status
228: ,x_msg_count

Line 274: BSC_BIS_LOCKS_PVT.LOCK_DATASET (

270: --dbms_output.put_line(' p_dataset_id = '|| p_dataset_id);
271:
272: SAVEPOINT BSCLockDataSetPUB;
273:
274: BSC_BIS_LOCKS_PVT.LOCK_DATASET (
275: p_dataset_id => p_dataset_id
276: ,p_time_stamp => p_time_stamp
277: ,x_measure_id1 => l_measure_id1
278: ,x_measure_id2 => l_measure_id2

Line 302: BSC_BIS_LOCKS_PVT.LOCK_DATASET (

298: fetch l_cursor into l_dataset_id;
299: EXIT WHEN l_cursor%NOTFOUND;
300: if l_dataset_id <> p_dataset_id then
301: --dbms_output.put_line(' l_dataset_id = '|| l_dataset_id);
302: BSC_BIS_LOCKS_PVT.LOCK_DATASET (
303: p_dataset_id => l_dataset_id
304: ,p_time_stamp => null
305: ,x_measure_id1 => l_temp_id1
306: ,x_measure_id2 => l_temp_id1

Line 388: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(

384:
385: SAVEPOINT BSCLockDataSrcPUB;
386:
387:
388: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(
389: p_measure_id
390: ,p_time_stamp
391: ,null
392: ,x_return_status

Line 571: BSC_BIS_LOCKS_PVT.LOCK_DATASET (

567: ,x_msg_data => x_msg_data
568: );
569:
570: /* Lock the Dataset and the associated Measures */
571: BSC_BIS_LOCKS_PVT.LOCK_DATASET (
572: p_dataset_id => p_dataset_id
573: ,p_time_stamp => null
574: ,x_measure_id1 => l_temp1
575: ,x_measure_id2 => l_temp2

Line 618: BSC_BIS_LOCKS_PVT.LOCK_DIM_LEVEL(

614:
615: SAVEPOINT BSCLockDimObjPUB;
616:
617:
618: BSC_BIS_LOCKS_PVT.LOCK_DIM_LEVEL(
619: p_dim_level_id
620: ,p_time_stamp
621: ,x_return_status
622: ,x_msg_count

Line 664: BSC_BIS_LOCKS_PVT.LOCK_DIM_GROUP (

660:
661: SAVEPOINT BSCLockDimPUB;
662:
663:
664: BSC_BIS_LOCKS_PVT.LOCK_DIM_GROUP (
665: p_dim_group_id
666: ,p_time_stamp
667: ,x_return_status
668: ,x_msg_count

Line 712: BSC_BIS_LOCKS_PVT.LOCK_DIM_SET (

708:
709: SAVEPOINT BSCLockDimSetPUB;
710:
711:
712: BSC_BIS_LOCKS_PVT.LOCK_DIM_SET (
713: p_kpi_Id
714: ,p_dim_set_id
715: ,p_time_stamp
716: ,x_return_status

Line 759: BSC_BIS_LOCKS_PVT.LOCK_KPI(

755:
756: SAVEPOINT BSCLockKpiPUB;
757:
758:
759: BSC_BIS_LOCKS_PVT.LOCK_KPI(
760: p_kpi_Id
761: ,p_time_stamp
762: ,p_full_lock_flag
763: ,x_return_status

Line 795: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_LEVEL(p_dim_level_id);

791: Function GET_TIME_STAMP_DIM_LEVEL(
792: p_dim_level_id IN number
793: ) return varchar2 is
794: Begin
795: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_LEVEL(p_dim_level_id);
796: EXCEPTION
797: WHEN OTHERS THEN
798: return NULL;
799: end GET_TIME_STAMP_DIM_LEVEL;

Line 808: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_GROUP(p_dim_group_id);

804: Function GET_TIME_STAMP_DIM_GROUP (
805: p_dim_group_id IN number
806: ) return varchar2 is
807: Begin
808: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_GROUP(p_dim_group_id);
809: EXCEPTION
810: WHEN OTHERS THEN
811: return NULL;
812:

Line 822: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_SET(p_kpi_Id,p_dim_set_id);

818: p_kpi_Id IN number
819: ,p_dim_set_id IN number
820: ) return varchar2 is
821: Begin
822: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_DIM_SET(p_kpi_Id,p_dim_set_id);
823: EXCEPTION
824: WHEN OTHERS THEN
825: return NULL;
826: end GET_TIME_STAMP_DIM_SET;

Line 835: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_KPI(p_kpi_Id);

831: Function GET_TIME_STAMP_KPI (
832: p_kpi_Id IN number
833: ) return varchar2 is
834: Begin
835: return BSC_BIS_LOCKS_PVT.GET_TIME_STAMP_KPI(p_kpi_Id);
836: EXCEPTION
837: WHEN OTHERS THEN
838: return NULL;
839: end GET_TIME_STAMP_KPI;

Line 853: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_LEVEL (

849: begin
850: SAVEPOINT BSCSetTimeDimObjPUB;
851:
852:
853: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_LEVEL (
854: p_dim_level_id
855: ,x_return_status
856: ,x_msg_count
857: ,x_msg_data

Line 894: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_GROUP (

890:
891: SAVEPOINT BSCSetTimeDimPUB;
892:
893:
894: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_GROUP (
895: p_dim_group_id
896: ,x_return_status
897: ,x_msg_count
898: ,x_msg_data

Line 936: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_SET (

932:
933: SAVEPOINT BSCSetTimeDimSetPUB;
934:
935:
936: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DIM_SET (
937: p_kpi_Id
938: , p_dim_set_id
939: ,x_return_status
940: ,x_msg_count

Line 978: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_KPI (

974:
975: SAVEPOINT BSCSetTimeKpiPUB;
976:
977:
978: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_KPI (
979: p_kpi_Id
980: ,x_return_status
981: ,x_msg_count
982: ,x_msg_data

Line 1027: BSC_BIS_LOCKS_PVT.LOCK_CREATE_DIMENSION(

1023:
1024: SAVEPOINT BSCLockCreDimPUB;
1025:
1026:
1027: BSC_BIS_LOCKS_PVT.LOCK_CREATE_DIMENSION(
1028: p_selected_dim_objets
1029: ,x_return_status
1030: ,x_msg_count
1031: ,x_msg_data

Line 1084: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIMENSION (

1080:
1081: SAVEPOINT BSCLockUpdDimPUB;
1082:
1083:
1084: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIMENSION (
1085: p_dimension_id
1086: ,p_selected_dim_objets
1087: ,p_time_stamp
1088: ,x_return_status

Line 1134: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIM_OBJ_IN_DIM(

1130:
1131: SAVEPOINT BSCLockUpdDimInObjPUB;
1132:
1133:
1134: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIM_OBJ_IN_DIM(
1135: p_dim_object_id
1136: ,p_dimension_id
1137: ,p_time_stamp
1138: ,x_return_status

Line 1185: BSC_BIS_LOCKS_PVT.LOCK_CREATE_DIMENSION_OBJECT(

1181:
1182: SAVEPOINT BSCLockCreDimObjPUB;
1183:
1184:
1185: BSC_BIS_LOCKS_PVT.LOCK_CREATE_DIMENSION_OBJECT(
1186: p_selected_dimensions
1187: ,x_return_status
1188: ,x_msg_count
1189: ,x_msg_data

Line 1239: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIMENSION_OBJECT(

1235:
1236: SAVEPOINT BSCLockUpdDimObjPUB;
1237:
1238:
1239: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_DIMENSION_OBJECT(
1240: p_dim_object_id
1241: ,p_selected_dimensions
1242: ,p_time_stamp
1243: ,x_return_status

Line 1296: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_RELATIONSHIPS(

1292:
1293: SAVEPOINT BSCLockUpdDimRelsPUB;
1294:
1295:
1296: BSC_BIS_LOCKS_PVT.LOCK_UPDATE_RELATIONSHIPS(
1297: p_dim_object_id
1298: ,p_selected_parends
1299: ,p_selected_childs
1300: ,p_time_stamp

Line 1357: BSC_BIS_LOCKS_PVT.LOCK_ASSIGN_DIM_SET (

1353:
1354: SAVEPOINT BSCLockAsgnDimSetPUB;
1355:
1356:
1357: BSC_BIS_LOCKS_PVT.LOCK_ASSIGN_DIM_SET (
1358: p_kpi_Id
1359: ,p_option_group0
1360: ,p_option_group1
1361: ,p_option_group2

Line 1410: BSC_BIS_LOCKS_PVT.LOCK_TAB_VIEW_ID

1406: ,x_msg_data OUT NOCOPY VARCHAR2
1407: )IS
1408: BEGIN
1409:
1410: BSC_BIS_LOCKS_PVT.LOCK_TAB_VIEW_ID
1411: (
1412: p_tab_id => p_tab_id
1413: ,p_tab_view_id => p_tab_view_id
1414: ,p_time_stamp => p_time_stamp

Line 1460: BSC_BIS_LOCKS_PVT.LOCK_TAB

1456: BEGIN
1457: FND_MSG_PUB.Initialize;
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459:
1460: BSC_BIS_LOCKS_PVT.LOCK_TAB
1461: (
1462: p_tab_id => p_tab_id
1463: ,p_time_stamp => p_time_stamp
1464: ,x_return_status => x_return_status

Line 1746: BSC_BIS_LOCKS_PVT.Lock_Calendar (

1742: FND_MSG_PUB.Initialize;
1743:
1744: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1745:
1746: BSC_BIS_LOCKS_PVT.Lock_Calendar (
1747: p_Calendar_Id => p_Calendar_Id
1748: , p_Time_Stamp => p_Time_Stamp
1749: , x_Return_Status => x_Return_Status
1750: , x_Msg_Count => x_Msg_Count

Line 1758: BSC_BIS_LOCKS_PVT.Lock_Periodicity (

1754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1755: END IF;
1756:
1757: FOR cPerIds IN c_Periodicity_Ids LOOP
1758: BSC_BIS_LOCKS_PVT.Lock_Periodicity (
1759: p_Periodicity_Id => cPerIds.PERIODICITY_ID
1760: , p_Time_Stamp => NULL
1761: , x_Return_Status => x_Return_Status
1762: , x_Msg_Count => x_Msg_Count

Line 1823: BSC_BIS_LOCKS_PVT.Lock_Calendar (

1819: FND_MSG_PUB.Initialize;
1820:
1821: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1822:
1823: BSC_BIS_LOCKS_PVT.Lock_Calendar (
1824: p_Calendar_Id => p_Calendar_Id
1825: , p_Time_Stamp => p_Time_Stamp
1826: , x_Return_Status => x_Return_Status
1827: , x_Msg_Count => x_Msg_Count

Line 1887: BSC_BIS_LOCKS_PVT.Lock_Periodicity (

1883: FND_MSG_PUB.Initialize;
1884:
1885: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: BSC_BIS_LOCKS_PVT.Lock_Periodicity (
1888: p_Periodicity_Id => p_Periodicity_Id
1889: , p_Time_Stamp => p_Time_Stamp
1890: , x_Return_Status => x_Return_Status
1891: , x_Msg_Count => x_Msg_Count