fnd_request.submit_request 的用法

最新推荐文章于 2022-06-06 13:07:23 发布

xywang_sunny

最新推荐文章于 2022-06-06 13:07:23 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle ebs

本文链接：https://blog.youkuaiyun.com/wangxiaoyan_1991/article/details/17279069

Oracle ebs 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了 Oracle E-Business Suite 中 fnd_request.submit_request 过程的使用方法及参数说明，帮助开发者理解如何正确地提交并发请求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


 --submit the request
 2      l_req_id_fee := fnd_request.submit_request('PO',--po模块
 3                                                 'REQIMPORT',
 4                                                 '',
 5                                                 '',
 6                                                 FALSE,
 7                                                 'POP_REQUEST',
 8                                                 to_char(SYSDATE, 'YYYYMMDD'),
 9                                                 'ALL',
10                                                 '',
11                                                 'N',
12                                                 'N');
13      
14      if (l_req_id_fee is null) or (l_req_id_fee = 0) then
15         raise l_submit_req;
16      else
17         --提交请求
18         COMMIT;
19         --更新状态(只有请求成功，状态才更改)
20         UPDATE hek_om_pop_headers_all
21         SET flow_status = 'reg_purchase'
22         --select * from hek_om_pop_headers_all
23         WHERE header_id IN (SELECT h.header_id
24                               FROM hek_om_pop_headers_v h
25                              WHERE h.flow_status = 'wait');
26         COMMIT;         
27      end if;

fnd_request.submit_request 的简单用法：

参数说明：

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.

注意：

在 Package 里面调用只需要传递需要的参数个数，因为它有默认值指示结束；
在 form 里面则不行，要写满 105 个，而且我们参数结束之后要用一个 chr(0) 来表示结束