oracle 提交请求集,手动提交请求集(REQUEST_SET)如何实现

下面的代码应该对你用吧，可以上developer guide上看看

success := fnd_submit.set_request_set('CDAR','FNDRSSUB1284');

If (success)  then

success := fnd_submit.submit_program('CDAR','CDARLGSPBK','STAGE10',

CHR(0),'','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','' );

If  (success) then

success := fnd_submit.submit_program('CDAR','CDARLGTR','STAGE20',v_control_id,

CHR(0),'','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','',

'','','','','','','','','','' );

end if;

end if;

v_request_id := fnd_submit.submit_set(null,FALSE);