APPS.FND_MANAGER dependencies on FND_CONCURRENT_PROGRAMS

Line 163: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

159: -- Get a concurrent program ID given appl ID and short name
160: --
161: FUNCTION concurrent_program_id_f(program_application_id number,
162: program_short_name varchar2) return number is
163: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
164: BEGIN
165: SELECT concurrent_program_id
166: INTO program_id
167: FROM fnd_concurrent_programs

Line 167: FROM fnd_concurrent_programs

163: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
164: BEGIN
165: SELECT concurrent_program_id
166: INTO program_id
167: FROM fnd_concurrent_programs
168: WHERE application_id = program_application_id
169: AND upper(concurrent_program_name) = upper(program_short_name);
170:
171: RETURN program_id;

Line 1042: prg_id fnd_concurrent_programs.concurrent_program_id%TYPE;

1038: is
1039: lib_appl_id fnd_application.application_id%TYPE;
1040: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1041: prg_appl_id fnd_application.application_id%TYPE;
1042: prg_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1043:
1044: last_update_login fnd_concurrent_queues.last_update_login%TYPE
1045: := last_update_login_f;
1046: last_update_date fnd_concurrent_queues.last_update_date%TYPE

Line 1398: fnd_concurrent_programs cp

1394:
1395: select 'Y'
1396: into dummy
1397: from fnd_conc_processor_programs pp,
1398: fnd_concurrent_programs cp
1399: where pp.processor_application_id = lib_appl_id
1400: and pp.concurrent_processor_id = lib_id
1401: and pp.concurrent_program_id = cp.concurrent_program_id
1402: and cp.application_id = pp.program_application_id