提交请求
点击(此处)折叠或打开
-
result := fnd_request.submit_request(application, --AP模快
-
program, --应用程序
-
description, --请求说明(可选)
-
start_time, --RUN 时间(可选)
-
sub_request, --立刻提交请求
-
argument1, --参数1
-
argument2, --参数2
-
argument3, --参数3
-
argument4, --参数4
-
argument5, --参数5.......此处省略6-99的参数
- argument100);
- 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，才能输出结果！
点击(此处)折叠或打开
-
fnd_message.set_string('已提交请求，编号：' || to_char(result));
- fnd_message.show;
等待请求结束
点击(此处)折叠或打开
-
FUNCTION fnd_concurrent.wait_for_request(request_id IN NUMBER DEFAULT NULL, --请求ID
-
INTERVAL IN NUMBER DEFAULT 60, --检查时间间隔
-
max_wait IN NUMBER DEFAULT 0, --最大等待时间
-
phase OUT VARCHAR2,
-
status OUT VARCHAR2,
-
dev_phase OUT VARCHAR2, --请求运行阶段
-
dev_status OUT VARCHAR2, --各个阶段状态
-
message OUT VARCHAR2 --运行完成后输出信息
- ) RETURN BOOLEAN;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29599494/viewspace-2106659/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
【EBS】模拟登录
请登录后发表评论
登录
全部评论
