How To Submit A Concurrent Request Set Using FND_SUBMIT.SUBMIT_PROGRAM (文档 ID 382791.1)

最新推荐文章于 2023-09-21 21:20:37 发布

kikiwhq

最新推荐文章于 2023-09-21 21:20:37 发布

阅读量592

点赞数

分类专栏： SA 文章标签： SA

SA 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

How To Submit A Concurrent Request Set Using FND_SUBMIT.SUBMIT_PROGRAM (文档 ID 382791.1)

转到底部

In this Document

Goal

Solution

APPLIES TO:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 23-FEB-2014

GOAL

How to submit a concurrent request set using FND_SUBMIT.SUBMIT_PROGRAM?

SOLUTION

First you need to create the request set using the Applications' forms then it can be submitted using the API.

Here is a sample program that submits a request set that has three stages each of which submits FNDSCURS - Active Users:

CREATE OR REPLACE PACKAGE BODY k_req_test AS
PROCEDURE k_req_test_submit(errbuf OUT VARCHAR2, retcode OUT NUMBER) IS

req_id number := 0;
vResult boolean;

BEGIN

vResult := fnd_submit.set_request_set('FND','FNDRSSUB843');

vResult := fnd_submit.submit_program('FND', 'FNDSCURS', 'STAGE10', CHR(0));
vResult := fnd_submit.submit_program('FND', 'FNDSCURS', 'STAGE20', CHR(0));
vResult := fnd_submit.submit_program('FND', 'FNDSCURS', 'STAGE30', CHR(0));

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

END k_req_test_submit;
END k_req_test;