FND_CONCURRENT.WAIT_FOR_REQUEST的说明

以下部分英文说明来自Oracle EBS Developer's Guide

1: function FND_CONCURRENT.WAIT_FOR_REQUEST

   2:  (request_id IN number default NULL,

   3:            interval   IN number default 60,

   4:            max_wait   IN number default 0,

   5:            phase      OUT varchar2,

   6:            status     OUT varchar2,

   7:            dev_phase  OUT varchar2,

   8:            dev_status OUT varchar2,

   9:            message    OUT varchar2) return  

  10:  boolean;

Description  Waits for request completion, then returns the request phase/status and completion message to the caller. Goes to sleep between checks for request completion.

Arguments (input)
request_id            The request ID of the request to wait on.

interval                  Number of seconds to wait between checks (i.e., number of  seconds to sleep.)

max_wait             The maximum time in seconds to wait for the request's completion.

Arguments (output)
phase                   The user-friendly request phase from the FND_LOOKUPS table.

status                   The user-friendly request status from the FND_LOOKUPS table.

dev_phase          The request phase as a constant string that can be used for program logic comparisons.

dev_status          The request status as a constant string that can be used for program logic comparisons.

message              The completion message supplied if the request has already completed.

dev_phase有Pending,Running,Complete,Inactive等几种，每种对应不同的Dev-Status，比如Complete阶段后就有Normal,Error,Warning,Cancelled,Terminated等几种状态。