nd_request.submit_request
来源:互联网 发布:python能做什么 知乎 编辑:程序博客网 时间:2024/06/10 05:48
http://blog.csdn.net/yanlele424/article/details/41075837
--submit the request 2 l_req_id_fee := fnd_request.submit_request('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) then15 raise l_submit_req;16 else17 --提交请求18 COMMIT;19 --更新状态(只有请求成功,状态才更改)20 UPDATE hek_om_pop_headers_all21 SET flow_status = 'reg_purchase'22 --select * from hek_om_pop_headers_all23 WHERE header_id IN (SELECT h.header_id24 FROM hek_om_pop_headers_v h25 WHERE h.flow_status = 'wait');26 COMMIT; 27 end if;282930 31
1、关于fnd_request.submit_request的用法
fnd_request.submit_request的用法:
FND_REQUEST.SUBMIT_REQUEST 函数是用来提交一个请求的,它返回一个NUMBER值.具体调用如下
:result := fnd_request.submit_request(application CHAR, --AP模快
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('AR',
'SVAINEX_P',
'',
'',
FALSE,
:parameter.invoice_store,
chr(0),
'','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','');
2、Oracle Erp等待报表运行机制
主要是用到了Fnd_concurrent.wait_for_ruqest这个function.
Fnd_concurrent.wait_for_request返回Boolean值,主要参数如下:
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;
dev_phase有Pending,Running,Complete,Inactive等几种,每种对应不同的Dev-Status,比如Complete阶段后就有Normal,Error,Warning,Cancelled,Terminated等几种状态。
例如:
l_request_status := Fnd_Concurrent.Wait_For_Request(l_request_id, 25, 30, 4l_phase, 5l_status, 6l_dev_phase, 7l_dev_status, 8l_message); 910IF l_request_status THEN11IF l_dev_status = 'NORMAL' THEN12NULL;13ELSE14Fnd_Message.Debug('请求运行不成功:'||l_dev_status);15RETURN;16END IF;17ELSE18Fnd_Message.Debug('请求未完成,无法查看报表内容!');19RETURN;20END IF;2122Editor_Pkg.Report(l_request_id,'Y');23
总结:FND_REQUEST.SUBMIT_REQUEST是一种通过后台方式提交请教的方法,可以在pkg和form中使用,在form中使用要将参数写全。 FND_CONCURRENT.WAIT_FOR_REQUEST是一个等待当前请求运行完毕的程序,可以利用这个等待当前的请求程序运行完毕再运行下面的程序。
有时候提交请求一直会返回0的情况:
检查是否有初始化环境:
SELECT user_id
INTO l_num_user_id
FROM applsys.fnd_user
WHERE user_name ='user_name';
SELECT responsibility_id
INTO l_num_resp_id
FROM apps.fnd_responsibility_vl
WHERE responsibility_name ='responsibility_name';
SELECT application_id
INTO l_num_resp_appl_id
FROM applsys.fnd_application
WHERE application_short_name = 'app_short_name';
fnd_global.apps_initialize (user_id => l_num_user_id,
resp_id => l_num_resp_id,
resp_appl_id => l_num_resp_appl_id
);
- nd_request.submit_request
- fnd_request.submit_request
- FND_REQUEST.SUBMIT_REQUEST in R12
- Oracle-Fnd_request.submit_request
- fnd_request.submit_request 的用法
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST
- Oracle EBS fnd_request.submit_request 与 Fnd_concurrent.wait_for_ruqest
- fnd_request.submit_request 在pl/sql中调用请求
- Oracle Submit Request - 请求的调用方法: FND_REQUEST.SUBMIT_REQUEST
- Oracle Submit Request - 请求的调用方法: FND_REQUEST.SUBMIT_REQUEST
- ORACLE ERP中 关于FND_REQUEST.SUBMIT_REQUEST和 FND_CONCURRENT.WAIT_FOR_REQUEST 的介绍与用法
- EBS Form开发中点击按钮提交请求报表的实现方式--fnd_request.submit_request
- 第十七周项目四日期结构体(2)两个人的生日相差多少天
- Android开发中的SQLite事务处理,即beginTransaction()方法
- 20T大文件挂载
- 将后台数据显示到前台页面的方法springmvc+hibernate+spring
- Matlab数组、矩阵技巧
- nd_request.submit_request
- 数据库网站统计之mysql计数器优化【转载-单曲兄弟的博文】
- iOS 获取MAC地址 iOS < 7
- 解决QT中无边框窗口播放视频时调用showMinimized最小化恢复后冻结窗口
- 工作中遇到的IE6兼容性问题及解决办法
- Codeforces Round #283 (Div. 2) E
- 实现中文字串截取无乱码的方法
- GNU GCC 实用工具 ar 的参数的意义
- Android 音频的播放之一