1 PACKAGE AHL_FMP_MR_APPROVAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMWKS.pls 115.5 2002/12/04 20:09:15 rtadikon 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 -- 04/11/2002 RTADIKON CREATION
21 -- End of Comments
22 --------------------------------------------------------------------
23 PROCEDURE Set_Activity_Details(
24 itemtype IN VARCHAR2
25 ,itemkey IN VARCHAR2
26 ,actid IN NUMBER
27 ,funcmode IN VARCHAR2
28 ,resultout OUT NOCOPY VARCHAR2);
29
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 -- 03/15/2002 RTADIKON created
52 --------------------------------------------------------------------------
53
54 PROCEDURE Ntf_Forward_FYI(
55 document_id IN VARCHAR2
56 ,display_type IN VARCHAR2
57 ,document IN OUT NOCOPY VARCHAR2
58 ,document_type IN OUT NOCOPY VARCHAR2
59 );
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 -- 03/15/2002 RTADIKON created
82 --------------------------------------------------------------------------
83 PROCEDURE Ntf_Approved_FYI(
84 document_id IN VARCHAR2
85 ,display_type IN VARCHAR2
86 ,document IN OUT NOCOPY VARCHAR2
87 ,document_type IN OUT NOCOPY VARCHAR2
88 );
89
90 --------------------------------------------------------------------------
91 -- PROCEDURE
92 -- Ntf_Final_Approval_FYI
93 --
94 -- PURPOSE
95 -- Generate the FYI Document for display in messages, either text or html
96 --
97 -- IN
98 -- document_id - Item Key
99 -- display_type - either 'text/plain' or 'text/html'
100 -- document - document buffer
101 -- document_type - type of document buffer created, either 'text/plain'
102 -- or 'text/html'
103 -- OUT
104 --
105 -- USED BY
106 -- Oracle ASO Apporval
107 --
108 -- HISTORY
109 -- 03/15/2002 RTADIKON created
110 --------------------------------------------------------------------------
111 PROCEDURE Ntf_Final_Approval_FYI(
112 document_id IN VARCHAR2
113 ,display_type IN VARCHAR2
114 ,document IN OUT NOCOPY VARCHAR2
115 ,document_type IN OUT NOCOPY VARCHAR2
116 );
117
118 --------------------------------------------------------------------------
119 -- PROCEDURE
120 -- Ntf_Rejected_FYI
121 --
122 -- PURPOSE
123 -- Generate the FYI Document for display in messages, either text or html
124 --
125 -- IN
126 -- document_id - Item Key
127 -- display_type - either 'text/plain' or 'text/html'
128 -- document - document buffer
129 -- document_type - type of document buffer created, either 'text/plain'
130 -- or 'text/html'
131 -- OUT
132 --
133 -- USED BY
134 -- Oracle ASO Apporval
135 --
136 -- HISTORY
137 -- 03/15/2002 RTADIKON created
138 --------------------------------------------------------------------------
139 PROCEDURE Ntf_Rejected_FYI(
140 document_id IN VARCHAR2
141 ,display_type IN VARCHAR2
142 ,document IN OUT NOCOPY VARCHAR2
143 ,document_type IN OUT NOCOPY VARCHAR2
144 );
145
146
147 --------------------------------------------------------------------------
148 -- PROCEDURE
149 -- Ntf_Approval
150 --
151 -- PURPOSE
152 -- Generate the Document to ask for approval, either text or html
153 --
154 -- IN
155 -- document_id - Item Key
156 -- display_type - either 'text/plain' or 'text/html'
157 -- document - document buffer
158 -- document_type - type of document buffer created, either 'text/plain'
159 -- or 'text/html'
160 -- OUT
161 --
162 -- USED BY
163 -- Oracle ASO Apporval
164 --
165 -- HISTORY
166 -- 03/15/2002 RTADIKON created
167 --------------------------------------------------------------------------
168 PROCEDURE Ntf_Approval(
169 document_id IN VARCHAR2
170 ,display_type IN VARCHAR2
171 ,document IN OUT NOCOPY VARCHAR2
172 ,document_type IN OUT NOCOPY VARCHAR2
173 );
174
175 --------------------------------------------------------------------------
176 -- PROCEDURE
177 -- Ntf_Approval_Reminder
178 --
179 -- PURPOSE
180 -- Generate the Reminder Document for display in messages, either text or html
181 --
182 -- IN
183 -- document_id - Item Key
184 -- display_type - either 'text/plain' or 'text/html'
185 -- document - document buffer
186 -- document_type - type of document buffer created, either 'text/plain'
187 -- or 'text/html'
188 -- OUT
189 --
190 -- USED BY
191 -- Oracle ASO Apporval
192 --
193 -- HISTORY
194 -- 03/15/2002 RTADIKON created
195 --------------------------------------------------------------------------
196 PROCEDURE Ntf_Approval_Reminder(
197 document_id IN VARCHAR2
198 ,display_type IN VARCHAR2
199 ,document IN OUT NOCOPY VARCHAR2
200 ,document_type IN OUT NOCOPY VARCHAR2
201 );
202
203
204 --------------------------------------------------------------------------
205 -- PROCEDURE
206 -- Ntf_Error_Act
207 --
208 -- PURPOSE
209 -- Generate the Document to request action to handle error, either text or html
210 --
211 -- IN
212 -- document_id - Item Key
213 -- display_type - either 'text/plain' or 'text/html'
214 -- document - document buffer
215 -- document_type - type of document buffer created, either 'text/plain'
216 -- or 'text/html'
217 -- OUT
218 --
219 -- USED BY
220 -- Oracle ASO Apporval
221 --
222 -- HISTORY
223 -- 03/15/2002 RTADIKON created
224 --------------------------------------------------------------------------
225 PROCEDURE Ntf_Error_Act(
226 document_id IN VARCHAR2
227 ,display_type IN VARCHAR2
228 ,document IN OUT NOCOPY VARCHAR2
229 ,document_type IN OUT NOCOPY VARCHAR2
230 );
231
232 ---------------------------------------------------------------------
233 -- PROCEDURE
234 -- Update_Status
235 --
236 -- PURPOSE
237 -- This Procedure will update the status
238 --
239 -- IN
240 --
241 -- OUT
242 --
243 -- USED BY
244 -- Oracle ASO Apporval
245 --
246 -- HISTORY
247 -- 03/15/2002 RTADIKON created
248 --------------------------------------------------------------------------
249 PROCEDURE Update_Status(
250 itemtype IN VARCHAR2
251 ,itemkey IN VARCHAR2
252 ,actid IN NUMBER
253 ,funcmode IN VARCHAR2
254 ,resultout OUT NOCOPY VARCHAR2
255 );
256
257 ---------------------------------------------------------------------
258 -- PROCEDURE
259 -- Revert_Status
260 --
261 -- PURPOSE
262 -- This Procedure will revert the status in the case of an error
263 --
264 -- IN
265 --
266 -- OUT
267 --
268 -- USED BY
269 -- Oracle ASO Apporval
270 --
271 -- HISTORY
272 -- 03/15/2002 RTADIKON created
273 --------------------------------------------------------------------------
274 PROCEDURE Revert_Status(
275 itemtype IN VARCHAR2
276 ,itemkey IN VARCHAR2
277 ,actid IN NUMBER
278 ,funcmode IN VARCHAR2
279 ,resultout OUT NOCOPY VARCHAR2
280 );
281 END AHL_FMP_MR_APPROVAL_PVT;