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