1 PACKAGE MWA_NOTIFICATION_API AUTHID CURRENT_USER as
2 /* $Header: MWANOTS.pls 120.1 2005/06/10 11:50:37 appldev $ */
3
4 -- The following constant indicates how many chars we must escape.
5
6 NUM_RECORDS constant NUMBER := 33;
7
8 ------------------------------------------------------------------------
9 -- Record type for url char replacement
10 ------------------------------------------------------------------------
11 TYPE escapeRec IS RECORD (
12 replace_char VARCHAR(1),
13 replacement_char VARCHAR(3));
14
15 TYPE t_chars IS TABLE OF escapeRec
16 INDEX BY binary_integer;
17
18 escapeRecord t_chars;
19
20 requestFailed exception;
21
22
23 ------------------------------------------------------------------------------
24 -- Function
25 -- mwaNotify
26 --
27 -- Description
28 -- Called by workflow when a notification event is raised by a workflow
29 --
30 -- Input Paramters
31 -- p_subscription_guidr Information called by workflow
32 --
33 -- p_event The actual event raised by a workflow that
34 -- wants to send a notification.
35 -- Returns
36 -- varchar2 Message indicating success or error.
37 ------------------------------------------------------------------------------
38
39 function mwaNotify (
40 p_subscription_guid IN raw,
41 p_event IN OUT nocopy WF_EVENT_T)
42
43 return varchar2 ;
44
45 ------------------------------------------------------------------------------
46 -- Function
47 -- raiseNotification
48 --
49 -- Description
50 -- Called by a developer in the middle of a workflow if a notification event
51 -- should be sent to a mobile device.
52 --
53 -- Input Paramters
54 -- username The apps username to send the notifiation too
55 --
56 -- subject The subject of the message
57 --
58 -- content The body of the message.
59 ------------------------------------------------------------------------------
60
61 procedure raiseNotification (username IN varchar2,
62 subject IN varchar2,
63 content IN varchar2) ;
64
65
66
67 function calculateLength (str IN varchar2) return varchar2 ;
68
69 function decodedLength (str in varchar2) return number ;
70
71 procedure fireNotification (subject IN varchar2,
72 username IN varchar2,
73 type in varchar2,
74 content in varchar2);
75
76
77 END MWA_NOTIFICATION_API;