DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_CONCURRENT_REQUESTS

Line 49: -- Maps the application column name attribute in fnd_concurrent requests

45: --
46: -- Name
47: -- map_attr_to_arg
48: -- Purpose
49: -- Maps the application column name attribute in fnd_concurrent requests
50: -- to the enabled arguments of the program's desc flexfield
51:
52:
53:

Line 128: from fnd_concurrent_requests r, fnd_concurrent_programs p

124: end loop;
125:
126: select r.program_application_id , p.concurrent_program_name
127: into app_id, prog_short_name
128: from fnd_concurrent_requests r, fnd_concurrent_programs p
129: where r.request_id = reqid
130: and r.concurrent_program_id = p.concurrent_program_id
131: and r.program_application_id = p.application_id;
132:

Line 180: from fnd_concurrent_requests

176: args(13), args(14), args(15), args(16),
177: args(17), args(18), args(19), args(20),
178: args(21), args(22), args(23), args(24),
179: args(25)
180: from fnd_concurrent_requests
181: where request_id = reqid;
182:
183: if (g_arg_count <> 0) then
184: select argument26,argument27,argument28,

Line 471: from fnd_concurrent_requests

467: elsif schedule_type = 'P' then
468: if my_schedule_name is null then
469: select resubmit_interval, resubmit_interval_unit_code
470: into interval, int_unit
471: from fnd_concurrent_requests
472: where request_id = req_id;
473: if date2 is null then
474: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
475: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));

Line 824: from fnd_concurrent_requests R,

820: (select R.phase_code,
821: decode(nvl(A.Action_type,0), 6, O.file_name, R.outfile_name),
822: decode(nvl(A.action_type,0), 6, O.file_size, R.ofile_size),
823: R.save_output_flag
824: from fnd_concurrent_requests R,
825: fnd_conc_pp_actions A,
826: fnd_conc_req_outputs O
827: where R.request_id = A.concurrent_request_id (+)
828: and R.request_id = O.concurrent_request_id (+)