[Home] [Help]
PACKAGE: APPS.OKC_OUTCOME_INIT_PVT
Source
1 Package OKC_OUTCOME_INIT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCROCES.pls 120.2 2010/07/12 12:05:45 skuchima ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
8 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
11 G_WORKFLOW_ACTIVE CONSTANT VARCHAR2(200) := 'OKC_WORKFLOW_ACTIVE';
12 G_WF_NAME_TOKEN CONSTANT VARCHAR2(200) := 'WF_ITEM';
13 G_WF_P_NAME_TOKEN CONSTANT VARCHAR2(200) := 'WF_PROCESS';
14 G_PROCESS_NOTFOUND CONSTANT VARCHAR2(200) := 'OKC_PROCESS_NOT_FOUND';
15 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
16 G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_OUTCOME_INIT_PVT';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22
23 --Global exception
24 G_EXCEPTION EXCEPTION;
25
26 -- subtype definitions
27 subtype msg_rec_typ is okc_aq_pvt.msg_rec_typ;
28 subtype msg_tab_typ is okc_aq_pvt.msg_tab_typ;
29 subtype corrid_rec_typ is okc_aq_pvt.corrid_rec_typ;
30
31 --Declare a record tupe
32 TYPE p_outcomerec_type IS RECORD(
33 name okc_process_def_parameters_v.name%TYPE,
34 data_type okc_process_def_parameters_v.data_type%TYPE,
35 value okc_process_def_parameters_v.default_value%TYPE);
36 TYPE p_outcometbl_type IS TABLE OF p_outcomerec_type
37 INDEX BY BINARY_INTEGER;
38
39 -- Fire an outcome for a condition occurrence
40 PROCEDURE Launch_outcome(p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42 p_corrid_rec IN corrid_rec_typ,
43 p_msg_tab_typ IN msg_tab_typ,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 --Execute a plsql procedure
49 PROCEDURE Launch_plsql(p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51 p_outcome_name IN VARCHAR2,
52 p_outcome_tbl IN p_outcometbl_type,
53 x_proc OUT NOCOPY VARCHAR2,
54 --NPALEPU
55 --14-DEC-2005
56 --Added new parameter X_PROC_NAME for bug # 4699009.
57 x_proc_name OUT NOCOPY VARCHAR2,
58 --END NPALEPU
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2);
62
63 --Launch a workflow
64 PROCEDURE Launch_workflow(p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66 p_outcome_name IN VARCHAR2,
67 p_outcome_tbl IN p_outcometbl_type,
68 x_proc OUT NOCOPY VARCHAR2,
69 --NPALEPU
70 --14-DEC-2005
71 --Added new parameter X_PROC_NAME for bug # 4699009.
72 x_proc_name OUT NOCOPY VARCHAR2,
73 --END NPALEPU
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 ---Called from the concurrent Program tocreate the OKCLAERT workflow processes Bug9724454
79 PROCEDURE submit_da_wf_mgr(errbuf OUT NOCOPY VARCHAR2,
80 retcode OUT NOCOPY VARCHAR2);
81
82
83 End okc_outcome_init_pvt;