APPS.FND_CONCURRENT dependencies on DUAL

Line 407: Into STime From Sys.Dual;

403: if ( max_wait > 0 ) then
404: Time_Out := TRUE;
405: Select To_Number(((To_Char(Sysdate, 'J') - 1 ) * 86400) +
406: To_Char(Sysdate, 'SSSSS'))
407: Into STime From Sys.Dual;
408: end if;
409:
410: LOOP
411: call_status := FND_CONCURRENT.get_request_status(Rid, '', '',

Line 421: Into ETime From Sys.Dual;

417:
418: if ( Time_Out ) then
419: Select To_Number(((To_Char(Sysdate, 'J') - 1 ) * 86400) +
420: To_Char(Sysdate, 'SSSSS'))
421: Into ETime From Sys.Dual;
422:
423: if ( (ETime - STime) >= max_wait ) then
424: dev_phase := req_phase;
425: return (call_status);

Line 561: SELECT userenv('SESSIONID') INTO cur_session_id FROM dual;

557: compare it with the session id of each manager process.
558: If they are they same, do not call check_process_status_by_handle,
559: as this will cause this session to lose its lock.
560: */
561: SELECT userenv('SESSIONID') INTO cur_session_id FROM dual;
562:
563:
564: For C1REC in C1 Loop
565:

Line 1452: from dual;

1448:
1449: begin
1450: Select sysdate + (greatest(Max_Wait, 0)/86400)
1451: into end_of_time
1452: from dual;
1453:
1454: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1455: into parent_req_id
1456: from dual;

Line 1456: from dual;

1452: from dual;
1453:
1454: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1455: into parent_req_id
1456: from dual;
1457:
1458: if (parent_req_id = -1) then return TRUE; end if;
1459:
1460: LOOP

Line 1481: from dual;

1477:
1478: /* otherwise return false if we have run out of time */
1479: select (end_of_time - sysdate) * 86400
1480: into time_left
1481: from dual;
1482:
1483: if (time_left <= Interval) then return FALSE; end if;
1484:
1485: /* If we still have time, take a nap before trying again */

Line 1533: from dual;

1529: platform_id, 1, SYSDATE,
1530: 1, SYSDATE, 0,
1531: 'O', p_server_id, p_address, p_description,
1532: p_host_name, p_domain,db_tier, p_virtual_ip
1533: from dual;
1534: else
1535: /*
1536: * Node exists already.
1537: * Allow for the case where multiple APPL_TOPs

Line 2139: from dual;

2135: begin
2136: /* start time */
2137: select sysdate
2138: into mystart
2139: from dual;
2140:
2141: /* get request info */
2142: begin
2143: select concurrent_program_id, program_application_id, phase_code,

Line 2181: from dual;

2177:
2178: /* time out? */
2179: select ((sysdate - mystart) * 86400) - Timeout
2180: into timesup
2181: from dual;
2182:
2183: /* have we run yet? */
2184: select decode(phase_code, 'C', 0, -1)
2185: into Done

Line 2255: from dual;

2251: begin
2252:
2253: select sysdate
2254: into mystart
2255: from dual;
2256:
2257:
2258: LOOP
2259: /* check to see if the icm is down */

Line 2269: from dual;

2265:
2266: /* time out? */
2267: select ((sysdate - mystart) * 86400) - Timeout
2268: into done
2269: from dual;
2270:
2271: if (done > 0) then return FALSE;
2272: end if;
2273: