APPS.FND_OAM_COLLECTION dependencies on FND_CONCURRENT_PROGRAMS_VL

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,