[Home] [Help]
78: -- 'T' Running Terminating.
79: if (fnd_conc_request_pkg.restart_parent (
80: request_id,
81: parent_request_id,
82: fnd_global.user_id)) then
83: fnd_message.set_name (
84: 'FND',
85: 'CONC-Restart parent request');
86: end if;
92: -- terminated or cancelled unless they are already
93: -- complete or terminating.
94: fnd_conc_request_pkg.delete_children (
95: request_id,
96: fnd_global.user_id);
97: end if;
98: end cancel_subrequests;
99:
100:
364: -- Name
365: -- cancel_request
366: -- Purpose
367: -- Cancel or terminate a request.
368: -- Make sure fnd_global.apps_initialize was called first.
369: --
370: -- Parameters:
371: -- req_id - ID of request to cancel.
372: -- message - Error message.
443: set phase_code = decode(new_status, 'T', phase_code, 'C'),
444: status_code = new_status,
445: completion_text = who_cancelled,
446: last_update_date = sysdate,
447: last_updated_by = fnd_global.user_id
448: where request_id = req_id;
449:
450: cancel_subrequests(req_id, par_req_id, is_sub_req, has_sub_req);
451:
473: -- Name
474: -- toggle_hold
475: -- Purpose
476: -- Toggles the hold flag for a concurrent request.
477: -- Make sure fnd_global.apps_initialize was called first.
478: --
479: -- Parameters:
480: -- req_id - ID of request to toggle.
481: -- message - Error message.
532:
533: update fnd_concurrent_requests
534: set hold_flag = new_hold,
535: last_update_date = sysdate,
536: last_updated_by = fnd_global.user_id
537: where request_id = req_id;
538:
539: commit;
540:
556: -- Name
557: -- alter_priority
558: -- Purpose
559: -- Alters the priority for a concurrent request.
560: -- Make sure fnd_global.apps_initialize was called first.
561: --
562: -- Parameters:
563: -- req_id - ID of request to toggle.
564: -- priority - New priority.
601:
602: update fnd_concurrent_requests
603: set priority = new_priority,
604: last_update_date = sysdate,
605: last_updated_by = fnd_global.user_id
606: where request_id = req_id;
607:
608: commit;
609: