APPS.FND_DELIVERY dependencies on FND_CONCURRENT_REQUESTS

Line 464: nls_lang fnd_concurrent_requests.nls_language%TYPE;

460: lob_of_type IN varchar2) return boolean is
461:
462: prog_app_name fnd_application.application_short_name%TYPE;
463: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
464: nls_lang fnd_concurrent_requests.nls_language%TYPE;
465: nls_terry fnd_concurrent_requests.nls_territory%TYPE;
466:
467: begin
468:

Line 465: nls_terry fnd_concurrent_requests.nls_territory%TYPE;

461:
462: prog_app_name fnd_application.application_short_name%TYPE;
463: conc_prog_name fnd_concurrent_programs.concurrent_program_name%TYPE;
464: nls_lang fnd_concurrent_requests.nls_language%TYPE;
465: nls_terry fnd_concurrent_requests.nls_territory%TYPE;
466:
467: begin
468:
469: SELECT a.application_short_name, p.concurrent_program_name,

Line 473: FROM fnd_concurrent_requests r, fnd_concurrent_programs p,

469: SELECT a.application_short_name, p.concurrent_program_name,
470: r.nls_language, r.nls_territory
471: INTO prog_app_name, conc_prog_name,
472: nls_lang, nls_terry
473: FROM fnd_concurrent_requests r, fnd_concurrent_programs p,
474: fnd_application a
475: WHERE r.program_application_id = p.application_id
476: AND r.concurrent_program_id = p.concurrent_program_id
477: AND p.application_id = a.application_id

Line 498: fnd_concurrent_requests cr

494:
495: SELECT count(*)
496: INTO dummy
497: FROM fnd_conc_pp_actions pp,
498: fnd_concurrent_requests cr
499: WHERE pp.concurrent_request_id = reqid
500: AND pp.argument1= delivery_type
501: AND pp.concurrent_request_id = cr.request_id
502: AND action_type in (7,8);