1 PACKAGE IEX_CO_WF AUTHID CURRENT_USER AS
2 /* $Header: IEXRCOWS.pls 120.0 2004/01/24 03:15:18 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
10 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
11 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'IEX_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_CO_WF';
21 G_APP_NAME CONSTANT VARCHAR2(3) := 'IEX';
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL EXCEPTION
25 ---------------------------------------------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL VARIABLES
31 ---------------------------------------------------------------------------
32 wf_yes varchar2(1) := 'Y';
33 wf_no varchar2(1) := 'N';
34
35 ---------------------------------------------------------------------------
36 -- Procedures and Functions
37 ---------------------------------------------------------------------------
38
39 /*Send notification to customer about intent to report to credit bureau*/
40 PROCEDURE notify_customer(itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 resultout out NOCOPY varchar2);
45
46
47 /*report customer to the credit bureau*/
48 PROCEDURE report_customer(itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 resultout out NOCOPY varchar2);
53
54 /*transfers case to external agency*/
55 PROCEDURE transfer_case(itemtype in varchar2,
56 itemkey in varchar2,
57 actid in number,
58 funcmode in varchar2,
59 resultout out NOCOPY varchar2);
60
61 /*review case transfer*/
62 PROCEDURE review_case(itemtype in varchar2,
63 itemkey in varchar2,
64 actid in number,
65 funcmode in varchar2,
66 resultout out NOCOPY varchar2);
67
68 /*review case transfer*/
69 PROCEDURE recall_case(itemtype in varchar2,
70 itemkey in varchar2,
71 actid in number,
72 funcmode in varchar2,
73 resultout out NOCOPY varchar2);
74
75 /** send signal to the main work flow that the custom work flow is over and
76 * also updates the work item
77 **/
78 PROCEDURE wf_send_signal_cancelled(itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 result out NOCOPY varchar2);
83
84 /** send signal to the main work flow that the custom work flow is over and
85 * also updates the work item
86 **/
87 PROCEDURE wf_send_signal_complete(itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funcmode in varchar2,
91 result out NOCOPY varchar2);
92
93
94 --PROCEDURE raise_report_cb_event(p_delinquency_id IN NUMBER);
95
96 END IEX_CO_WF;