[Home] [Help]
PACKAGE: APPS.OKL_REQ_WF
Source
1 PACKAGE OKL_REQ_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRRQWS.pls 115.2 2002/11/30 08:58:53 spillaip noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
9 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
10 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
11 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
12 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
13 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
14 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
16 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_REQ_WF';
21 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
22
23 ---------------------------------------------------------------------
24 -- GLOBAL EXCEPTION
25 ------------------------------------------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27
28 --------------------------------------------------------------------------
29 -- Concurrent API to invoke the workflow for requesting approval of a Cure
30 ---------------------------------------------------------------------------
31
32 PROCEDURE invoke_workflow(
33 errbuf OUT NOCOPY VARCHAR2,
34 retcode OUT NOCOPY NUMBER);
35 ---------------------------------------------------------------------------
36
37 PROCEDURE raise_request_business_event( p_trans_id IN NUMBER);
38
39
40 PROCEDURE Request_Approved(itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 resultout out nocopy varchar2 );
45 PROCEDURE Request_Rejected(itemtype in varchar2,
46 itemkey in varchar2,
47 actid in number,
48 funcmode in varchar2,
49 resultout out nocopy varchar2);
50
51 PROCEDURE populate_notif_attributes(itemtype in varchar2,
52 itemkey in varchar2,
53 actid in number,
54 funcmode in varchar2,
55 resultout out nocopy varchar2);
56
57 END OKL_REQ_WF;