1 PACKAGE AHL_ITEMGROUPS_APPROVAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVIWFS.pls 115.0 2003/07/03 14:36:54 sjayacha noship $ */
3 --------------------------------------------------------------------------
4 -- PROCEDURE
5 -- Set_Activity_Details
6 --
7 -- PURPOSE
8 -- This procedure will set the workflow attributes for the details of the activity.
9 --
10 -- IN
11 -- itemtype - The internale name of the Item Type
12 -- itemkey - Unique key formulated in Start_WF_Process for WF internal reference
13 -- actid - The ID number of the activity from which this procedure is called.
14 -- funcmode - The execution mode of the activity
15 -- OUT
16 -- resultout - The expected result thats returned when the procedure comletes.
17 -- USED BY
18 -- Oracle CMRO Apporval
19 --
20 -- HISTORY
21 -- 04/23/2003 Senthil Kumar created
22 --------------------------------------------------------------------------
23
24 PROCEDURE Set_Activity_Details(
25 itemtype IN VARCHAR2
26 ,itemkey IN VARCHAR2
27 ,actid IN NUMBER
28 ,funcmode IN VARCHAR2
29 ,resultout OUT NOCOPY VARCHAR2);
30
31
32 PROCEDURE Ntf_Forward_FYI(
33 document_id IN VARCHAR2
34 ,display_type IN VARCHAR2
35 ,document IN OUT NOCOPY VARCHAR2
36 ,document_type IN OUT NOCOPY VARCHAR2
37 );
38
39
40 PROCEDURE Ntf_Approved_FYI(
41 document_id IN VARCHAR2
42 ,display_type IN VARCHAR2
43 ,document IN OUT NOCOPY VARCHAR2
44 ,document_type IN OUT NOCOPY VARCHAR2
45 );
46
47 --------------------------------------------------------------------------
48 -- PROCEDURE
49 -- Ntf_Final_Approval_FYI
50 --
51 -- PURPOSE
52 -- Generate the FYI Document for display in messages, either text or html
53 --
54 -- IN
55 -- document_id - Item Key
56 -- display_type - either 'text/plain' or 'text/html'
57 -- document - document buffer
58 -- document_type - type of document buffer created, either 'text/plain'
59 -- or 'text/html'
60 -- OUT
61 --
62 -- USED BY
63 -- Oracle CMRO Apporval
64 --
65 -- HISTORY
66 -- 04/23/2003 Senthil Kumar created
67 --------------------------------------------------------------------------
68 PROCEDURE Ntf_Final_Approval_FYI(
69 document_id IN VARCHAR2
70 ,display_type IN VARCHAR2
71 ,document IN OUT NOCOPY VARCHAR2
72 ,document_type IN OUT NOCOPY VARCHAR2
73 );
74
75 --------------------------------------------------------------------------
76 -- PROCEDURE
77 -- Ntf_Rejected_FYI
78 --
79 -- PURPOSE
80 -- Generate the FYI Document for display in messages, either text or html
81 --
82 -- IN
83 -- document_id - Item Key
84 -- display_type - either 'text/plain' or 'text/html'
85 -- document - document buffer
86 -- document_type - type of document buffer created, either 'text/plain'
87 -- or 'text/html'
88 -- OUT
89 --
90 -- USED BY
91 -- Oracle CMRO Apporval
92 --
93 -- HISTORY
94 -- 04/23/2003 Senthil Kumar created
95 --------------------------------------------------------------------------
96 PROCEDURE Ntf_Rejected_FYI(
97 document_id IN VARCHAR2
98 ,display_type IN VARCHAR2
99 ,document IN OUT NOCOPY VARCHAR2
100 ,document_type IN OUT NOCOPY VARCHAR2
101 );
102
103
104 --------------------------------------------------------------------------
105 -- PROCEDURE
106 -- Ntf_Approval
107 --
108 -- PURPOSE
109 -- Generate the Document to ask for approval, either text or html
110 --
111 -- IN
112 -- document_id - Item Key
113 -- display_type - either 'text/plain' or 'text/html'
114 -- document - document buffer
115 -- document_type - type of document buffer created, either 'text/plain'
116 -- or 'text/html'
117 -- OUT
118 --
119 -- USED BY
120 -- Oracle CMRO Apporval
121 --
122 -- HISTORY
123 -- 04/23/2003 Senthil Kumar created
124 --------------------------------------------------------------------------
125 PROCEDURE Ntf_Approval(
126 document_id IN VARCHAR2
127 ,display_type IN VARCHAR2
128 ,document IN OUT NOCOPY VARCHAR2
129 ,document_type IN OUT NOCOPY VARCHAR2
130 );
131
132 --------------------------------------------------------------------------
133 -- PROCEDURE
134 -- Ntf_Approval_Reminder
135 --
136 -- PURPOSE
137 -- Generate the Reminder Document for display in messages, either text or html
138 --
139 -- IN
140 -- document_id - Item Key
141 -- display_type - either 'text/plain' or 'text/html'
142 -- document - document buffer
143 -- document_type - type of document buffer created, either 'text/plain'
144 -- or 'text/html'
145 -- OUT
146 --
147 -- USED BY
148 -- Oracle CMRO Apporval
149 --
150 -- HISTORY
151 -- 04/23/2003 Senthil Kumar created
152 --------------------------------------------------------------------------
153 PROCEDURE Ntf_Approval_Reminder(
154 document_id IN VARCHAR2
155 ,display_type IN VARCHAR2
156 ,document IN OUT NOCOPY VARCHAR2
157 ,document_type IN OUT NOCOPY VARCHAR2
158 );
159
160
161 --------------------------------------------------------------------------
162 -- PROCEDURE
163 -- Ntf_Error_Act
164 --
165 -- PURPOSE
166 -- Generate the Document to request action to handle error, either text or html
167 --
168 -- IN
169 -- document_id - Item Key
170 -- display_type - either 'text/plain' or 'text/html'
171 -- document - document buffer
172 -- document_type - type of document buffer created, either 'text/plain'
173 -- or 'text/html'
174 -- OUT
175 --
176 -- USED BY
177 -- Oracle CMRO Apporval
178 --
179 -- HISTORY
180 -- 04/23/2003 Senthil Kumar created
181 --------------------------------------------------------------------------
182 PROCEDURE Ntf_Error_Act(
183 document_id IN VARCHAR2
184 ,display_type IN VARCHAR2
185 ,document IN OUT NOCOPY VARCHAR2
186 ,document_type IN OUT NOCOPY VARCHAR2
187 );
188
189 ---------------------------------------------------------------------
190 -- PROCEDURE
191 -- Update_Status
192 --
193 -- PURPOSE
194 -- This Procedure will update the status
195 --
196 -- IN
197 --
198 -- OUT
199 --
200 -- USED BY
201 -- Oracle CMRO Apporval
202 --
203 -- HISTORY
204 -- 04/23/2003 Senthil Kumar created
205 --------------------------------------------------------------------------
206 PROCEDURE Update_Status(
207 itemtype IN VARCHAR2
208 ,itemkey IN VARCHAR2
209 ,actid IN NUMBER
210 ,funcmode IN VARCHAR2
211 ,resultout OUT NOCOPY VARCHAR2
212 );
213
214 ---------------------------------------------------------------------
215 -- PROCEDURE
216 -- Revert_Status
217 --
218 -- PURPOSE
219 -- This Procedure will revert the status in the case of an error
220 --
221 -- IN
222 --
223 -- OUT
224 --
225 -- USED BY
226 -- Oracle CMRO Apporval
227 --
228 -- HISTORY
229 -- 04/23/2003 Senthil Kumar created
230 --------------------------------------------------------------------------
231 PROCEDURE Revert_Status(
232 itemtype IN VARCHAR2
233 ,itemkey IN VARCHAR2
234 ,actid IN NUMBER
235 ,funcmode IN VARCHAR2
236 ,resultout OUT NOCOPY VARCHAR2
237 );
238
239 END AHL_ITEMGROUPS_APPROVAL_PVT;