APPS.FND_CONCURRENT dependencies on FND_APPLICATION

Line 237: Fnd_Application A

233: begin
234: Select Concurrent_Program_ID, P.Application_ID
235: Into Program_ID, Prog_Appl_ID
236: From Fnd_Concurrent_Programs P,
237: Fnd_Application A
238: Where Concurrent_Program_Name = Program
239: And P.Application_ID = A.Application_ID
240: And A.Application_Short_Name = Appl_ShortName;
241: --

Line 981: fnd_lookups L, fnd_application_vl A

977: begin
978: select PRINTER_NAME, user_printer_style_name, l.meaning
979: into printer, style, save_output
980: from fnd_concurrent_programs p, fnd_printer_styles_VL ps,
981: fnd_lookups L, fnd_application_vl A
982: where
983: l.lookup_code = p.SAVE_OUTPUT_FLAG
984: and l.lookup_type = ltype
985: and ps.printer_style_name = p.OUTPUT_PRINT_STYLE

Line 1121: from fnd_application where application_id = temp;

1117: program_name := null;
1118: end;
1119:
1120: select lower(application_short_name) || '/' || upper(program_name) into temp
1121: from fnd_application where application_id = temp;
1122:
1123: fnd_global.tag_db_session('cp', temp);
1124:
1125: mo_global.init('M');

Line 1719: FND_APPLICATION fa

1715: CONTROL_CODE c_ctrl_code,
1716: ENABLED_FLAG c_enabled
1717: from FND_CONCURRENT_QUEUES fcq,
1718: FND_CP_SERVICES fcs,
1719: FND_APPLICATION fa
1720: where
1721: fcq.MANAGER_TYPE = to_char(fcs.SERVICE_id)
1722: and fcq.application_id = fa.application_id
1723: and fcs.SERVICE_ID = svc_id;

Line 1799: FND_APPLICATION fa,

1795: fcp.NODE_NAME c_node,
1796: fcp.SERVICE_PARAMETERS c_parameters
1797: from FND_CONCURRENT_QUEUES fcq,
1798: FND_CONCURRENT_PROCESSES fcp,
1799: FND_APPLICATION fa,
1800: FND_LOOKUP_VALUES_VL flv
1801: where
1802: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID
1803: and fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID

Line 1830: FND_APPLICATION fa

1826: begin
1827: select 0
1828: into i
1829: from FND_CONCURRENT_QUEUES fcq,
1830: FND_APPLICATION fa
1831: where fcq.APPLICATION_ID = fa.APPLICATION_ID
1832: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1833: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1834: exception

Line 2099: fnd_application A

2095: fnd_concurrent_requests R2,
2096: fnd_concurrent_programs P1,
2097: fnd_concurrent_programs P2,
2098: fnd_concurrent_queues Q,
2099: fnd_application A
2100: where r1.request_id = reqid
2101: and P1.APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
2102: and P1.concurrent_program_id = R1.concurrent_program_id
2103: and p1.queue_control_flag = 'Y'

Line 2423: from fnd_concurrent_programs_vl cp, fnd_application a

2419: begin
2420: begin
2421: select cp.USER_CONCURRENT_PROGRAM_NAME
2422: into action
2423: from fnd_concurrent_programs_vl cp, fnd_application a
2424: where cp.concurrent_program_name = prog
2425: AND cp.application_id = a.application_id
2426: AND a.application_short_name = 'FND';
2427: exception when others then

Line 2455: from fnd_application_vl

2451: elsif (Arg1 = -1) then
2452: begin
2453: select APPLICATION_NAME
2454: into Detail
2455: from fnd_application_vl
2456: where APPLICATION_ID = Arg2;
2457: exception
2458: when others then
2459: Detail := 'APPID = ' || to_char(Arg2);

Line 2900: FROM fnd_application

2896: WHERE user_name = upper(p_user_name);
2897:
2898: CURSOR l_appl_id_csr(p_application_short_name varchar2) IS
2899: SELECT application_id
2900: FROM fnd_application
2901: WHERE application_short_name = p_application_short_name;
2902:
2903: CURSOR l_prog_id_csr(p_program_name varchar2,
2904: p_application_id number) IS