DBA Data[Home] [Help]

APPS.FND_CONCURRENT dependencies on FND_APPLICATION

Line 235: Fnd_Application A

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

Line 912: fnd_lookups L, fnd_application_vl A

908: begin
909: select PRINTER_NAME, user_printer_style_name, l.meaning
910: into printer, style, save_output
911: from fnd_concurrent_programs p, fnd_printer_styles_VL ps,
912: fnd_lookups L, fnd_application_vl A
913: where
914: l.lookup_code = p.SAVE_OUTPUT_FLAG
915: and l.lookup_type = ltype
916: and ps.printer_style_name = p.OUTPUT_PRINT_STYLE

Line 1610: FND_APPLICATION fa

1606: CONTROL_CODE c_ctrl_code,
1607: ENABLED_FLAG c_enabled
1608: from FND_CONCURRENT_QUEUES fcq,
1609: FND_CP_SERVICES fcs,
1610: FND_APPLICATION fa
1611: where
1612: fcq.MANAGER_TYPE = to_char(fcs.SERVICE_id)
1613: and fcq.application_id = fa.application_id
1614: and fcs.SERVICE_ID = svc_id;

Line 1690: FND_APPLICATION fa,

1686: fcp.NODE_NAME c_node,
1687: fcp.SERVICE_PARAMETERS c_parameters
1688: from FND_CONCURRENT_QUEUES fcq,
1689: FND_CONCURRENT_PROCESSES fcp,
1690: FND_APPLICATION fa,
1691: FND_LOOKUP_VALUES_VL flv
1692: where
1693: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID
1694: and fcp.CONCURRENT_QUEUE_ID = fcq.CONCURRENT_QUEUE_ID

Line 1721: FND_APPLICATION fa

1717: begin
1718: select 0
1719: into i
1720: from FND_CONCURRENT_QUEUES fcq,
1721: FND_APPLICATION fa
1722: where fcq.APPLICATION_ID = fa.APPLICATION_ID
1723: and APPLICATION_SHORT_NAME = upper(appl_short_name)
1724: and upper(CONCURRENT_QUEUE_NAME) = upper(svc_instance_name);
1725: exception

Line 1990: fnd_application A

1986: fnd_concurrent_requests R2,
1987: fnd_concurrent_programs P1,
1988: fnd_concurrent_programs P2,
1989: fnd_concurrent_queues Q,
1990: fnd_application A
1991: where r1.request_id = reqid
1992: and P1.APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
1993: and P1.concurrent_program_id = R1.concurrent_program_id
1994: and p1.queue_control_flag = 'Y'

Line 2314: from fnd_concurrent_programs_vl cp, fnd_application a

2310: begin
2311: begin
2312: select cp.USER_CONCURRENT_PROGRAM_NAME
2313: into action
2314: from fnd_concurrent_programs_vl cp, fnd_application a
2315: where cp.concurrent_program_name = prog
2316: AND cp.application_id = a.application_id
2317: AND a.application_short_name = 'FND';
2318: exception when others then

Line 2346: from fnd_application_vl

2342: elsif (Arg1 = -1) then
2343: begin
2344: select APPLICATION_NAME
2345: into Detail
2346: from fnd_application_vl
2347: where APPLICATION_ID = Arg2;
2348: exception
2349: when others then
2350: Detail := 'APPID = ' || to_char(Arg2);

Line 2780: FROM fnd_application

2776: WHERE user_name = p_user_name;
2777:
2778: CURSOR l_appl_id_csr(p_application_short_name varchar2) IS
2779: SELECT application_id
2780: FROM fnd_application
2781: WHERE application_short_name = p_application_short_name;
2782:
2783: CURSOR l_prog_id_csr(p_program_name varchar2,
2784: p_application_id number) IS