【EBS】代码提交请求

提交请求

点击(此处)折叠或打开

1. result := fnd_request.submit_request(application, --AP模快
   
2.                                      program, --应用程序
   
3.                                      description, --请求说明(可选)
   
4.                                      start_time, --RUN 时间(可选)
   
5.                                      sub_request, --立刻提交请求
   
6.                                      argument1, --参数1
   
7.                                      argument2, --参数2
   
8.                                      argument3, --参数3
   
9.                                      argument4, --参数4
   
10.                                      argument5, --参数5.......此处省略6-99的参数
    
11.                                      argument100);

 提交成功的情况下，result是请求编号，异常时result=0。

• application:Short name of the application associated with the concurrent request to be submitted.
• program:Short name of the concurrent program (not the executable) for which the request should be submitted.
• description:Description of the request that is displayed in the Concurrent Requests form (Optional.)
• start_time:Time at which the request should start running, formatted as HH24:MI or HH24:MI:SS (Optional.)
• sub_request:Set to TRUE if the request is submitted from another request and should be treated as a sub-request.
• argument1...100:Arguments for the concurrent request; up to 100 arguments are permitted. If submitted from Oracle Forms, you must specify all 100 arguments.

输出请求编号

必须Commit，才能输出结果！

点击(此处)折叠或打开

1. fnd_message.set_string('已提交请求，编号：' || to_char(result));
   
2. fnd_message.show;

等待请求结束

点击(此处)折叠或打开

1. FUNCTION fnd_concurrent.wait_for_request(request_id IN NUMBER DEFAULT NULL, --请求ID
   
2.                                          INTERVAL IN NUMBER DEFAULT 60, --检查时间间隔
   
3.                                          max_wait IN NUMBER DEFAULT 0, --最大等待时间
   
4.                                          phase OUT VARCHAR2,
   
5.                                          status OUT VARCHAR2,
   
6.                                          dev_phase OUT VARCHAR2, --请求运行阶段
   
7.                                          dev_status OUT VARCHAR2, --各个阶段状态
   
8.                                          message OUT VARCHAR2 --运行完成后输出信息
   
9.                                          ) RETURN BOOLEAN;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29599494/viewspace-2106659/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29599494/viewspace-2106659/