22: v_userid number;
23: v_conc_req_id number;
24: BEGIN
25: -- check if its concurrent request
26: select fnd_global.conc_request_id into v_conc_req_id from dual;
27: if v_conc_req_id > 0 then
28: select fcr.requested_by into v_userid
29: from fnd_concurrent_requests fcr
30: where fcr.request_id = v_conc_req_id;
28: select fcr.requested_by into v_userid
29: from fnd_concurrent_requests fcr
30: where fcr.request_id = v_conc_req_id;
31: else
32: select fnd_global.user_id into v_userid from dual;
33: if (v_userid < 0 or v_userid is null) then
34: v_userid := 0; -- default
35: end if;
36: end if;