[Home] [Help]
PACKAGE: APPS.IGIDOSL
Source
1 PACKAGE igidosl AUTHID CURRENT_USER AS
2 -- $Header: igidosls.pls 120.15 2011/10/25 10:43:24 dramired ship $
3 --
4
5
6 --
7 -- Procedure
8 -- Debug_log_string
9 --
10 -- Purpose
11 -- This has been added as a part of fnd_log changes.
12 -- This procedure is used to input debug message if
13 -- debug log is enabled.
14 --
15 -- History
16 -- 19-DEC-2003 Rgopalan Initial Version
17 --
18
19 Procedure Debug_log_string (P_level IN NUMBER,
20 P_module IN VARCHAR2,
21 P_Message IN VARCHAR2);
22
23
24 --
25 -- Procedure
26 -- Debug_log_unexp_error
27 -- Purpose
28 -- puts enexpected error to log.
29 -- History
30 -- 24-DEC-2003 Rgopalan Initial Version
31 --
32
33 Procedure Debug_log_unexp_error (P_module IN VARCHAR2,
34 P_error_type IN VARCHAR2);
35
36
37 --
38 -- Procedure
39 -- Selector
40 -- Purpose
41 -- Chooses the process to run when the workflow is invoked
42 -- History
43 -- 22-OCT-2001 L Silveira Initial Version
44 --
45 PROCEDURE Selector( itemtype IN VARCHAR2,
46 itemkey IN VARCHAR2,
47 actid IN NUMBER,
48 funcmode IN VARCHAR2,
49 resultout OUT NOCOPY VARCHAR2
50 );
51
52 --
53 -- Procedure
54 -- StartUp
55 -- Purpose
56 -- Creates and starts an instance of the workflow.
57 -- History
58 -- 22-OCT-2001 L Silveira Initial Version
59 --
60 PROCEDURE Startup ( Wkf_Name VARCHAR2,
61 Dossier_Id NUMBER,
62 Dossier_Num VARCHAR2,
63 Ledger_Id NUMBER, -- Added for bug 6126275
64 Packet_Id NUMBER,
65 User_Name VARCHAR2,
66 Dossier_Transaction_name VARCHAR2,
67 Dossier_Description VARCHAR2,
68 User_Id VARCHAR2,
69 Responsibility_Id VARCHAR2,
70 Dossier_Transaction_Detail VARCHAR2
71 );
72
73 --
74 -- Procedure
75 -- SetRole
76 -- Purpose
77 -- Copies the selected authorizer to the role variable
78 -- History
79 -- 22-OCT-2001 L Silveira Initial Version
80 --
81 PROCEDURE SetRole ( itemtype VARCHAR2,
82 itemkey VARCHAR2,
83 actid NUMBER,
84 funcmode VARCHAR2,
85 result OUT NOCOPY VARCHAR2
86 );
87
88 --
89 -- Procedure
90 -- GetParentPosition
91 -- Purpose
92 -- Traverses through the Approval Hierarchies from bottom
93 -- to top setting the context for validation.
94 -- History
95 -- 22-OCT-2001 L Silveira Initial Version
96 --
97 PROCEDURE GetParentPosition ( itemtype VARCHAR2,
98 itemkey VARCHAR2,
99 actid NUMBER,
100 funcmode VARCHAR2,
101 result OUT NOCOPY VARCHAR2
102 );
103
104 --
105 -- Procedure
106 -- Approve
107 -- Purpose
108 -- Set status of Dossier to 'Approved'
109 -- History
110 -- 22-OCT-2001 L Silveira Initial Version
111 --
112 PROCEDURE Approve ( itemtype VARCHAR2,
113 itemkey VARCHAR2,
114 actid NUMBER,
115 funcmode VARCHAR2,
116 result OUT NOCOPY VARCHAR2
117 );
118
119 --
120 -- Procedure
121 -- Reject
122 -- Purpose
123 -- Set status of Dossier to 'Rejected'
124 -- History
125 -- 22-OCT-2001 L Silveira Initial Version
126 --
127 PROCEDURE Reject ( itemtype VARCHAR2,
128 itemkey VARCHAR2,
129 actid NUMBER,
130 funcmode VARCHAR2,
131 result OUT NOCOPY VARCHAR2
132 );
133
134 --
135 -- Procedure
136 -- SendApproved
137 -- Purpose
138 -- Notifies the Creator of the Dossier that it has been
139 -- approved.
140 -- History
141 -- 22-OCT-2001 L Silveira Initial Version
142 --
143 PROCEDURE SendApproved ( itemtype IN VARCHAR2,
144 itemkey IN VARCHAR2,
145 actid IN NUMBER,
146 funcmode IN VARCHAR2,
147 result OUT NOCOPY VARCHAR2
148 );
149
150 --
151 -- Procedure
152 -- SendRejected
153 -- Purpose
154 -- Notifies the Creator of the Dossier that is has been
155 -- rejected.
156 -- History
157 -- 22-OCT-2001 L Silveira Initial Version
158 --
159 PROCEDURE SendRejected ( itemtype IN VARCHAR2,
160 itemkey IN VARCHAR2,
161 actid IN NUMBER,
162 funcmode IN VARCHAR2,
163 result OUT NOCOPY VARCHAR2
164 );
165
166 --
167 -- Procedure
168 -- CreateList
169 -- Purpose
170 -- Create User List For Parent Position
171 -- History
172 -- 22-OCT-2001 L Silveira Initial Version
173 --
174 PROCEDURE CreateList ( itemtype VARCHAR2,
175 itemkey VARCHAR2,
176 actid NUMBER,
177 funcmode VARCHAR2,
178 result OUT NOCOPY VARCHAR2
179 );
180
181 --
182 -- Procedure
183 -- CheckList
184 -- Purpose
185 -- Check Chosen Option was in List.
186 -- History
187 -- 22-OCT-2001 L Silveira Initial Version
188 --
189 PROCEDURE CheckList ( itemtype VARCHAR2,
190 itemkey VARCHAR2,
191 actid NUMBER,
192 funcmode VARCHAR2,
193 result OUT NOCOPY VARCHAR2
194 );
195
196 --
197 -- Procedure
198 -- UnreserveFunds
199 -- Purpose
200 -- Calls the procedure to unreserve encumbered funds
201 -- for a dossier that has been rejected.
202 -- History
203 -- 22-OCT-2001 L Silveira Initial Version
204 --
205 PROCEDURE UnreserveFunds ( itemtype VARCHAR2,
206 itemkey VARCHAR2,
207 actid NUMBER,
208 funcmode VARCHAR2,
209 result OUT NOCOPY VARCHAR2
210 );
211
212
213 --
214 -- Procedure
215 -- FrameDosTable
216 --
217 -- Purpose
218 -- This procedure frames an HTML table to display details
219 -- in workflow notification.
220 --
221 -- History
222 -- 19-DEC-2003 Rgopalan Initial Version
223 --
224
225 PROCEDURE FrameDosTable ( Document IN OUT NOCOPY CLOB);
226
227
228 --
229 -- Procedure
230 -- AddTotalToTable
231 --
232 -- Purpose
233 -- This Procedure will displaytotal for every destination
234 -- in HTML table, this will be displayed in the
235 -- workflow notification.
236 --
237 -- History
238 -- 24-DEC-2003 Rgopalan 115.8
239
240 PROCEDURE AddTotalToTable ( Document IN OUT NOCOPY CLOB,
241 p_total IN VARCHAR2);
242
243
244 --
245 -- Procedure
246 -- Dossier_Transaction_Detail
247 --
248 -- Purpose
249 -- This Procedure will add source and deatination rows
250 -- to the HTML table, this will be diaplyed in the
251 -- workflow notification.
252 --
253 -- History
254 -- 11-JAN-2001 Sekhar Kappaganti Initial Version
255 -- 19-DEC-2003 Rgopalan 115.8
256
257 Procedure dossier_transaction_detail(document_id in VARCHAR2,
258 display_type in VARCHAR2,
259 document in out NOCOPY CLOB,
260 document_type in out NOCOPY VARCHAR2);
261
262 --
263 -- Bug 2542174 Start(1)
264 --
265 --
266 -- Procedure
267 -- RewindInProcess
268 -- Purpose
269 -- Rewinds the 'In Process' status of the Dossier Transaction
270 -- to 'Creating'
271 -- History
272 -- 23-SEP-2002 L Silveira Initial Version
273 --
274 PROCEDURE RewindInProcess( itemtype IN VARCHAR2,
275 itemkey IN VARCHAR2,
276 actid IN NUMBER,
277 funcmode IN VARCHAR2,
278 result OUT NOCOPY VARCHAR2
279 );
280
281 --
282 -- Procedure
283 -- IsEmployee
284 -- Purpose
285 -- Validates if dossier approval launcher is an employee.
286 -- History
287 -- 23-SEP-2002 L Silveira Initial Version
288 --
289 PROCEDURE IsEmployee( itemtype IN VARCHAR2,
290 itemkey IN VARCHAR2,
291 actid IN NUMBER,
292 funcmode IN VARCHAR2,
293 result OUT NOCOPY VARCHAR2
294 );
295
296 --
297 -- Procedure
298 -- HasPosition
299 -- Purpose
300 -- Validates if dossier approval launcher has a position
301 -- assignment.
302 -- History
303 -- 23-SEP-2002 L Silveira Initial Version
304 --
305 PROCEDURE HasPosition( itemtype IN VARCHAR2,
306 itemkey IN VARCHAR2,
307 actid IN NUMBER,
308 funcmode IN VARCHAR2,
309 result OUT NOCOPY VARCHAR2
310 );
311
312 --
313 -- Procedure
314 -- PositionInHierarchy
315 -- Purpose
316 -- Validates if dossier approval launcher position is in the
317 -- hierarchy attached to the dossier type.
318 -- History
319 -- 23-SEP-2002 L Silveira Initial Version
320 --
321 PROCEDURE PositionInHierarchy( itemtype IN VARCHAR2,
322 itemkey IN VARCHAR2,
323 actid IN NUMBER,
324 funcmode IN VARCHAR2,
325 result OUT NOCOPY VARCHAR2
326 );
327 --
328 -- Bug 2542174 End(1)
329 --
330 PROCEDURE IsRespValid( itemtype IN VARCHAR2,
331 itemkey IN VARCHAR2,
332 actid IN NUMBER,
333 funcmode IN VARCHAR2,
334 result OUT NOCOPY VARCHAR2 ) ;
335 END igidosl;