[Home] [Help]
PACKAGE: APPS.XDPCORE
Source
1 PACKAGE XDPCORE AUTHID CURRENT_USER AS
2 /* $Header: XDPCORES.pls 120.1 2005/06/15 22:37:27 appldev $ */
3
4
5
6 e_NullValueException EXCEPTION;
7
8
9
10
11 x_ErrMsg VARCHAR2(2000);
12 x_DebugMsg VARCHAR2(2000);
13
14 x_ErrorID number;
15 x_Code number;
16 x_Str varchar2(800);
17 x_MessageList XDP_TYPES.MESSAGE_TOKEN_LIST;
18
19 business_error VARCHAR2(1) := 'N';
20 object_type VARCHAR2(2000);
21 object_key VARCHAR2(32000);
22 error_name VARCHAR2(30);
23 error_number NUMBER;
24 error_message VARCHAR2(2000);
25 error_stack VARCHAR2(32000);
26
27 -- StartWfProcess
28 -- Generates the itemkey, sets up the Item Attributes,
29 -- then starts the workflow process.
30 --
31 Procedure StartWfProcess ( ItemType in VARCHAR2,
32 ItemKey in VARCHAR2,
33 OrderID in number,
34 WorkflowProcess in VARCHAR2,
35 Caller in VARCHAR2);
36
37
38 -- StartOA Process
39 -- Creates and Starts the OA process
40
41 Procedure StartOAProcess ( OrderID in number);
42
43
44 -- StartInitOrderProcess
45 -- Creates and Starts the InitialOrderProcess
46
47 Procedure StartInitOrderProcess ( OrderID in number);
48
49 -- StartORUProcess
50 -- Creates and Starts the Order Resubmission Process
51
52 Procedure StartORUProcess ( ResubmissionJOBID in number,
53 itemtype OUT NOCOPY varchar2,
54 itemkey OUT NOCOPY varchar2);
55
56
57
58 -- CreateOrderProcess
59 -- then creates the Main Order Process which the Order processor Dequer starts off
60 --
61 Procedure CreateOrderProcess (OrderID in number,
62 ItemType OUT NOCOPY VARCHAR2,
63 ItemKey OUT NOCOPY VARCHAR2 );
64
65
66 -- ENQUEUE_PENDING_QUEUE
67 -- Resultout
68 -- Activity Performed - Activity was completed without any errors
69 --
70 -- Your Description here:
71
72 /****
73
74 Procedure ENQUEUE_PENDING_QUEUE (itemtype in varchar2,
75 itemkey in varchar2,
76 actid in number,
77 funcmode in varchar2,
78 resultout OUT NOCOPY varchar2);
79
80 *****/
81
82
83 -- RESUME_SDP
84 -- Resultout
85 -- Activity Performed - Activity was completed without any errors
86 --
87 -- Your Description here: Put the Order requiring Order Analyzer into the
88 -- Order Analyzer Queue for processing.
89
90 Procedure RESUME_SDP (itemtype in varchar2,
91 itemkey in varchar2,
92 actid in number,
93 funcmode in varchar2,
94 resultout OUT NOCOPY varchar2);
95
96
97 -- LAUNCH_ORDER_ANALYZER
98 -- Resultout
99 -- Activity Performed - Activity was completed without any errors
100 --
101 -- Your Description here:
102
103 Procedure LAUNCH_ORDER_ANALYZER (itemtype in varchar2,
104 itemkey in varchar2,
105 actid in number,
106 funcmode in varchar2,
107 resultout OUT NOCOPY varchar2 );
108
109
110 -- IS_OA_NEEDED
111 -- Resultout
112 -- Activity Performed - Activity was completed without any errors
113 --
114 -- Your Description here:
115
116
117 Procedure IS_OA_NEEDED (itemtype in varchar2,
118 itemkey in varchar2,
119 actid in number,
120 funcmode in varchar2,
121 resultout OUT NOCOPY varchar2);
122
123
124
125 -- Activity Performed - Activity was completed without any errors
126 --
127 -- Your Description here:
128
129
130 Procedure ORDER_TYPE (itemtype in varchar2,
131 itemkey in varchar2,
132 actid in number,
133 funcmode in varchar2,
134 resultout OUT NOCOPY varchar2);
135
136
137
138 -- Resultout
139 -- Activity Performed - Activity was completed without any errors
140 --
141 -- Your Description here:
142
143
144 Procedure WHAT_SOURCE (itemtype in varchar2,
145 itemkey in varchar2,
146 actid in number,
147 funcmode in varchar2,
148 resultout OUT NOCOPY varchar2);
149
150
151 Procedure OP_START (itemtype in varchar2,
152 itemkey in varchar2,
153 actid in number,
154 funcmode in varchar2,
155 resultout OUT NOCOPY varchar2);
156
157 Procedure OP_END (itemtype in varchar2,
158 itemkey in varchar2,
159 actid in number,
160 funcmode in varchar2,
161 resultout OUT NOCOPY varchar2);
162
163 Procedure CheckNAddItemAttrText(itemtype in varchar2,
164 itemkey in varchar2,
165 AttrName in varchar2,
166 AttrValue in varchar2,
167 ErrCode OUT NOCOPY number,
168 ErrStr OUT NOCOPY varchar2);
169
170 Procedure CheckNAddItemAttrNumber(itemtype in varchar2,
171 itemkey in varchar2,
172 AttrName in varchar2,
173 AttrValue in number,
174 ErrCode OUT NOCOPY number,
175 ErrStr OUT NOCOPY varchar2);
176
177 Procedure CheckNAddItemAttrDate(itemtype in varchar2,
178 itemkey in varchar2,
179 AttrName in varchar2,
180 AttrValue in date,
181 ErrCode OUT NOCOPY number,
182 ErrStr OUT NOCOPY varchar2);
183
184 --This procedure creates the child process and sets the parent child
185 --relationship along with the label of wait flow activity in parent
186 -- bug fix for bug #2269403
187 Procedure CreateNAddAttrNParentLabel(itemtype in varchar2,
188 itemkey in varchar2,
189 processname in varchar2,
190 parentitemtype in varchar2,
191 parentitemkey in varchar2,
192 waitflowLabel in varchar2,
193 OrderID in number,
194 LineitemID in number,
195 WIInstanceID in number,
196 FAInstanceID in number);
197
198 Procedure CreateAndAddAttrNum(itemtype in varchar2,
199 itemkey in varchar2,
200 processname in varchar2,
201 parentitemtype in varchar2,
202 parentitemkey in varchar2,
203 OrderID in number,
204 LineitemID in number,
205 WIInstanceID in number,
206 FAInstanceID in number);
207
208
209 Procedure SEND_NOTIFICATION (role in varchar2,
210 msg_type in varchar2,
211 msg_name in varchar2,
212 due_date in varchar2,
213 itemtype in varchar2,
214 itemkey in varchar2,
215 actid in number,
216 priority in number default 100,
217 OrderID in number default null,
218 WIInstanceID in number default null,
219 FAInstanceID in number default null,
220 notifID OUT NOCOPY number);
221
222 Procedure START_FA_RESUBMIT_PROCESS( p_fe_id IN NUMBER,
223 p_start_date IN DATE ,
224 p_end_date IN DATE,
225 p_resubmission_job_id IN NUMBER,
226 x_error_code OUT NOCOPY NUMBER,
227 x_error_message OUT NOCOPY VARCHAR2);
228
229
230 Procedure START_RESUBMISSION_CHANNELS( p_fe_id IN NUMBER,
231 p_channels_reqd IN NUMBER,
232 p_usage_code IN VARCHAR2,
233 x_channels_started OUT NOCOPY NUMBER,
234 x_error_code OUT NOCOPY NUMBER,
235 x_error_message OUT NOCOPY VARCHAR2) ;
236 --
237 -- Clear
238 -- Clear the error buffers.
239 -- EXCEPTIONS
240 -- none
241 --
242 procedure Clear;
243 pragma restrict_references(CLEAR, WNDS, RNDS, RNPS);
244
245
246 --
247 -- Get_Error
248 -- Return current error info and clear error stack.
249 -- Returns null if no current error.
250 -- OUT
251 -- error_name - error name - varchar2(30)
252 -- error_message - substituted error message - varchar2(2000)
253 -- error_stack - error call stack, truncated if needed - varchar2(2000)
254 -- EXCEPTIONS
255 -- none
256 --
257 procedure Get_Error(object_type OUT NOCOPY varchar2,
258 object_key OUT NOCOPY varchar2,
259 err_name OUT NOCOPY varchar2,
260 err_message OUT NOCOPY varchar2,
261 err_stack OUT NOCOPY varchar2);
262 pragma restrict_references(GET_ERROR, WNDS, RNDS);
263
264
265 --
266 -- Context
267 -- set procedure context (for stack trace)
268 -- IN
269 -- pkg_name - package name
270 -- proc_name - procedure/function name
271 -- arg1 - first IN argument
272 -- argn - n'th IN argument
273 -- EXCEPTIONS
274 -- none
275 --
276
277 procedure Context(pkg_name in varchar2,
278 proc_name in varchar2,
279 arg1 in varchar2 default '*none*',
280 arg2 in varchar2 default '*none*',
281 arg3 in varchar2 default '*none*',
282 arg4 in varchar2 default '*none*',
283 arg5 in varchar2 default '*none*',
284 arg6 in varchar2 default '*none*',
285 arg7 in varchar2 default '*none*',
286 arg8 in varchar2 default '*none*',
287 arg9 in varchar2 default '*none*',
288 arg10 in varchar2 default '*none*');
289 pragma restrict_references(CONTEXT, WNDS);
290
291 --
292 -- Error_Context
293 -- set procedure Error context (for logging errors)
294 -- IN
295 -- EXCEPTIONS
296 -- none
297
298 Procedure error_context (object_type in varchar2,
299 object_key in varchar2,
300 error_name in varchar2,
301 error_message in varchar2);
302 pragma restrict_references(error_CONTEXT, WNDS);
303
304 function is_business_error return varchar2;
305 pragma restrict_references(is_business_error, WNDS);
306
307 --
308 -- Raise
309 -- Raise an exception to the caller
310 -- IN
311 -- none
312 -- EXCEPTIONS
313 -- Raises an a user-defined (20002) exception with the error message.
314 --
315 procedure Raise(err_number in number default -20001,
316 err_message in varchar2 default null);
317
318 End XDPCORE;