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 236: From Fnd_Concurrent_Programs P,

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

Line 292: Fnd_Concurrent_programs P,

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

Line 980: from fnd_concurrent_programs p, fnd_printer_styles_VL ps,

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

Line 1109: from FND_CONCURRENT_PROGRAMS P,

1105: execution_method_code,
1106: multi_org_category, org_id, p.application_id
1107: into optmode, program_name, ptrace, rtrace, etstat, emethod,
1108: morg_cat, orgid, temp
1109: from FND_CONCURRENT_PROGRAMS P,
1110: FND_CONCURRENT_REQUESTS R
1111: WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
1112: And P.APPLICATION_ID = R.Program_APPLICATION_ID
1113: And R.request_id = fnd_global.conc_request_id;

Line 1173: from fnd_concurrent_programs P,

1169:
1170: begin
1171: select p.RESOURCE_CONSUMER_GROUP
1172: into prg_rcg
1173: from fnd_concurrent_programs P,
1174: fnd_concurrent_requests R
1175: where R.request_id = fnd_global.conc_request_id
1176: and r.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
1177: and R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID;

Line 1245: from FND_CONCURRENT_PROGRAMS P,

1241:
1242: begin
1243: select P.Rollback_Segment
1244: into RBS
1245: from FND_CONCURRENT_PROGRAMS P,
1246: FND_CONCURRENT_REQUESTS R
1247: WHERE R.request_id = fnd_global.conc_request_id
1248: AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
1249: And R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;

Line 1477: Fnd_Concurrent_programs P,

1473: Phase.Lookup_Code p_lookup_code,
1474: Status.Lookup_Code s_lookup_code,
1475: Phase.Meaning p_meaning, Status.Meaning s_meaning
1476: From Fnd_Concurrent_Requests R,
1477: Fnd_Concurrent_programs P,
1478: Fnd_Lookups Phase,
1479: Fnd_Lookups Status
1480: Where
1481: Phase.Lookup_Type = PHASE_LOOKUP_TYPE

Line 2039: from fnd_concurrent_requests R, fnd_concurrent_programs P

2035: my_service_id number := service_id;
2036:
2037: Cursor C1 IS
2038: Select request_id
2039: from fnd_concurrent_requests R, fnd_concurrent_programs P
2040: where r.phase_code = 'P'
2041: and p.application_id = r.PROGRAM_APPLICATION_ID
2042: and p.concurrent_program_id = r.concurrent_program_id
2043: and p.queue_control_flag = 'Y'

Line 2096: fnd_concurrent_programs P1,

2092: Cursor C1 IS
2093: Select R2.request_id
2094: from fnd_concurrent_requests R1,
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

Line 2097: fnd_concurrent_programs P2,

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

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

2902:
2903: CURSOR l_prog_id_csr(p_program_name varchar2,
2904: p_application_id number) IS
2905: SELECT concurrent_program_id, srs_flag
2906: FROM fnd_concurrent_programs
2907: WHERE concurrent_program_name = p_program_name
2908: AND application_id = p_application_id;
2909:
2910: BEGIN

Line 2950: p_object_name => 'FND_CONCURRENT_PROGRAMS',

2946:
2947: fnd_data_security.get_security_predicate
2948: (p_api_version => 1.0,
2949: p_function => 'FND_CP_REQ_SUBMIT',
2950: p_object_name => 'FND_CONCURRENT_PROGRAMS',
2951: x_predicate => l_predicate,
2952: x_return_status => l_return_status,
2953: p_table_alias => 'p');
2954:

Line 2955: 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 || '';

2951: x_predicate => l_predicate,
2952: x_return_status => l_return_status,
2953: p_table_alias => 'p');
2954:
2955: 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 || '';
2956:
2957: execute immediate l_sql_stmt INTO l_ret_value using l_conc_program_id, l_application_id;
2958:
2959: IF (l_ret_value > 0) THEN