279: select 'I',
280: 'M'
281: into upcode,
282: uscode
283: from sys.dual
284: where not exists (select null
285: from fnd_concurrent_worker_requests
286: where request_id = rid
287: and running_processes > 0
811: end if;
812:
813: select to_char(trunc(sysdate) + (end_time - begin_time), 'HH24:MI:SS')
814: into e_time
815: from sys.dual;
816:
817: return e_time;
818:
819: end;