APPS.BSC_BIS_LOCKS_PUB dependencies on BSC_CURRENT_SESSIONS

Line 1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u

1535: )IS
1536: PRAGMA AUTONOMOUS_TRANSACTION;
1537: CURSOR c_conflict_session IS
1538: SELECT c.program_id, u.user_name, s.machine, s.terminal
1539: FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u
1540: WHERE c.session_id = s.audsid
1541: AND c.program_id IN (-100, -101, -200, -201, -700, -800, -802)
1542: AND c.session_id <> USERENV('SESSIONID')
1543: AND c.user_id = u.user_id (+);

Line 1547: FROM bsc_current_sessions

1543: AND c.user_id = u.user_id (+);
1544:
1545: CURSOR c_sessions IS
1546: SELECT session_id
1547: FROM bsc_current_sessions
1548: WHERE program_id IN (-100,-101,-200,-201,-202,-700,-800, -802);
1549:
1550: l_session_ids VARCHAR2(8000);
1551: l_sql VARCHAR2(8000);

Line 1558: DELETE BSC_CURRENT_SESSIONS

1554: FND_MSG_PUB.Initialize;
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556: -- First we need to delete the orphan sessions
1557: --Delete all orphan the sessions
1558: DELETE BSC_CURRENT_SESSIONS
1559: WHERE SESSION_ID NOT IN
1560: (SELECT VS.AUDSID
1561: FROM V$SESSION VS);
1562:

Line 1564: DELETE BSC_CURRENT_SESSIONS

1560: (SELECT VS.AUDSID
1561: FROM V$SESSION VS);
1562:
1563: --Delete all the session not being reused by FND
1564: DELETE BSC_CURRENT_SESSIONS
1565: WHERE ICX_SESSION_ID IN (
1566: SELECT SESSION_ID
1567: FROM ICX_SESSIONS
1568: WHERE (FND_SESSION_MANAGEMENT.CHECK_SESSION(SESSION_ID,NULL,NULL,'N') <> 'VALID'));

Line 1575: in BSC_CURRENT_SESSIONS for those programs for which

1571: /**************************************
1572: Changed for the POSCO bug 4955767
1573: The logic is the following.
1574: 1.First we will check if there are any sessions
1575: in BSC_CURRENT_SESSIONS for those programs for which
1576: concurrent programs are run.
1577: This include loader,Metadata optimizer,system migration and upgrade
1578: 2.If there are sessions corresponding to above programs then only
1579: it will enter into the curose loop otherwise it will not.

Line 1595: l_sql := ' DELETE bsc_current_sessions'||

1591: END IF;
1592: END LOOP;
1593:
1594: IF(l_session_ids IS NOT NULL) THEN
1595: l_sql := ' DELETE bsc_current_sessions'||
1596: ' WHERE session_id IN '||
1597: ' ( '||
1598: ' SELECT oracle_session_id '||
1599: ' FROM fnd_concurrent_requests '||

Line 1607: DELETE BSC_CURRENT_SESSIONS

1603: EXECUTE IMMEDIATE l_sql ;
1604: END IF;
1605:
1606: --Delete all the Killed Sessions
1607: DELETE BSC_CURRENT_SESSIONS
1608: WHERE SESSION_ID IN (
1609: SELECT VS.AUDSID
1610: FROM V$SESSION VS
1611: WHERE VS.STATUS = 'KILLED');

Line 1647: INSERT INTO BSC_CURRENT_SESSIONS (

1643: END IF;
1644:
1645: END LOOP;
1646:
1647: INSERT INTO BSC_CURRENT_SESSIONS (
1648: SESSION_ID,
1649: PROGRAM_ID,
1650: CREATED_BY,
1651: CREATION_DATE,

Line 1713: DELETE FROM bsc_current_sessions

1709: PROCEDURE Unlock_Designer_Session_AT
1710: IS
1711: PRAGMA AUTONOMOUS_TRANSACTION;
1712: BEGIN
1713: DELETE FROM bsc_current_sessions
1714: WHERE session_id = USERENV('SESSIONID')
1715: AND program_id = -400;
1716:
1717: COMMIT;