[Home] [Help]
261:
262: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'
263: , n_appid in number) is
264: select count(c.application_id) id_count
265: from fnd_concurrent_programs c
266: where c.application_id = n_appid
267: and c.concurrent_program_name like c_name ESCAPE '\';
268:
269: cursor cur_lookup(c_name in dba_objects.object_name%type := '%'
507: cursor cur_concurrent(c_name in dba_objects.object_name%type := '%'
508: , n_appid in number) is
509: select c.concurrent_program_id id
510: , c.concurrent_program_name name
511: from fnd_concurrent_programs c
512: where c.application_id = n_appid
513: and c.concurrent_program_name like c_name ESCAPE '\'
514: order by c.concurrent_program_name;
515:
1241: , c.run_alone_flag
1242: , c.srs_flag
1243: , c.save_output_flag
1244: , c.required_style
1245: from fnd_concurrent_programs_tl t
1246: , fnd_concurrent_programs c
1247: where c.application_id = n_appid
1248: and c.concurrent_program_id = n_tabid
1249: and c.concurrent_program_id = t.concurrent_program_id
1242: , c.srs_flag
1243: , c.save_output_flag
1244: , c.required_style
1245: from fnd_concurrent_programs_tl t
1246: , fnd_concurrent_programs c
1247: where c.application_id = n_appid
1248: and c.concurrent_program_id = n_tabid
1249: and c.concurrent_program_id = t.concurrent_program_id
1250: and c.application_id = t.application_id
1258: , e.subroutine_name
1259: , t.user_executable_name
1260: , t.description
1261: from fnd_executables e
1262: , fnd_concurrent_programs c
1263: , fnd_executables_tl t
1264: where e.application_id = n_appid
1265: and c.concurrent_program_id = n_tabid
1266: and c.executable_id = e.executable_id