首页  ·  知识 ·  生产制造
fnd_request.submit_request的用法
网友   http://hi.erp100.com/space-2010-do-blog-id-6766968.html    编辑:德仔   图片来源:网络
FND_REQUEST.SUBMIT_REQUEST 函數是用來提交一個請求的,它返回一個NUMBER值.具體調用如下 :result := fnd_requ
FND_REQUEST.SUBMIT_REQUEST 函數是用來提交一個請求的,它返回一個NUMBER值.具體調用如下
   :result := fnd_request.submit_request(application CHAR, --模快
                                         program CHAR,      --應用程式
                                         description CHAR,   --請求說明(可選)
                                         start_time CHAR,    --RUN 時間(可選)
                                         sub_request BOOLEAN, --立刻提交請求
                                         argument1 CHAR,   --參數1
                                         argument2 CHAR,   --參數2
                                         argument3 CHAR,   --參數3
                                         argument4 CHAR,   --參數4
                                         argument5 CHAR,   --參數5.......
                                         argument100 CHAR);
英文說明(zt oracle) :
Parameters are as follows:

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.

补充说明:
在用fnd_request.submit_request的时候,第五个参数用false,不要被参数名称误导;
这个函数有105个参数,前面五个定义请求本身,后面100个是传递给请求的具体参数,都是Char类型,
我们需要转换,默认值是chr(0),代表这个参数不用传递给调用的请求;
在Package里面调用只需要传递需要的参数个数,因为它有默认值指示结束;
在form里面则不行,要写满105个,而且我们参数结束之后要用一个chr(0)来表示结束 关于fnd_request.submit_request的用法:
FND_REQUEST.SUBMIT_REQUEST 函數是用來提交一個請求的,它返回一個NUMBER值.具體調用如下
   :result := fnd_request.submit_request(application CHAR, --模快
                                         program CHAR,      --應用程式
                                         description CHAR,   --請求說明(可選)
                                         start_time CHAR,    --RUN 時間(可選)
                                         sub_request BOOLEAN, --立刻提交請求
                                         argument1 CHAR,   --參數1
                                         argument2 CHAR,   --參數2
                                         argument3 CHAR,   --參數3
                                         argument4 CHAR,   --參數4
                                         argument5 CHAR,   --參數5.......
                                         argument100 CHAR);
英文說明(zt oracle) :
Parameters are as follows:

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.

补充说明:
在用fnd_request.submit_request的时候,第五个参数用false,不要被参数名称误导;
这个函数有105个参数,前面五个定义请求本身,后面100个是传递给请求的具体参数,都是Char类型,
我们需要转换,默认值是chr(0),代表这个参数不用传递给调用的请求;
在Package里面调用只需要传递需要的参数个数,因为它有默认值指示结束;
在form里面则不行,要写满105个,而且我们参数结束之后要用一个chr(0)来表示结束
本文作者:网友 来源: http://hi.erp100.com/space-2010-do-blog-id-6766968.html
CIO之家 www.ciozj.com 微信公众号:imciow
   
免责声明:本站转载此文章旨在分享信息,不代表对其内容的完全认同。文章来源已尽可能注明,若涉及版权问题,请及时与我们联系,我们将积极配合处理。同时,我们无法对文章内容的真实性、准确性及完整性进行完全保证,对于因文章内容而产生的任何后果,本账号不承担法律责任。转载仅出于传播目的,读者应自行对内容进行核实与判断。请谨慎参考文章信息,一切责任由读者自行承担。
延伸阅读