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