1 PACKAGE ari_utilities AUTHID CURRENT_USER AS
2 /* $Header: ARIUTILS.pls 120.12.12010000.4 2009/01/15 11:57:24 nkanchan ship $ */
3
4
5 FUNCTION check_external_user_access (p_person_party_id IN VARCHAR2,
6 p_customer_id IN VARCHAR2,
7 p_customer_site_use_id IN VARCHAR2)
8 RETURN VARCHAR2 ;
9
10 PROCEDURE send_notification(p_user_name IN VARCHAR2,
11 p_customer_name IN VARCHAR2,
12 p_request_id IN NUMBER,
13 p_requests IN NUMBER,
14 p_parameter IN VARCHAR2,
15 p_subject_msg_name IN VARCHAR2,
16 p_subject_msg_appl IN VARCHAR2 DEFAULT 'AR',
17 p_body_msg_name IN VARCHAR2 DEFAULT NULL,
18 p_body_msg_appl In VARCHAR2 DEFAULT 'AR');
19
20 /*========================================================================
21 | PUBLIC function curr_round_amt
22 |
23 | DESCRIPTION
24 | Rounds a given amount based on the precision defined for the currency code.
25 | ----------------------------------------
26 |
27 | PSEUDO CODE/LOGIC
28 | This function rounds the amount based on the precision defined for the
29 | currency code.
30 |
31 | PARAMETERS
32 | amount IN NUMBER Input amount for rounding
33 | currency_code IN VARCHAR2 Currency Code
34 |
35 | RETURNS
36 | NUMBER Rounded Amount
37 |
38 | KNOWN ISSUES
39 |
40 | NOTES
41 |
42 | MODIFICATION HISTORY
43 | Date Author Description of Changes
44 | 17-DEC-2004 vnb Created
45 |
46 *=======================================================================*/
47 FUNCTION curr_round_amt( p_amount IN NUMBER,
48 p_currency_code IN VARCHAR2)
49 RETURN NUMBER;
50
51 TYPE t_ar_lookups_table IS TABLE OF VARCHAR2(80)
52 INDEX BY BINARY_INTEGER;
53
54 pg_ar_lookups_rec t_ar_lookups_table;
55
56 FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
57 p_lookup_code IN VARCHAR2)
58 RETURN VARCHAR2;
59
60 FUNCTION get_bill_to_site_use_id (p_address_id IN NUMBER) RETURN NUMBER;
61
62 FUNCTION get_site_uses (p_address_id IN NUMBER) RETURN VARCHAR2;
63
64 FUNCTION site_use_meaning (p_site_use IN VARCHAR2) RETURN VARCHAR2;
65
66 FUNCTION cust_srch_sec_predicate(obj_schema VARCHAR2,
67 obj_name VARCHAR2) RETURN VARCHAR2;
68
69 FUNCTION get_default_currency ( p_customer_id IN VARCHAR2,
70 p_session_id IN VARCHAR2)
71
72 RETURN VARCHAR2;
73
74 --------------------------------------------------------------------------------
75 --Check if the person party has access to this customer site
76 FUNCTION check_site_access (p_person_party_id IN VARCHAR2,
77 p_customer_id IN VARCHAR2,
78 p_customer_site_use_id IN VARCHAR2)
79 RETURN VARCHAR2;
80 --------------------------------------------------------------------------------
81 --Check if the admin identified by p_person_party_id has access to this customer
82 FUNCTION check_admin_access (p_person_party_id IN VARCHAR2,
83 p_customer_id IN VARCHAR2)
84 RETURN VARCHAR2;
85 --------------------------------------------------------------------------------
86
87
88 /*========================================================================
89 | PUBLIC procedure get_contact_id
90 |
91 | DESCRIPTION
92 | Returns contact id of the given site at the customer/site level
93 | ----------------------------------------
94 |
95 | PSEUDO CODE/LOGIC
96 |
97 | PARAMETERS
98 | p_customer_id IN Customer Id
99 | p_customer_site_use_id IN Customer Site Id
100 | p_contact_role_type IN Contact Role Type
101 |
102 | RETURNS
103 | l_contact_id Contact id of the given site at the customer/site level
104 | KNOWN ISSUES
105 |
106 | MODIFICATION HISTORY
107 | Date Author Description of Changes
108 | 12-AUG-2005 rsinthre Created
109 *=======================================================================*/
110 FUNCTION get_contact_id(p_customer_id IN NUMBER,
111 p_customer_site_use_id IN NUMBER DEFAULT NULL,
112 p_contact_role_type IN VARCHAR2 DEFAULT 'ALL') RETURN NUMBER;
113
114
115 /*========================================================================
116 | PUBLIC procedure get_contact
117 |
118 | DESCRIPTION
119 | Returns contact name of the given site at the customer/site level
120 | ----------------------------------------
121 |
122 | PSEUDO CODE/LOGIC
123 |
124 | PARAMETERS
125 | p_customer_id IN Customer Id
126 | p_customer_site_use_id IN Customer Site Id
127 | p_contact_role_type IN Contact Role Type
128 |
129 | RETURNS
130 | l_contact_name Contact name of the given site at the customer/site level
131 | KNOWN ISSUES
132 |
133 | MODIFICATION HISTORY
134 | Date Author Description of Changes
135 | 12-AUG-2005 rsinthre Created
136 *=======================================================================*/
137 FUNCTION get_contact(p_customer_id IN NUMBER,
138 p_customer_site_use_id IN NUMBER,
139 p_contact_role_type IN VARCHAR2 DEFAULT 'ALL') RETURN VARCHAR2;
140
141 /*========================================================================
142 | PUBLIC procedure get_contact
143 |
144 | DESCRIPTION
145 | Returns contact name of the given contact id
146 | ----------------------------------------
147 |
148 | PSEUDO CODE/LOGIC
149 |
150 | PARAMETERS
151 | p_contact_id IN Customer Id
152 |
153 | RETURNS
154 | l_contact_name Contact name of the given contact id
155 | KNOWN ISSUES
156 |
157 | MODIFICATION HISTORY
158 | Date Author Description of Changes
159 | 5-JUL-2005 hikumar Created
160 *=======================================================================*/
161 FUNCTION get_contact(p_contact_id IN NUMBER) RETURN VARCHAR2;
162
163 /*========================================================================
164 | PUBLIC procedure get_phone
165 |
166 | DESCRIPTION
167 | Returns contact point of the given contact type, site at the customer/site level
168 | ----------------------------------------
169 |
170 | PSEUDO CODE/LOGIC
171 |
172 | PARAMETERS
173 | p_customer_id IN Customer Id
174 | p_customer_site_use_id IN Customer Site Id
175 | p_contact_role_type IN Contact Role Type
176 | p_phone_type IN contact type like 'PHONE', 'FAX', 'GEN' etc
177 |
178 | RETURNS
179 | l_contact_phone Contact type number of the given site at the customer/site level
180 | KNOWN ISSUES
181 |
182 | MODIFICATION HISTORY
183 | Date Author Description of Changes
184 | 12-AUG-2005 rsinthre Created
185 *=======================================================================*/
186 FUNCTION get_phone(p_customer_id IN NUMBER,
187 p_customer_site_use_id IN NUMBER DEFAULT NULL,
188 p_contact_role_type IN VARCHAR2 DEFAULT 'ALL',
189 p_phone_type IN VARCHAR2 DEFAULT 'ALL') RETURN VARCHAR2;
190 /*========================================================================
191 | PUBLIC procedure get_phone
192 |
193 | DESCRIPTION
194 | Returns contact point of the given contact id
195 | ----------------------------------------
196 |
197 | PSEUDO CODE/LOGIC
198 |
199 | PARAMETERS
200 | p_contact_id IN Customer Id
201 | p_phone_type IN contact type like 'PHONE', 'FAX', 'GEN' etc
202 |
203 | RETURNS
204 | l_contact_phone Contact type number of the given contact id
205 | KNOWN ISSUES
206 |
207 | MODIFICATION HISTORY
208 | Date Author Description of Changes
209 | 5-JUL-2005 hikumar Created
210 *=======================================================================*/
211 FUNCTION get_phone(p_contact_id IN NUMBER,
212 p_phone_type IN VARCHAR2 DEFAULT 'ALL') RETURN VARCHAR2;
213
214 FUNCTION get_service_charge_activity_id ( p_customer_id IN VARCHAR2,
215 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
216
217 FUNCTION is_service_charge_enabled ( p_customer_id IN VARCHAR2,
218 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN boolean;
219
220 FUNCTION get_max_future_payment_date( p_customer_id IN VARCHAR2,
221 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN DATE;
222
223 FUNCTION save_payment_instrument_info ( p_customer_id IN VARCHAR2,
224 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
225
226 FUNCTION is_save_payment_instr_enabled ( p_customer_id IN VARCHAR2,
227 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
228
229 FUNCTION is_aging_enabled ( p_customer_id IN VARCHAR2,
230 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
231
232 FUNCTION multi_print_limit ( p_customer_id IN VARCHAR2,
233 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
234
235 FUNCTION is_discount_grace_days_enabled ( p_customer_id IN VARCHAR2,
236 p_customer_site_use_id IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
237
238 FUNCTION is_discount_grace_days_enabled RETURN boolean;
239
240 -- this procedure returns the html used for the 'Contact Us'
241 -- icon.
242
243 PROCEDURE get_contact_info (
244 p_customer_id IN VARCHAR2,
245 p_customer_site_use_id IN VARCHAR2,
246 p_language_string IN VARCHAR2,
247 p_page IN VARCHAR2,
248 p_trx_id IN VARCHAR2,
249 p_output_string OUT NOCOPY VARCHAR2
250 );
251
252 FUNCTION get_site_use_location (p_address_id IN NUMBER) RETURN VARCHAR2;
253
254 /*========================================================================
255 | PUBLIC function get_site_use_code
256 |
257 | DESCRIPTION
258 | Function returns the site use codes for the given adddress id
259 |
260 | PARAMETERS
261 | p_address_id IN NUMBER
262 |
263 | RETURNS
264 | Site Use Codes for the given address id.
265 |
266 | MODIFICATION HISTORY
267 | Date Author Description of Changes
268 | 12-Feb-2007 abhisjai Created
269 *=======================================================================*/
270 FUNCTION get_site_use_code (p_address_id IN NUMBER) RETURN VARCHAR2;
271
272 FUNCTION get_group_header (p_customer_id IN NUMBER,p_party_id IN NUMBER , p_trx_number IN VARCHAR) RETURN NUMBER;
273
274
275 FUNCTION invoke_invoice_email_notwf ( p_subscription_guid In RAW, p_event IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2;
276
277 PROCEDURE det_if_send_email ( l_itemtype in varchar2,
278 l_itemkey in varchar2,
279 actid in number,
280 funcmode in varchar2,
281 rslt out NOCOPY varchar2);
282
283 FUNCTION get_contact_emails( p_customer_id IN VARCHAR2 ,
284 p_customer_acct_site_id IN VARCHAR2 ) RETURN VARCHAR2;
285
286 TYPE CONTEXT_REC_TYPE IS RECORD
287 (
288 CONTEXT_TYPE VARCHAR2(100),
289 CONTEXT_ID NUMBER
290 );
291 TYPE CONTEXTS_TBL_TYPE IS TABLE OF CONTEXT_REC_TYPE INDEX BY BINARY_INTEGER;
292
293 PROCEDURE cancel_dispute(p_dispute_id IN NUMBER,
294 p_cancel_comments IN VARCHAR2,
295 p_return_status OUT NOCOPY VARCHAR2
296 );
297
298 END ari_utilities ;
[Home] [Help]