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_REQUESTS

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 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 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 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 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 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 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 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 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 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