1 PACKAGE UMX_NOTIFICATION_UTIL AUTHID CURRENT_USER as
2 /* $Header: UMXNTFSS.pls 115.4 2004/02/19 01:30:05 ssallaka noship $ */
3 -- Start of Comments
4 -- Package name : UMX_NOTIFICATION_UTIL
5 -- Purpose :
6 -- This package contains specification for notification details
7 -- Procedure
8 -- query_role_display_name
9 --
10 -- Description
11 -- query the wf_local_roles for the role display name
12 -- IN
13 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
14 -- itemkey - A string generated from the application object's primary key.
15 -- actid - The function activity(instance id).
16 -- funcmode - Run/Cancel/Timeout
17 -- OUT
18 -- resultout - result of the process based on which the next step is followed
19
20
21 procedure Query_role_display_name (item_type in varchar2,
22 item_key in varchar2,
23 activity_id in number,
24 command in varchar2,
25 resultout out NOCOPY varchar2);
26
27 -- Procedure
28 -- Check_Context
29 --
30 -- Description
31 -- populate the wf_local_roles table with information from workflow
32 -- IN
33 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
34 -- itemkey - A string generated from the application object's primary key.
35 -- actid - The function activity(instance id).
36 -- funcmode - Run/Cancel/Timeout
37 -- OUT
38 -- resultout - result of the process based on which the next step is followed
39
40
41 procedure Check_Context (item_type in varchar2,
42 item_key in varchar2,
43 activity_id in number,
44 command in varchar2,
45 resultout out NOCOPY varchar2);
46
47 --
48 -- Procedure
49 -- Notification_process_done
50 --
51 -- Description
52 -- populate the wf_local_roles table with information from workflow
53 -- IN
54 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
55 -- itemkey - A string generated from the application object's primary key.
56 -- actid - The function activity(instance id).
57 -- funcmode - Run/Cancel/Timeout
58 -- OUT
59 -- resultout - result of the process based on which the next step is followed
60
61
62 procedure Notification_Process_Done (item_type in varchar2,
63 item_key in varchar2,
64 activity_id in number,
65 command in varchar2,
66 resultout out NOCOPY varchar2);
67
68 -- Procedure
69 -- GetNextApprover
70 --
71 -- Description
72 -- populate the wf_local_roles table with information from workflow
73 -- IN
74 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
75 -- itemkey - A string generated from the application object's primary key.
76 -- actid - The function activity(instance id).
77 -- funcmode - Run/Cancel/Timeout
78 -- OUT
79 -- resultout - result of the process based on which the next step is followed
80
81
82 procedure GetNextApprover (item_type in varchar2,
83 item_key in varchar2,
84 activity_id in number,
85 command in varchar2,
86 resultout out NOCOPY varchar2);
87
88 -- Procedure
89 -- get_recipient_username
90 --
91 -- Description
92 -- Return the username of the notification recipient.
93 -- IN
94 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
95 -- itemkey - A string generated from the application object's primary key.
96 -- actid - The function activity(instance id).
97 -- funcmode - Run/Cancel/Timeout
98 -- OUT
99 -- resultout - result of the process based on which the next step is followed
100 procedure get_recipient_username (item_type in varchar2,
101 item_key in varchar2,
102 activity_id in number,
103 command in varchar2,
104 resultout out NOCOPY varchar2);
105 procedure throw_exception (item_type in varchar2,
106 item_key in varchar2,
107 activity_id in number,
108 command in varchar2,
109 resultout out NOCOPY varchar2);
110
111 procedure UpdateApprovalStatus (item_type in varchar2,
112 item_key in varchar2,
113 activity_id in number,
114 command in varchar2,
115 resultout out NOCOPY varchar2);
116 procedure UpdateRejectedStatus (item_type in varchar2,
117 item_key in varchar2,
118 activity_id in number,
119 command in varchar2,
120 resultout out NOCOPY varchar2);
121
122 end UMX_NOTIFICATION_UTIL;