1 PACKAGE CS_WF_AUTO_NTFY_UPDATE_PKG AS
2 /* $Header: cswfauts.pls 120.1 2006/02/06 18:53:22 spusegao noship $ */
3
4
5 PROCEDURE Check_Rules_For_Event( itemtype IN VARCHAR2,
6 itemkey IN VARCHAR2,
7 actid IN NUMBER,
8 funmode IN VARCHAR2,
9 result OUT NOCOPY VARCHAR2 );
10
11 PROCEDURE Check_Notification_Rules( itemtype IN VARCHAR2,
12 itemkey IN VARCHAR2,
13 actid IN NUMBER,
14 funmode IN VARCHAR2,
15 result OUT NOCOPY VARCHAR2 );
16
17 PROCEDURE Get_Recipients_To_Notify( itemtype IN VARCHAR2,
18 itemkey IN VARCHAR2,
19 actid IN NUMBER,
20 funmode IN VARCHAR2,
21 result OUT NOCOPY VARCHAR2 );
22
23 PROCEDURE Set_Notification_Details( itemtype IN VARCHAR2,
24 itemkey IN VARCHAR2,
25 actid IN NUMBER,
26 funmode IN VARCHAR2,
27 result OUT NOCOPY VARCHAR2 );
28
29 PROCEDURE All_Recipients_Notified( itemtype IN VARCHAR2,
30 itemkey IN VARCHAR2,
31 actid IN NUMBER,
32 funmode IN VARCHAR2,
33 result OUT NOCOPY VARCHAR2 );
34
35 PROCEDURE Verify_Notify_Rules_Done( itemtype IN VARCHAR2,
36 itemkey IN VARCHAR2,
37 actid IN NUMBER,
38 funmode IN VARCHAR2,
39 result OUT NOCOPY VARCHAR2 );
40
41 PROCEDURE Check_Status_Rules( itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funmode IN VARCHAR2,
45 result OUT NOCOPY VARCHAR2 );
46
47 PROCEDURE Get_Links_For_Rule( itemtype IN VARCHAR2,
48 itemkey IN VARCHAR2,
49 actid IN NUMBER,
50 funmode IN VARCHAR2,
51 result OUT NOCOPY VARCHAR2 );
52
53 PROCEDURE Execute_Rules_Per_SR( itemtype IN VARCHAR2,
54 itemkey IN VARCHAR2,
55 actid IN NUMBER,
56 funmode IN VARCHAR2,
57 result OUT NOCOPY VARCHAR2 );
58
59 PROCEDURE Verify_Update_Valid( itemtype IN VARCHAR2,
60 itemkey IN VARCHAR2,
61 actid IN NUMBER,
62 funmode IN VARCHAR2,
63 result OUT NOCOPY VARCHAR2 );
64
65 PROCEDURE Update_SR( itemtype IN VARCHAR2,
66 itemkey IN VARCHAR2,
67 actid IN NUMBER,
68 funmode IN VARCHAR2,
69 result OUT NOCOPY VARCHAR2 );
70
71 PROCEDURE Set_Notify_Error( itemtype IN VARCHAR2,
72 itemkey IN VARCHAR2,
73 actid IN NUMBER,
74 funmode IN VARCHAR2,
75 result OUT NOCOPY VARCHAR2 );
76
77 PROCEDURE Verify_All_Links_Done( itemtype IN VARCHAR2,
78 itemkey IN VARCHAR2,
79 actid IN NUMBER,
80 funmode IN VARCHAR2,
81 result OUT NOCOPY VARCHAR2 );
82
83 PROCEDURE Verify_Update_Rules_Done( itemtype IN VARCHAR2,
84 itemkey IN VARCHAR2,
85 actid IN NUMBER,
86 funmode IN VARCHAR2,
87 result OUT NOCOPY VARCHAR2 );
88
89 PROCEDURE Get_Request_Attributes( itemtype VARCHAR2,
90 itemkey VARCHAR2,
91 actid NUMBER,
92 funmode VARCHAR2,
93 result OUT NOCOPY VARCHAR2 );
94
95 -- Release 11.5.10
96 PROCEDURE Create_Contact_Interaction( itemtype IN VARCHAR2,
97 itemkey IN VARCHAR2,
98 actid IN NUMBER,
99 funmode IN VARCHAR2,
100 result OUT NOCOPY VARCHAR2 );
101
102 PROCEDURE All_Interactions_Created( itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 funmode IN VARCHAR2,
106 result OUT NOCOPY VARCHAR2 );
107
108
109 PROCEDURE Get_Fnd_User_Role
110 ( p_fnd_user_id IN NUMBER,
111 x_role_name OUT NOCOPY VARCHAR2,
112 x_role_display_name OUT NOCOPY VARCHAR2 );
113
114
115 PROCEDURE Create_Interaction_Activity(
116 p_api_revision IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_incident_id IN NUMBER,
120 p_incident_number IN VARCHAR2 DEFAULT NULL,
121 p_party_id IN NUMBER,
122 p_user_id IN NUMBER,
123 p_resp_appl_id IN NUMBER,
124 p_resp_id IN NUMBER,
125 p_login_id IN NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_resource_id OUT NOCOPY NUMBER,
128 x_resource_type OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2);
131
132 PROCEDURE Prepare_HTML_Notification
133 ( itemtype IN VARCHAR2,
134 itemkey IN VARCHAR2,
135 actid IN NUMBER,
136 funmode IN VARCHAR2,
137 result OUT NOCOPY VARCHAR2 );
138
139 PROCEDURE Are_All_HTML_Recips_Notified
140 ( itemtype IN VARCHAR2,
141 itemkey IN VARCHAR2,
142 actid IN NUMBER,
143 funmode IN VARCHAR2,
144 result OUT NOCOPY VARCHAR2 ) ;
145
146 END CS_WF_AUTO_NTFY_UPDATE_PKG;