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