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_PUB dependencies on BSC_LOCKS_PVT

Line 51: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;

47: ,x_msg_data OUT NOCOPY varchar2
48: ) IS
49:
50: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_SYSTEM_LOCK';
51: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;
52: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;
53: l_child_object_count NUMBER := 0;
54: l_last_save_time DATE;
55: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

Line 52: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;

48: ) IS
49:
50: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_SYSTEM_LOCK';
51: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;
52: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;
53: l_child_object_count NUMBER := 0;
54: l_last_save_time DATE;
55: l_object_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
56: l_lowest_level_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

Line 65: BSC_LOCKS_PVT.Initialize;

61: --DBMS_OUTPUT.PUT_LINE('CHECK_SYSTEM_LOCK: '||p_object_key||' '||p_object_type);
62: SAVEPOINT BSCLocksPubCheckSystemLock;
63: FND_MSG_PUB.Initialize;
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: BSC_LOCKS_PVT.Initialize;
66:
67: -- Get the machine and terminal information
68: BSC_LOCKS_PVT.GET_SESSION
69: (

Line 68: BSC_LOCKS_PVT.GET_SESSION

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: BSC_LOCKS_PVT.Initialize;
66:
67: -- Get the machine and terminal information
68: BSC_LOCKS_PVT.GET_SESSION
69: (
70: x_machine => l_machine
71: ,x_terminal => l_terminal
72: ,x_return_status => x_return_status

Line 78: BSC_LOCKS_PVT.LOCK_USER

74: ,x_msg_data => x_msg_data
75: );
76:
77: -- Check the top level object's lock
78: BSC_LOCKS_PVT.LOCK_USER
79: (
80: p_object_key => p_object_key
81: ,p_object_type => p_object_type
82: ,p_user_type => 'M'

Line 93: BSC_LOCKS_PVT.LOCK_USER

89: ,x_msg_data => x_msg_data
90: );
91:
92: SAVEPOINT BSCLocksPubCheckAll1;
93: BSC_LOCKS_PVT.LOCK_USER
94: (
95: p_object_key => 'ALL'
96: ,p_object_type => 'ALL'
97: ,p_user_type => 'M'

Line 106: BSC_LOCKS_PVT.LOCK_USER

102: ,x_return_status => x_return_status
103: ,x_msg_count => x_msg_count
104: ,x_msg_data => x_msg_data
105: );
106: BSC_LOCKS_PVT.LOCK_USER
107: (
108: p_object_key => 'ALL'
109: ,p_object_type => p_object_type
110: ,p_user_type => 'M'

Line 126: BSC_LOCKS_PVT.GET_CHILD_OBJECTS

122: l_lowest_level_type := NULL;
123: IF (p_program_id = -203 OR p_object_type = 'CUSTOM_VIEW') THEN
124: l_lowest_level_type := 'OBJECTIVE';
125: END IF;
126: BSC_LOCKS_PVT.GET_CHILD_OBJECTS
127: (
128: p_object_key => p_object_key
129: ,p_object_type => p_object_type
130: ,p_cascade_lock_level => p_cascade_lock_level

Line 143: BSC_LOCKS_PVT.LOCK_USER

139:
140: -- Check the child objects' locks
141: l_object_type := p_object_type;
142: FOR i IN 1..l_child_object_count LOOP
143: BSC_LOCKS_PVT.LOCK_USER
144: (
145: p_object_key => l_child_object_keys(i)
146: ,p_object_type => l_child_object_types(i)
147: ,p_user_type => 'M'

Line 159: BSC_LOCKS_PVT.LOCK_USER

155: );
156: IF (l_object_type <> l_child_object_types(i)) THEN
157: l_object_type := l_child_object_types(i);
158: SAVEPOINT BSCLocksPubCheckAll2;
159: BSC_LOCKS_PVT.LOCK_USER
160: (
161: p_object_key => 'ALL'
162: ,p_object_type => l_object_type
163: ,p_user_type => 'M'

Line 262: BSC_LOCKS_PVT.Initialize;

258: --DBMS_OUTPUT.PUT_LINE('CHECK_SYSTEM_LOCKS');
259: SAVEPOINT BSCLocksPubCheckSystemLocks;
260: FND_MSG_PUB.Initialize;
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: BSC_LOCKS_PVT.Initialize;
263:
264: IF (p_object_keys.COUNT <> 0 AND p_object_keys.COUNT = p_object_types.COUNT) THEN
265: FOR i IN p_object_keys.FIRST..p_object_keys.LAST LOOP
266: BSC_LOCKS_PUB.CHECK_SYSTEM_LOCK

Line 445: BSC_LOCKS_PVT.Initialize;

441: --DBMS_OUTPUT.PUT_LINE('SYNCHRONIZE');
442: SAVEPOINT BSCLocksPubSynchronize;
443: FND_MSG_PUB.Initialize;
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445: BSC_LOCKS_PVT.Initialize;
446: l_bsc_schema := BSC_LOCKS_PVT.GET_BSC_SCHEMA;
447:
448: -- Get the machine and terminal information
449: BSC_LOCKS_PVT.GET_SESSION

Line 446: l_bsc_schema := BSC_LOCKS_PVT.GET_BSC_SCHEMA;

442: SAVEPOINT BSCLocksPubSynchronize;
443: FND_MSG_PUB.Initialize;
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445: BSC_LOCKS_PVT.Initialize;
446: l_bsc_schema := BSC_LOCKS_PVT.GET_BSC_SCHEMA;
447:
448: -- Get the machine and terminal information
449: BSC_LOCKS_PVT.GET_SESSION
450: (

Line 449: BSC_LOCKS_PVT.GET_SESSION

445: BSC_LOCKS_PVT.Initialize;
446: l_bsc_schema := BSC_LOCKS_PVT.GET_BSC_SCHEMA;
447:
448: -- Get the machine and terminal information
449: BSC_LOCKS_PVT.GET_SESSION
450: (
451: x_machine => l_machine
452: ,x_terminal => l_terminal
453: ,x_return_status => x_return_status

Line 465: BSC_LOCKS_PVT.DELETE_LOCK_INFO

461: l_object_key := cobj.OBJECT_KEY;
462: --DBMS_OUTPUT.PUT_LINE('Invalid Object: '||l_object_type||' '||l_object_key);
463: BEGIN
464: -- Lock the invalid object
465: BSC_LOCKS_PVT.DELETE_LOCK_INFO
466: (
467: p_object_key => l_object_key
468: ,p_object_type => l_object_type
469: ,p_program_id => p_program_id

Line 485: --BSC_LOCKS_PVT.LOCK_OBJECT_ALL

481: END LOOP;
482:
483: ---- Check the Lock in the lock table
484: --SAVEPOINT BSCLocksPubLockObjectAll;
485: --BSC_LOCKS_PVT.LOCK_OBJECT_ALL
486: --(
487: -- x_return_status => x_return_status
488: -- ,x_msg_count => x_msg_count
489: -- ,x_msg_data => x_msg_data

Line 503: --BSC_LOCKS_PVT.INSERT_LOCK_ALL_AUTONOMOUS

499: -- EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_bsc_schema||'.BSC_OBJECT_LOCK_USERS');
500: --END IF;
501: --
502: ---- Create the entries for "ALL"
503: --BSC_LOCKS_PVT.INSERT_LOCK_ALL_AUTONOMOUS
504: --(
505: -- p_object_type => 'ALL'
506: -- ,p_program_id => p_program_id
507: -- ,p_user_id => p_user_id

Line 517: --BSC_LOCKS_PVT.LOCK_OBJECT_ALL

513: -- ,x_msg_data => x_msg_data
514: --);
515: --
516: ---- Lock the lock table
517: --BSC_LOCKS_PVT.LOCK_OBJECT_ALL
518: --(
519: -- x_return_status => x_return_status
520: -- ,x_msg_count => x_msg_count
521: -- ,x_msg_data => x_msg_data

Line 525: --BSC_LOCKS_PVT.INSERT_LOCK_SCORECARD

521: -- ,x_msg_data => x_msg_data
522: --);
523: --
524: ---- Insert Scorecards
525: --BSC_LOCKS_PVT.INSERT_LOCK_SCORECARD
526: --(
527: -- p_program_id => p_program_id
528: -- ,p_user_id => p_user_id
529: -- ,p_machine => l_machine

Line 537: --BSC_LOCKS_PVT.INSERT_LOCK_OBJECTIVE

533: -- ,x_msg_data => x_msg_data
534: --);
535: --
536: ---- Insert Objectives
537: --BSC_LOCKS_PVT.INSERT_LOCK_OBJECTIVE
538: --(
539: -- p_program_id => p_program_id
540: -- ,p_user_id => p_user_id
541: -- ,p_machine => l_machine

Line 549: --BSC_LOCKS_PVT.INSERT_LOCK_DIMENSION

545: -- ,x_msg_data => x_msg_data
546: --);
547: --
548: ---- Insert Dimensions
549: --BSC_LOCKS_PVT.INSERT_LOCK_DIMENSION
550: --(
551: -- p_program_id => p_program_id
552: -- ,p_user_id => p_user_id
553: -- ,p_machine => l_machine

Line 561: --BSC_LOCKS_PVT.INSERT_LOCK_DIMENSION_OBJECT

557: -- ,x_msg_data => x_msg_data
558: --);
559: --
560: ---- Insert Dimension Objects
561: --BSC_LOCKS_PVT.INSERT_LOCK_DIMENSION_OBJECT
562: --(
563: -- p_program_id => p_program_id
564: -- ,p_user_id => p_user_id
565: -- ,p_machine => l_machine

Line 573: --BSC_LOCKS_PVT.INSERT_LOCK_MEASURE

569: -- ,x_msg_data => x_msg_data
570: --);
571: --
572: ---- Insert Measures
573: --BSC_LOCKS_PVT.INSERT_LOCK_MEASURE
574: --(
575: -- p_program_id => p_program_id
576: -- ,p_user_id => p_user_id
577: -- ,p_machine => l_machine

Line 585: --BSC_LOCKS_PVT.INSERT_LOCK_DATA_COLUMN

581: -- ,x_msg_data => x_msg_data
582: --);
583: --
584: ---- Insert Data Columns
585: --BSC_LOCKS_PVT.INSERT_LOCK_DATA_COLUMN
586: --(
587: -- p_program_id => p_program_id
588: -- ,p_user_id => p_user_id
589: -- ,p_machine => l_machine

Line 597: --BSC_LOCKS_PVT.INSERT_LOCK_CUSTOM_VIEW

593: -- ,x_msg_data => x_msg_data
594: --);
595: --
596: ---- Insert Custom Views
597: --BSC_LOCKS_PVT.INSERT_LOCK_CUSTOM_VIEW
598: --(
599: -- p_program_id => p_program_id
600: -- ,p_user_id => p_user_id
601: -- ,p_machine => l_machine

Line 609: --BSC_LOCKS_PVT.INSERT_LOCK_LAUNCHPAD

605: -- ,x_msg_data => x_msg_data
606: --);
607: --
608: ---- Insert Launchpads
609: --BSC_LOCKS_PVT.INSERT_LOCK_LAUNCHPAD
610: --(
611: -- p_program_id => p_program_id
612: -- ,p_user_id => p_user_id
613: -- ,p_machine => l_machine

Line 621: --BSC_LOCKS_PVT.INSERT_LOCK_PERIODICITY

617: -- ,x_msg_data => x_msg_data
618: --);
619: --
620: ---- Insert Periodicities
621: --BSC_LOCKS_PVT.INSERT_LOCK_PERIODICITY
622: --(
623: -- p_program_id => p_program_id
624: -- ,p_user_id => p_user_id
625: -- ,p_machine => l_machine

Line 633: --BSC_LOCKS_PVT.INSERT_LOCK_CALENDAR

629: -- ,x_msg_data => x_msg_data
630: --);
631: --
632: ---- Insert Calendars
633: --BSC_LOCKS_PVT.INSERT_LOCK_CALENDAR
634: --(
635: -- p_program_id => p_program_id
636: -- ,p_user_id => p_user_id
637: -- ,p_machine => l_machine

Line 645: --BSC_LOCKS_PVT.INSERT_LOCK_TABLE

641: -- ,x_msg_data => x_msg_data
642: --);
643: --
644: ---- Insert Tables
645: --BSC_LOCKS_PVT.INSERT_LOCK_TABLE
646: --(
647: -- p_program_id => p_program_id
648: -- ,p_user_id => p_user_id
649: -- ,p_machine => l_machine

Line 749: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;

745: ,x_msg_data OUT NOCOPY varchar2
746: ) IS
747:
748: l_api_name CONSTANT VARCHAR2(30) := 'GET_SYSTEM_LOCK';
749: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;
750: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;
751: l_child_object_count NUMBER := 0;
752: l_last_save_time DATE;
753: l_lowest_level_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;

Line 750: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;

746: ) IS
747:
748: l_api_name CONSTANT VARCHAR2(30) := 'GET_SYSTEM_LOCK';
749: l_child_object_keys BSC_LOCKS_PVT.t_array_object_key;
750: l_child_object_types BSC_LOCKS_PVT.t_array_object_type;
751: l_child_object_count NUMBER := 0;
752: l_last_save_time DATE;
753: l_lowest_level_type BSC_OBJECT_LOCKS.OBJECT_TYPE%TYPE;
754: l_machine BSC_OBJECT_LOCK_USERS.MACHINE%TYPE;

Line 763: BSC_LOCKS_PVT.Initialize;

759: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK: '||p_object_key||' '||p_object_type||' '||p_lock_type);
760: SAVEPOINT BSCLocksPubGetSystemLock;
761: FND_MSG_PUB.Initialize;
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: BSC_LOCKS_PVT.Initialize;
764:
765: -- Validate the top level object
766: --BSC_LOCKS_PVT.VALIDATE_OBJECT
767: --(

Line 766: --BSC_LOCKS_PVT.VALIDATE_OBJECT

762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: BSC_LOCKS_PVT.Initialize;
764:
765: -- Validate the top level object
766: --BSC_LOCKS_PVT.VALIDATE_OBJECT
767: --(
768: -- p_object_key => p_object_key
769: -- ,p_object_type => p_object_type
770: -- ,x_return_status => x_return_status

Line 776: BSC_LOCKS_PVT.GET_SESSION

772: -- ,x_msg_data => x_msg_data
773: --);
774:
775: -- Get the machine and terminal information
776: BSC_LOCKS_PVT.GET_SESSION
777: (
778: x_machine => l_machine
779: ,x_terminal => l_terminal
780: ,x_return_status => x_return_status

Line 787: BSC_LOCKS_PVT.LOCK_USER

783: );
784:
785: -- Lock the user entry for the top level object
786: IF (p_lock_type <> 'R') THEN
787: BSC_LOCKS_PVT.LOCK_USER
788: (
789: p_object_key => p_object_key
790: ,p_object_type => p_object_type
791: ,p_user_type => 'M'

Line 804: BSC_LOCKS_PVT.LOCK_OBJECT

800: END IF;
801:
802: -- Lock the top level object
803: l_last_save_time :=
804: BSC_LOCKS_PVT.LOCK_OBJECT
805: (
806: p_object_key => p_object_key
807: ,p_object_type => p_object_type
808: ,p_lock_type => p_lock_type

Line 824: BSC_LOCKS_PVT.GET_CHILD_OBJECTS

820: l_lowest_level_type := NULL;
821: IF (p_program_id = -203 OR p_object_type = 'CUSTOM_VIEW') THEN
822: l_lowest_level_type := 'OBJECTIVE';
823: END IF;
824: BSC_LOCKS_PVT.GET_CHILD_OBJECTS
825: (
826: p_object_key => p_object_key
827: ,p_object_type => p_object_type
828: ,p_cascade_lock_level => p_cascade_lock_level

Line 841: BSC_LOCKS_PVT.LOCK_OBJECT

837:
838: -- Lock the child objects
839: FOR i IN 1..l_child_object_count LOOP
840: l_last_save_time :=
841: BSC_LOCKS_PVT.LOCK_OBJECT
842: (
843: p_object_key => l_child_object_keys(i)
844: ,p_object_type => l_child_object_types(i)
845: ,p_lock_type => p_lock_type

Line 859: BSC_LOCKS_PVT.UPDATE_USER_INFO

855: END LOOP;
856:
857: IF (p_lock_type <> 'R') THEN
858: -- Update the user information
859: BSC_LOCKS_PVT.UPDATE_USER_INFO
860: (
861: p_object_key => p_object_key
862: ,p_object_type => p_object_type
863: ,p_user_type => 'M'

Line 874: BSC_LOCKS_PVT.UPDATE_LOCK_INFO

870: ,x_msg_data => x_msg_data
871: );
872:
873: -- Update last_save_time
874: BSC_LOCKS_PVT.UPDATE_LOCK_INFO
875: (
876: p_object_key => p_object_key
877: ,p_object_type => p_object_type
878: ,p_lock_type => p_lock_type

Line 981: BSC_LOCKS_PVT.Initialize;

977: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCKS');
978: SAVEPOINT BSCLocksPubGetSystemLocks;
979: FND_MSG_PUB.Initialize;
980: x_return_status := FND_API.G_RET_STS_SUCCESS;
981: BSC_LOCKS_PVT.Initialize;
982:
983: IF (p_object_keys.COUNT <> 0 AND
984: p_object_keys.COUNT = p_object_types.COUNT) THEN
985: FOR i IN p_object_keys.FIRST..p_object_keys.LAST LOOP

Line 1108: BSC_LOCKS_PVT.Initialize;

1104: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCKS');
1105: SAVEPOINT BSCLocksPubGetSystemLocks;
1106: FND_MSG_PUB.Initialize;
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: BSC_LOCKS_PVT.Initialize;
1109:
1110: IF (p_object_keys.COUNT <> 0 AND
1111: p_object_keys.COUNT = p_object_types.COUNT AND
1112: p_object_keys.COUNT = p_lock_types.COUNT) THEN

Line 1263: BSC_LOCKS_PVT.Initialize;

1259: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK: '||p_object_type);
1260: SAVEPOINT BSCLocksPubGetSystemLock;
1261: FND_MSG_PUB.Initialize;
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263: BSC_LOCKS_PVT.Initialize;
1264:
1265: -- Get the machine and terminal information
1266: BSC_LOCKS_PVT.GET_SESSION
1267: (

Line 1266: BSC_LOCKS_PVT.GET_SESSION

1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263: BSC_LOCKS_PVT.Initialize;
1264:
1265: -- Get the machine and terminal information
1266: BSC_LOCKS_PVT.GET_SESSION
1267: (
1268: x_machine => l_machine
1269: ,x_terminal => l_terminal
1270: ,x_return_status => x_return_status

Line 1277: BSC_LOCKS_PVT.LOCK_USER

1273: );
1274:
1275: -- Lock the user entry for the top level object
1276: IF (p_lock_type <> 'R') THEN
1277: BSC_LOCKS_PVT.LOCK_USER
1278: (
1279: p_object_key => 'ALL'
1280: ,p_object_type => p_object_type
1281: ,p_user_type => 'M'

Line 1293: BSC_LOCKS_PVT.LOCK_OBJECT

1289: );
1290: END IF;
1291:
1292: -- Lock the object
1293: BSC_LOCKS_PVT.LOCK_OBJECT
1294: (
1295: p_object_type => p_object_type
1296: ,p_lock_type => p_lock_type
1297: ,p_query_time => p_query_time

Line 1311: BSC_LOCKS_PVT.UPDATE_USER_INFO

1307:
1308: IF (p_lock_type <> 'R') THEN
1309: FOR cobj IN c_get_object(p_object_type) LOOP
1310: -- Update the user information
1311: BSC_LOCKS_PVT.UPDATE_USER_INFO
1312: (
1313: p_object_key => cobj.OBJECT_KEY
1314: ,p_object_type => p_object_type
1315: ,p_user_type => 'M'

Line 1326: BSC_LOCKS_PVT.UPDATE_LOCK_INFO

1322: ,x_msg_data => x_msg_data
1323: );
1324:
1325: -- Update last_save_time
1326: BSC_LOCKS_PVT.UPDATE_LOCK_INFO
1327: (
1328: p_object_key => cobj.OBJECT_KEY
1329: ,p_object_type => p_object_type
1330: ,p_lock_type => p_lock_type

Line 1423: BSC_LOCKS_PVT.Initialize;

1419: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK');
1420: SAVEPOINT BSCLocksPubGetSystemLock;
1421: FND_MSG_PUB.Initialize;
1422: x_return_status := FND_API.G_RET_STS_SUCCESS;
1423: BSC_LOCKS_PVT.Initialize;
1424: l_insert_flag := FALSE;
1425:
1426: -- Get the machine and terminal information
1427: BSC_LOCKS_PVT.GET_SESSION

Line 1427: BSC_LOCKS_PVT.GET_SESSION

1423: BSC_LOCKS_PVT.Initialize;
1424: l_insert_flag := FALSE;
1425:
1426: -- Get the machine and terminal information
1427: BSC_LOCKS_PVT.GET_SESSION
1428: (
1429: x_machine => l_machine
1430: ,x_terminal => l_terminal
1431: ,x_return_status => x_return_status

Line 1442: BSC_LOCKS_PVT.INSERT_LOCK_ALL_AUTONOMOUS

1438: FETCH c_locate_object INTO l_last_save_time;
1439: l_insert_flag := (c_locate_object%NOTFOUND);
1440: CLOSE c_locate_object;
1441: IF (l_insert_flag) THEN
1442: BSC_LOCKS_PVT.INSERT_LOCK_ALL_AUTONOMOUS
1443: (
1444: p_object_type => 'ALL'
1445: ,p_program_id => p_program_id
1446: ,p_user_id => p_user_id

Line 1457: BSC_LOCKS_PVT.LOCK_USER

1453: );
1454: END IF;
1455:
1456: -- Lock the user entry
1457: BSC_LOCKS_PVT.LOCK_USER
1458: (
1459: p_object_key => 'ALL'
1460: ,p_object_type => 'ALL'
1461: ,p_user_type => 'M'

Line 1473: BSC_LOCKS_PVT.LOCK_OBJECT_ALL

1469: );
1470:
1471: -- Check the Lock in the lock table
1472: SAVEPOINT BSCLocksPubLockObjectAll;
1473: BSC_LOCKS_PVT.LOCK_OBJECT_ALL
1474: (
1475: x_return_status => x_return_status
1476: ,x_msg_count => x_msg_count
1477: ,x_msg_data => x_msg_data

Line 1482: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS

1478: );
1479: ROLLBACK TO BSCLocksPubLockObjectAll;
1480:
1481: -- Update the user information for 'ALL'
1482: BSC_LOCKS_PVT.UPDATE_USER_INFO_AUTONOMOUS
1483: (
1484: p_object_key => 'ALL'
1485: ,p_object_type => 'ALL'
1486: ,p_user_type => 'L'

Line 1497: BSC_LOCKS_PVT.LOCK_OBJECT_ALL

1493: ,x_msg_data => x_msg_data
1494: );
1495:
1496: -- Lock the lock table
1497: BSC_LOCKS_PVT.LOCK_OBJECT_ALL
1498: (
1499: x_return_status => x_return_status
1500: ,x_msg_count => x_msg_count
1501: ,x_msg_data => x_msg_data

Line 1505: BSC_LOCKS_PVT.UPDATE_USER_INFO

1501: ,x_msg_data => x_msg_data
1502: );
1503:
1504: -- Update the user information
1505: BSC_LOCKS_PVT.UPDATE_USER_INFO
1506: (
1507: p_object_key => 'ALL'
1508: ,p_object_type => 'ALL'
1509: ,p_user_type => 'ALL'

Line 1520: BSC_LOCKS_PVT.UPDATE_LOCK_INFO

1516: ,x_msg_data => x_msg_data
1517: );
1518:
1519: -- Update last_save_time
1520: BSC_LOCKS_PVT.UPDATE_LOCK_INFO
1521: (
1522: p_object_key => 'ALL'
1523: ,p_object_type => 'ALL'
1524: ,p_lock_type => 'ALL'

Line 1636: BSC_LOCKS_PVT.Initialize;

1632: BEGIN
1633: --DBMS_OUTPUT.PUT_LINE('GET_SYSTEM_LOCK');
1634: FND_MSG_PUB.Initialize;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: BSC_LOCKS_PVT.Initialize;
1637:
1638: BSC_SECURITY.Refresh_System_Lock(p_program_id);
1639: --Delete all orphan the sessions
1640: --DELETE BSC_CURRENT_SESSIONS

Line 1682: FND_MESSAGE.SET_TOKEN('COMPONENT',BSC_LOCKS_PVT.g_modules(cd.program_id) , TRUE);

1678: --COMMIT;
1679:
1680: FOR cd IN c_conflict_session(p_program_id) LOOP
1681: FND_MESSAGE.SET_NAME('BSC','BSC_SEC_LOCKED_SYSTEM');
1682: FND_MESSAGE.SET_TOKEN('COMPONENT',BSC_LOCKS_PVT.g_modules(cd.program_id) , TRUE);
1683: FND_MESSAGE.SET_TOKEN('USERNAME' ,cd.user_name, TRUE);
1684: FND_MESSAGE.SET_TOKEN('MACHINE' ,cd.machine, TRUE);
1685: FND_MESSAGE.SET_TOKEN('TERMINAL' ,cd.terminal, TRUE);
1686: FND_MSG_PUB.ADD;