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.AD_CONC_SESSION_LOCKS dependencies on AD_PLANNED_RES_LOCKS

Line 893: from ad_planned_res_locks

889: */
890: begin
891:
892: select distinct nvl(done_flag,'N') bulk collect into x_done_flag
893: from ad_planned_res_locks
894: where session_id = x_session_id and
895: stage_code = x_stage_code;
896:
897: if (x_done_flag.count = 0) then

Line 919: * ad_planned_res_locks */

915: exception
916: when others then
917: error_message := substr(sqlerrm, 1, 100);
918: error_code := BASE_ERROR + 6; /* Error, reading
919: * ad_planned_res_locks */
920: goto acquire_error;
921: end;
922: end if;
923:

Line 979: from ad_planned_res_locks p

975: sysdate,
976: null,
977: x_status,
978: x_priority
979: from ad_planned_res_locks p
980: where p.session_id = x_session_id and
981: p.stage_code = x_stage_code and
982: p.action_flag in ('A', 'P', 'B') and
983: not exists (

Line 1246: from ad_planned_res_locks wl

1242: wl.appl_top_id || ':' || wl.language || ':' ||
1243: wl.extra_context1 || ':' || wl.extra_context2 || ':' ||
1244: wl.extra_context3 || ':' || decode (lock_mode, 'S', 'M',
1245: lock_mode)
1246: from ad_planned_res_locks wl
1247: where session_id = x_session_id and
1248: stage_code = x_stage_code and
1249: action_flag = 'P') and
1250: session_id = x_session_id and

Line 1266: from ad_planned_res_locks wl

1262: language,
1263: extra_context1,
1264: extra_context2,
1265: extra_context3
1266: from ad_planned_res_locks wl
1267: where session_id = x_session_id and
1268: stage_code = x_stage_code and
1269: action_flag = 'P'
1270: minus

Line 1286: from ad_planned_res_locks wl

1282: (select wl.resource_code || ':' || wl.context || ':' ||
1283: wl.appl_top_id || ':' || wl.language || ':' ||
1284: wl.extra_context1 || ':' || wl.extra_context2 || ':' ||
1285: wl.extra_context3
1286: from ad_planned_res_locks wl
1287: where session_id = x_session_id and
1288: stage_code = x_stage_code and
1289: action_flag = 'P') and
1290: session_id = x_session_id and

Line 1323: update ad_planned_res_locks set done_flag = 'N' where

1319:
1320: update ad_working_res_locks set in_process_flag = 'N'
1321: where session_id = x_session_id and in_process_flag = 'Y';
1322:
1323: update ad_planned_res_locks set done_flag = 'N' where
1324: session_id = x_session_id and stage_code = x_stage_code;
1325:
1326: update ad_sessions set wait_loop_time = 0
1327: where session_id = x_session_id;

Line 1389: -- BASE_ERROR + 3 --> Exception,reading ad_planned_res_locks

1385: -- 4) error_code - Out parameter
1386: -- 0 --> Success
1387: -- BASE_ERROR + 1 --> This stage is already done.
1388: -- BASE_ERROR + 2 --> Invalid argument.
1389: -- BASE_ERROR + 3 --> Exception,reading ad_planned_res_locks
1390: -- BASE_ERROR + 4 --> Inconsistency state (some of the lock
1391: -- rows have done_flag='Y' and others
1392: -- have done_flag='N')
1393: -- It shouldn't happen.

Line 1394: -- BASE_ERROR + 5 --> Exception,reading ad_planned_res_locks

1390: -- BASE_ERROR + 4 --> Inconsistency state (some of the lock
1391: -- rows have done_flag='Y' and others
1392: -- have done_flag='N')
1393: -- It shouldn't happen.
1394: -- BASE_ERROR + 5 --> Exception,reading ad_planned_res_locks
1395: -- BASE_ERROR + 6 --> Unhandled exception
1396: -- BASE_ERROR + 7 --> Lock rows are not prestaged.
1397: -- BASE_ERROR + 8 --> Data error.Demote to 'X' is not valid
1398: -- BASE_ERROR + 9 --> Error, Locks need to be promoted is

Line 1455: from ad_planned_res_locks

1451: * Done (done_flag = 'Y')
1452: */
1453: begin
1454: select distinct nvl(done_flag,'N') bulk collect into x_done_flag
1455: from ad_planned_res_locks
1456: where session_id = x_session_id and
1457: stage_code = x_stage_code;
1458:
1459: if (x_done_flag.count = 0) then

Line 1481: * ad_planned_res_locks */

1477: exception
1478: when others then
1479: error_message := substr(sqlerrm, 1, 100);
1480: error_code := BASE_ERROR + 5; /* Error, reading
1481: * ad_planned_res_locks */
1482: goto release_error;
1483: end;
1484:
1485:

Line 1510: from ad_planned_res_locks wl

1506: (select wl.resource_code || ':' || wl.context || ':' ||
1507: wl.appl_top_id || ':' || wl.language || ':' ||
1508: wl.extra_context1 || ':' || wl.extra_context2 || ':' ||
1509: wl.extra_context3
1510: from ad_planned_res_locks wl
1511: where session_id = x_session_id and
1512: stage_code = x_stage_code and
1513: action_flag in ('B', 'R')) and
1514: session_id = x_session_id

Line 1517: select count(*) into x_lock_count from ad_planned_res_locks

1513: action_flag in ('B', 'R')) and
1514: session_id = x_session_id
1515: );
1516:
1517: select count(*) into x_lock_count from ad_planned_res_locks
1518: where session_id = x_session_id and
1519: stage_code = x_stage_code and
1520: action_flag = 'D' and
1521: lock_mode = 'X';

Line 1530: select count(*) into x_lock_count from ad_planned_res_locks

1526: * check prestage rows */
1527: goto release_error;
1528: end if;
1529:
1530: select count(*) into x_lock_count from ad_planned_res_locks
1531: where session_id = x_session_id and
1532: stage_code = x_stage_code and
1533: action_flag = 'D';
1534:

Line 1544: from ad_planned_res_locks wl

1540: (select wl.resource_code || ':' || wl.context || ':' ||
1541: wl.appl_top_id || ':' || wl.language || ':' ||
1542: wl.extra_context1 || ':' || wl.extra_context2 || ':' ||
1543: wl.extra_context3
1544: from ad_planned_res_locks wl
1545: where session_id = x_session_id and
1546: stage_code = x_stage_code and
1547: action_flag = 'D') and
1548: session_id = x_session_id);

Line 1557: update ad_planned_res_locks set done_flag = 'Y' where

1553: * check prestage rows */
1554: goto release_error;
1555: end if;
1556:
1557: update ad_planned_res_locks set done_flag = 'Y' where
1558: session_id = x_session_id and stage_code = x_stage_code;
1559: else
1560: delete from ad_working_res_locks where session_id = x_session_id;
1561: end if;

Line 1568: * ad_planned_res_locks */

1564: when others then
1565: rollback;
1566: error_message := substr(sqlerrm, 1, 100);
1567: error_code := BASE_ERROR + 3; /* Error, reading
1568: * ad_planned_res_locks */
1569: goto release_error;
1570: end;
1571:
1572: if (release_admin_flag = 1) then

Line 1613: DELETE FROM AD_PLANNED_RES_LOCKS

1609: is
1610: begin
1611: --
1612: --
1613: DELETE FROM AD_PLANNED_RES_LOCKS
1614: WHERE SESSION_ID = p_session_id AND
1615: STAGE_CODE <> p_end_stage_cd AND
1616: STAGE_CODE <> p_begin_stage_cd;
1617: --