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_PUB

Line 1: PACKAGE BODY BSC_BIS_LOCKS_PUB as

1: PACKAGE BODY BSC_BIS_LOCKS_PUB as
2: /* $Header: BSCPLOCB.pls 120.5 2006/04/20 07:26:37 visuri noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_BIS_LOCKS_PUB';
5: g_db_object varchar2(30) := null;

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_BIS_LOCKS_PUB';

1: PACKAGE BODY BSC_BIS_LOCKS_PUB as
2: /* $Header: BSCPLOCB.pls 120.5 2006/04/20 07:26:37 visuri noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_BIS_LOCKS_PUB';
5: g_db_object varchar2(30) := null;
6: /*------------------------------------------------------------------------------------------
7: Getting Time Stamp for Dataset
8: -------------------------------------------------------------------------------------------*/

Line 46: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET (

42:
43: SAVEPOINT BSCSetTimeDataSetPUB;
44:
45: /* change time stamp for current dataset */
46: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET (
47: p_dataset_id
48: ,sysdate
49: ,x_return_status
50: ,x_msg_count

Line 85: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

81: ,x_return_status OUT NOCOPY varchar2
82: ,x_msg_count OUT NOCOPY number
83: ,x_msg_data OUT NOCOPY varchar2
84: ) is
85: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
86: l_sql varchar2(3000);
87: l_operation varchar2(20);
88: l_measure_id1 number;
89: l_measure_id2 number;

Line 183: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE (

179:
180: SAVEPOINT BSCSetTimeDataSrcPUB;
181:
182:
183: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE (
184: p_measure_id
185: ,sysdate
186: ,x_return_status
187: ,x_msg_count

Line 259: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;

255: ,x_return_status OUT NOCOPY varchar2
256: ,x_msg_count OUT NOCOPY number
257: ,x_msg_data OUT NOCOPY varchar2
258: ) is
259: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
260: l_sql varchar2(3000);
261: l_measure_id1 number;
262: l_measure_id2 number;
263: l_temp_id1 number;

Line 339: BSC_BIS_LOCKS_PUB.LOCK_KPI(

335: fetch l_cursor into l_kpi_id;
336: EXIT WHEN l_cursor%NOTFOUND;
337: if l_dataset_id <> p_dataset_id then
338: --dbms_output.put_line(' l_kpi_id = '|| l_kpi_id);
339: BSC_BIS_LOCKS_PUB.LOCK_KPI(
340: p_Kpi_Id => l_kpi_id
341: ,p_time_stamp => null
342: ,p_Full_Lock_Flag => null
343: ,x_return_status => x_return_status

Line 561: BSC_BIS_LOCKS_PUB.LOCK_KPI(

557:
558:
559: SAVEPOINT BSCLockAsgnMeasurePUB;
560: /* Lock the KPI */
561: BSC_BIS_LOCKS_PUB.LOCK_KPI(
562: p_Kpi_Id => p_Kpi_Id
563: ,p_time_stamp => p_time_stamp
564: ,p_Full_Lock_Flag => null
565: ,x_return_status => x_return_status

Line 1695: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';

1691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF (x_msg_data IS NOT NULL) THEN
1695: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';
1696: ELSE
1697: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';
1698: END IF;
1699: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1697: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';

1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF (x_msg_data IS NOT NULL) THEN
1695: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';
1696: ELSE
1697: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';
1698: END IF;
1699: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1700:
1701: END Lock_Designer_Session_AT;

Line 1795: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

1791: WHEN NO_DATA_FOUND THEN
1792: ROLLBACK TO LockUpdateCalendarPUB;
1793: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF (x_msg_data IS NOT NULL) THEN
1795: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1796: ELSE
1797: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1798: END IF;
1799: WHEN OTHERS THEN

Line 1797: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

1793: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF (x_msg_data IS NOT NULL) THEN
1795: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1796: ELSE
1797: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1798: END IF;
1799: WHEN OTHERS THEN
1800: ROLLBACK TO LockUpdateCalendarPUB;
1801: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1803: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

1799: WHEN OTHERS THEN
1800: ROLLBACK TO LockUpdateCalendarPUB;
1801: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: IF (x_msg_data IS NOT NULL) THEN
1803: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1804: ELSE
1805: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1806: END IF;
1807: END Lock_Calendar_And_Periods;

Line 1805: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

1801: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: IF (x_msg_data IS NOT NULL) THEN
1803: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1804: ELSE
1805: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1806: END IF;
1807: END Lock_Calendar_And_Periods;
1808:
1809:

Line 1859: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';

1855: WHEN NO_DATA_FOUND THEN
1856: ROLLBACK TO LockCalendarPUB;
1857: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF (x_msg_data IS NOT NULL) THEN
1859: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1860: ELSE
1861: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1862: END IF;
1863: WHEN OTHERS THEN

Line 1861: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';

1857: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF (x_msg_data IS NOT NULL) THEN
1859: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1860: ELSE
1861: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1862: END IF;
1863: WHEN OTHERS THEN
1864: ROLLBACK TO LockCalendarPUB;
1865: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1867: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';

1863: WHEN OTHERS THEN
1864: ROLLBACK TO LockCalendarPUB;
1865: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: IF (x_msg_data IS NOT NULL) THEN
1867: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1868: ELSE
1869: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1870: END IF;
1871: END Lock_Calendar;

Line 1869: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';

1865: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: IF (x_msg_data IS NOT NULL) THEN
1867: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1868: ELSE
1869: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1870: END IF;
1871: END Lock_Calendar;
1872:
1873:

Line 1922: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';

1918: WHEN NO_DATA_FOUND THEN
1919: ROLLBACK TO LockPeriodicityPUB;
1920: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF (x_msg_data IS NOT NULL) THEN
1922: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1923: ELSE
1924: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1925: END IF;
1926: WHEN OTHERS THEN

Line 1924: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';

1920: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF (x_msg_data IS NOT NULL) THEN
1922: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1923: ELSE
1924: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1925: END IF;
1926: WHEN OTHERS THEN
1927: ROLLBACK TO LockPeriodicityPUB;
1928: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1930: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';

1926: WHEN OTHERS THEN
1927: ROLLBACK TO LockPeriodicityPUB;
1928: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: IF (x_msg_data IS NOT NULL) THEN
1930: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1931: ELSE
1932: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1933: END IF;
1934: END Lock_Periodicity;

Line 1932: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';

1928: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: IF (x_msg_data IS NOT NULL) THEN
1930: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1931: ELSE
1932: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1933: END IF;
1934: END Lock_Periodicity;
1935:
1936: End BSC_BIS_LOCKS_PUB;

Line 1936: End BSC_BIS_LOCKS_PUB;

1932: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1933: END IF;
1934: END Lock_Periodicity;
1935:
1936: End BSC_BIS_LOCKS_PUB;