APPS.FND_CONCURRENT dependencies on DUAL

Line 409: Into STime From Sys.Dual;

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

Line 423: Into ETime From Sys.Dual;

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

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

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

Line 1561: from dual;

1557:
1558: begin
1559: Select sysdate + (greatest(Max_Wait, 0)/86400)
1560: into end_of_time
1561: from dual;
1562:
1563: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1564: into parent_req_id
1565: from dual;

Line 1565: from dual;

1561: from dual;
1562:
1563: Select NVL(Parent_Request_ID,FND_GLOBAL.CONC_REQUEST_ID)
1564: into parent_req_id
1565: from dual;
1566:
1567: if (parent_req_id = -1) then return TRUE; end if;
1568:
1569: LOOP

Line 1590: from dual;

1586:
1587: /* otherwise return false if we have run out of time */
1588: select (end_of_time - sysdate) * 86400
1589: into time_left
1590: from dual;
1591:
1592: if (time_left <= Interval) then return FALSE; end if;
1593:
1594: /* If we still have time, take a nap before trying again */

Line 1642: from dual;

1638: platform_id, 1, SYSDATE,
1639: 1, SYSDATE, 0,
1640: 'O', p_server_id, p_address, p_description,
1641: p_host_name, p_domain,db_tier, p_virtual_ip
1642: from dual;
1643: else
1644: /*
1645: * Node exists already.
1646: * Allow for the case where multiple APPL_TOPs

Line 2248: from dual;

2244: begin
2245: /* start time */
2246: select sysdate
2247: into mystart
2248: from dual;
2249:
2250: /* get request info */
2251: begin
2252: select concurrent_program_id, program_application_id, phase_code,

Line 2290: from dual;

2286:
2287: /* time out? */
2288: select ((sysdate - mystart) * 86400) - Timeout
2289: into timesup
2290: from dual;
2291:
2292: /* have we run yet? */
2293: select decode(phase_code, 'C', 0, -1)
2294: into Done

Line 2364: from dual;

2360: begin
2361:
2362: select sysdate
2363: into mystart
2364: from dual;
2365:
2366:
2367: LOOP
2368: /* check to see if the icm is down */

Line 2378: from dual;

2374:
2375: /* time out? */
2376: select ((sysdate - mystart) * 86400) - Timeout
2377: into done
2378: from dual;
2379:
2380: if (done > 0) then return FALSE;
2381: end if;
2382: