FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrent
program in ORACLE Applications.
Parameters:
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.
Example: Submission of Standard Order Import Program
SET SERVEROUTPUT
ON;
DECLARE
v_request_id
NUMBER
DEFAULT0;
--Order Import Parameters
p_operating_unit
VARCHAR2(20)
:=NULL;
p_order_source
VARCHAR2(20)
:='XYZ';
p_orig_sys_document_ref
VARCHAR2(20)
:=NULL;
p_operation_code
VARCHAR2(20)
:=NULL;
p_validate_only
VARCHAR2(20)
:='N';
p_debug_level
VARCHAR2(20)
:='1';
p_num_instances
VARCHAR2(20)
:='4';
p_sold_to_org_id
VARCHAR2(20)
:=NULL;
p_sold_to_org
VARCHAR2(20)
:=NULL;
p_change_sequence VARCHAR2(20)
:=NULL;
p_perf_param
VARCHAR2(20)
:='Y';
p_rtrim_data
VARCHAR2(20)
:='N';
p_pro_ord_with_null_flag
VARCHAR2(20)
:='Y';
p_default_org_id
VARCHAR2(20)
:='83';
p_validate_desc_flex
VARCHAR2(20)
:='N';
-- End of Parameters -----
v_context varchar2(100);
FUNCTION set_context(
i_user_name IN
VARCHAR2
,i_resp_name
IN
VARCHAR2
,i_org_id
IN
NUMBER)
RETURNVARCHAR2
IS
/* Inorder to reduce the
content of the post I moved the implementation part of this function to another post and it is
available here */
END set_context;
BEGIN
-- Setting the context ----
v_context
:= set_context('&V_USER_NAME','&V_RESPONSIBILITY',82);
IF v_context
='F'
THEN
DBMS_OUTPUT.PUT_LINE('Error
while setting the context');
ENDIF;
DBMS_OUTPUT.PUT_LINE('Submit
Order Import Concurrent Program');
v_request_id:=
FND_REQUEST.SUBMIT_REQUEST
(
application
=>
'ONT'
,program
=>
'OEOIMP'
,description
=>
'Order Import'
,start_time
=>
SYSDATE
,sub_request
=>
NULL
,argument1
=>
p_operating_unit
,argument2
=>
p_order_source
,argument3
=>
p_orig_sys_document_ref
,argument4
=>
p_operation_code
,argument5
=>
p_validate_only
,argument6
=>
p_debug_level
,argument7
=>
p_num_instances
,argument8
=>
p_sold_to_org_id
,argument9
=>
p_sold_to_org
,argument10
=>
p_change_sequence
,argument11
=>
p_perf_param
,argument12
=>
p_rtrim_data
,argument13
=>
p_pro_ord_with_null_flag
,argument14
=>
p_default_org_id
,argument15
=>
p_validate_desc_flex
);
COMMIT;
DBMS_OUTPUT.PUT_LINE('Request_id:
'||v_request_id);
EXCEPTIONWHENOTHERSTHEN
DBMS_OUTPUT.PUT_LINE(SQLCODE||'
Error :'||SQLERRM);
END;
分享到:
相关推荐
1 手动提交Request 在Form里面,我们可以用 APPS.FND_REQUEST.SUBMIT_REQUEST 提交一个Request到Oracle Request Manager。 如果提交成功,该函数返回Request ID,否则,返回0。
--创建触发器 create or replace trigger trigger_customerLink before insert on customerLink_table for each row when (new.id is null) begin select seq_link_id.nextval into:new.id from dual;...
今天学到在系统中定义的消息不仅可以当作普通的消息来引用展示(如文章以下所有内容),还可以把它当作一个固定变量来使用 ,通过使用FND_MESSAGE.SET_NAME和FND_MESSAGE.GET。 例如以下代码是把系统中定义的GME_...
Hi, This is Verilog practice code
SOA Using Java Web Services 英文版原文
* fnd_flex_value_sets * fnd_flex_values * fnd_flex_values_vl ----弹性域 * fnd_id_flexs * fnd_id_flex_structures where id_flex_code=""GL#"" * fnd_id_flex_segments where id_flex_code=""GL#"" and id...
FND_MESSAGE PACKAGE 这个包是使用 消息字典 api
File find componet for delphi
OracleEBSFlexField弹性域技术专题
Download Patch 13602850 (p13602850_R12_GENERIC.zip) into a temporary directory. Run the following command: perl $FND_TOP/patch/115/bin/IREPParserSetup.pl When prompted, provide the temporary ...
oracle 官方网络培训资料(财务部分中文版) for FA
EN_ITIL4_FND_考试样卷答案及解析
EBS_FND_单据序列和序列分配API开发,包括详细的代码(建表/验证数据/塞入正是表等)。
EBSR12 系统管理员 安装 维护 教程
Directory: VHDL-FPGA-VerilogPlat: VHDLSize: 27KB
用vc编写的关于模态和非模态的实例,对学习模态和非模态
详细阐述欧拉法解微分方程组的编程过程,相对于使用ode函数,更能体现到控制运行的机制。
本人常用sql,做编译用,33333333333q
此针对于oracle ebs的值集进行详细的讲解
EBS 并发请求