通过代码调用并发请求

1、调用请求，成功并跳转到请求界面
l_reqid := fnd_request.submit_request(‘CUX’
,’CUX70INVITF’
,:wms_manage.description
,NULL
,FALSE
,:wms_manage.subinventory_code
,rec.organization_id
,:wms_manage.description
,to_char(:wms_manage.disabled_date
,’yyyy-mm-dd’)
,:wms_manage.attribute_code
,chr(0));

IF l_reqid > 0 THEN lb_commit := app_form.quietcommit;
fnd_function.execute(function_name => ‘FND_FNDRSRUN’
,open_flag => ‘Y’
,session_flag => ‘Y’
,other_params => ‘CONCURRENT_PROGRAM_NAME=”CUXDISIBP”
PROGRAM_APPL_SHORT_NAME=”CUX” DODT_REQ_ID=”’ ||
to_char(l_reqid) || ‘”’);
ELSE
fnd_message.set_string(‘提交并发失败!’);
fnd_message.error;
RAISE form_trigger_failure;
END IF;

2、提交请求后跳转到请求界面
fnd_function.execute(function_name => ‘FND_FNDRSRUN’,
open_flag => ‘Y’,
session_flag => ‘Y’,
other_params => ‘DODT_REQ_ID=’ || l_reqid || ’ ’ || ‘PROGRAM_APPL_SHORT_NAME=”CUX”’ || ’ ’ ||
‘CONCURRENT_PROGRAM_NAME=”CUXCFG007”’);