[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:
411: -- Name
412: -- cancel_request
413: -- Purpose
414: -- Cancel or terminate a request.
415: -- Make sure fnd_global.apps_initialize was called first.
416: --
417: -- Parameters:
418: -- req_id - ID of request to cancel.
419: -- message - Error message.
490: set phase_code = decode(new_status, 'T', phase_code, 'C'),
491: status_code = new_status,
492: completion_text = who_cancelled,
493: last_update_date = sysdate,
494: last_updated_by = fnd_global.user_id
495: where request_id = req_id;
496:
497: cancel_subrequests(req_id, par_req_id, is_sub_req, has_sub_req);
498:
520: -- Name
521: -- toggle_hold
522: -- Purpose
523: -- Toggles the hold flag for a concurrent request.
524: -- Make sure fnd_global.apps_initialize was called first.
525: --
526: -- Parameters:
527: -- req_id - ID of request to toggle.
528: -- message - Error message.
579:
580: update fnd_concurrent_requests
581: set hold_flag = new_hold,
582: last_update_date = sysdate,
583: last_updated_by = fnd_global.user_id
584: where request_id = req_id;
585:
586: commit;
587:
603: -- Name
604: -- alter_priority
605: -- Purpose
606: -- Alters the priority for a concurrent request.
607: -- Make sure fnd_global.apps_initialize was called first.
608: --
609: -- Parameters:
610: -- req_id - ID of request to toggle.
611: -- priority - New priority.
648:
649: update fnd_concurrent_requests
650: set priority = new_priority,
651: last_update_date = sysdate,
652: last_updated_by = fnd_global.user_id
653: where request_id = req_id;
654:
655: commit;
656: