[Home] [Help]
255: delete_portlet(p_plug_id, p_user_id);
256: end if;
257: */
258:
259: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
260: INSERT INTO BIS_SCHEDULER
261: (schedule_id
262: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
263: --,plug_id
352: if p_plug_id is not null then
353: delete_portlet(p_plug_id, p_user_id);
354: end if;
355: */
356: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
357: INSERT INTO BIS_SCHEDULER
358: (schedule_id
359: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
360: -- ,plug_id
553: l_request_type := 'R';
554: else
555: l_request_type := p_request_type;
556: END IF;
557: SELECT bis_scheduler_s.nextval INTO l_schedule_id FROM dual;
558: INSERT INTO BIS_SCHEDULER
559: (schedule_id
560: -- mdamle 09/04/01 - Scheduling Enhancements - Phase II - Multiple Preferences per schedule
561: --,plug_id
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:
1271: -- Get the next run date from the next pending request
1272: select to_char(requested_start_date, 'Mon DD, YYYY HH:MI AM')
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:
1279: end if;
1280: -- rcmuthuk Bug Fix:2799113. Moved parmPrint param to last.
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
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
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
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')
2531:
2532: begin
2533: select s.function_name, type
2534: into vFunctionName, vType
2535: from bis_scheduler s, fnd_form_functions f
2536: where schedule_id = p_schedule_id
2537: and s.function_name = f.function_name;
2538: exception
2539: when others then null;