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_LOCKS_PVT dependencies on BSC_OBJECT_LOCKS

Line 244: FROM BSC_OBJECT_LOCKS

240: c_object_key VARCHAR2,
241: c_object_type VARCHAR2
242: ) IS
243: SELECT SESSION_ID
244: FROM BSC_OBJECT_LOCKS
245: WHERE OBJECT_KEY = c_object_key
246: AND OBJECT_TYPE = c_object_type
247: AND LOCK_TYPE = 'W';
248:

Line 386: FROM BSC_OBJECT_LOCKS

382: CURSOR c_get_object(
383: c_object_type VARCHAR2
384: ) IS
385: SELECT DISTINCT OBJECT_KEY
386: FROM BSC_OBJECT_LOCKS
387: WHERE OBJECT_TYPE = c_object_type;
388:
389: BEGIN
390: --DBMS_OUTPUT.PUT_LINE('LOCK_OBJECT: '||p_object_type);

Line 663: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;

659: ,x_msg_data OUT NOCOPY varchar2
660: ) RETURN DATE IS
661:
662: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_WRITE';
663: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
664: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
665: l_insert_flag BOOLEAN;
666: l_last_save_time DATE;
667: l_session_id NUMBER := USERENV('SESSIONID');

Line 664: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

660: ) RETURN DATE IS
661:
662: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_WRITE';
663: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
664: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
665: l_insert_flag BOOLEAN;
666: l_last_save_time DATE;
667: l_session_id NUMBER := USERENV('SESSIONID');
668:

Line 675: FROM BSC_OBJECT_LOCKS

671: c_object_type VARCHAR2,
672: c_lock_type VARCHAR2
673: ) IS
674: SELECT LAST_SAVE_TIME
675: FROM BSC_OBJECT_LOCKS
676: WHERE OBJECT_KEY = c_object_key
677: AND OBJECT_TYPE = c_object_type
678: AND LOCK_TYPE = c_lock_type
679: FOR UPDATE NOWAIT;

Line 834: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;

830:
831: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_WRITE';
832: l_count NUMBER;
833: l_last_save_time DATE;
834: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
835: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
836:
837: CURSOR c_get_object(
838: c_object_key VARCHAR2,

Line 842: FROM BSC_OBJECT_LOCKS

838: c_object_key VARCHAR2,
839: c_object_type VARCHAR2
840: ) IS
841: SELECT LOCK_TYPE
842: FROM BSC_OBJECT_LOCKS
843: WHERE OBJECT_KEY = c_object_key
844: AND OBJECT_TYPE = c_object_type;
845:
846: CURSOR c_lock_object(

Line 851: FROM BSC_OBJECT_LOCKS

847: c_object_key VARCHAR2,
848: c_object_type VARCHAR2
849: ) IS
850: SELECT LAST_SAVE_TIME
851: FROM BSC_OBJECT_LOCKS
852: WHERE OBJECT_KEY = c_object_key
853: AND OBJECT_TYPE = c_object_type
854: ORDER BY LOCK_TYPE
855: FOR UPDATE NOWAIT;

Line 863: FROM BSC_OBJECT_LOCKS

859: c_object_type VARCHAR2,
860: c_lock_type VARCHAR2
861: ) IS
862: SELECT LAST_SAVE_TIME
863: FROM BSC_OBJECT_LOCKS
864: WHERE OBJECT_KEY = c_object_key
865: AND OBJECT_TYPE = c_object_type
866: AND LOCK_TYPE = c_lock_type
867: FOR UPDATE NOWAIT;

Line 983: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;

979: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_READ';
980: l_count NUMBER;
981: l_insert_flag BOOLEAN;
982: l_last_save_time DATE;
983: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
984: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
985: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
986: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
987: l_session_id NUMBER := USERENV('SESSIONID');

Line 984: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

980: l_count NUMBER;
981: l_insert_flag BOOLEAN;
982: l_last_save_time DATE;
983: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
984: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
985: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
986: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
987: l_session_id NUMBER := USERENV('SESSIONID');
988:

Line 985: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;

981: l_insert_flag BOOLEAN;
982: l_last_save_time DATE;
983: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
984: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
985: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
986: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
987: l_session_id NUMBER := USERENV('SESSIONID');
988:
989: CURSOR c_get_object(

Line 994: FROM BSC_OBJECT_LOCKS

990: c_object_key VARCHAR2,
991: c_object_type VARCHAR2
992: ) IS
993: SELECT OBJECT_KEY, OBJECT_TYPE, LOCK_TYPE
994: FROM BSC_OBJECT_LOCKS
995: WHERE OBJECT_KEY = c_object_key
996: AND OBJECT_TYPE = c_object_type
997: AND LENGTH(LOCK_TYPE) > 1
998: AND SUBSTR(LOCK_TYPE,1,1) = 'R'

Line 1007: FROM BSC_OBJECT_LOCKS

1003: c_object_type VARCHAR2,
1004: c_lock_type VARCHAR2
1005: ) IS
1006: SELECT LAST_SAVE_TIME
1007: FROM BSC_OBJECT_LOCKS
1008: WHERE OBJECT_KEY = c_object_key
1009: AND OBJECT_TYPE = c_object_type
1010: AND LOCK_TYPE = c_lock_type
1011: FOR UPDATE NOWAIT;

Line 1018: FROM BSC_OBJECT_LOCKS

1014: c_object_key VARCHAR2,
1015: c_object_type VARCHAR2
1016: ) IS
1017: SELECT LAST_SAVE_TIME
1018: FROM BSC_OBJECT_LOCKS
1019: WHERE OBJECT_KEY = c_object_key
1020: AND OBJECT_TYPE = c_object_type
1021: AND LOCK_TYPE = 'W';
1022:

Line 1195: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;

1191: ,x_msg_data OUT NOCOPY varchar2
1192: ) IS
1193:
1194: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_ALL';
1195: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
1196: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
1197: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
1198: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
1199: l_last_save_time BSC_OBJECT_LOCKS.LAST_SAVE_TIME%TYPE;

Line 1196: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

1192: ) IS
1193:
1194: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_ALL';
1195: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
1196: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
1197: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
1198: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
1199: l_last_save_time BSC_OBJECT_LOCKS.LAST_SAVE_TIME%TYPE;
1200: l_exception_flag BOOLEAN;

Line 1197: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;

1193:
1194: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_OBJECT_ALL';
1195: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
1196: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
1197: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
1198: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
1199: l_last_save_time BSC_OBJECT_LOCKS.LAST_SAVE_TIME%TYPE;
1200: l_exception_flag BOOLEAN;
1201:

Line 1199: l_last_save_time BSC_OBJECT_LOCKS.LAST_SAVE_TIME%TYPE;

1195: l_object_key BSC_OBJECT_LOCKS.OBJECT_KEY%TYPE;
1196: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
1197: l_lock_type BSC_OBJECT_LOCKS.LOCK_TYPE%TYPE;
1198: l_user_type BSC_OBJECT_LOCK_USERS.USER_TYPE%TYPE;
1199: l_last_save_time BSC_OBJECT_LOCKS.LAST_SAVE_TIME%TYPE;
1200: l_exception_flag BOOLEAN;
1201:
1202: CURSOR c_lock_object IS
1203: SELECT LAST_SAVE_TIME

Line 1204: FROM BSC_OBJECT_LOCKS

1200: l_exception_flag BOOLEAN;
1201:
1202: CURSOR c_lock_object IS
1203: SELECT LAST_SAVE_TIME
1204: FROM BSC_OBJECT_LOCKS
1205: FOR UPDATE NOWAIT;
1206:
1207: CURSOR c_get_object IS
1208: SELECT OBJECT_TYPE, OBJECT_KEY, LOCK_TYPE

Line 1209: FROM BSC_OBJECT_LOCKS;

1205: FOR UPDATE NOWAIT;
1206:
1207: CURSOR c_get_object IS
1208: SELECT OBJECT_TYPE, OBJECT_KEY, LOCK_TYPE
1209: FROM BSC_OBJECT_LOCKS;
1210:
1211: CURSOR c_locate_lock(
1212: c_object_key VARCHAR2,
1213: c_object_type VARCHAR2,

Line 1217: FROM BSC_OBJECT_LOCKS

1213: c_object_type VARCHAR2,
1214: c_lock_type VARCHAR2
1215: ) IS
1216: SELECT LAST_SAVE_TIME
1217: FROM BSC_OBJECT_LOCKS
1218: WHERE OBJECT_KEY = c_object_key
1219: AND OBJECT_TYPE = c_object_type
1220: AND LOCK_TYPE = c_lock_type
1221: FOR UPDATE NOWAIT;

Line 1231: LOCK TABLE BSC_OBJECT_LOCKS IN EXCLUSIVE MODE NOWAIT;

1227:
1228: -- Lock the user entry for the top level object
1229: BEGIN
1230: LOCK TABLE BSC_OBJECT_LOCK_USERS IN EXCLUSIVE MODE NOWAIT;
1231: LOCK TABLE BSC_OBJECT_LOCKS IN EXCLUSIVE MODE NOWAIT;
1232: --FOR clock IN c_lock_object LOOP
1233: -- l_last_save_time := clock.LAST_SAVE_TIME;
1234: --END LOOP;
1235: EXCEPTION

Line 1940: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

1936: ,x_msg_data OUT NOCOPY varchar2
1937: ) IS
1938:
1939: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_SCORECARD';
1940: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
1941: l_session_id NUMBER := USERENV('SESSIONID');
1942:
1943: BEGIN
1944: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_SCORECARD');

Line 1963: INSERT INTO BSC_OBJECT_LOCKS (

1959: ,x_msg_data => x_msg_data
1960: );
1961:
1962: -- Insert Scorecard entries
1963: INSERT INTO BSC_OBJECT_LOCKS (
1964: OBJECT_KEY,
1965: OBJECT_TYPE,
1966: LOCK_TYPE,
1967: LAST_SAVE_TIME,

Line 2104: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2100: ,x_msg_data OUT NOCOPY varchar2
2101: ) IS
2102:
2103: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_OBJECTIVE';
2104: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2105: l_session_id NUMBER := USERENV('SESSIONID');
2106:
2107: BEGIN
2108: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_OBJECTIVE');

Line 2127: INSERT INTO BSC_OBJECT_LOCKS (

2123: ,x_msg_data => x_msg_data
2124: );
2125:
2126: -- Insert Objective entries
2127: INSERT INTO BSC_OBJECT_LOCKS (
2128: OBJECT_KEY,
2129: OBJECT_TYPE,
2130: LOCK_TYPE,
2131: LAST_SAVE_TIME,

Line 2268: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2264: ,x_msg_data OUT NOCOPY varchar2
2265: ) IS
2266:
2267: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_DIMENSION';
2268: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2269: l_session_id NUMBER := USERENV('SESSIONID');
2270:
2271: BEGIN
2272: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DIMENSION');

Line 2291: INSERT INTO BSC_OBJECT_LOCKS (

2287: ,x_msg_data => x_msg_data
2288: );
2289:
2290: -- Insert Dimension entries
2291: INSERT INTO BSC_OBJECT_LOCKS (
2292: OBJECT_KEY,
2293: OBJECT_TYPE,
2294: LOCK_TYPE,
2295: LAST_SAVE_TIME,

Line 2432: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2428: ,x_msg_data OUT NOCOPY varchar2
2429: ) IS
2430:
2431: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_DIMENSION_OBJECT';
2432: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2433: l_session_id NUMBER := USERENV('SESSIONID');
2434:
2435: BEGIN
2436: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DIMENSION_OBJECT');

Line 2455: INSERT INTO BSC_OBJECT_LOCKS (

2451: ,x_msg_data => x_msg_data
2452: );
2453:
2454: -- Insert Dimension Object entries
2455: INSERT INTO BSC_OBJECT_LOCKS (
2456: OBJECT_KEY,
2457: OBJECT_TYPE,
2458: LOCK_TYPE,
2459: LAST_SAVE_TIME,

Line 2596: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2592: ,x_msg_data OUT NOCOPY varchar2
2593: ) IS
2594:
2595: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_MEASURE';
2596: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2597: l_session_id NUMBER := USERENV('SESSIONID');
2598:
2599: BEGIN
2600: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_MEASURE');

Line 2619: INSERT INTO BSC_OBJECT_LOCKS (

2615: ,x_msg_data => x_msg_data
2616: );
2617:
2618: -- Insert Measure entries
2619: INSERT INTO BSC_OBJECT_LOCKS (
2620: OBJECT_KEY,
2621: OBJECT_TYPE,
2622: LOCK_TYPE,
2623: LAST_SAVE_TIME,

Line 2760: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2756: ,x_msg_data OUT NOCOPY varchar2
2757: ) IS
2758:
2759: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_DATA_COLUMN';
2760: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2761: l_session_id NUMBER := USERENV('SESSIONID');
2762:
2763: BEGIN
2764: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_DATA_COLUMN');

Line 2783: INSERT INTO BSC_OBJECT_LOCKS (

2779: ,x_msg_data => x_msg_data
2780: );
2781:
2782: -- Insert Data Column entries
2783: INSERT INTO BSC_OBJECT_LOCKS (
2784: OBJECT_KEY,
2785: OBJECT_TYPE,
2786: LOCK_TYPE,
2787: LAST_SAVE_TIME,

Line 2924: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

2920: ,x_msg_data OUT NOCOPY varchar2
2921: ) IS
2922:
2923: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_CUSTOM_VIEW';
2924: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
2925: l_session_id NUMBER := USERENV('SESSIONID');
2926:
2927: BEGIN
2928: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_CUSTOM_VIEW');

Line 2947: INSERT INTO BSC_OBJECT_LOCKS (

2943: ,x_msg_data => x_msg_data
2944: );
2945:
2946: -- Insert Custom View entries
2947: INSERT INTO BSC_OBJECT_LOCKS (
2948: OBJECT_KEY,
2949: OBJECT_TYPE,
2950: LOCK_TYPE,
2951: LAST_SAVE_TIME,

Line 3088: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

3084: ,x_msg_data OUT NOCOPY varchar2
3085: ) IS
3086:
3087: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_LAUNCHPAD';
3088: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
3089: l_session_id NUMBER := USERENV('SESSIONID');
3090:
3091: BEGIN
3092: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_LAUNCHPAD');

Line 3111: INSERT INTO BSC_OBJECT_LOCKS (

3107: ,x_msg_data => x_msg_data
3108: );
3109:
3110: -- Insert Launchpad entries
3111: INSERT INTO BSC_OBJECT_LOCKS (
3112: OBJECT_KEY,
3113: OBJECT_TYPE,
3114: LOCK_TYPE,
3115: LAST_SAVE_TIME,

Line 3255: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

3251: ,x_msg_data OUT NOCOPY varchar2
3252: ) IS
3253:
3254: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_PERIODICITY';
3255: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
3256: l_session_id NUMBER := USERENV('SESSIONID');
3257:
3258: BEGIN
3259: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_PERIODICITY');

Line 3278: INSERT INTO BSC_OBJECT_LOCKS (

3274: ,x_msg_data => x_msg_data
3275: );
3276:
3277: -- Insert Periodicity entries
3278: INSERT INTO BSC_OBJECT_LOCKS (
3279: OBJECT_KEY,
3280: OBJECT_TYPE,
3281: LOCK_TYPE,
3282: LAST_SAVE_TIME,

Line 3419: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

3415: ,x_msg_data OUT NOCOPY varchar2
3416: ) IS
3417:
3418: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_CALENDAR';
3419: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
3420: l_session_id NUMBER := USERENV('SESSIONID');
3421:
3422: BEGIN
3423: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_CALENDAR');

Line 3442: INSERT INTO BSC_OBJECT_LOCKS (

3438: ,x_msg_data => x_msg_data
3439: );
3440:
3441: -- Insert Calendar entries
3442: INSERT INTO BSC_OBJECT_LOCKS (
3443: OBJECT_KEY,
3444: OBJECT_TYPE,
3445: LOCK_TYPE,
3446: LAST_SAVE_TIME,

Line 3583: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

3579: ,x_msg_data OUT NOCOPY varchar2
3580: ) IS
3581:
3582: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_LOCK_TABLE';
3583: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
3584: l_session_id NUMBER := USERENV('SESSIONID');
3585:
3586: BEGIN
3587: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_TABLE');

Line 3606: INSERT INTO BSC_OBJECT_LOCKS (

3602: ,x_msg_data => x_msg_data
3603: );
3604:
3605: -- Insert Table entries
3606: INSERT INTO BSC_OBJECT_LOCKS (
3607: OBJECT_KEY,
3608: OBJECT_TYPE,
3609: LOCK_TYPE,
3610: LAST_SAVE_TIME,

Line 3749: INSERT INTO BSC_OBJECT_LOCKS (

3745: BEGIN
3746: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_INFO');
3747: x_return_status := FND_API.G_RET_STS_SUCCESS;
3748:
3749: INSERT INTO BSC_OBJECT_LOCKS (
3750: OBJECT_KEY,
3751: OBJECT_TYPE,
3752: LOCK_TYPE,
3753: LAST_SAVE_TIME,

Line 3923: UPDATE BSC_OBJECT_LOCKS

3919: --DBMS_OUTPUT.PUT_LINE('UPDATE_LOCK_INFO');
3920: x_return_status := FND_API.G_RET_STS_SUCCESS;
3921:
3922: IF (p_object_key = 'ALL' AND p_object_type = 'ALL') THEN
3923: UPDATE BSC_OBJECT_LOCKS
3924: SET LAST_SAVE_TIME = p_last_save_time,
3925: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3926: LAST_UPDATE_DATE = SYSDATE,
3927: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

Line 3933: UPDATE BSC_OBJECT_LOCKS

3929: WHERE p_lock_type = 'ALL'
3930: OR LOCK_TYPE = p_lock_type;
3931:
3932: ELSE
3933: UPDATE BSC_OBJECT_LOCKS
3934: SET LAST_SAVE_TIME = p_last_save_time,
3935: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3936: LAST_UPDATE_DATE = SYSDATE,
3937: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID,

Line 4612: DELETE FROM BSC_OBJECT_LOCKS

4608: ,x_msg_count => x_msg_count
4609: ,x_msg_data => x_msg_data
4610: );
4611:
4612: DELETE FROM BSC_OBJECT_LOCKS
4613: WHERE OBJECT_TYPE = p_object_type
4614: AND OBJECT_KEY = p_object_key;
4615:
4616: DELETE FROM BSC_OBJECT_LOCK_USERS