1 PACKAGE AHL_UC_WF_APPR_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVUWFS.pls 115.0 2003/08/07 22:29:25 cxcheng noship $ */
3
4
5 ---------------------------------------------------------------------
6 -- PROCEDURE
7 -- SET_ACTIVITY_DETAILS
8 --
9 --
10 -- PURPOSE
11 -- This Procedure will set all the item attribute details
12 --
13 --
14 -- Used By Activities
15 --
16 -- NOTES
17 --
18 -- VERSION
19 -- Verions 1.0
20 --
21 -- HISTORY
22 -- 05/29/03 SBethi Created
23 -- End of Comments
24 --------------------------------------------------------------------
25 PROCEDURE SET_ACTIVITY_DETAILS
26 (
27 itemtype IN VARCHAR2
28 ,itemkey IN VARCHAR2
29 ,actid IN NUMBER
30 ,funcmode IN VARCHAR2
31 ,resultout OUT NOCOPY VARCHAR2
32 );
33
34 --------------------------------------------------------------------------
35 -- PROCEDURE
36 -- NTF_FORWARD_FYI
37 --
38 -- PURPOSE
39 -- Generate the FYI Document for display in messages, either text or html
40 --
41 -- IN
42 -- document_id - Item Key
43 -- display_type - either 'text/plain' or 'text/html'
44 -- document - document buffer
45 -- document_type - type of document buffer created, either 'text/plain'
46 -- or 'text/html'
47 -- OUT
48 --
49 -- USED BY
50 -- Oracle ASO Apporval
51 --
52 -- VERSION
53 -- Verions 1.0
54 --
55 -- HISTORY
56 -- 05/29/03 SBethi Created
57 -- End of Comments
58 --------------------------------------------------------------------------
59
60 PROCEDURE NTF_FORWARD_FYI
61 (
62 document_id IN VARCHAR2
63 ,display_type IN VARCHAR2
64 ,document IN OUT NOCOPY VARCHAR2
65 ,document_type IN OUT NOCOPY VARCHAR2
66 );
67
68 --------------------------------------------------------------------------
69 -- PROCEDURE
70 -- NTF_APPROVED_FYI
71 --
72 -- PURPOSE
73 -- Generate the FYI Document for display in messages, either text or html
74 --
75 -- IN
76 -- document_id - Item Key
77 -- display_type - either 'text/plain' or 'text/html'
78 -- document - document buffer
79 -- document_type - type of document buffer created, either 'text/plain'
80 -- or 'text/html'
81 -- OUT
82 --
83 -- USED BY
84 -- Oracle ASO Apporval
85 --
86 -- VERSION
87 -- Verions 1.0
88 --
89 -- HISTORY
90 -- 05/29/03 SBethi Created
91 -- End of Comments
92 --------------------------------------------------------------------------
93 PROCEDURE NTF_APPROVED_FYI
94 (
95 document_id IN VARCHAR2
96 ,display_type IN VARCHAR2
97 ,document IN OUT NOCOPY VARCHAR2
98 ,document_type IN OUT NOCOPY VARCHAR2
99 );
100
101 --------------------------------------------------------------------------
102 -- PROCEDURE
103 -- NTF_FINAL_APPROVAL_FYI
104 --
105 -- PURPOSE
106 -- Generate the FYI Document for display in messages, either text or html
107 --
108 -- IN
109 -- document_id - Item Key
110 -- display_type - either 'text/plain' or 'text/html'
111 -- document - document buffer
112 -- document_type - type of document buffer created, either 'text/plain'
113 -- or 'text/html'
114 -- OUT
115 --
116 -- USED BY
117 -- Oracle ASO Apporval
118 --
119 -- VERSION
120 -- Verions 1.0
121 --
122 -- HISTORY
123 -- 05/29/03 SBethi Created
124 -- End of Comments
125 --------------------------------------------------------------------------
126 PROCEDURE NTF_FINAL_APPROVAL_FYI
127 (
128 document_id IN VARCHAR2
129 ,display_type IN VARCHAR2
130 ,document IN OUT NOCOPY VARCHAR2
131 ,document_type IN OUT NOCOPY VARCHAR2
132 );
133
134 --------------------------------------------------------------------------
135 -- PROCEDURE
136 -- NTF_REJECTED_FYI
137 --
138 -- PURPOSE
139 -- Generate the FYI Document for display in messages, either text or html
140 --
141 -- IN
142 -- document_id - Item Key
143 -- display_type - either 'text/plain' or 'text/html'
144 -- document - document buffer
145 -- document_type - type of document buffer created, either 'text/plain'
146 -- or 'text/html'
147 -- OUT
148 --
149 -- USED BY
150 -- Oracle ASO Apporval
151 --
152 -- VERSION
153 -- Verions 1.0
154 --
155 -- HISTORY
156 -- 05/29/03 SBethi Created
157 -- End of Comments
158 --------------------------------------------------------------------------
159 PROCEDURE NTF_REJECTED_FYI
160 (
161 document_id IN VARCHAR2
162 ,display_type IN VARCHAR2
163 ,document IN OUT NOCOPY VARCHAR2
164 ,document_type IN OUT NOCOPY VARCHAR2
165 );
166
167
168 --------------------------------------------------------------------------
169 -- PROCEDURE
170 -- NTF_APPROVAL
171 --
172 -- PURPOSE
173 -- Generate the Document to ask for approval, either text or html
174 --
175 -- IN
176 -- document_id - Item Key
177 -- display_type - either 'text/plain' or 'text/html'
178 -- document - document buffer
179 -- document_type - type of document buffer created, either 'text/plain'
180 -- or 'text/html'
181 -- OUT
182 --
183 -- USED BY
184 -- Oracle ASO Apporval
185 --
186 -- VERSION
187 -- Verions 1.0
188 --
189 -- HISTORY
190 -- 05/29/03 SBethi Created
191 -- End of Comments
192 --------------------------------------------------------------------------
193 PROCEDURE NTF_APPROVAL
194 (
195 document_id IN VARCHAR2
196 ,display_type IN VARCHAR2
197 ,document IN OUT NOCOPY VARCHAR2
198 ,document_type IN OUT NOCOPY VARCHAR2
199 );
200
201 --------------------------------------------------------------------------
202 -- PROCEDURE
203 -- NTF_APPROVAL_REMINDER
204 --
205 -- PURPOSE
206 -- Generate the Reminder Document for display in messages, either text or html
207 --
208 -- IN
209 -- document_id - Item Key
210 -- display_type - either 'text/plain' or 'text/html'
211 -- document - document buffer
212 -- document_type - type of document buffer created, either 'text/plain'
213 -- or 'text/html'
214 -- OUT
215 --
216 -- USED BY
217 -- Oracle ASO Apporval
218 --
219 -- VERSION
220 -- Verions 1.0
221 --
222 -- HISTORY
223 -- 05/29/03 SBethi Created
224 -- End of Comments
225 --------------------------------------------------------------------------
226 PROCEDURE NTF_APPROVAL_REMINDER
227 (
228 document_id IN VARCHAR2
229 ,display_type IN VARCHAR2
230 ,document IN OUT NOCOPY VARCHAR2
231 ,document_type IN OUT NOCOPY VARCHAR2
232 );
233
234
235 --------------------------------------------------------------------------
236 -- PROCEDURE
237 -- NTF_ERROR_ACT
238 --
239 -- PURPOSE
240 -- Generate the Document to request action to handle error, either text or html
241 --
242 -- IN
243 -- document_id - Item Key
244 -- display_type - either 'text/plain' or 'text/html'
245 -- document - document buffer
246 -- document_type - type of document buffer created, either 'text/plain'
247 -- or 'text/html'
248 -- OUT
249 --
250 -- USED BY
251 -- Oracle ASO Apporval
252 --
253 -- VERSION
254 -- Verions 1.0
255 --
256 -- HISTORY
257 -- 05/29/03 SBethi Created
258 -- End of Comments
259 --------------------------------------------------------------------------
260 PROCEDURE NTF_ERROR_ACT
261 (
262 document_id IN VARCHAR2
263 ,display_type IN VARCHAR2
264 ,document IN OUT NOCOPY VARCHAR2
265 ,document_type IN OUT NOCOPY VARCHAR2
266 );
267
268 ---------------------------------------------------------------------
269 -- PROCEDURE
270 -- UPDATE_STATUS
271 --
272 -- PURPOSE
273 -- This Procedure will update the status
274 --
275 -- IN
276 --
277 -- OUT
278 --
279 -- USED BY
280 -- Oracle ASO Apporval
281 --
282 -- VERSION
283 -- Verions 1.0
284 --
285 -- HISTORY
286 -- 05/29/03 SBethi Created
287 -- End of Comments
288 --------------------------------------------------------------------------
289 PROCEDURE UPDATE_STATUS
290 (
291 itemtype IN VARCHAR2
292 ,itemkey IN VARCHAR2
293 ,actid IN NUMBER
294 ,funcmode IN VARCHAR2
295 ,resultout OUT NOCOPY VARCHAR2
296 );
297
298 ---------------------------------------------------------------------
299 -- PROCEDURE
300 -- Revert_Status
301 --
302 -- PURPOSE
303 -- This Procedure will revert the status in the case of an error
304 --
305 -- IN
306 --
307 -- OUT
308 --
309 -- USED BY
310 -- Oracle ASO Apporval
311 --
312 -- VERSION
313 -- Verions 1.0
314 --
315 -- HISTORY
316 -- 05/29/03 SBethi Created
317 -- End of Comments
318 --------------------------------------------------------------------------
319 PROCEDURE REVERT_STATUS
320 (
321 itemtype IN VARCHAR2
322 ,itemkey IN VARCHAR2
323 ,actid IN NUMBER
324 ,funcmode IN VARCHAR2
325 ,resultout OUT NOCOPY VARCHAR2
326 );
327
328
329 END AHL_UC_WF_APPR_PVT;