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_PVT

Line 1: PACKAGE BODY BSC_BIS_LOCKS_PVT as

1: PACKAGE BODY BSC_BIS_LOCKS_PVT as
2: /* $Header: BSCVLOCB.pls 120.1 2005/07/12 08:48:34 adrao noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 34: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_BIS_LOCKS_PVT';

30: | 04-JUL-05 Aditya Rao added Calendar and Periodicity Locking APIs |
31: +======================================================================================+
32: */
33:
34: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_BIS_LOCKS_PVT';
35: g_db_object varchar2(30) := null;
36:
37:
38: /*-------------------------------------------------------------------------------------------------------------------

Line 141: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (

137: l_sql varchar2(32000);
138: begin
139: SAVEPOINT BSCSetTimeDataSetPVT;
140:
141: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASET (
142: p_dim_set_id => p_dim_set_id
143: ,p_lud => sysdate
144: ,x_return_status => x_return_status
145: ,x_msg_count => x_msg_count

Line 220: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASOURCE (

216: begin
217:
218: SAVEPOINT BSCSetTimeDataSrcPVT;
219:
220: BSC_BIS_LOCKS_PVT.SET_TIME_STAMP_DATASOURCE (
221: p_measure_id => p_measure_id
222: ,p_lud => sysdate
223: ,x_return_status => x_return_status
224: ,x_msg_count => x_msg_count

Line 366: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(

362: --dbms_output.put_line(' x_measure_id1 = ' || x_measure_id1 );
363: --dbms_output.put_line(' x_measure_id2 = ' || x_measure_id2 );
364: if (l_cursor%found) then
365: if x_measure_id2 is not null then
366: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(
367: x_measure_id1
368: ,null
369: ,l_dataset_name
370: ,x_return_status

Line 376: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(

372: ,x_msg_data
373: ) ;
374: end if;
375: if x_measure_id2 is not null and l_operation is not null then
376: BSC_BIS_LOCKS_PVT.LOCK_DATASOURCE(
377: x_measure_id2
378: ,null
379: ,l_dataset_name
380: ,x_return_status

Line 2863: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';

2859: CLOSE l_Cursor;
2860: END IF;
2861: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2862: IF (x_msg_data IS NOT NULL) THEN
2863: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2864: ELSE
2865: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2866: END IF;
2867: RAISE;

Line 2865: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';

2861: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2862: IF (x_msg_data IS NOT NULL) THEN
2863: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2864: ELSE
2865: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2866: END IF;
2867: RAISE;
2868: WHEN OTHERS THEN
2869: ROLLBACK TO LockCalendarPVT;

Line 2889: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';

2885: );
2886: RAISE FND_API.G_EXC_ERROR;
2887: ELSE
2888: IF (x_msg_data IS NOT NULL) THEN
2889: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2890: ELSE
2891: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2892: END IF;
2893: END IF;

Line 2891: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';

2887: ELSE
2888: IF (x_msg_data IS NOT NULL) THEN
2889: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2890: ELSE
2891: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Calendar ';
2892: END IF;
2893: END IF;
2894: RAISE;
2895: END Lock_Calendar;

Line 2983: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';

2979: CLOSE l_Cursor;
2980: END IF;
2981: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: IF (x_msg_data IS NOT NULL) THEN
2983: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
2984: ELSE
2985: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
2986: END IF;
2987: RAISE;

Line 2985: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';

2981: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2982: IF (x_msg_data IS NOT NULL) THEN
2983: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
2984: ELSE
2985: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
2986: END IF;
2987: RAISE;
2988: WHEN OTHERS THEN
2989: ROLLBACK TO LockPeriodicityPVT;

Line 3012: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';

3008: );
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSE
3011: IF (x_msg_data IS NOT NULL) THEN
3012: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
3013: ELSE
3014: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
3015: END IF;
3016: END IF;

Line 3014: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';

3010: ELSE
3011: IF (x_msg_data IS NOT NULL) THEN
3012: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
3013: ELSE
3014: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PVT.Lock_Periodicity ';
3015: END IF;
3016: END IF;
3017: RAISE;
3018: END Lock_Periodicity;

Line 3056: End BSC_BIS_LOCKS_PVT;

3052: END Get_Periodicity_Name;
3053:
3054:
3055:
3056: End BSC_BIS_LOCKS_PVT;