APPS.FND_TRANSACTION dependencies on DUAL

Line 221: from dual;

217: begin
218: -- get transaction request_id from sequence
219: select fnd_trn_request_id_s.nextval
220: into request_id
221: from dual;
222:
223: /* initialize and seed random... */
224: dbms_random.initialize(request_id);
225:

Line 234: from sys.dual;

230: -- session id
231: if (sid is null) then
232: select userenv('SESSIONID')
233: into sid
234: from sys.dual;
235: end if;
236:
237: -- PIPE/QUEUE profile option switch
238: FND_PROFILE.GET('CONC_TM_TRANSPORT_TYPE', p_transport_type);

Line 291: -- Individual arguments longer than 480 chars will be truncated.

287: -- program - Transaction program short name.
288: -- arg_n - Arguments 1 through 20 to the transaction program.
289: --
290: -- Each argument is at most 480 characters.
291: -- Individual arguments longer than 480 chars will be truncated.
292: --
293: --
294: -- OUT
295: -- outcome - varchar(30) - Transaction program completion status.

Line 426: select nvl(mo_global.get_access_mode, morg_cat) into org_type from dual;

422: enable_trace_flag := 'FALSE';
423: end if;
424:
425: -- get org type and id
426: select nvl(mo_global.get_access_mode, morg_cat) into org_type from dual;
427: select nvl(mo_global.get_current_org_id, 0) into org_id from dual;
428:
429: -- Request expires at SYSDATE + timeout
430: expiration_time := sysdate + (timeout * DAY_PER_SEC);

Line 427: select nvl(mo_global.get_current_org_id, 0) into org_id from dual;

423: end if;
424:
425: -- get org type and id
426: select nvl(mo_global.get_access_mode, morg_cat) into org_type from dual;
427: select nvl(mo_global.get_current_org_id, 0) into org_id from dual;
428:
429: -- Request expires at SYSDATE + timeout
430: expiration_time := sysdate + (timeout * DAY_PER_SEC);
431: