1 PACKAGE OKL_CO_WF AUTHID CURRENT_USER AS
2 /* $Header: OKLRCOWS.pls 115.2 2002/12/18 06:16:24 spillaip 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) := 'OKL_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) := 'OKL_CO_WF';
21 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
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 /*checks for syndication*/
40 PROCEDURE get_syndicate_flag(itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 resultout out nocopy varchar2);
45
46 /*checks if case can be sent to third party*/
47 PROCEDURE get_sendtothirdparty_flag(itemtype in varchar2,
48 itemkey in varchar2,
49 actid in number,
50 funcmode in varchar2,
51 resultout out nocopy varchar2);
52
53 /*checks if vendor approval is required to send the case
54 **to third party*/
55 PROCEDURE get_vendorapproval_flag(itemtype in varchar2,
56 itemkey in varchar2,
57 actid in number,
58 funcmode in varchar2,
59 resultout out nocopy varchar2);
60
61 /*checks if vendor notification is required after sending the case
62 **to third party*/
63 PROCEDURE get_vendornotify_flag(itemtype in varchar2,
64 itemkey in varchar2,
65 actid in number,
66 funcmode in varchar2,
67 resultout out nocopy varchar2);
68
69 /*returns vendor information*/
70 PROCEDURE get_vendor_info(p_case_number in varchar2,
71 x_vendor_id out nocopy number,
72 x_vendor_name out nocopy varchar2,
73 x_vendor_email out nocopy varchar2,
74 x_return_status out nocopy varchar2);
75
76 /*Send notification to customer about intent to report to credit bureau*/
77 PROCEDURE notify_customer(itemtype in varchar2,
78 itemkey in varchar2,
79 actid in number,
80 funcmode in varchar2,
81 resultout out nocopy varchar2);
82
83 /*procedure to halt flow for a specific period of time*/
84 PROCEDURE wait_before_report(itemtype in varchar2,
85 itemkey in varchar2,
86 actid in number,
87 funcmode in varchar2,
88 resultout out nocopy varchar2);
89
90 /*report customer to the credit bureau*/
91 PROCEDURE report_customer(itemtype in varchar2,
92 itemkey in varchar2,
93 actid in number,
94 funcmode in varchar2,
95 resultout out nocopy varchar2);
96
97 /*sends email to obtain vendor approval*/
98 PROCEDURE send_vendor_approval(itemtype in varchar2,
99 itemkey in varchar2,
100 actid in number,
101 funcmode in varchar2,
102 resultout out nocopy varchar2);
103
104 /*transfers case to external agency*/
105 PROCEDURE transfer_case(itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funcmode in varchar2,
109 resultout out nocopy varchar2);
110
111 /*review case transfer*/
112 PROCEDURE review_case(itemtype in varchar2,
113 itemkey in varchar2,
114 actid in number,
115 funcmode in varchar2,
116 resultout out nocopy varchar2);
117
118 /*review case transfer*/
119 PROCEDURE recall_case(itemtype in varchar2,
120 itemkey in varchar2,
121 actid in number,
122 funcmode in varchar2,
123 resultout out nocopy varchar2);
124
125 /*sends email to notify vendor about action taken against a case*/
126 PROCEDURE send_vendor_notify(itemtype in varchar2,
127 itemkey in varchar2,
128 actid in number,
129 funcmode in varchar2,
130 resultout out nocopy varchar2);
131
132 /** send signal to the main work flow that the custom work flow is over and
133 * also updates the work item
134 **/
135 PROCEDURE wf_send_signal_cancelled(itemtype in varchar2,
136 itemkey in varchar2,
137 actid in number,
138 funcmode in varchar2,
139 result out nocopy varchar2);
140
141 /** send signal to the main work flow that the custom work flow is over and
142 * also updates the work item
143 **/
144 PROCEDURE wf_send_signal_complete(itemtype in varchar2,
145 itemkey in varchar2,
146 actid in number,
147 funcmode in varchar2,
148 result out nocopy varchar2);
149
150 FUNCTION get_party_name(p_case_number in varchar2) RETURN VARCHAR2;
151 PRAGMA RESTRICT_REFERENCES(get_party_name, WNDS);
152
153 FUNCTION get_case_contracts(p_case_number in varchar2) RETURN VARCHAR2;
154 PRAGMA RESTRICT_REFERENCES(get_case_contracts, WNDS);
155
156 FUNCTION get_case_total_value(p_case_number in varchar2) RETURN NUMBER;
157 PRAGMA RESTRICT_REFERENCES(get_case_total_value, TRUST);
158
159 FUNCTION get_amt_overdue(p_case_number in varchar2) RETURN NUMBER;
160 PRAGMA RESTRICT_REFERENCES(get_amt_overdue, WNDS);
161
162 FUNCTION get_vendor_name(p_case_number in varchar2) RETURN VARCHAR2;
163 PRAGMA RESTRICT_REFERENCES(get_vendor_name, WNDS);
164
165 --PROCEDURE raise_report_cb_event(p_delinquency_id IN NUMBER);
166
167 END OKL_CO_WF;