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

Line 55: v_conc_req_id fnd_concurrent_requests.request_id%TYPE;

51: -- request (i.e. FNDOAMCOL execution) or not.
52: --
53: FUNCTION is_request RETURN boolean
54: IS
55: v_conc_req_id fnd_concurrent_requests.request_id%TYPE;
56: v_retu boolean := false;
57: BEGIN
58: -- check if its concurrent request
59: select fnd_global.conc_request_id into v_conc_req_id from dual;

Line 78: from fnd_concurrent_requests fcr

74: -- check if its concurrent request
75: select fnd_global.conc_request_id into v_conc_req_id from dual;
76: if v_conc_req_id > 0 then
77: select fcr.requested_by into v_userid
78: from fnd_concurrent_requests fcr
79: where fcr.request_id = v_conc_req_id;
80: else
81: select fnd_global.user_id into v_userid from dual;
82: if (v_userid < 0 or v_userid is null) then

Line 733: from fnd_cp_services fcs, fnd_concurrent_queues fcq

729: select
730: fcq.application_id application_id,
731: fcq.concurrent_queue_id concurrent_queue_id,
732: fcq.concurrent_queue_name concurrent_queue_name
733: from fnd_cp_services fcs, fnd_concurrent_queues fcq
734: where
735: fcs.service_id = to_number(fcq.manager_type)
736: and fcs.server_type in (v_server_type, 'E')
737: and upper(fcq.target_node) = upper(v_node_name)

Line 1408: from fnd_concurrent_requests

1404: if (is_collection_enabled('RUNNING_REQ')) then
1405: -- get the number of running requests
1406: select count(*)
1407: into ct_running_req
1408: from fnd_concurrent_requests
1409: where phase_code = 'R';
1410:
1411: -- update the number of running requests
1412: update_metric_internal('RUNNING_REQ', to_char(ct_running_req), -1);

Line 1419: from fnd_concurrent_processes

1415: if (is_collection_enabled('SERVICE_PROCS')) then
1416: -- get the number of service processes
1417: select count(*)
1418: into ct_service_processes
1419: from fnd_concurrent_processes
1420: where process_status_code in ('R','A','P');
1421:
1422: -- update the number of service processes
1423: update_metric_internal('SERVICE_PROCS', to_char(ct_service_processes), -1);

Line 1430: from fnd_concurrent_queues_vl

1426: if (is_collection_enabled('SERVICES_UP')) then
1427: -- Now get the number of Services Up
1428: select count(concurrent_queue_id)
1429: into ct_services_up
1430: from fnd_concurrent_queues_vl
1431: where running_processes = max_processes and max_processes > 0;
1432:
1433: -- Update Services Up
1434: update_metric_internal('SERVICES_UP', to_char(ct_services_up), 0);

Line 1441: from fnd_concurrent_queues_vl

1437: if (is_collection_enabled('SERVICES_DOWN')) then
1438: -- Get the number of services down
1439: select count(concurrent_queue_id)
1440: into ct_services_down
1441: from fnd_concurrent_queues_vl
1442: where running_processes = 0 and max_processes > 0;
1443:
1444: -- Update Services down
1445: update_metric_internal('SERVICES_DOWN', to_char(ct_services_down), 2);

Line 1632: from fnd_concurrent_requests

1628: v_numerator number;
1629: v_denominator number;
1630: begin
1631: select count(*) into v_numerator
1632: from fnd_concurrent_requests
1633: where phase_code in ('R', 'C')
1634: and status_code <> 'D'
1635: and greatest(requested_start_date, request_date)
1636: between sysdate-1 and sysdate;

Line 1639: from fnd_concurrent_requests

1635: and greatest(requested_start_date, request_date)
1636: between sysdate-1 and sysdate;
1637:
1638: select count(*) into v_denominator
1639: from fnd_concurrent_requests
1640: where ( (phase_code in ('R', 'C')
1641: and status_code <> 'D')
1642: or ( status_code in ('I','Q')
1643: and hold_flag <> 'Y') )

Line 1934: fnd_concurrent_queues fcq,

1930: foa.concurrent_queue_name concurrent_queue_name,
1931: fcq.concurrent_queue_id concurrent_queue_id,
1932: foa.status_code status_code
1933: from fnd_oam_app_sys_status foa,
1934: fnd_concurrent_queues fcq,
1935: fnd_oam_svci_info fsi
1936: where foa.application_id = fcq.application_id
1937: and foa.concurrent_queue_name = fcq.concurrent_queue_name
1938: and foa.application_id = fsi.application_id (+)

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 2145: fnd_concurrent.get_request_status(

2141: BEGIN
2142: -- First query to see if there is a request already submitted for this
2143: -- program.
2144: outcome :=
2145: fnd_concurrent.get_request_status(
2146: request_id=>p_request_id,
2147: appl_shortname=>'FND',
2148: program=>'FNDOAMCOL',
2149: phase=>p_phase,

Line 2240: p_repeat_interval fnd_concurrent_requests.resubmit_interval%TYPE,

2236: -- Notes:
2237: --
2238: --
2239: PROCEDURE resubmit(
2240: p_repeat_interval fnd_concurrent_requests.resubmit_interval%TYPE,
2241: p_repeat_interval_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE,
2242: p_ret_code OUT NOCOPY number,
2243: p_ret_msg OUT NOCOPY varchar2)
2244: IS

Line 2241: p_repeat_interval_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE,

2237: --
2238: --
2239: PROCEDURE resubmit(
2240: p_repeat_interval fnd_concurrent_requests.resubmit_interval%TYPE,
2241: p_repeat_interval_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE,
2242: p_ret_code OUT NOCOPY number,
2243: p_ret_msg OUT NOCOPY varchar2)
2244: IS
2245: v_in_progress_count number := 0;

Line 2247: v_curr_interval fnd_concurrent_requests.resubmit_interval%TYPE;

2243: p_ret_msg OUT NOCOPY varchar2)
2244: IS
2245: v_in_progress_count number := 0;
2246: v_continue_submit boolean := false;
2247: v_curr_interval fnd_concurrent_requests.resubmit_interval%TYPE;
2248: v_curr_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE;
2249: ret_code number := -1;
2250: ret_msg varchar2(1000) := '';
2251: retval boolean;

Line 2248: v_curr_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE;

2244: IS
2245: v_in_progress_count number := 0;
2246: v_continue_submit boolean := false;
2247: v_curr_interval fnd_concurrent_requests.resubmit_interval%TYPE;
2248: v_curr_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE;
2249: ret_code number := -1;
2250: ret_msg varchar2(1000) := '';
2251: retval boolean;
2252: BEGIN

Line 2254: from fnd_concurrent_requests fcr,

2250: ret_msg varchar2(1000) := '';
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

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 2270: from fnd_concurrent_requests fcr,

2266: else
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

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 2386: fnd_concurrent_requests fcr,

2382: cursor req_id_list(p_tol varchar2,p_offset varchar2) is
2383: select fcr.request_id request_id,
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

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 2482: fnd_concurrent_requests fcr,

2478: fcpoi.avg_run_time avg_run_time,
2479: fcpoi.alert_long_running_threshold/60 threshold_minutes,
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

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 2585: fnd_concurrent_requests fcr,

2581: cursor req_id_list(p_tol varchar2) is
2582: select fcr.request_id request_id,
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

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 2672: fnd_concurrent_requests fcr,

2668: select fcr.request_id request_id,
2669: fcp.user_concurrent_program_name user_concurrent_program_name,
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

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,