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_LOCKS_PVT

Line 1: PACKAGE BODY BSC_LOCKS_PVT AS

1: PACKAGE BODY BSC_LOCKS_PVT AS
2: /*$Header: BSCVLOKB.pls 120.8 2005/12/07 18:27:12 calaw noship $ */
3:
4: /*------------------------------------------------------------------------------------------
5: Procedure VALIDATE_OBJECT

Line 256: BSC_LOCKS_PVT.LOCK_OBJECT_READ

252: l_last_save_time := NULL;
253:
254: IF (p_lock_type = 'R') THEN
255: l_last_save_time :=
256: BSC_LOCKS_PVT.LOCK_OBJECT_READ
257: (
258: p_object_key => p_object_key
259: ,p_object_type => p_object_type
260: ,p_program_id => p_program_id

Line 270: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE

266: ,x_msg_data => x_msg_data
267: );
268: ELSE
269: l_last_save_time :=
270: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE
271: (
272: p_object_key => p_object_key
273: ,p_object_type => p_object_type
274: ,p_program_id => p_program_id

Line 290: BSC_LOCKS_PVT.RAISE_EXCEPTION

286: OPEN c_get_session_id(p_object_key, p_object_type);
287: FETCH c_get_session_id INTO l_last_session_id;
288: CLOSE c_get_session_id;
289: IF (l_last_session_id IS NOT NULL AND l_last_session_id <> l_session_id) THEN
290: BSC_LOCKS_PVT.RAISE_EXCEPTION
291: (
292: p_object_key => p_object_key
293: ,p_object_type => p_object_type
294: ,p_exception_type => 'M'

Line 397: BSC_LOCKS_PVT.LOCK_OBJECT

393:
394: -- Lock the top level object
395: FOR cobj IN c_get_object(p_object_type) LOOP
396: l_last_save_time :=
397: BSC_LOCKS_PVT.LOCK_OBJECT
398: (
399: p_object_key => cobj.OBJECT_KEY
400: ,p_object_type => p_object_type
401: ,p_lock_type => p_lock_type

Line 415: BSC_LOCKS_PVT.LOCK_OBJECT

411: END LOOP;
412:
413: -- Lock the ALL entry
414: l_last_save_time :=
415: BSC_LOCKS_PVT.LOCK_OBJECT
416: (
417: p_object_key => 'ALL'
418: ,p_object_type => p_object_type
419: ,p_lock_type => p_lock_type

Line 433: BSC_LOCKS_PVT.LOCK_OBJECT

429:
430: -- Lock the child objects
431: IF (p_cascade_lock_level <> 0) THEN
432: IF (UPPER(p_object_type) = 'SCORECARD') THEN
433: BSC_LOCKS_PVT.LOCK_OBJECT
434: (
435: p_object_type => 'OBJECTIVE'
436: ,p_lock_type => p_lock_type
437: ,p_query_time => p_query_time

Line 447: BSC_LOCKS_PVT.LOCK_OBJECT

443: ,x_return_status => x_return_status
444: ,x_msg_count => x_msg_count
445: ,x_msg_data => x_msg_data
446: );
447: BSC_LOCKS_PVT.LOCK_OBJECT
448: (
449: p_object_type => 'CUSTOM_VIEW'
450: ,p_lock_type => p_lock_type
451: ,p_query_time => p_query_time

Line 462: BSC_LOCKS_PVT.LOCK_OBJECT

458: ,x_msg_count => x_msg_count
459: ,x_msg_data => x_msg_data
460: );
461: IF (p_cascade_lock_level > 1) THEN
462: BSC_LOCKS_PVT.LOCK_OBJECT
463: (
464: p_object_type => 'LAUNCHPAD'
465: ,p_lock_type => p_lock_type
466: ,p_query_time => p_query_time

Line 480: BSC_LOCKS_PVT.LOCK_OBJECT

476: END IF;
477:
478: -- No cascade lock for generate database configuration
479: ELSIF (UPPER(p_object_type) = 'OBJECTIVE' AND p_program_id <> -203) THEN
480: BSC_LOCKS_PVT.LOCK_OBJECT
481: (
482: p_object_type => 'DIMENSION'
483: ,p_lock_type => p_lock_type
484: ,p_query_time => p_query_time

Line 494: BSC_LOCKS_PVT.LOCK_OBJECT

490: ,x_return_status => x_return_status
491: ,x_msg_count => x_msg_count
492: ,x_msg_data => x_msg_data
493: );
494: BSC_LOCKS_PVT.LOCK_OBJECT
495: (
496: p_object_type => 'MEASURE'
497: ,p_lock_type => p_lock_type
498: ,p_query_time => p_query_time

Line 510: BSC_LOCKS_PVT.LOCK_OBJECT

506: ,x_msg_data => x_msg_data
507: );
508:
509: ELSIF (UPPER(p_object_type) = 'DIMENSION') THEN
510: BSC_LOCKS_PVT.LOCK_OBJECT
511: (
512: p_object_type => 'DIMENSION_OBJECT'
513: ,p_lock_type => p_lock_type
514: ,p_query_time => p_query_time

Line 526: BSC_LOCKS_PVT.LOCK_OBJECT

522: ,x_msg_data => x_msg_data
523: );
524:
525: ELSIF (UPPER(p_object_type) = 'MEASURE') THEN
526: BSC_LOCKS_PVT.LOCK_OBJECT
527: (
528: p_object_type => 'DATA_COLUMN'
529: ,p_lock_type => p_lock_type
530: ,p_query_time => p_query_time

Line 543: BSC_LOCKS_PVT.LOCK_OBJECT

539: );
540:
541: -- Custom View: only lock 1 level down
542: ELSIF (UPPER(p_object_type) = 'CUSTOM_VIEW') THEN
543: BSC_LOCKS_PVT.LOCK_OBJECT
544: (
545: p_object_type => 'LAUNCHPAD'
546: ,p_lock_type => p_lock_type
547: ,p_query_time => p_query_time

Line 557: BSC_LOCKS_PVT.LOCK_OBJECT

553: ,x_return_status => x_return_status
554: ,x_msg_count => x_msg_count
555: ,x_msg_data => x_msg_data
556: );
557: BSC_LOCKS_PVT.LOCK_OBJECT
558: (
559: p_object_type => 'OBJECTIVE'
560: ,p_lock_type => p_lock_type
561: ,p_query_time => p_query_time

Line 571: BSC_LOCKS_PVT.LOCK_OBJECT

567: ,x_return_status => x_return_status
568: ,x_msg_count => x_msg_count
569: ,x_msg_data => x_msg_data
570: );
571: BSC_LOCKS_PVT.LOCK_OBJECT
572: (
573: p_object_type => 'MEASURE'
574: ,p_lock_type => p_lock_type
575: ,p_query_time => p_query_time

Line 689: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE

685: l_insert_flag := TRUE;
686:
687: -- Lock the object
688: l_last_save_time :=
689: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE
690: (
691: p_object_key => p_object_key
692: ,p_object_type => p_object_type
693: ,x_insert_flag => l_insert_flag

Line 716: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS

712: FETCH c_locate_lock INTO l_last_save_time;
713: CLOSE c_locate_lock;
714:
715: -- Insert new lock entry
716: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS
717: (
718: p_object_key => p_object_key
719: ,p_object_type => p_object_type
720: ,p_lock_type => 'W'

Line 731: BSC_LOCKS_PVT.RAISE_EXCEPTION

727: ROLLBACK TO BSCLocksPvtLockObjectWrite;
728: EXCEPTION
729: WHEN OTHERS THEN
730: ROLLBACK TO BSCLocksPvtLockObjectWrite;
731: BSC_LOCKS_PVT.RAISE_EXCEPTION
732: (
733: p_object_key => l_object_key
734: ,p_object_type => l_object_type
735: ,p_exception_type => 'L'

Line 743: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE

739: );
740: END;
741:
742: l_last_save_time :=
743: BSC_LOCKS_PVT.LOCK_OBJECT_WRITE
744: (
745: p_object_key => p_object_key
746: ,p_object_type => p_object_type
747: ,p_program_id => p_program_id

Line 758: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS

754: );
755:
756: -- Update the user info
757: ELSE
758: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS
759: (
760: p_object_key => p_object_key
761: ,p_object_type => p_object_type
762: ,p_user_type => 'L'

Line 893: BSC_LOCKS_PVT.RAISE_EXCEPTION

889: CLOSE c_locate_lock;
890: END LOOP;
891: EXCEPTION
892: WHEN OTHERS THEN
893: BSC_LOCKS_PVT.RAISE_EXCEPTION
894: (
895: p_object_key => p_object_key
896: ,p_object_type => p_object_type
897: ,p_exception_type => l_user_type

Line 1071: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS

1067: FETCH c_locate_lock INTO l_last_save_time;
1068: CLOSE c_locate_lock;
1069:
1070: -- Insert write lock entry
1071: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS
1072: (
1073: p_object_key => p_object_key
1074: ,p_object_type => p_object_type
1075: ,p_lock_type => 'W'

Line 1085: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS

1081: );
1082: END IF;
1083:
1084: -- Insert read lock entry
1085: BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS
1086: (
1087: p_object_key => p_object_key
1088: ,p_object_type => p_object_type
1089: ,p_lock_type => 'R'||TO_CHAR(l_count)

Line 1100: BSC_LOCKS_PVT.RAISE_EXCEPTION

1096: ROLLBACK TO BSCLocksPvtLockObjectRead;
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: ROLLBACK TO BSCLocksPvtLockObjectRead;
1100: BSC_LOCKS_PVT.RAISE_EXCEPTION
1101: (
1102: p_object_key => l_object_key
1103: ,p_object_type => l_object_type
1104: ,p_exception_type => 'L'

Line 1118: BSC_LOCKS_PVT.RAISE_EXCEPTION

1114: FETCH c_locate_lock INTO l_last_save_time;
1115: CLOSE c_locate_lock;
1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: BSC_LOCKS_PVT.RAISE_EXCEPTION
1119: (
1120: p_object_key => p_object_key
1121: ,p_object_type => p_object_type
1122: ,p_exception_type => 'L'||TO_CHAR(l_count)

Line 1131: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS

1127: END;
1128: END IF;
1129:
1130: -- Update the user info
1131: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS
1132: (
1133: p_object_key => p_object_key
1134: ,p_object_type => p_object_type
1135: ,p_user_type => 'L'||TO_CHAR(l_count)

Line 1250: BSC_LOCKS_PVT.RAISE_EXCEPTION

1246: FETCH c_locate_lock INTO l_last_save_time;
1247: CLOSE c_locate_lock;
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: BSC_LOCKS_PVT.RAISE_EXCEPTION
1251: (
1252: p_object_key => l_object_key
1253: ,p_object_type => l_object_type
1254: ,p_exception_type => l_user_type

Line 1265: BSC_LOCKS_PVT.LOCK_OBJECT_ALL

1261: END;
1262:
1263: -- Couldn't find the entry being locked, try again
1264: IF (l_exception_flag) THEN
1265: BSC_LOCKS_PVT.LOCK_OBJECT_ALL
1266: (
1267: x_return_status => x_return_status
1268: ,x_msg_count => x_msg_count
1269: ,x_msg_data => x_msg_data

Line 1374: BSC_LOCKS_PVT.RAISE_EXCEPTION

1370: --l_insert_flag := (c_lock_user%NOTFOUND);
1371: CLOSE c_lock_user;
1372: EXCEPTION
1373: WHEN OTHERS THEN
1374: BSC_LOCKS_PVT.RAISE_EXCEPTION
1375: (
1376: p_object_key => p_object_key
1377: ,p_object_type => p_object_type
1378: ,p_exception_type => 'L'

Line 1388: -- BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS

1384:
1385: -- Commended out because of compatibility issues with "ALL" entries
1386: --IF (l_insert_Flag) THEN
1387: -- BEGIN
1388: -- BSC_LOCKS_PVT.INSERT_LOCK_INFO_AUTONOMOUS
1389: -- (
1390: -- p_object_key => p_object_key
1391: -- ,p_object_type => p_object_type
1392: -- ,p_lock_type => 'W'

Line 1403: -- BSC_LOCKS_PVT.INSERT_USER_INFO_AUTONOMOUS

1399: -- EXCEPTION
1400: -- WHEN OTHERS THEN
1401: -- NULL;
1402: -- END;
1403: -- BSC_LOCKS_PVT.INSERT_USER_INFO_AUTONOMOUS
1404: -- (
1405: -- p_object_key => p_object_key
1406: -- ,p_object_type => p_object_type
1407: -- ,p_user_type => p_user_type

Line 1416: -- BSC_LOCKS_PVT.LOCK_USER

1412: -- ,x_return_status => x_return_status
1413: -- ,x_msg_count => x_msg_count
1414: -- ,x_msg_data => x_msg_data
1415: -- );
1416: -- BSC_LOCKS_PVT.LOCK_USER
1417: -- (
1418: -- p_object_key => p_object_key
1419: -- ,p_object_type => p_object_type
1420: -- ,p_user_type => p_user_type

Line 1652: BSC_LOCKS_PVT.GET_CHILD_OBJECTS

1648: IF (l_cascade_lock_level > 0) THEN
1649: l_cascade_lock_level := l_cascade_lock_level - 1;
1650: END IF;
1651: FOR i IN (l_initial_count+1)..x_child_object_count LOOP
1652: BSC_LOCKS_PVT.GET_CHILD_OBJECTS
1653: (
1654: p_object_key => x_child_object_keys(i)
1655: ,p_object_type => x_child_object_types(i)
1656: ,p_cascade_lock_level => l_cascade_lock_level

Line 1744: BSC_LOCKS_PVT.INSERT_LOCK_INFO

1740: BEGIN
1741: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_ALL: '||p_object_type);
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;
1743:
1744: BSC_LOCKS_PVT.INSERT_LOCK_INFO
1745: (
1746: p_object_key => 'ALL'
1747: ,p_object_type => p_object_type
1748: ,p_lock_type => 'W'

Line 1755: BSC_LOCKS_PVT.INSERT_USER_INFO

1751: ,x_return_status => x_return_status
1752: ,x_msg_count => x_msg_count
1753: ,x_msg_data => x_msg_data
1754: );
1755: BSC_LOCKS_PVT.INSERT_USER_INFO
1756: (
1757: p_object_key => 'ALL'
1758: ,p_object_type => p_object_type
1759: ,p_user_type => 'L'

Line 1768: BSC_LOCKS_PVT.INSERT_USER_INFO

1764: ,x_return_status => x_return_status
1765: ,x_msg_count => x_msg_count
1766: ,x_msg_data => x_msg_data
1767: );
1768: BSC_LOCKS_PVT.INSERT_USER_INFO
1769: (
1770: p_object_key => 'ALL'
1771: ,p_object_type => p_object_type
1772: ,p_user_type => 'M'

Line 1859: BSC_LOCKS_PVT.INSERT_LOCK_ALL

1855: BEGIN
1856: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_ALL_AUTONOMOUS: '||p_object_type);
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858:
1859: BSC_LOCKS_PVT.INSERT_LOCK_ALL
1860: (
1861: p_object_type => p_object_type
1862: ,p_program_id => p_program_id
1863: ,p_user_id => p_user_id

Line 1949: BSC_LOCKS_PVT.INSERT_LOCK_ALL

1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946: l_object_type := 'SCORECARD';
1947:
1948: -- Insert the ALL entries
1949: BSC_LOCKS_PVT.INSERT_LOCK_ALL
1950: (
1951: p_object_type => l_object_type
1952: ,p_program_id => p_program_id
1953: ,p_user_id => p_user_id

Line 2113: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2109: x_return_status := FND_API.G_RET_STS_SUCCESS;
2110: l_object_type := 'OBJECTIVE';
2111:
2112: -- Insert the ALL entries
2113: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2114: (
2115: p_object_type => l_object_type
2116: ,p_program_id => p_program_id
2117: ,p_user_id => p_user_id

Line 2277: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274: l_object_type := 'DIMENSION';
2275:
2276: -- Insert the ALL entries
2277: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2278: (
2279: p_object_type => l_object_type
2280: ,p_program_id => p_program_id
2281: ,p_user_id => p_user_id

Line 2441: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2437: x_return_status := FND_API.G_RET_STS_SUCCESS;
2438: l_object_type := 'DIMENSION_OBJECT';
2439:
2440: -- Insert the ALL entries
2441: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2442: (
2443: p_object_type => l_object_type
2444: ,p_program_id => p_program_id
2445: ,p_user_id => p_user_id

Line 2605: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2601: x_return_status := FND_API.G_RET_STS_SUCCESS;
2602: l_object_type := 'MEASURE';
2603:
2604: -- Insert the ALL entries
2605: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2606: (
2607: p_object_type => l_object_type
2608: ,p_program_id => p_program_id
2609: ,p_user_id => p_user_id

Line 2769: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2765: x_return_status := FND_API.G_RET_STS_SUCCESS;
2766: l_object_type := 'DATA_COLUMN';
2767:
2768: -- Insert the ALL entries
2769: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2770: (
2771: p_object_type => l_object_type
2772: ,p_program_id => p_program_id
2773: ,p_user_id => p_user_id

Line 2933: BSC_LOCKS_PVT.INSERT_LOCK_ALL

2929: x_return_status := FND_API.G_RET_STS_SUCCESS;
2930: l_object_type := 'CUSTOM_VIEW';
2931:
2932: -- Insert the ALL entries
2933: BSC_LOCKS_PVT.INSERT_LOCK_ALL
2934: (
2935: p_object_type => l_object_type
2936: ,p_program_id => p_program_id
2937: ,p_user_id => p_user_id

Line 3097: BSC_LOCKS_PVT.INSERT_LOCK_ALL

3093: x_return_status := FND_API.G_RET_STS_SUCCESS;
3094: l_object_type := 'LAUNCHPAD';
3095:
3096: -- Insert the ALL entries
3097: BSC_LOCKS_PVT.INSERT_LOCK_ALL
3098: (
3099: p_object_type => l_object_type
3100: ,p_program_id => p_program_id
3101: ,p_user_id => p_user_id

Line 3264: BSC_LOCKS_PVT.INSERT_LOCK_ALL

3260: x_return_status := FND_API.G_RET_STS_SUCCESS;
3261: l_object_type := 'PERIODICITY';
3262:
3263: -- Insert the ALL entries
3264: BSC_LOCKS_PVT.INSERT_LOCK_ALL
3265: (
3266: p_object_type => l_object_type
3267: ,p_program_id => p_program_id
3268: ,p_user_id => p_user_id

Line 3428: BSC_LOCKS_PVT.INSERT_LOCK_ALL

3424: x_return_status := FND_API.G_RET_STS_SUCCESS;
3425: l_object_type := 'CALENDAR';
3426:
3427: -- Insert the ALL entries
3428: BSC_LOCKS_PVT.INSERT_LOCK_ALL
3429: (
3430: p_object_type => l_object_type
3431: ,p_program_id => p_program_id
3432: ,p_user_id => p_user_id

Line 3592: BSC_LOCKS_PVT.INSERT_LOCK_ALL

3588: x_return_status := FND_API.G_RET_STS_SUCCESS;
3589: l_object_type := 'TABLE';
3590:
3591: -- Insert the ALL entries
3592: BSC_LOCKS_PVT.INSERT_LOCK_ALL
3593: (
3594: p_object_type => l_object_type
3595: ,p_program_id => p_program_id
3596: ,p_user_id => p_user_id

Line 3840: BSC_LOCKS_PVT.INSERT_LOCK_INFO

3836: BEGIN
3837: --DBMS_OUTPUT.PUT_LINE('INSERT_LOCK_INFO_AUTONOMOUS');
3838: x_return_status := FND_API.G_RET_STS_SUCCESS;
3839:
3840: BSC_LOCKS_PVT.INSERT_LOCK_INFO
3841: (
3842: p_object_key => p_object_key
3843: ,p_object_type => p_object_type
3844: ,p_lock_type => p_lock_type

Line 3944: BSC_LOCKS_PVT.INSERT_LOCK_INFO

3940: AND OBJECT_KEY = p_object_key
3941: AND LOCK_TYPE = p_lock_type;
3942:
3943: IF (SQL%NOTFOUND) THEN
3944: BSC_LOCKS_PVT.INSERT_LOCK_INFO
3945: (
3946: p_object_key => p_object_key
3947: ,p_object_type => p_object_type
3948: ,p_lock_type => p_lock_type

Line 4025: BSC_LOCKS_PVT.UPDATE_LOCK_INFO

4021: BEGIN
4022: --DBMS_OUTPUT.PUT_LINE('UPDATE_LOCK_INFO_AUTONOMOUS');
4023: x_return_status := FND_API.G_RET_STS_SUCCESS;
4024:
4025: BSC_LOCKS_PVT.UPDATE_LOCK_INFO
4026: (
4027: p_object_key => p_object_key
4028: ,p_object_type => p_object_type
4029: ,p_lock_type => p_lock_type

Line 4232: BSC_LOCKS_PVT.INSERT_USER_INFO

4228: BEGIN
4229: --DBMS_OUTPUT.PUT_LINE('INSERT_USER_INFO_AUTONOMOUS');
4230: x_return_status := FND_API.G_RET_STS_SUCCESS;
4231:
4232: BSC_LOCKS_PVT.INSERT_USER_INFO
4233: (
4234: p_object_key => p_object_key
4235: ,p_object_type => p_object_type
4236: ,p_user_type => p_user_type

Line 4357: BSC_LOCKS_PVT.INSERT_USER_INFO_AUTONOMOUS

4353: AND OBJECT_KEY = p_object_key
4354: AND USER_TYPE = p_user_type;
4355:
4356: IF (SQL%NOTFOUND) THEN
4357: BSC_LOCKS_PVT.INSERT_USER_INFO_AUTONOMOUS
4358: (
4359: p_object_key => p_object_key
4360: ,p_object_type => p_object_type
4361: ,p_user_type => p_user_type

Line 4370: BSC_LOCKS_PVT.LOCK_USER

4366: ,x_return_status => x_return_status
4367: ,x_msg_count => x_msg_count
4368: ,x_msg_data => x_msg_data
4369: );
4370: BSC_LOCKS_PVT.LOCK_USER
4371: (
4372: p_object_key => p_object_key
4373: ,p_object_type => p_object_type
4374: ,p_user_type => p_user_type

Line 4482: BSC_LOCKS_PVT.UPDATE_USER_INFO

4478: BEGIN
4479: --DBMS_OUTPUT.PUT_LINE('UPDATE_USER_INFO_AUTONOMOUS');
4480: x_return_status := FND_API.G_RET_STS_SUCCESS;
4481:
4482: BSC_LOCKS_PVT.UPDATE_USER_INFO
4483: (
4484: p_object_key => p_object_key
4485: ,p_object_type => p_object_type
4486: ,p_user_type => p_user_type

Line 4581: BSC_LOCKS_PVT.LOCK_USER

4577: --DBMS_OUTPUT.PUT_LINE('DELETE_LOCK_INFO');
4578: x_return_status := FND_API.G_RET_STS_SUCCESS;
4579:
4580: -- Lock the user entry of the object
4581: BSC_LOCKS_PVT.LOCK_USER
4582: (
4583: p_object_key => p_object_key
4584: ,p_object_type => p_object_type
4585: ,p_user_type => 'M'

Line 4597: BSC_LOCKS_PVT.LOCK_OBJECT

4593: );
4594:
4595: -- Lock the object
4596: l_last_save_time :=
4597: BSC_LOCKS_PVT.LOCK_OBJECT
4598: (
4599: p_object_key => p_object_key
4600: ,p_object_type => p_object_type
4601: ,p_lock_type => 'W'

Line 4700: BSC_LOCKS_PVT.DELETE_LOCK_INFO

4696: BEGIN
4697: --DBMS_OUTPUT.PUT_LINE('DELETE_LOCK_INFO_AUTONOMOUS');
4698: x_return_status := FND_API.G_RET_STS_SUCCESS;
4699:
4700: BSC_LOCKS_PVT.DELETE_LOCK_INFO
4701: (
4702: p_object_key => p_object_key
4703: ,p_object_type => p_object_type
4704: ,p_program_id => p_program_id

Line 4976: END BSC_LOCKS_PVT;

4972: WHEN OTHERS THEN
4973: RETURN NULL;
4974: END;
4975:
4976: END BSC_LOCKS_PVT;