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 532: from fnd_concurrent_requests

528: elsif schedule_type = 'P' then
529: if my_schedule_name is null then
530: select resubmit_interval, resubmit_interval_unit_code
531: into interval, int_unit
532: from fnd_concurrent_requests
533: where request_id = req_id;
534: if date2 is null then
535: fnd_message.set_name('FND','SCH-PERIODIC NO END DATE');
536: fnd_message.set_token('UNIT_INTERVAL', to_char(interval));

Line 885: from fnd_concurrent_requests R,

881: (select R.phase_code,
882: decode(nvl(A.Action_type,0), 6, O.file_name, R.outfile_name),
883: decode(nvl(A.action_type,0), 6, O.file_size, R.ofile_size),
884: R.save_output_flag
885: from fnd_concurrent_requests R,
886: fnd_conc_pp_actions A,
887: fnd_conc_req_outputs O
888: where R.request_id = A.concurrent_request_id (+)
889: and R.request_id = O.concurrent_request_id (+)