1 PACKAGE AP_WEB_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: apwutils.pls 120.3 2011/12/07 10:46:41 meesubra ship $ */
3
4 /*
5 * Encrypts a string
6 *
7 * @param msg String to be encrypted.
8 * @return Encrypted string
9 */
10 function encrypt(msg in varchar2) return varchar2;
11
12
13 /*
14 * Decrypts a string that was encrypted by encrypt().
15 *
16 * @param msg Encrypted string
17 * @return Decrypted message
18 */
19 function decrypt(msg in varchar2) return varchar2;
20
21
22 /*
23 * Given the host name, returns the proxy host/port to go through.
24 * Uses the profile options WEB_PROXY_HOST and WEB_PROXY_PORT. If these are not set,
25 * then it uses the profile options HZ_WEBPROXY_NAME and HZ_WEBPROXY_PORT.
26 *
27 * This procedure currently assumes that the host that is being accessed will reside outside
28 * the firewall and does not honor the WEB_PROXY_BYPASS_DOMAINS profile option.
29 * <i>This is an enhancement that is probably needed.</i>
30 *
31 * @param p_host_name The name of the host that you are trying to access. (Currently not used)
32 * @param p_proxy_host Hostname of the proxy server.
33 * @param p_proxy_port Port of the proxy server.
34 */
35 PROCEDURE GET_PROXY(p_host_name IN VARCHAR2, p_proxy_host OUT nocopy VARCHAR2, p_proxy_port OUT nocopy NUMBER);
36
37
38 /*
39 * Updates the download columns in AP_CARD_PROGRAMS_ALL
40 */
41 PROCEDURE UPDATE_DOWNLOAD_SIZES(p_card_program_id in NUMBER, p_file_size in NUMBER);
42
43 ------------------------------------------------------------------------
44 -- PROCEDURE NotifyEmployeeOnPayment
45 --
46 -- This API notifies the employee, when payments are made to employee
47 -- or credit card company in behalf of the employee, based on the
48 -- sse_cc_payment_notify profile option. This replaces the AFTER INSERT
49 -- trigger AP_SSE_NOTIFY_EMPLOYEE on table AP_INVOICE_PAYMENTS_ALL.
50 -- Introduced as part of the bugfix 9557247
51 ------------------------------------------------------------------------
52
53 PROCEDURE NotifyEmployeeOnPayment (P_Event_Type IN VARCHAR2,
54 P_Check_ID IN NUMBER,
55 P_Return_Status OUT NOCOPY VARCHAR2,
56 P_Msg_Count OUT NOCOPY NUMBER,
57 P_Msg_Data OUT NOCOPY VARCHAR2);
58
59 PROCEDURE LogStatement(p_pkgname IN VARCHAR2,
60 p_message IN VARCHAR2);
61
62 end AP_WEB_UTIL_PKG;
[Home] [Help]