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

Line 44: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

40: -------------------------------------------------------------------------------------------------------------------*/
41: FUNCTION get_Dataset_Name(
42: p_dataset_id IN NUMBER
43: ) RETURN VARCHAR2 IS
44: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
45: l_sql varchar2(300);
46: temp varchar2(300);
47: Begin
48: l_sql := 'SELECT NAME FROM BSC_SYS_DATASETS_VL WHERE DATASET_ID =:1';

Line 61: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

57:
58: FUNCTION get_Datasource_Name(
59: p_datasource_id IN NUMBER
60: ) RETURN VARCHAR2 IS
61: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
62: l_sql varchar2(300);
63: temp varchar2(1000);
64: Begin
65: l_sql := 'SELECT MEASURE_COL FROM BSC_SYS_MEASURES WHERE MEASURE_ID =:1';

Line 81: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

77: -------------------------------------------------------------------------------------------*/
78: Function GET_TIME_STAMP_DATASET (
79: p_dim_set_id IN number
80: ) return varchar2 is
81: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
82: l_sql varchar2(32000);
83: object_id number;
84: temp date;
85: Begin

Line 95: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

91:
92: open l_cursor for l_sql USING p_dim_set_id;
93: fetch l_cursor into temp;
94: close l_cursor;
95: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: return NULL;

Line 108: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

104: -------------------------------------------------------------------------------------------*/
105: Function GET_TIME_STAMP_DATASOURCE (
106: p_measure_id IN number
107: ) return varchar2 is
108: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
109: l_sql varchar2(32000);
110: object_id number;
111: temp date;
112: Begin

Line 121: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

117:
118: open l_cursor for l_sql USING p_measure_id;
119: fetch l_cursor into temp;
120: close l_cursor;
121: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: return NULL;

Line 306: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

302: ,x_msg_data OUT NOCOPY varchar2
303: ) is
304: l_object_id number;
305: l_last_update_date date;
306: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
307: l_sql varchar2(32000);
308:
309: l_operation varchar2(20);
310: l_dataset_name varchar2(500);

Line 340: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

336: ,p_data => x_msg_data);
337: RAISE FND_API.G_EXC_ERROR;
338: end if;
339: if not p_time_stamp is null then
340: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
341: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' updated by other user ');
342: FND_MSG_PUB.Initialize;
343: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
344: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));

Line 439: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

435: ,x_msg_data OUT NOCOPY varchar2
436: ) is
437: l_object_id number;
438: l_last_update_date date;
439: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
440: l_sql varchar2(32000);
441: begin
442:
443: --SQL statement used to lock a dimension:

Line 469: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

465: RAISE FND_API.G_EXC_ERROR;
466: end if;
467:
468: if not p_time_stamp is null then
469: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
470: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' updated by other user ');
471: FND_MSG_PUB.Initialize;
472: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
473: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name,get_Datasource_Name(p_measure_id)));

Line 521: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

517: -------------------------------------------------------------------------------------------------------------------*/
518: FUNCTION get_Dim_Level_Name(
519: p_dim_level_id IN NUMBER
520: ) RETURN VARCHAR2 IS
521: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
522: l_sql varchar2(300);
523: object_id number;
524: temp varchar2(300);
525: Begin

Line 539: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

535: /*-------------------------------------------------------------------------------------------------------------------*/
536: FUNCTION get_Dim_Group_Name(
537: p_dim_group_id IN NUMBER
538: ) RETURN VARCHAR2 IS
539: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
540: l_sql varchar2(300);
541: object_id number;
542: temp varchar2(300);
543: Begin

Line 558: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

554: FUNCTION get_Dim_Set_Name(
555: p_kpi_id IN NUMBER
556: ,p_dim_set_id IN NUMBER
557: ) RETURN VARCHAR2 IS
558: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
559: l_sql varchar2(300);
560: object_id number;
561: temp varchar2(300);
562: Begin

Line 578: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

574:
575: FUNCTION get_KPI_Name(
576: p_kpi_id IN NUMBER
577: ) RETURN VARCHAR2 IS
578: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
579: l_sql varchar2(300);
580: object_id number;
581: temp varchar2(300);
582: Begin

Line 602: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

598: FUNCTION get_TabView_Name(
599: p_tab_id IN NUMBER
600: ,p_tab_view_id IN NUMBER
601: ) RETURN VARCHAR2 IS
602: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
603: l_sql varchar2(300);
604: object_id number;
605: temp varchar2(300);
606: Begin

Line 626: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

622: ,x_return_status OUT NOCOPY varchar2
623: ,x_msg_count OUT NOCOPY number
624: ,x_msg_data OUT NOCOPY varchar2
625: ) IS
626: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
627: l_sql varchar2(300);
628: l_lock_Rec t_lock_Rec;
629: l_count number;
630:

Line 665: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

661: ,x_return_status OUT NOCOPY varchar2
662: ,x_msg_count OUT NOCOPY number
663: ,x_msg_data OUT NOCOPY varchar2
664: ) IS
665: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
666: l_sql varchar2(300);
667: l_lock_Rec t_lock_Rec;
668: l_count number;
669:

Line 758: p_numberTable IN BSC_BIS_LOCKS_PUB.t_numberTable

754: /*----------------------------------------------------------------------------
755: Convert
756: ----------------------------------------------------------------------------*/
757: Procedure convert_table(
758: p_numberTable IN BSC_BIS_LOCKS_PUB.t_numberTable
759: ,x_lock_table OUT NOCOPY t_lock_table
760: ,x_return_status OUT NOCOPY varchar2
761: ,x_msg_count OUT NOCOPY number
762: ,x_msg_data OUT NOCOPY varchar2

Line 809: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

805: ,x_return_status OUT NOCOPY varchar2
806: ,x_msg_count OUT NOCOPY number
807: ,x_msg_data OUT NOCOPY varchar2
808: ) IS
809: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
810: l_sql varchar2(32000);
811: l_lock_Rec t_lock_Rec;
812: l_index number;
813: l_count number;

Line 873: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

869: ,x_return_status OUT NOCOPY varchar2
870: ,x_msg_count OUT NOCOPY number
871: ,x_msg_data OUT NOCOPY varchar2
872: ) IS
873: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
874: l_sql varchar2(32000);
875: l_lock_Rec t_lock_Rec;
876: l_index number;
877: l_count number;

Line 936: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

932: ,x_msg_data OUT NOCOPY varchar2
933: ) is
934: l_object_id number;
935: l_last_update_date date;
936: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
937: l_sql varchar2(32000);
938: begin
939:
940: SAVEPOINT BSCLockDimObjPVT;

Line 965: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

961: RAISE FND_API.G_EXC_ERROR;
962: end if;
963:
964: if not p_time_stamp is null then
965: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
966: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' updated by other user ');
967: FND_MSG_PUB.Initialize;
968: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_LEVEL');
969: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));

Line 1027: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1023:
1024: ) is
1025: l_object_id number;
1026: l_last_update_date date;
1027: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1028: l_sql varchar2(32000);
1029:
1030: begin
1031:

Line 1059: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

1055: ,p_data => x_msg_data);
1056: RAISE FND_API.G_EXC_ERROR;
1057: end if;
1058: if not p_time_stamp is null then
1059: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1060: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' updated by other user ');
1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
1063: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));

Line 1122: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1118: ) is
1119: l_kpi_id number;
1120: l_dim_set_id number;
1121: l_last_update_date date;
1122: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1123: l_sql varchar2(32000);
1124:
1125: Begin
1126:

Line 1154: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then

1150: ,p_data => x_msg_data);
1151: RAISE FND_API.G_EXC_ERROR;
1152: end if;
1153: if not p_time_stamp is null then
1154: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1155: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' updated by other user ');
1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483

Line 1217: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1213: ) is
1214: l_kpi_id number;
1215: l_dim_set_id number;
1216: l_last_update_date varchar2(50);
1217: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1218: l_sql varchar2(300);
1219: l_temp varchar2(300);
1220:
1221: Begin

Line 1319: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1315: ------------------------------------------------------------------------------------------*/
1316: Function GET_TIME_STAMP_DIM_LEVEL(
1317: p_dim_level_id IN number
1318: ) return varchar2 is
1319: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1320: l_sql varchar2(32000);
1321: object_id number;
1322: temp date;
1323: Begin

Line 1332: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1328:
1329: open l_cursor for l_sql USING p_dim_level_id;
1330: fetch l_cursor into temp;
1331: close l_cursor;
1332: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1333:
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: return NULL;

Line 1346: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1342: -------------------------------------------------------------------------------------------*/
1343: Function GET_TIME_STAMP_DIM_GROUP (
1344: p_dim_group_id IN number
1345: ) return varchar2 is
1346: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1347: l_sql varchar2(32000);
1348: object_id number;
1349: temp date;
1350: Begin

Line 1359: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1355:
1356: open l_cursor for l_sql USING p_dim_group_id;
1357: fetch l_cursor into temp;
1358: close l_cursor;
1359: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: return NULL;

Line 1373: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1369: Function GET_TIME_STAMP_DIM_SET (
1370: p_kpi_Id IN number
1371: ,p_dim_set_id IN number
1372: ) return varchar2 is
1373: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1374: l_sql varchar2(32000);
1375: object_id number;
1376: temp date;
1377: Begin

Line 1387: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1383:
1384: open l_cursor for l_sql USING p_kpi_Id, p_dim_set_id;
1385: fetch l_cursor into temp;
1386: close l_cursor;
1387: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1388:
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: return NULL;

Line 1401: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1397: -------------------------------------------------------------------------------------------*/
1398: Function GET_TIME_STAMP_KPI (
1399: p_kpi_Id IN number
1400: ) return varchar2 is
1401: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1402: l_sql varchar2(32000);
1403: object_id number;
1404: temp date;
1405: Begin

Line 1414: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1410: ' WHERE INDICATOR =:1' ;
1411: open l_cursor for l_sql USING p_kpi_Id;
1412: fetch l_cursor into temp;
1413: close l_cursor;
1414: return TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: return NULL;

Line 1433: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1429: FUNCTION get_tab_time_stamp(
1430: p_tab_id IN NUMBER
1431: )RETURN VARCHAR2
1432: IS
1433: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1434: l_sql VARCHAR2(32000);
1435: temp BSC_TABS_B.last_update_date%TYPE;
1436: BEGIN
1437: l_sql := 'SELECT LAST_UPDATE_DATE ' ||

Line 1446: RETURN TO_CHAR(temp,BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1442: OPEN l_cursor FOR l_sql USING p_tab_id;
1443: FETCH l_cursor INTO temp;
1444: CLOSE l_cursor;
1445:
1446: RETURN TO_CHAR(temp,BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1447:
1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: RETURN NULL;

Line 1468: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1464: p_tab_id IN NUMBER
1465: ,p_tab_view_id IN NUMBER
1466: ) RETURN VARCHAR2
1467: IS
1468: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1469: l_sql VARCHAR2(32000);
1470: object_id NUMBER;
1471: temp DATE;
1472: Begin

Line 1483: RETURN TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);

1479:
1480: FETCH l_cursor INTO temp;
1481: CLOSE l_cursor;
1482:
1483: RETURN TO_CHAR(temp, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT);
1484:
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: RETURN NULL;

Line 1668: p_selected_dim_objets IN BSC_BIS_LOCKS_PUB.t_numberTable

1664: p_selected_dim_objets: Array with the Ids corresponding to the Dimesion Objects
1665: that will be assigned to the new dimension.
1666: -------------------------------------------------------------------------------------------*/
1667: Procedure LOCK_CREATE_DIMENSION (
1668: p_selected_dim_objets IN BSC_BIS_LOCKS_PUB.t_numberTable
1669: ,x_return_status OUT NOCOPY varchar2
1670: ,x_msg_count OUT NOCOPY number
1671: ,x_msg_data OUT NOCOPY varchar2
1672: ) is

Line 1683: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

1679: if p_selected_dim_objets.COUNT > 0 then
1680: l_index := p_selected_dim_objets.FIRST;
1681: LOOP
1682: l_dim_level_id := p_selected_dim_objets(l_index);
1683: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
1684: p_dim_level_id => l_dim_level_id
1685: ,p_time_stamp => null
1686: ,x_return_status => x_return_status
1687: ,x_msg_count => x_msg_count

Line 1734: ,p_selected_dim_objets IN BSC_BIS_LOCKS_PUB.t_numberTable

1730:
1731: -------------------------------------------------------------------------------------------*/
1732: Procedure LOCK_UPDATE_DIMENSION (
1733: p_dimension_id IN number
1734: ,p_selected_dim_objets IN BSC_BIS_LOCKS_PUB.t_numberTable
1735: ,p_time_stamp IN varchar2/* := null */
1736: ,x_return_status OUT NOCOPY varchar2
1737: ,x_msg_count OUT NOCOPY number
1738: ,x_msg_data OUT NOCOPY varchar2

Line 1749: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

1745:
1746: l_impacted_dim_sets t_lock_table;
1747: l_impacted_dimentions t_lock_table;
1748:
1749: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
1750: l_sql varchar2(300);
1751:
1752: l_lock_Rec t_lock_Rec;
1753: l_count number;

Line 1761: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (

1757:
1758: SAVEPOINT BSCLockUpdDimPVT;
1759:
1760: /*1 Lock the Dimension calling: */
1761: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (
1762: p_dim_group_id => p_dimension_id
1763: ,p_time_stamp => p_time_stamp
1764: ,x_return_status => x_return_status
1765: ,x_msg_count => x_msg_count

Line 1804: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

1800: LOOP
1801: l_dim_level_id := l_previous_dim_objets(l_index).obj_key1;
1802: if NOT l_selected_dim_objets.EXISTS(l_dim_level_id) then
1803: /* 4.1 Lock Dimension Objects deleted from de list*/
1804: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
1805: p_dim_level_id => l_dim_level_id
1806: ,p_time_stamp => null
1807: ,x_return_status => x_return_status
1808: ,x_msg_count => x_msg_count

Line 1826: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

1822: LOOP
1823: l_dim_level_id := l_selected_dim_objets(l_index).obj_key1;
1824: if NOT l_previous_dim_objets.EXISTS(l_dim_level_id) then
1825: /* 4.2 Lock Dimension Objects Added to de list*/
1826: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
1827: p_dim_level_id => l_dim_level_id
1828: ,p_time_stamp => null
1829: ,x_return_status => x_return_status
1830: ,x_msg_count => x_msg_count

Line 1861: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

1857: );
1858: if not l_impacted_dim_sets is null then
1859: for l_index in 1.. l_impacted_dim_sets.count loop
1860: l_lock_Rec := l_impacted_dim_sets(l_index);
1861: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
1862: p_Kpi_Id => l_lock_Rec.obj_key1
1863: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
1864: ,p_time_stamp => null
1865: ,x_return_status => x_return_status

Line 1920: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (

1916: SAVEPOINT BSCLockUpdDimInObjPVT;
1917:
1918:
1919: /* Lock Dimension */
1920: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (
1921: p_dim_group_id => p_dimension_id
1922: ,p_time_stamp => p_time_stamp
1923: ,x_return_status => x_return_status
1924: ,x_msg_count => x_msg_count

Line 1928: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

1924: ,x_msg_count => x_msg_count
1925: ,x_msg_data => x_msg_data
1926: );
1927: /* LocKl Dimension Object */
1928: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
1929: p_dim_level_id => p_dim_object_id
1930: ,p_time_stamp => null
1931: ,x_return_status => x_return_status
1932: ,x_msg_count => x_msg_count

Line 1947: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

1943: ,x_msg_data => x_msg_data
1944: );
1945: for l_index in 1.. l_impacted_dim_sets.count loop
1946: l_lock_Rec := l_impacted_dim_sets(l_index);
1947: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
1948: p_Kpi_Id => l_lock_Rec.obj_key1
1949: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
1950: ,p_time_stamp => null
1951: ,x_return_status => x_return_status

Line 1993: p_selected_dimensions IN BSC_BIS_LOCKS_PUB.t_numberTable

1989: p_selected_dimensions: This Array has the Ids corresponding to the Dimensions where
1990: the dimension object will be assigned.
1991: -------------------------------------------------------------------------------------------*/
1992: Procedure LOCK_CREATE_DIMENSION_OBJECT(
1993: p_selected_dimensions IN BSC_BIS_LOCKS_PUB.t_numberTable
1994: ,x_return_status OUT NOCOPY varchar2
1995: ,x_msg_count OUT NOCOPY number
1996: ,x_msg_data OUT NOCOPY varchar2
1997: ) is

Line 2015: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (

2011: l_index := p_selected_dimensions.FIRST;
2012: LOOP
2013: l_dim_group_id := p_selected_dimensions(l_index);
2014: l_impacted_dimentions(l_index).obj_key1 := l_dim_group_id;
2015: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (
2016: p_dim_group_id => l_dim_group_id
2017: ,p_time_stamp => null
2018: ,x_return_status => x_return_status
2019: ,x_msg_count => x_msg_count

Line 2042: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2038: );
2039: /* Lock affected KPI Dimension Sets */
2040: for l_index in 1.. l_impacted_dim_sets.count loop
2041: l_lock_Rec := l_impacted_dim_sets(l_index);
2042: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2043: p_Kpi_Id => l_lock_Rec.obj_key1
2044: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
2045: ,p_time_stamp => null
2046: ,x_return_status => x_return_status

Line 2089: ,p_selected_dimensions IN BSC_BIS_LOCKS_PUB.t_numberTable

2085: updated by other user.
2086: -------------------------------------------------------------------------------------------*/
2087: Procedure LOCK_UPDATE_DIMENSION_OBJECT(
2088: p_dim_object_id IN number
2089: ,p_selected_dimensions IN BSC_BIS_LOCKS_PUB.t_numberTable
2090: ,p_time_stamp IN varchar2
2091: ,x_return_status OUT NOCOPY varchar2
2092: ,x_msg_count OUT NOCOPY number
2093: ,x_msg_data OUT NOCOPY varchar2

Line 2095: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

2091: ,x_return_status OUT NOCOPY varchar2
2092: ,x_msg_count OUT NOCOPY number
2093: ,x_msg_data OUT NOCOPY varchar2
2094: ) is
2095: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
2096: l_sql varchar2(32000);
2097: l_dim_set_id number;
2098: l_kpi_id number;
2099:

Line 2132: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

2128: END LOOP;
2129: end if;
2130:
2131: /* 1. Lock the Dimension object that will be updated */
2132: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
2133: p_dim_level_id => p_dim_object_id
2134: ,p_time_stamp => p_time_stamp
2135: ,x_return_status => x_return_status
2136: ,x_msg_count => x_msg_count

Line 2152: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2148: LOOP
2149: fetch l_cursor into l_kpi_id, l_dim_set_id;
2150: exit when l_cursor%NOTFOUND;
2151: /* 3. Lock each Dimension Set where the Dimension object is used: */
2152: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2153: p_Kpi_Id => l_Kpi_Id
2154: ,p_Dim_Set_Id => l_Dim_Set_Id
2155: ,p_time_stamp => null
2156: ,x_return_status => x_return_status

Line 2213: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (

2209: /* 6. Lock the affected dimensions found in step 5 */
2210: if l_impacted_dimentions.COUNT > 0 then
2211: l_dimension_id := l_impacted_dimentions.FIRST;
2212: LOOP
2213: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP (
2214: p_dim_group_id => l_dimension_id
2215: ,p_time_stamp => null
2216: ,x_return_status => x_return_status
2217: ,x_msg_count => x_msg_count

Line 2239: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2235: /* 8. Lock each Dimension Set found in Step 7 calling: */
2236: if not l_impacted_dim_sets is null then
2237: for l_index in 1.. l_impacted_dim_sets.count loop
2238: l_lock_Rec := l_impacted_dim_sets(l_index);
2239: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2240: p_Kpi_Id => l_lock_Rec.obj_key1
2241: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
2242: ,p_time_stamp => null
2243: ,x_return_status => x_return_status

Line 2287: ,p_selected_parends IN BSC_BIS_LOCKS_PUB.t_numberTable

2283: been updated by other user.
2284: -------------------------------------------------------------------------------------------*/
2285: Procedure LOCK_UPDATE_RELATIONSHIPS(
2286: p_dim_object_id IN number
2287: ,p_selected_parends IN BSC_BIS_LOCKS_PUB.t_numberTable
2288: ,p_selected_childs IN BSC_BIS_LOCKS_PUB.t_numberTable
2289: ,p_time_stamp IN varchar2
2290: ,x_return_status OUT NOCOPY varchar2
2291: ,x_msg_count OUT NOCOPY number

Line 2288: ,p_selected_childs IN BSC_BIS_LOCKS_PUB.t_numberTable

2284: -------------------------------------------------------------------------------------------*/
2285: Procedure LOCK_UPDATE_RELATIONSHIPS(
2286: p_dim_object_id IN number
2287: ,p_selected_parends IN BSC_BIS_LOCKS_PUB.t_numberTable
2288: ,p_selected_childs IN BSC_BIS_LOCKS_PUB.t_numberTable
2289: ,p_time_stamp IN varchar2
2290: ,x_return_status OUT NOCOPY varchar2
2291: ,x_msg_count OUT NOCOPY number
2292: ,x_msg_data OUT NOCOPY varchar2

Line 2294: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

2290: ,x_return_status OUT NOCOPY varchar2
2291: ,x_msg_count OUT NOCOPY number
2292: ,x_msg_data OUT NOCOPY varchar2
2293: ) is
2294: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
2295: l_sql varchar2(300);
2296: l_lock_Rec t_lock_Rec;
2297: l_count number;
2298: l_index number;

Line 2315: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

2311:
2312: SAVEPOINT BSCLockUpdDimRelsPVT;
2313:
2314: /*1. Lock the Dimension object that will be updated: */
2315: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
2316: p_dim_level_id => p_dim_object_id
2317: ,p_time_stamp => p_time_stamp
2318: ,x_return_status => x_return_status
2319: ,x_msg_count => x_msg_count

Line 2361: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

2357: l_index := l_impacted_dim_objects.FIRST;
2358: LOOP
2359: l_parent_dim_object_id := l_impacted_dim_objects(l_index).obj_key1;
2360: /*4. Lock Deleted and added Parent Dimension object */
2361: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
2362: p_dim_level_id => l_parent_dim_object_id
2363: ,p_time_stamp => null
2364: ,x_return_status => x_return_status
2365: ,x_msg_count => x_msg_count

Line 2380: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2376: );
2377: /*6. Lock the Dimension Set got it in step 5 */
2378: for l_index in 1.. l_impacted_dim_sets.count loop
2379: l_lock_Rec := l_impacted_dim_sets(l_index);
2380: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2381: p_Kpi_Id => l_lock_Rec.obj_key1
2382: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
2383: ,p_time_stamp => null
2384: ,x_return_status => x_return_status

Line 2434: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(

2430: l_index := l_impacted_dim_objects.FIRST;
2431: LOOP
2432: l_child_dim_object_id := l_impacted_dim_objects(l_index).obj_key1;
2433: /*9. Lock deleted and added Child Dimension object*/
2434: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL(
2435: p_dim_level_id => l_child_dim_object_id
2436: ,p_time_stamp => null
2437: ,x_return_status => x_return_status
2438: ,x_msg_count => x_msg_count

Line 2453: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2449: );
2450: /*11. Lock the Dimension Sets got it in step 10. */
2451: for l_index in 1.. l_impacted_dim_sets.count loop
2452: l_lock_Rec := l_impacted_dim_sets(l_index);
2453: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2454: p_Kpi_Id => l_lock_Rec.obj_key1
2455: ,p_Dim_Set_Id => l_lock_Rec.obj_key2
2456: ,p_time_stamp => null
2457: ,x_return_status => x_return_status

Line 2526: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (

2522: /*1. Lock the Dimension Set */
2523:
2524: SAVEPOINT BSCLockAsgnDimSetPVT;
2525:
2526: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET (
2527: p_Kpi_Id => p_Kpi_Id
2528: ,p_Dim_Set_Id => p_Dim_Set_Id
2529: ,p_time_stamp => null
2530: ,x_return_status => x_return_status

Line 2536: BSC_BIS_LOCKS_PUB.LOCK_KPI(

2532: ,x_msg_data => x_msg_data
2533: );
2534: /*2. Lock the KPI */
2535:
2536: BSC_BIS_LOCKS_PUB.LOCK_KPI(
2537: p_Kpi_Id => p_Kpi_Id
2538: ,p_time_stamp => p_time_stamp
2539: ,p_Full_Lock_Flag => null
2540: ,x_return_status => x_return_status

Line 2585: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

2581: ,x_msg_count OUT NOCOPY NUMBER
2582: ,x_msg_data OUT NOCOPY VARCHAR2
2583: )IS
2584: l_last_update_date VARCHAR2(50);
2585: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
2586: l_sql varchar2(300);
2587: l_temp VARCHAR2(300);
2588:
2589: BEGIN

Line 2700: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

2696: ,x_msg_count OUT NOCOPY NUMBER
2697: ,x_msg_data OUT NOCOPY VARCHAR2
2698: )IS
2699: l_last_update_date VARCHAR2(50);
2700: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
2701: l_sql VARCHAR2(300);
2702: l_temp VARCHAR2(300);
2703: BEGIN
2704:

Line 2786: l_Cursor BSC_BIS_LOCKS_PUB.t_CURSOR;

2782:
2783: l_Object_Id NUMBER;
2784: l_Last_Update_Date DATE;
2785: l_Sql VARCHAR2(1024);
2786: l_Cursor BSC_BIS_LOCKS_PUB.t_CURSOR;
2787: l_Meaning BSC_LOOKUPS.MEANING%TYPE;
2788:
2789: BEGIN
2790: SAVEPOINT LockCalendarPVT;

Line 2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN

2809: RAISE FND_API.G_EXC_ERROR;
2810: END IF;
2811:
2812: IF NOT p_Time_Stamp IS NULL THEN
2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');
2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2816: FND_MSG_PUB.ADD;
2817: x_Return_Status := FND_API.G_RET_STS_ERROR;

Line 2907: l_Cursor BSC_BIS_LOCKS_PUB.t_CURSOR;

2903: ) IS
2904: l_Object_Id NUMBER;
2905: l_Last_Update_Date DATE;
2906: l_Sql VARCHAR2(1024);
2907: l_Cursor BSC_BIS_LOCKS_PUB.t_CURSOR;
2908: l_Meaning BSC_LOOKUPS.MEANING%TYPE;
2909:
2910: BEGIN
2911: SAVEPOINT LockPeriodicityPVT;

Line 2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN

2930: RAISE FND_API.G_EXC_ERROR;
2931: END IF;
2932:
2933: IF NOT p_Time_Stamp IS NULL THEN
2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');
2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
2937: FND_MSG_PUB.ADD;
2938: x_Return_Status := FND_API.G_RET_STS_ERROR;