1 PACKAGE AR_CMGT_UTIL AS
2 /* $Header: ARCMUTLS.pls 120.20.12010000.2 2008/09/24 15:09:43 mraymond ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 /* Bug 2855292 */
9 TYPE ocm_global_setup_options IS RECORD
10 ( aging_bucket_id ar_cmgt_setup_options.aging_bucket_id%TYPE,
11 default_credit_classification
12 ar_cmgt_setup_options.default_credit_classification%TYPE,
13 default_exchange_rate_type
14 ar_cmgt_setup_options.default_exchange_rate_type%TYPE,
15 match_rule_id ar_cmgt_setup_options.match_rule_id%TYPE,
16 cer_dso_days ar_cmgt_setup_options.cer_dso_days%TYPE,
17 period ar_cmgt_setup_options.period%TYPE,
18 auto_application_num_flag
19 ar_cmgt_setup_options.auto_application_num_flag%TYPE
20 );
21
22 TYPE t_ocm_global_setup_options IS TABLE OF ocm_global_setup_options
23 INDEX BY BINARY_INTEGER;
24
25 pg_ocm_global_setup_options t_ocm_global_setup_options;
26
27 /*=======================================================================+
28 | Declare PUBLIC Exceptions
29 +=======================================================================*/
30
31 PROCEDURE debug (
32 p_message IN VARCHAR2,
33 p_module_name IN VARCHAR2 default 'ar.cmgt.plsql.AR_CMGT_UTIL',
34 p_log_level IN NUMBER default fnd_log.level_statement);
35
36 PROCEDURE wf_debug (p_process_name IN VARCHAR2,
37 p_message IN VARCHAR2);
38
39 /*========================================================================
40 | PUBLIC FUNCTION
41 | get_wf_debug_flag()
42 | DESCRIPTION
43 | This function checks both AFLOG_ENABLED and AR_CMGT_WF_DEBUG
44 | profiles and returns Y if either are set. Internally,
45 | we handle the logging for either (or both) methods.
46 |
47 | PSEUDO CODE/LOGIC
48 |
49 | PARAMETERS
50 | debug_flag OUT Y or N
51 |
52 | KNOWN ISSUES
53 |
54 | NOTES
55 |
56 | MODIFICATION HISTORY
57 | Date Author Description of Changes
58 | 10-APR-2008 M Raymond Created
59 |
60 *=======================================================================*/
61
62 FUNCTION get_wf_debug_flag
63 RETURN VARCHAR2;
64
65 /*========================================================================
66 | PUBLIC FUNCTION
67 | check_user_resource()
68 | DESCRIPTION
69 | This function checks whether resource id passed is for the user who
70 | is logged.
71 |
72 | PSEUDO CODE/LOGIC
73 |
74 | PARAMETERS
75 | p_credit_analyst_id IN Credit Analyst Id of the case folder
76 |
77 | KNOWN ISSUES
78 |
79 | NOTES
80 |
81 | MODIFICATION HISTORY
82 | Date Author Description of Changes
83 | 20-May-2002 S.Nambiar Created
84 |
85 *=======================================================================*/
86 FUNCTION check_update_permissions(p_credit_analyst_id IN NUMBER,
87 p_requestor_id IN NUMBER,
88 p_credit_request_status IN VARCHAR2 )
89 RETURN VARCHAR2;
90
91 /* Overloaded Function */
92 FUNCTION check_update_permissions(p_credit_analyst_id IN NUMBER,
93 p_requestor_id IN NUMBER)
94 RETURN VARCHAR2;
95 /*========================================================================
96 | PUBLIC FUNCTION
97 | check_emp_credit_analyst()
98 | DESCRIPTION
99 | This function checks whether employee id passed is a credit analyst
100 | or not
101 | PSEUDO CODE/LOGIC
102 |
103 | PARAMETERS
104 | p_employee_id IN Employee Id of the user logged in
105 |
106 | KNOWN ISSUES
107 |
108 | NOTES
109 |
110 | MODIFICATION HISTORY
111 | Date Author Description of Changes
112 | 20-May-2002 S.Nambiar Created
113 |
114 *=======================================================================*/
115 FUNCTION check_emp_credit_analyst(p_employee_id IN NUMBER )
116 RETURN VARCHAR2;
117
118 FUNCTION check_emp_credit_analyst
119 RETURN VARCHAR2;
120
121
122 /*========================================================================
123 | PUBLIC FUNCTION
124 | check_credit_analyst()
125 | DESCRIPTION
126 | This function checks whether resource_id passed is a credit analyst.
127 | For a credit analysts there will be a credit analyst role assigned
128 | in resource manager.
129 |
130 | PSEUDO CODE/LOGIC
131 |
132 | PARAMETERS
133 | p_resource_id IN resource_id
134 |
135 | KNOWN ISSUES
136 |
137 | NOTES
138 |
139 | MODIFICATION HISTORY
140 | Date Author Description of Changes
141 | 20-May-2002 S.Nambiar Created
142 |
143 *=======================================================================*/
144 FUNCTION check_credit_analyst(p_resource_id IN NUMBER )
145 RETURN VARCHAR2;
146
147
148 /*========================================================================
149 | PUBLIC FUNCTION
150 | find_analysis_level()
151 | DESCRIPTION
152 | This function checks tells you whether the analysis is at the
153 | party, customer account, or account site level.
154 |
155 | PSEUDO CODE/LOGIC
156 |
157 | PARAMETERS
158 | p_party_id IN Party Id
159 | p_cust_account_id IN Customer Account Id
160 | p_cust_acct_site_id IN Customer Account Site Id
161 |
162 | KNOWN ISSUES
163 |
164 | NOTES
165 |
166 | MODIFICATION HISTORY
167 | Date Author Description of Changes
168 | 10-Jun-2003 M.Senthil Created
169 |
170 *=======================================================================*/
171 FUNCTION find_analysis_level(p_party_id IN NUMBER,
172 p_cust_account_id IN NUMBER,
173 p_cust_acct_site_id IN NUMBER)
174 RETURN VARCHAR2;
175
176
177 /*========================================================================
178 | PUBLIC FUNCTION
179 | get_limit_currency()
180 | DESCRIPTION
181 | This function takes in some parameters and fills in the appropriate
182 | values regarding which currency is returned.
183 |
184 | PSEUDO CODE/LOGIC
185 |
186 | PARAMETERS
187 | p_party_id IN Party Id
188 | p_cust_account_id IN Customer Account Id
189 | p_cust_acct_site_id IN Customer Account Site Id
190 | p_trx_currency_code IN Transaction Currency Code
191 |
192 | KNOWN ISSUES
193 |
194 | NOTES
195 |
196 | MODIFICATION HISTORY
197 | Date Author Description of Changes
198 | 10-Jun-2003 M.Senthil Created
199 |
200 *=======================================================================*/
201 PROCEDURE get_limit_currency(
202 p_party_id IN NUMBER,
203 p_cust_account_id IN NUMBER,
204 p_cust_acct_site_id IN NUMBER,
205 p_trx_currency_code IN VARCHAR2,
206 p_limit_curr_code OUT nocopy VARCHAR2,
207 p_trx_limit OUT nocopy NUMBER,
208 p_overall_limit OUT nocopy NUMBER,
209 p_cust_acct_profile_amt_id OUT nocopy NUMBER,
210 p_global_exposure_flag OUT nocopy VARCHAR2,
211 p_include_all_flag OUT nocopy VARCHAR2,
212 p_usage_curr_tbl OUT nocopy HZ_CREDIT_USAGES_PKG.curr_tbl_type,
213 p_excl_curr_list OUT nocopy VARCHAR2
214 );
215
216
217 FUNCTION get_latest_cf_number(p_credit_request_id IN NUMBER)
218 RETURN NUMBER;
219
220 PROCEDURE get_no_of_ref_data_points(
221 p_credit_classification IN VARCHAR2,
222 p_review_type IN VARCHAR2,
223 p_data_point_id IN NUMBER,
224 p_number_of_references OUT NOCOPY NUMBER,
225 p_value OUT NOCOPY VARCHAR2 );
226
227
228 PROCEDURE copy_checklist_data_points(
229 p_new_check_list_id IN VARCHAR2,
230 p_old_check_list_id IN VARCHAR2);
231
232 FUNCTION IS_DUPLICATE_CHECKLIST (
233 p_credit_classification IN VARCHAR2,
234 p_review_type IN VARCHAR2,
235 p_start_date IN DATE)
236 return VARCHAR2;
237
238 FUNCTION is_valid_date (
239 p_start_date IN DATE,
240 p_end_date IN DATE)
241 return NUMBER;
242
243 FUNCTION get_fnd_user_name (
244 p_user_id IN NUMBER )
245 return VARCHAR2;
246
247 FUNCTION get_credit_analyst_name(p_credit_analyst_id IN NUMBER)
248 RETURN VARCHAR2;
249
250 FUNCTION check_delete_permissions(p_credit_analyst_id IN NUMBER,
251 p_requestor_id IN NUMBER,
252 p_credit_request_status IN VARCHAR2 )
253 RETURN VARCHAR2;
254
255 FUNCTION get_person_based_on_resource ( l_resource_id IN NUMBER)
256 return NUMBER;
257
261 FUNCTION check_casefolder_exists(p_party_id IN NUMBER,
258 FUNCTION get_person_based_on_cf ( l_case_folder_id IN NUMBER)
259 return NUMBER;
260
262 p_cust_account_id IN NUMBER,
263 p_cust_account_site_id IN NUMBER)
264 return VARCHAR2;
265
266 FUNCTION IsApplicationExists(
267 p_party_id IN NUMBER,
268 p_cust_account_id IN NUMBER,
269 p_site_use_id IN NUMBER)
270 return VARCHAR2;
271
272 FUNCTION get_score_summary(p_case_folder_id IN NUMBER)
273 RETURN NUMBER;
274
275 FUNCTION get_credit_classification(p_party_id IN NUMBER,
276 p_cust_account_id IN NUMBER,
277 p_site_use_id IN NUMBER)
278 RETURN VARCHAR2;
279
280 PROCEDURE CLOSE_WF_NOTIFICATION (
281 p_credit_request_id IN NUMBER,
282 p_message_name IN VARCHAR2,
283 p_recipient_role IN VARCHAR2,
284 p_resultout OUT NOCOPY VARCHAR2,
285 p_error_msg OUT NOCOPY VARCHAR2);
286
287
288 FUNCTION convert_amount ( p_from_currency VARCHAR2,
289 p_to_currency VARCHAR2,
290 p_conversion_date DATE,
291 p_conversion_type VARCHAR2 DEFAULT NULL,
292 p_amount NUMBER )
293 RETURN NUMBER;
294
295 FUNCTION get_setup_option(p_detail_type IN VARCHAR2)
296 RETURN VARCHAR2;
297
298 PROCEDURE OM_CUST_APPLY_HOLD (
299 p_party_id IN NUMBER,
300 p_cust_account_id IN NUMBER,
301 p_site_use_id IN NUMBER,
302 p_error_msg OUT NOCOPY VARCHAR2,
303 p_return_status OUT NOCOPY VARCHAR2 );
304
305
306 PROCEDURE OM_CUST_RELEASE_HOLD (
307 p_party_id IN NUMBER,
308 p_cust_account_id IN NUMBER,
309 p_site_use_id IN NUMBER,
310 p_error_msg OUT NOCOPY VARCHAR2,
311 p_return_status OUT NOCOPY VARCHAR2 ) ;
312
313 FUNCTION get_requestor_name(p_requestor_id IN NUMBER)
314 RETURN VARCHAR2;
315
316 END AR_CMGT_UTIL;