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.BIS_RG_SCHEDULES_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 1266: from fnd_concurrent_requests

1262: -- Fixed the SQL
1263: -- Get the last run date from the last completed request
1264: select to_char(max(requested_start_date), 'Mon DD, YYYY HH:MI AM')
1265: into vLastRun
1266: from fnd_concurrent_requests
1267: where phase_code = 'C'
1268: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)
1269: connect by prior request_id = parent_request_id;
1270:

Line 1274: from fnd_concurrent_requests

1270:
1271: -- Get the next run date from the next pending request
1272: select to_char(requested_start_date, 'Mon DD, YYYY HH:MI AM')
1273: into vNextRun
1274: from fnd_concurrent_requests
1275: where phase_code IN ('P', 'R')
1276: start with request_id = (select s.concurrent_request_id from bis_scheduler s where schedule_id = vDupScheduleId)
1277: connect by prior request_id = parent_request_id;
1278:

Line 1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1329: -- mdamle 08/20/2001 - Fixed SQL
1330: begin
1331: select max(schedule_id)
1332: into vScheduleId
1333: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1334: where s.function_name = pFunctionName
1335: and s.parameter_string = pParameters
1336: and s.concurrent_request_id = cr.request_id
1337: and cr.release_class_id = rc.release_class_id

Line 1341: from fnd_concurrent_requests

1337: and cr.release_class_id = rc.release_class_id
1338: and s.plug_id = pPlugId
1339: and (rc.date2 is null or rc.date2 > sysdate)
1340: and 0 < (select count(*)
1341: from fnd_concurrent_requests
1342: where phase_code = 'P'
1343: start with request_id = cr.request_id
1344: connect by prior request_id = parent_request_id);
1345:

Line 1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1357: -- mdamle 08/20/2001 - Fixed SQL
1358: begin
1359: select max(schedule_id)
1360: into vScheduleId
1361: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1362: where s.function_name = pFunctionName
1363: and s.parameter_string = pParameters
1364: and s.concurrent_request_id = cr.request_id
1365: and cr.release_class_id = rc.release_class_id

Line 1368: from fnd_concurrent_requests

1364: and s.concurrent_request_id = cr.request_id
1365: and cr.release_class_id = rc.release_class_id
1366: and (rc.date2 is null or rc.date2 > sysdate)
1367: and 0 < (select count(*)
1368: from fnd_concurrent_requests
1369: where phase_code = 'P'
1370: start with request_id = cr.request_id
1371: connect by prior request_id = parent_request_id);
1372: exception

Line 1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc

1377:
1378: begin
1379: select max(schedule_id)
1380: into vScheduleId
1381: from bis_scheduler s, fnd_concurrent_requests cr, fnd_conc_release_classes rc
1382: where s.function_name = pFunctionName
1383: -- mdamle 09/21/01 - Fixed Bug#1999262 - Added nvl
1384: and nvl(s.parameter_string, ' ') = nvl(pParameters, ' ')
1385: and s.concurrent_request_id = cr.request_id

Line 1389: from fnd_concurrent_requests

1385: and s.concurrent_request_id = cr.request_id
1386: and cr.release_class_id = rc.release_class_id
1387: and (rc.date2 is null or rc.date2 > sysdate)
1388: and 0 < (select count(*)
1389: from fnd_concurrent_requests
1390: where phase_code IN ('P', 'R')
1391: start with request_id = cr.request_id
1392: connect by prior request_id = parent_request_id);
1393: exception

Line 1957: update fnd_concurrent_requests

1953: --aleung, 8/21/01 -- autoincrement feature
1954: procedure updateIncrementDate(p_concurrent_Request_id IN NUMBER) is
1955: begin
1956:
1957: update fnd_concurrent_requests
1958: set increment_dates = 'Y'
1959: where request_id = p_concurrent_request_id;
1960: commit;
1961:

Line 2166: from bis_scheduler s, fnd_concurrent_requests cr

2162: procedure delete_Notification_Data is
2163:
2164: cursor cNotificationSchedules is
2165: select schedule_id
2166: from bis_scheduler s, fnd_concurrent_requests cr
2167: where s.concurrent_request_id = cr.request_id
2168: and 0 = (select count(*)
2169: from fnd_concurrent_requests
2170: where phase_code IN ('P', 'R')

Line 2169: from fnd_concurrent_requests

2165: select schedule_id
2166: from bis_scheduler s, fnd_concurrent_requests cr
2167: where s.concurrent_request_id = cr.request_id
2168: and 0 = (select count(*)
2169: from fnd_concurrent_requests
2170: where phase_code IN ('P', 'R')
2171: start with request_id = cr.request_id
2172: connect by prior request_id = parent_request_id)
2173: and 0 = (select count(*) from bis_schedule_preferences sp

Line 2409: from fnd_concurrent_requests

2405: begin
2406: begin
2407: select request_id, status_code, phase_code
2408: into vPendingRequestId, vStatusCode, vPhaseCode
2409: from fnd_concurrent_requests
2410: where phase_code <> 'C'
2411: start with request_id = pRequestId
2412: connect by prior request_id = parent_request_id;
2413: exception

Line 2433: update fnd_concurrent_requests

2429: end if;
2430:
2431: vCompletionText := fnd_message.get_string('BIS', 'BIS_REQUEST_CANCELED');
2432:
2433: update fnd_concurrent_requests
2434: set status_code = vStatusCode,
2435: phase_code = vPhaseCode,
2436: completion_text = vCompletionText
2437: where request_id = vPendingRequestId;