240: -- COMMENT: Wrapper around call to FND_CONCURRENT.GET_REQUEST_STATUS
241: -- ======================================================================
242: PROCEDURE get_request_info
243: (
244: p_request_id IN fnd_concurrent_requests.request_id%TYPE,
245: x_phase OUT NOCOPY VARCHAR2,
246: x_status OUT NOCOPY VARCHAR2,
247: x_devphase OUT NOCOPY VARCHAR2,
248: x_devstatus OUT NOCOPY VARCHAR2,
247: x_devphase OUT NOCOPY VARCHAR2,
248: x_devstatus OUT NOCOPY VARCHAR2,
249: x_message OUT NOCOPY VARCHAR2
250: ) IS
251: l_request_id fnd_concurrent_requests.request_id%TYPE;
252: l_success BOOLEAN;
253: BEGIN
254:
255: l_request_id := p_request_id;
357: -- that can be used for comparisons
358: -- ======================================================================
359: FUNCTION get_request_internal_status
360: (
361: p_request_id IN fnd_concurrent_requests.request_id%TYPE
362: ) RETURN VARCHAR2 IS
363: l_phase VARCHAR2(80);
364: l_status VARCHAR2(80);
365: l_devphase VARCHAR2(30);
400: -- COMMENT: Returns a displayable status for the concurrent request
401: -- ======================================================================
402: FUNCTION get_request_display_status
403: (
404: p_request_id IN fnd_concurrent_requests.request_id%TYPE
405: ) RETURN VARCHAR2 IS
406: l_phase VARCHAR2(80);
407: l_status VARCHAR2(80);
408: l_devphase VARCHAR2(30);
519: -- FND_CONCURRENT.CANCEL_REQUEST
520: -- ======================================================================
521: FUNCTION cancel_concurrent_request
522: (
523: p_request_id IN fnd_concurrent_requests.request_id%TYPE
524: ) RETURN VARCHAR2 IS
525: l_success BOOLEAN;
526: l_message VARCHAR2(255);
527: BEGIN