DBA Data[Home] [Help]

PACKAGE: APPS.IGI_EXPWORKFLOW

Source


1 PACKAGE igi_expworkflow AUTHID CURRENT_USER AS
2   -- $Header: igiwfacs.pls 115.6 2002/11/19 04:37:17 panaraya ship $
3   --
4   -- Procedure
5   --   Selector
6   -- Purpose
7   --   Calls the required runnable process.
8   -- History
9   --   09-JUN-99  G. Celand Initial Revision
10   -- Notes
11  PROCEDURE Selector( itemtype   IN VARCHAR2,
12                      itemkey    IN VARCHAR2,
13                      actid      IN NUMBER,
14                      funcmode   IN VARCHAR2,
15                      resultout OUT NOCOPY VARCHAR2) ;
16 
17 
18   -- Procedure
19   --   StartUp
20   -- Purpose
21   --   Creates and starts an instance of the workflow.
22   -- History
23   --   May 24, 1999 Ashik KESSARIA    Creation
24   -- Notes
25   PROCEDURE Startup ( Wkf_Name       VARCHAR2,
26                       Trans_Unit_Id  NUMBER,
27                       Trans_Unit_Num VARCHAR2,
28                       Wkf_Id         NUMBER,
29                       Flow_Id        NUMBER,
30                       User_Name      VARCHAR2);
31 
32 
33   -- Procedure
34   --   LegalNumbering
35   -- Purpose
36   --   Generates Legal Numbering for TU and DU
37   -- History
38   --   May 24, 1999 Ashik KESSARIA    Creation
39   -- Notes
40   PROCEDURE LegalNumbering ( itemtype   VARCHAR2,
41                              itemkey    VARCHAR2,
42                              actid      NUMBER,
43                              funcmode   VARCHAR2,
44                              result OUT NOCOPY VARCHAR2);
45 
46 
47   -- Procedure
48   --   SetRole
49   -- Purpose
50   --   Sets up a role for a notification to use
51   -- History
52   --   May 24, 1999 Ashik KESSARIA    Creation
53   -- Notes
54   PROCEDURE SetRole ( itemtype   VARCHAR2,
55                       itemkey    VARCHAR2,
56                       actid      NUMBER,
57                       funcmode   VARCHAR2,
58                       result OUT NOCOPY VARCHAR2);
59 
60 
61   -- Procedure
62   --   GetParentPosition
63   -- Purpose
64   --   Traverses through the Approval Hierarchies from bottom
65   --   to top setting the context for validation.
66   -- History
67   --   May 24, 1999 Ashik KESSARIA    Creation
68   -- Notes
69   PROCEDURE GetParentPosition ( itemtype   VARCHAR2,
70                                 itemkey    VARCHAR2,
71                                 actid      NUMBER,
72                                 funcmode   VARCHAR2,
73                                 result OUT NOCOPY VARCHAR2);
74 
75 
76   -- Procedure
77   --   Terminate
78   -- Purpose
79   --   Set status of TU to Terminated -TER
80   -- History
81   --   May 24, 1999 G. Celand Creation
82   -- Notes
83   PROCEDURE Terminate ( itemtype   VARCHAR2,
84                         itemkey    VARCHAR2,
85                         actid      NUMBER,
86                         funcmode   VARCHAR2,
87                         result OUT NOCOPY VARCHAR2);
88 
89 
90   -- Procedure
91   --   BreakLink
92   -- Purpose
93   --   Break the link between a TU and DU
94   -- History
95   --   May 24, 1999 Ashik KESSARIA    Creation
96   -- Notes
97   PROCEDURE BreakLink( itemtype   VARCHAR2,
98                        itemkey    VARCHAR2,
99                        actid      NUMBER,
100                        funcmode   VARCHAR2,
101                        result OUT NOCOPY VARCHAR2);
102 
103 
104 
105   -- Procedure
106   --   CreateList
107   -- Purpose
108   --   Create User List For Parent Position
109   -- History
110   --   May 24, 1999 Ashik KESSARIA    Creation
111   -- Notes
112   PROCEDURE CreateList ( itemtype   VARCHAR2,
113                          itemkey    VARCHAR2,
114                          actid      NUMBER,
115                          funcmode   VARCHAR2,
116                          result OUT NOCOPY VARCHAR2);
117 
118 
119   -- Procedure
120   --   CheckList
121   -- Purpose
122   --   Checks Chosen Option was in List.
123   -- History
124   --   May 24, 1999 Ashik KESSARIA    Creation
125   -- Notes
126   PROCEDURE CheckList ( itemtype   VARCHAR2,
127                         itemkey    VARCHAR2,
128                         actid      NUMBER,
129                         funcmode   VARCHAR2,
130                         result OUT NOCOPY VARCHAR2);
131 
132 
133   -- Procedure
134   --   Cancel
135   -- Purpose
136   --   To Call the Cancel Routine to cancel all successfully
137   --   validated documents in a Transmission Unit.
138   -- History
139   --   16-JUN-1999 GWCeland    Creation
140   -- Notes
141   PROCEDURE Cancel ( itemtype   VARCHAR2,
142                      itemkey    VARCHAR2,
143                      actid      NUMBER,
144                      funcmode   VARCHAR2,
145                      result OUT NOCOPY VARCHAR2);
146 
147 
148   -- Procedure
149   --   HoldApprove
150   -- Purpose
151   --   Stub.
152   -- History
153   --   16-JUN-1999 GWCeland    Creation
154   -- Notes
155   PROCEDURE HoldApprove ( itemtype   VARCHAR2,
156                           itemkey    VARCHAR2,
157                           actid      NUMBER,
158                           funcmode   VARCHAR2,
159                           result OUT NOCOPY VARCHAR2);
160 
161 
162   -- Procedure
163   --   Complete_AR
164   -- Purpose
165   --   To  complete all AR documents contained within a dialogue unit
166   -- History
167   --   23-Sep-1999 GWCeland    Creation
168   -- Notes
169   PROCEDURE Complete_AR ( itemtype   VARCHAR2,
170                           itemkey    VARCHAR2,
171                           actid      NUMBER,
172                           funcmode   VARCHAR2,
173                           result OUT NOCOPY VARCHAR2);
174 
175 
176   -- Procedure
177   --   ValidateGLDate
178   -- Purpose
179   --   To to check that the GL date will be updated to a valid date.
180   -- History
181   --   02-Dec-1999 GWCeland    Creation
182   -- Notes
183   PROCEDURE ValidateGLDate ( itemtype   VARCHAR2,
184                              itemkey    VARCHAR2,
185                              actid      NUMBER,
186                              funcmode   VARCHAR2,
187                              result OUT NOCOPY VARCHAR2);
188 
189 
190   -- Procedure
191   --   MainAuthRequired
192   -- Purpose
193   --   To to check if any dialog need requisitioning.
194   -- History
195   --   22-Dec-1999 GWCeland    Creation
196   -- Notes
197   PROCEDURE MainAuthRequired ( itemtype   VARCHAR2,
198                                itemkey    VARCHAR2,
199                                actid      NUMBER,
200                                funcmode   VARCHAR2,
201                                result OUT NOCOPY VARCHAR2);
202 
203   -- Procedure
204   --   ResetDUStatus
205   -- Purpose
206   --   Reset Dialog Unit status for next authorizer.
207   -- History
208   --   11-Jan-2000 GWCeland    Creation
209   -- Notes
210   PROCEDURE ResetDUStatus ( itemtype   VARCHAR2,
211                             itemkey    VARCHAR2,
212                             actid      NUMBER,
213                             funcmode   VARCHAR2,
214                             result OUT NOCOPY VARCHAR2);
215 
216   -- Procedure
217   --   ContinueValidating
218   -- Purpose
219   --   Determines if all dialog units have been rejected and if so avoids acceptance.
220   -- History
221   --   11-Jan-2000 GWCeland    Creation
222   -- Notes
223   PROCEDURE ContinueValidating ( itemtype   VARCHAR2,
224                                  itemkey    VARCHAR2,
225                                  actid      NUMBER,
226                                  funcmode   VARCHAR2,
227                                  result OUT NOCOPY VARCHAR2);
228 
229 
230   -- Procedure
231   --   AllDUsRejected
232   -- Purpose
233   --   Determines if all dialog units have been rejected and if so avoids point of acceptance.
234   -- History
235   --   19-Jan-2000 GWCeland    Creation
236   -- Notes
237   PROCEDURE AllDUsRejected ( itemtype   VARCHAR2,
238                              itemkey    VARCHAR2,
239                              actid      NUMBER,
240                              funcmode   VARCHAR2,
241                              result OUT NOCOPY VARCHAR2);
242 
243 
244 
245   PROCEDURE control_buttons( itemtype   IN VARCHAR2,
246                              itemkey    IN VARCHAR2,
247                              actid      IN NUMBER,
248                              funcmode   IN VARCHAR2,
249                              resultout  OUT NOCOPY VARCHAR2) ;
250 
251 
252 
253   PROCEDURE control_forwarding( itemtype   IN VARCHAR2,
254                                 itemkey    IN VARCHAR2,
255                                 actid      IN NUMBER,
256                                 funcmode   IN VARCHAR2,
257                                 resultout  OUT NOCOPY VARCHAR2) ;
258 
259 
260 
261    -- global variable to hold user id
262    g_userid NUMBER ;
263 
264 END igi_expworkflow ;