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_OAM_COLLECTION dependencies on FND_CONCURRENT_PROGRAMS

Line 2060: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

2056: declare
2057: cursor pending_req is
2058: select
2059: fcr.request_id request_id
2060: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
2061: where
2062: fcr.program_application_id = fcp.application_id
2063: and fcr.concurrent_program_id = fcp.concurrent_program_id
2064: and fcp.concurrent_program_name = 'FNDOAMCOL'

Line 2255: fnd_concurrent_programs fcp

2251: retval boolean;
2252: BEGIN
2253: select count(*) into v_in_progress_count
2254: from fnd_concurrent_requests fcr,
2255: fnd_concurrent_programs fcp
2256: where
2257: fcr.program_application_id = fcp.application_id
2258: and fcr.concurrent_program_id = fcp.concurrent_program_id
2259: and fcp.concurrent_program_name = 'FNDOAMCOL'

Line 2271: fnd_concurrent_programs fcp

2267: -- compare repeat intervals to see if we need to resubmit
2268: select fcr.resubmit_interval, fcr.resubmit_interval_unit_code
2269: into v_curr_interval, v_curr_unit_code
2270: from fnd_concurrent_requests fcr,
2271: fnd_concurrent_programs fcp
2272: where
2273: fcr.program_application_id = fcp.application_id
2274: and fcr.concurrent_program_id = fcp.concurrent_program_id
2275: and fcp.concurrent_program_name = 'FNDOAMCOL'

Line 2295: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

2291: declare
2292: cursor repeating_req is
2293: select
2294: fcr.request_id request_id
2295: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
2296: where
2297: fcr.program_application_id = fcp.application_id
2298: and fcr.concurrent_program_id = fcp.concurrent_program_id
2299: and fcp.concurrent_program_name = 'FNDOAMCOL'

Line 2388: fnd_concurrent_programs_vl fcp

2384: fcp.user_concurrent_program_name user_concurrent_program_name
2385: from
2386: fnd_concurrent_requests fcr,
2387: fnd_conc_prog_onsite_info fcpoi,
2388: fnd_concurrent_programs_vl fcp
2389: where
2390: fcr.program_application_id=fcpoi.program_application_id
2391: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID
2392: AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID

Line 2405: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE

2401: -- Types for record of tables
2402: TYPE NumTabType IS TABLE OF NUMBER
2403: INDEX BY BINARY_INTEGER;
2404: TYPE VarcharTabType IS TABLE OF
2405: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE
2406: INDEX BY BINARY_INTEGER;
2407:
2408: TYPE RecTabType IS RECORD
2409: (request_id NumTabType,

Line 2484: fnd_concurrent_programs_vl fcp

2480: fcpoi.alert_long_running_tolerance tolerance
2481: from
2482: fnd_concurrent_requests fcr,
2483: fnd_conc_prog_onsite_info fcpoi,
2484: fnd_concurrent_programs_vl fcp
2485: where
2486: fcr.program_application_id=fcpoi.program_application_id
2487: AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID
2488: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID

Line 2503: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE

2499: -- Types for record of tables
2500: TYPE NumTabType IS TABLE OF NUMBER
2501: INDEX BY BINARY_INTEGER;
2502: TYPE VarcharTabType IS TABLE OF
2503: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE
2504: INDEX BY BINARY_INTEGER;
2505:
2506: TYPE SpecRecTabType IS RECORD
2507: (request_id NumTabType,

Line 2587: fnd_concurrent_programs_vl fcp

2583: fcp.user_concurrent_program_name user_concurrent_program_name
2584: from
2585: fnd_concurrent_requests fcr,
2586: fnd_conc_prog_onsite_info fcpoi,
2587: fnd_concurrent_programs_vl fcp
2588: where
2589: fcr.program_application_id=fcpoi.program_application_id
2590: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID
2591: AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID

Line 2602: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE

2598: -- Types for record of tables
2599: TYPE NumTabType IS TABLE OF NUMBER
2600: INDEX BY BINARY_INTEGER;
2601: TYPE VarcharTabType IS TABLE OF
2602: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE
2603: INDEX BY BINARY_INTEGER;
2604:
2605: TYPE RecTabType IS RECORD
2606: (request_id NumTabType,

Line 2674: fnd_concurrent_programs_vl fcp

2670: nvl(fcpoi.ALERT_LONG_PENDING_TOLERANCE,0)/60 tolerance_minutes
2671: from
2672: fnd_concurrent_requests fcr,
2673: fnd_conc_prog_onsite_info fcpoi,
2674: fnd_concurrent_programs_vl fcp
2675: where
2676: fcr.program_application_id=fcpoi.program_application_id
2677: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID
2678: AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID

Line 2690: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE

2686: -- Types for record of tables
2687: TYPE NumTabType IS TABLE OF NUMBER
2688: INDEX BY BINARY_INTEGER;
2689: TYPE VarcharTabType IS TABLE OF
2690: fnd_concurrent_programs_vl.user_concurrent_program_name%TYPE
2691: INDEX BY BINARY_INTEGER;
2692:
2693: TYPE SpecRecTabType IS RECORD
2694: (request_id NumTabType,