eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_CONCURRENT dependencies on FND_CONCURRENT_PROGRAMS

Line 234: From Fnd_Concurrent_Programs P,

230: end if;
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;

Line 290: Fnd_Concurrent_programs P,

286: Into req_phase, req_status, comptext,
287: phase_code, status_code,
288: phasem, statusm
289: From Fnd_Concurrent_Requests R,
290: Fnd_Concurrent_programs P,
291: Fnd_Lookups Phase,
292: Fnd_Lookups Status
293: Where
294: Phase.Lookup_Type = PHASE_LOOKUP_TYPE

Line 911: from fnd_concurrent_programs p, fnd_printer_styles_VL ps,

907: ltype varchar2(8) := 'YES_NO';
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

Line 1009: from FND_CONCURRENT_PROGRAMS P,

1005: execution_method_code,
1006: multi_org_category, org_id
1007: into optmode, program_name, ptrace, rtrace, etstat, emethod,
1008: morg_cat, orgid
1009: from FND_CONCURRENT_PROGRAMS P,
1010: FND_CONCURRENT_REQUESTS R
1011: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1012: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1013: And R.request_id = fnd_global.conc_request_id;

Line 1068: from fnd_concurrent_programs P,

1064:
1065: begin
1066: select p.RESOURCE_CONSUMER_GROUP
1067: into prg_rcg
1068: from fnd_concurrent_programs P,
1069: fnd_concurrent_requests R
1070: where R.request_id = fnd_global.conc_request_id
1071: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1072: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;

Line 1136: from FND_CONCURRENT_PROGRAMS P,

1132:
1133: begin
1134: select P.Rollback_Segment
1135: into RBS
1136: from FND_CONCURRENT_PROGRAMS P,
1137: FND_CONCURRENT_REQUESTS R
1138: WHERE R.request_id = fnd_global.conc_request_id
1139: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1140: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;

Line 1368: Fnd_Concurrent_programs P,

1364: Phase.Lookup_Code p_lookup_code,
1365: Status.Lookup_Code s_lookup_code,
1366: Phase.Meaning p_meaning, Status.Meaning s_meaning
1367: From Fnd_Concurrent_Requests R,
1368: Fnd_Concurrent_programs P,
1369: Fnd_Lookups Phase,
1370: Fnd_Lookups Status
1371: Where
1372: Phase.Lookup_Type = PHASE_LOOKUP_TYPE

Line 1930: from fnd_concurrent_requests R, fnd_concurrent_programs P

1926: my_service_id number := service_id;
1927:
1928: Cursor C1 IS
1929: Select request_id
1930: from fnd_concurrent_requests R, fnd_concurrent_programs P
1931: where r.phase_code = 'P'
1932: and p.application_id = r.PROGRAM_APPLICATION_ID
1933: and p.concurrent_program_id = r.concurrent_program_id
1934: and p.queue_control_flag = 'Y'

Line 1987: fnd_concurrent_programs P1,

1983: Cursor C1 IS
1984: Select R2.request_id
1985: from fnd_concurrent_requests R1,
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

Line 1988: fnd_concurrent_programs P2,

1984: Select R2.request_id
1985: from fnd_concurrent_requests R1,
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

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 2786: FROM fnd_concurrent_programs

2782:
2783: CURSOR l_prog_id_csr(p_program_name varchar2,
2784: p_application_id number) IS
2785: SELECT concurrent_program_id, srs_flag
2786: FROM fnd_concurrent_programs
2787: WHERE concurrent_program_name = p_program_name
2788: AND application_id = p_application_id;
2789:
2790: BEGIN

Line 2830: p_object_name => 'FND_CONCURRENT_PROGRAMS',

2826:
2827: fnd_data_security.get_security_predicate
2828: (p_api_version => 1.0,
2829: p_function => 'FND_CP_REQ_SUBMIT',
2830: p_object_name => 'FND_CONCURRENT_PROGRAMS',
2831: x_predicate => l_predicate,
2832: x_return_status => l_return_status,
2833: p_table_alias => 'p');
2834:

Line 2835: l_sql_stmt := 'select count(p.concurrent_program_id) from fnd_concurrent_programs p where p.concurrent_program_id = :1 and p.application_id = :2 and ' || l_predicate || '';

2831: x_predicate => l_predicate,
2832: x_return_status => l_return_status,
2833: p_table_alias => 'p');
2834:
2835: l_sql_stmt := 'select count(p.concurrent_program_id) from fnd_concurrent_programs p where p.concurrent_program_id = :1 and p.application_id = :2 and ' || l_predicate || '';
2836:
2837: execute immediate l_sql_stmt INTO l_ret_value using l_conc_program_id, l_application_id;
2838:
2839: IF (l_ret_value > 0) THEN