DBA Data[Home] [Help]

PACKAGE: APPS.XDP_ENGINE

Source


1 PACKAGE XDP_ENGINE AUTHID CURRENT_USER AS
2 /* $Header: XDPENGNS.pls 120.1 2005/06/15 22:56:36 appldev  $ */
3 
4 
5 -- Datastructure Definitions
6 
7 TYPE PARAMETER_REC IS RECORD(
8     PARAMETER_NAME VARCHAR2(80),
9     IS_VALUE_EVALUATED_FLAG Varchar2(1),
10     PARAMETER_VALUE VARCHAR2(2000),
11     PARAMETER_REFERENCE_VALUE VARCHAR2(2000) DEFAULT NULL);
12 
13 -- list of the activation parameter
14   TYPE PARAMETER_LIST IS TABLE OF PARAMETER_REC
15     INDEX BY BINARY_INTEGER;
16 
17 
18   pv_FeAttributeList XDP_TYPES.ORDER_PARAMETER_LIST;
19 
20   pv_evalModeUponReceipt varchar2(80) := 'ON_ORDER_RECEIPT';
21   pv_evalModeDeferred varchar2(80) := 'ON_PROCESS_ORDER';
22   pv_evalModeWIStart varchar2(80) := 'ON_WORKITEM_START';
23 
24 -- API specifications
25 
26 -- Start of comments
27 --	API name 	: GET_WORKITEM_PARAM_VALUE
28 --	Type		: Public
29 --	Function	: Get a workitem parameter value.
30 --	Pre-reqs	: None.
31 --	Parameters	:
32 --
33 --	IN		:	p_wi_instance_id:	NUMBER	Required
34 --					The runtime ID for a given work item instance
35 --				p_parameter_name:	VARCHAR2 	Required
36 --					The name of the work item parameter
37 --	@return		The value of the parameter will be returned.
38 --
39 --	Version	: Current version	11.5
40 --	Notes	:
41 --   Get a workitem parameter value.  The macro
42 --   $WI.<parameter_name> in FP actually uses this
43 --   function for runtime value substitution.
44 -- End of comments
45  FUNCTION GET_WORKITEM_PARAM_VALUE(
46 	p_wi_instance_id IN NUMBER,
47 	p_parameter_name IN VARCHAR2)
48    RETURN VARCHAR2;
49 
50 -- Start of comments
51 --	API name 	: GET_WORKITEM_PARAM_REF_VALUE
52 --	Type		: Public
53 --	Function	: Get a workitem parameter reference value.
54 --	Pre-reqs	: None.
55 --	Parameters	:
56 --
57 --	IN		:	p_wi_instance_id:	NUMBER	Required
58 --					The runtime ID for a given work item instance
59 --				p_parameter_name:	VARCHAR2 	Required
60 --					The name of the work item parameter
61 --	@return		The reference value of the parameter will be returned.
62 --
63 --	Version	: Current version	11.5
64 --	Notes	:
65 --   Get a workitem parameter reference value.  The macro
66 --   $WI_REF.<parameter_name> in FP actually uses this
67 --   function for runtime value substitution.
68 -- End of comments
69  FUNCTION GET_WORKITEM_PARAM_REF_VALUE(
70 	p_wi_instance_id IN NUMBER,
71 	p_parameter_name IN VARCHAR2)
72    RETURN VARCHAR2;
73 
74 -- Start of comments
75 --	API name 	: GET_WORKITEM_PARAM_VALUE
76 --	Type		: Private
77 --	Function	: Get the additional information for a work item parameter.
78 --	Pre-reqs	: None.
79 --	Parameters	:
80 --
81 --	IN		:	p_wi_instance_id:	NUMBER	Required
82 --					The runtime ID for a given work item instance
83 --				p_parameter_name:	VARCHAR2 	Required
84 --					The name of the work item parameter
85 --	OUT		:	p_param_val:			VARCHAR2
86 --					The value of the parameter.
87 --				p_parameter_ref_val:	VARCHAR2
88 --					The reference value of the parameter.
89 --				p_log_value_flag:	BOOLEAN
90 --					Indicate that the value should be stored in audit trail table or not
91 --				p_return_code:		NUMBER
92 --					Indicate the status of the API call.  Any non-zero values represents error.
93 --				p_error_description:	VARCHAR2
94 --					The description of error which is raised by the API
95 --
96 --	Version	: Current version	11.5
97 --	Notes	:
98 --  This procedure is used by SEND function to
99 --  get the additional information regarding
100 --  an workitem parameter.  It will also return a flag
101 --  to indicate if the parameter contains value
102 --  for a data sensitive parameter.  If it does, the command
103 --  string which SFM is about to send will not be logged
104 --  in our command audit trail tables.
105 -- End of comments
106  PROCEDURE GET_WORKITEM_PARAM_VALUE(
107 	p_wi_instance_id IN NUMBER,
108 	p_parameter_name IN VARCHAR2,
109 	p_param_val	     OUT NOCOPY VARCHAR2,
110 	p_param_ref_val  OUT NOCOPY VARCHAR2,
111 	p_log_value_flag  OUT NOCOPY BOOLEAN,
112 	p_return_code   OUT NOCOPY number,
113 	p_error_description  OUT NOCOPY VARCHAR2);
114 
115 -- Start of comments
116 --	API name 	: GET_WORKITEM_PARAM_List
117 --	Type		: Private
118 --	Function	: Get a list of parameter value for a given work item.
119 --	Pre-reqs	: None.
120 --	Parameters	:
121 --
122 --	IN		:	p_wi_instance_id:	NUMBER	Required
123 --					The runtime ID for a given work item instance
124 --	@return		The list of values for all the parameters of a given work item
125 --	Version	: Current version	11.5
126 --	Notes	:
127 --   Get a list of the parameter values for
128 --   a given workitem instance
129 -- End of comments
130  FUNCTION GET_WORKITEM_PARAM_List(
131 	p_wi_instance_id IN NUMBER)
132    RETURN XDP_ENGINE.PARAMETER_LIST;
133 
134 -- Start of comments
135 --	API name 	: SET_WORKITEM_PARAM_VALUE
136 --	Type		: Public
137 --	Function	: Set the value for a work item parameter.
138 --	Pre-reqs	: None.
139 --	Parameters	:
140 --
141 --	IN		:	p_wi_instance_id:	NUMBER	Required
142 --					The runtime ID for a given work item instance
143 --				p_parameter_name:	VARCHAR2 	Required
144 --					The name of the work item parameter
145 --				p_parameter_value:	VARCHAR2 	Required
146 --					The new value of the work item parameter
147 --				p_parameter_reference_value:	VARCHAR2 	Optional
148 --					The new reference value of the work item parameter
149 --					Default to be NULL.
150 --				p_evaluation_required:	BOOLEAN 	Optional
151 --					Indicate that the evaluation procedure should be executed if applicable.
152 --					Default to be FALSE.
153 --
154 --	Version	: Current version	11.5
155 --	Notes	:
156 --   Set the workitem parameter value for
157 --   a given workitem instance.  The parameter
158 --   evaluation procedure will be executed if
159 --   applicable.
160 -- End of comments
161  PROCEDURE Set_Workitem_Param_value(
162 		p_wi_instance_id IN NUMBER,
163 		p_parameter_name IN VARCHAR2,
164 		p_parameter_value IN VARCHAR2,
165 		p_parameter_reference_value IN VARCHAR2 DEFAULT NULL,
166 		p_evaluation_required IN BOOLEAN DEFAULT FALSE);
167 
168 -- Start of comments
169 --	API name 	: GET_WORKITEM_PROV_DATE
170 --	Type		: Public
171 --	Function	: Get the Fulfillment Date for a Workitem Instance.
172 --	Pre-reqs	: None.
173 --	Parameters	:
174 --
175 --	IN		:	p_wi_instance_id:	NUMBER	Required
176 --					The runtime ID for a given work item instance
177 --	@return		The work item Fulfillment date.
178 --
179 --	Version	: Current version	11.5
180 --	Notes	:
181 --   Get the Fulfillment Date for a Workitem Instance
182 -- End of comments
183  FUNCTION GET_WORKITEM_PROV_DATE(
184                p_wi_instance_id IN NUMBER)
185    RETURN DATE;
186 
187 -- Start of comments
188 --	API name 	: SET_WORKITEM_PROV_DATE
189 --	Type		: Public
190 --	Function	: Set the Fulfillment Date for a Workitem Instance.
191 --	Pre-reqs	: None.
192 --	Parameters	:
193 --
194 --	IN		:	p_wi_instance_id:	NUMBER	Required
195 --					The runtime ID for a given work item instance
196 --				p_prov_date			DATE	Required
197 --					The Fulfillment Date for a Workitem Instance
198 --	OUT		:	p_return_code:		NUMBER
199 --					Indicate the status of the API call.  Any non-zero values represents error.
200 --				p_error_description:	VARCHAR2
201 --					The description of error which is raised by the API
202 --
203 --	Version	: Current version	11.5
204 --	Notes	:
205 --  Set the Fulfillment Date for a Workitem Instance
206 --  If the Workitem is being processed or already processed an error code is returned
207 -- End of comments
208   PROCEDURE SET_WORKITEM_PROV_DATE(
209 		p_wi_instance_id in NUMBER,
210 		p_prov_date IN DATE,
211      	p_return_code   OUT NOCOPY NUMBER,
212         p_error_description  OUT NOCOPY VARCHAR2);
213 
214 -- Start of comments
215 --	API name 	: GET_FA_PARAM_VALUE
216 --	Type		: Public
217 --	Function	: Get a fulfillment action parameter value.
218 --	Pre-reqs	: None.
219 --	Parameters	:
220 --
221 --	IN		:	p_fa_instance_id:	NUMBER	Required
222 --					The runtime ID for a given fulfillment action instance
223 --				p_parameter_name:	VARCHAR2 	Required
224 --					The name of the fulfillment action parameter
225 --	@return		The value of the parameter will be returned.
226 --
227 --	Version	: Current version	11.5
228 --	Notes	:
229 --  Get an FA parameter value.  The macro
230 --  $FA.<parameter_name> in FP actually uses this
231 --  function for runtime value substitution.
232 -- End of comments
233  FUNCTION GET_FA_PARAM_VALUE(
234 	p_fa_instance_id IN NUMBER,
235 	p_parameter_name IN VARCHAR2)
236    RETURN VARCHAR2;
237 
238 -- Start of comments
239 --	API name 	: GET_FA_PARAM_REF_VALUE
240 --	Type		: Public
241 --	Function	: Get a fulfillment action parameter reference value.
242 --	Pre-reqs	: None.
243 --	Parameters	:
244 --
245 --	IN		:	p_fa_instance_id:	NUMBER	Required
246 --					The runtime ID for a given fulfillment action instance
247 --				p_parameter_name:	VARCHAR2 	Required
248 --					The name of the fulfillment action parameter
249 --	@return		The reference value of the parameter will be returned.
250 --
251 --	Version	: Current version	11.5
252 --	Notes	:
253 --  Get an FA parameter reference value.  The macro
254 --  $FA_REF.<parameter_name> in FP actually uses this
255 --  function for runtime value substitution.
256 -- End of comments
257  FUNCTION GET_FA_PARAM_REF_VALUE(
258 	p_fa_instance_id IN NUMBER,
259 	p_parameter_name IN VARCHAR2)
260    RETURN VARCHAR2;
261 
262 -- Start of comments
263 --	API name 	: GET_FA_PARAM_VALUE
264 --	Type		: Private
265 --	Function	: Get the additional information for FA parameter.
266 --	Pre-reqs	: None.
267 --	Parameters	:
268 --
269 --	IN		:	p_fa_instance_id:	NUMBER	Required
270 --					The runtime ID for a given fulfillment action instance
271 --				p_parameter_name:	VARCHAR2 	Required
272 --					The name of the fulfillment action parameter
273 --	OUT		:	p_param_val:			VARCHAR2
274 --					The value of the parameter.
275 --				p_parameter_ref_val:	VARCHAR2
276 --					The reference value of the parameter.
277 --				p_log_value_flag:	BOOLEAN
278 --					Indicate that the value should be stored in audit trail table or not
279 --				p_return_code:		NUMBER
280 --					Indicate the status of the API call.  Any non-zero values represents error.
281 --				p_error_description:	VARCHAR2
282 --					The description of error which is raised by the API
283 --
284 --	Version	: Current version	11.5
285 --	Notes	:
286 --  This procedure is used by SEND function to
287 --  get the additional information regarding
288 --  an FA parameter.  It will also return a flag
289 --  to indicate if the parameter contains decrypted value
290 --  for an encypted parameter.  If it does, the command
291 --  string which SFM is about to send will not be logged
292 --  in our command audit trail tables.
293 -- End of comments
294  PROCEDURE GET_FA_PARAM(
295 	p_fa_instance_id IN NUMBER,
296 	p_parameter_name IN VARCHAR2,
297 	p_param_val	     OUT NOCOPY VARCHAR2,
298 	p_param_ref_val  OUT NOCOPY VARCHAR2,
299 	p_log_value_flag  OUT NOCOPY BOOLEAN,
300 	p_return_code   OUT NOCOPY number,
301 	p_error_description  OUT NOCOPY VARCHAR2);
302 
303 -- Start of comments
304 --	API name 	: GET_FA_PARAM_List
305 --	Type		: Private
306 --	Function	: Get a list of parameter values for a given fulfillment action instance.
307 --	Pre-reqs	: None.
308 --	Parameters	:
309 --
310 --	IN		:	p_fa_instance_id:	NUMBER	Required
311 --					The runtime ID for a given fulfillment action instance
312 --	@return		The list of values for all the parameters of a given fulfillment action
313 --
314 --	Version	: Current version	11.5
315 --	Notes	:
316 --  Get a list of the parameter values for
317 --  a given FA instance
318 -- End of comments
319  FUNCTION GET_FA_PARAM_List(
320 	p_fa_instance_id IN NUMBER)
321    RETURN XDP_ENGINE.PARAMETER_LIST;
322 
323 -- Start of comments
324 --	API name 	: SET_FA_PARAM_VALUE
325 --	Type		: Public
326 --	Function	: Set the value for a fulfillment action parameter.
327 --	Pre-reqs	: None.
328 --	Parameters	:
329 --
330 --	IN		:	p_fa_instance_id:	NUMBER	Required
331 --					The runtime ID for a given fulfillment action instance
332 --				p_fa_parameter_name:	VARCHAR2 	Required
333 --					The name of the fulfillment action parameter
334 --				p_parameter_value:	VARCHAR2 	Required
335 --					The new value of the fulfillment action parameter
336 --				p_parameter_reference_value:	VARCHAR2 	Optional
337 --					The new reference value of the fulfillment action parameter
338 --					Default to be NULL.
339 --				p_evaluation_required:	BOOLEAN 	Optional
340 --					Indicate that the evaluation procedure should be executed if applicable.
341 --
342 --	Version	: Current version	11.5
343 --	Notes	:
344 --   Set the FA parameter value for
345 --   a given FA instance.  The parameter
346 --   evaluation procedure will be executed if
347 --   applicable.
348 -- End of comments
349  PROCEDURE Set_FA_Param_value(
350 		p_fa_instance_id IN NUMBER,
351 		p_parameter_name IN VARCHAR2,
352 		p_parameter_value IN VARCHAR2,
353 		p_parameter_reference_value IN VARCHAR2 DEFAULT NULL,
354 		p_evaluation_required IN BOOLEAN DEFAULT FALSE);
355 
356 
357 -- Start of comments
358 --	API name 	: GET_ORDER_PARAM_VALUE
359 --	Type		: Public
360 --	Function	: Get an order parameter value.
361 --	Pre-reqs	: None.
362 --	Parameters	:
363 --
364 --	IN		:	p_order_id:	NUMBER	Required
365 --					The internal ID for a given order
366 --				p_parameter_name:	VARCHAR2 	Required
367 --					The name of the order parameter
368 --	@return		The value of the parameter will be returned.
369 --
370 --	Version	: Current version	11.5
371 --	Notes	:
372 --  Get the value of an order parameter
373 -- End of comments
374  FUNCTION GET_ORDER_PARAM_VALUE(
375 	p_order_id IN NUMBER,
376 	p_parameter_name IN VARCHAR2)
377    RETURN VARCHAR2;
378 
379 -- Start of comments
380 --
381 --	Version	: Current version	11.5
382 --	API name 	: GET_ORDER_PARAM_List
383 --	Type		: Private
384 --	Function	: Get a list of parameter values for a given order.
385 --	Pre-reqs	: None.
386 --	Parameters	:
387 --
388 --	IN		:	p_order_id:	NUMBER	Required
389 --					The internal ID for a given order
390 --	@return		The list of values for all the order parameters of a given order
391 --
392 --	Notes	:
393 -- End of comments
394  FUNCTION GET_ORDER_PARAM_List(
395 	p_order_id IN NUMBER  )
396    RETURN XDP_ENGINE.PARAMETER_LIST;
397 
398 -- Start of comments
399 --	API name 	: SET_ORDER_PARAM_VALUE
400 --	Type		: Public
401 --	Function	: Set the value for an order parameter.
402 --	Pre-reqs	: None.
403 --	Parameters	:
404 --
405 --	IN		:	p_order_id:	NUMBER	Required
406 --					The internal ID for a given order
407 --				p_parameter_name:	VARCHAR2 	Required
408 --					The name of the order parameter
409 --				p_parameter_value:	VARCHAR2 	Required
410 --					The new value of the order parameter
411 --
412 --	Version	: Current version	11.5
413 --	Notes	:
414 --  Set an order parameter value
415 -- End of comments
416  PROCEDURE Set_ORDER_Param_value(
417 		p_order_id IN NUMBER,
418 		p_parameter_name IN VARCHAR2,
419 		p_parameter_value IN VARCHAR2);
420 
424 --	Function	: Get an order line parameter value.
421 -- Start of comments
422 --	API name 	: GET_LINE_PARAM_VALUE
423 --	Type		: Public
425 --	Pre-reqs	: None.
426 --	Parameters	:
427 --
428 --	IN		:	p_line_item_id:	NUMBER	Required
429 --					The internal ID for a given order line
430 --				p_parameter_name:	VARCHAR2 	Required
431 --					The name of the order line parameter
432 --	@return		The value of the parameter will be returned.
433 --
434 --	Version	: Current version	11.5
435 --	Notes	:
436 --  Get the value of a line parameter
437 -- End of comments
438  FUNCTION GET_LINE_PARAM_VALUE(
439 	p_line_item_id IN NUMBER,
440 	p_parameter_name IN VARCHAR2)
441    RETURN VARCHAR2;
442 
443 -- Start of comments
444 --	API name 	: GET_LINE_PARAM_REF_VALUE
445 --	Type		: Public
446 --	Function	: Get an order line parameter reference value.
447 --	Pre-reqs	: None.
448 --	Parameters	:
449 --
450 --	IN		:	p_line_item_id:	NUMBER	Required
451 --					The internal ID for a given order line
452 --				p_parameter_name:	VARCHAR2 	Required
453 --					The name of the order line parameter
454 --	@return		The reference value of the parameter will be returned.
455 --
456 --	Version	: Current version	11.5
457 --	Notes	:
458 -- End of comments
459  FUNCTION GET_LINE_PARAM_REF_VALUE(
460 	p_line_item_id IN NUMBER,
461 	p_parameter_name IN VARCHAR2)
462    RETURN VARCHAR2;
463 
464 -- Start of comments
465 --	API name 	: ADD_LINE_PARAM
466 --	Type		: Public
467 --	Function	: Add a new runtime parameter to a given line.
468 --	Pre-reqs	: None.
469 --	Parameters	:
470 --
471 --	IN		:	p_line_item_id:	NUMBER	Required
472 --					The internal ID for a given order line
473 --				p_parameter_name:	VARCHAR2 	Required
474 --					The name of the order line parameter
475 --				p_parameter_value:	VARCHAR2 	Required
476 --					The value of the order line parameter
477 --				p_parameter_reference_value:	VARCHAR2 	Optional
478 --					The reference value of the order line parameter
479 --
480 --	Version	: Current version	11.5
481 --	Notes	:
482 -- End of comments
483  PROCEDURE ADD_LINE_PARAM(
484 	p_line_item_id IN NUMBER,
485 	p_parameter_name IN VARCHAR2,
486 	p_parameter_value IN VARCHAR2,
487 	p_parameter_reference_value IN VARCHAR2 DEFAULT NULL);
488 
489 -- Start of comments
490 --	API name 	: SET_LINE_PARAM_VALUE
491 --	Type		: Public
492 --	Function	: Update an existing parameter value for a given line.
493 --	Pre-reqs	: None.
494 --	Parameters	:
495 --
496 --	IN		:	p_line_item_id:	NUMBER	Required
497 --					The internal ID for a given order line
498 --				p_parameter_name:	VARCHAR2 	Required
499 --					The name of the order line parameter
500 --				p_parameter_value:	VARCHAR2 	Required
501 --					The value of the order line parameter
502 --				p_parameter_reference_value:	VARCHAR2 	Optional
503 --					The reference value of the order line parameter
504 --
505 --	Version	: Current version	11.5
506 --	Notes	:
507 -- End of comments
508  PROCEDURE Set_LINE_PARAM_Value(
509 	p_line_item_id IN NUMBER,
510 	p_parameter_name IN VARCHAR2,
511 	p_parameter_value IN VARCHAR2,
512 	p_parameter_reference_value IN VARCHAR2 DEFAULT NULL);
513 
514 -- Start of comments
515 --	API name 	: Get_FE_ConfigInfo
516 --	Type		: Public
517 --	Function	: Retrieve the configuration data for a given fulfillment element.
518 --	Pre-reqs	: None.
519 --	Parameters	:
520 --
521 --	IN		:	p_fe:	VARCHAR2	Required
522 --					The name of the fulfillment element
523 --	OUT		:	p_fe_id:			NUMBER
524 --					Internal ID for the FE.
525 --				p_fetype_id:		NUMBER
526 --					Internal id for the Fulfillment Element type
527 --				p_fetype:			VARCHAR2
528 --					Name of the Fulfillment Element TYPE.
529 --				p_fe_sw_generic:	VARCHAR2
530 --					The current software generic of the Fulfillment Element.
531 --				p_adapter_type:		VARCHAR2
532 --					The current adapter type of the Fulfillment Element.
533 --
534 --	Version	: Current version	11.5
535 --	Notes	:
536 --  Retrieve the configuration data
537 --  for a given fulfillment element
538 -- End of comments
539  PROCEDURE Get_FE_ConfigInfo(
540 		p_fe IN VARCHAR2,
541 		p_fe_id   OUT NOCOPY NUMBER,
542 		p_fetype_id OUT NOCOPY NUMBER,
543 		p_fetype    OUT NOCOPY VARCHAR2,
544 		p_fe_sw_generic  OUT NOCOPY varchar2,
545 		p_adapter_type OUT NOCOPY varchar2 );
546 
547 -- Start of comments
548 --	API name 	: Get_FE_ConfigInfo
549 --	Type		: Public
550 --	Function	: Retrieve the configuration data for a given fulfillment element.
551 --	Pre-reqs	: None.
552 --	Parameters	:
553 --
554 --	IN		:	p_fe_id:	NUMBER	Required
555 --					Internal ID for the FE.
556 --	OUT		:	p_fe_name:			VARCHAR2
557 --					The name of the fulfillment element
558 --				p_fetype_id:		NUMBER
559 --					Internal id for the Fulfillment Element type
560 --				p_fetype:			VARCHAR2
561 --					Name of the Fulfillment Element TYPE.
562 --				p_fe_sw_generic:	VARCHAR2
563 --					The current software generic of the Fulfillment Element.
564 --				p_adapter_type:		VARCHAR2
565 --					The current adapter type of the Fulfillment Element.
566 --
567 --	Version	: Current version	11.5
568 --	Notes	:
569 --  Retrieve the configuration data
570 --  for a given fulfillment element
571 -- End of comments
575 		p_fetype_id OUT NOCOPY NUMBER,
572  PROCEDURE Get_FE_ConfigInfo(
573 		p_fe_id IN NUMBER,
574 		p_fe_name   OUT NOCOPY VARCHAR2,
576 		p_fetype    OUT NOCOPY VARCHAR2,
577 		p_fe_sw_generic  OUT NOCOPY varchar2,
578 		p_adapter_type OUT NOCOPY varchar2 );
579 
580 
581 -- Start of comments
582 --	API name 	: Get_FE_AttributeVal
583 --	Type		: Group
584 --	Function	: Retrieve the FE Attribute value for a given fulfillment element.
585 --	Pre-reqs	: None.
586 --
587 --	Version	: Current version	11.5
588 --	Notes	:
589 --  Retrieve the FE Attribute value
590 --  for a given fulfillment element
591 -- End of comments
592  FUNCTION  Get_FE_AttributeVal(
593 		p_fe_name IN VARCHAR2,
594 		p_attribute_name IN VARCHAR2)
595   return varchar2;
596 
597 -- Start of comments
598 --	API name 	: Get_FE_AttributeVal
599 --	Type		: Group
600 --	Function	: Overload function.  Retrieve the FE Attribute value for a given fulfillment element.
601 --	Pre-reqs	: None.
602 --
603 --	Version	: Current version	11.5
604 --	Notes	:
605 --  Retrieve the FE Attribute value
606 --  for a given fulfillment element
607 -- End of comments
608  FUNCTION  Get_FE_AttributeVal(
609 		p_fe_id IN NUMBER,
610 		p_attribute_name IN VARCHAR2)
611   return varchar2;
612 
613 -- Start of comments
614 --	API name 	: Get_FE_AttributeVal_List
615 --	Type		: Group
616 --	Function	: Retrieve all the FE Attribute value for a given fulfillment element.
617 --	Pre-reqs	: None.
618 --
619 --	Version	: Current version	11.5
620 --	Notes	:
621 -- End of comments
622  FUNCTION  Get_FE_AttributeVal_List(
623 		  p_fe_name in varchar2)
624    RETURN XDP_TYPES.ORDER_PARAMETER_LIST;
625 
626 
627 -- Start of comments
628 --	API name 	: Get_FE_AttributeVal_List
629 --	Type		: Group
630 --	Function	: Retrieve all the FE Attribute value for a given
631 --			  fulfillment element ID.
632 --	Pre-reqs	: None.
633 --
634 --	Version	: Current version	11.5
635 --	Notes	:
636 -- End of comments
637  FUNCTION  Get_FE_AttributeVal_List(
638 		  p_fe_id in number)
639    RETURN XDP_TYPES.ORDER_PARAMETER_LIST;
640 
641 
642  Procedure PreFetch_FeAttrList( p_fe_name in varchar2,
643 				p_attr_count OUT NOCOPY number);
644 
645  Procedure Fetch_FeAttrFromList(p_index in number,
646 				p_attr_name OUT NOCOPY varchar2,
647 				p_attr_value OUT NOCOPY varchar2);
648 
649 
650 -- Start of comments
651 --	API name 	: Get_FE_ConnectionProc
652 --	Type		: Group
653 --	Function	: Retrieve the connect/disconnect procedure name for a given fulfillment element.
654 --	Pre-reqs	: None.
655 --
656 --	Version	: Current version	11.5
657 --	Notes	:
658 -- End of comments
659  PROCEDURE  Get_FE_ConnectionProc(
660 		p_fe_name IN VARCHAR2,
661 		p_connect_proc_name OUT NOCOPY VARCHAR2,
662 		p_disconnect_proc_name OUT NOCOPY VARCHAR2);
663 
664 -- Start of comments
665 --	API name 	: Get_FE_ConnectionProc
666 --	Type		: Group
667 --	Function	: Overload Function. Get the connect/disconnect procedure name for a given fulfillment element.
668 --	Pre-reqs	: None.
669 --
670 --	Version	: Current version	11.5
671 --	Notes	:
672 --   Retrieve the FE connect/disconnect procedure name
673 --   for a given fulfillment element
674 -- End of comments
675  PROCEDURE  Get_FE_ConnectionProc(
676 		p_fe_id IN NUMBER,
677 		p_connect_proc_name OUT NOCOPY VARCHAR2,
678 		p_disconnect_proc_name OUT NOCOPY VARCHAR2);
679 
680 -- Start of comments
681 --	API name 	: Is_fe_valid
682 --	Type		: Public
683 --	Function	: Check if a Fulfillment is valid as of today
684 --	Pre-reqs	: None.
685 --
686 --	Version	: Current version	11.5
687 --	Notes	:
688 -- End of comments
689  Function Is_Fe_Valid(p_fe_name in varchar2) return BOOLEAN;
690 
691 -- Start of comments
692 --	API name 	: Is_fe_valid
693 --	Type		: Public
694 --	Function	: Check if a Fulfillment is valid as of today
695 --	Pre-reqs	: None.
696 --
697 --	Version	: Current version	11.5
698 --	Notes	:
699 -- End of comments
700  Function Is_Fe_Valid(p_fe_id in number) return BOOLEAN;
701 
702 
703 -- Start of comments
704 --	API name 	: Get_Workitem_List
705 --	Type		: Public
706 --	Function	: Retrieve the list of the workitems SFM has executed for the given order.
707 --	Pre-reqs	: None.
708 --
709 --	Version	: Current version	11.5
710 --	Notes	:
711 -- End of comments
712 Function Get_Workitem_List(
713 	p_sdp_order_id NUMBER)
714   return XDP_TYPES.WORKITEM_LIST;
715 
716 -- Start of comments
717 --	API name 	: Get_FA_List
718 --	Type		: Public
719 --	Function	: Retrieve the list of the fulfillment actions SFM has executed for the given workitem.
720 --	Pre-reqs	: None.
721 --
722 --	Version	: Current version	11.5
723 --	Notes	:
724 -- End of comments
725 Function Get_FA_List(
726 	p_wi_instance_id NUMBER)
727   return XDP_TYPES.FULFILLMENT_ACTION_LIST;
728 
729 -- Start of comments
730 --	API name 	: Get_FA_AUDIT_TRAILS
731 --	Type		: Public
735 --	Version	: Current version	11.5
732 --	Function	: Get the list of commands wnd responses which have been sent and received by the given FA
733 --	Pre-reqs	: None.
734 --
736 --	Notes	:
737 -- End of comments
738 Function Get_FA_AUDIT_TRAILS(
739 	p_fa_instance_id NUMBER)
740   return XDP_TYPES.FA_COMMAND_AUDIT_TRAIL;
741 
742 -- Start of comments
743 --	API name 	: Reset_Sync_Registration
744 --	Type		: Public
745 --	Function	: Reset a Synchronisation Request
746 --	Pre-reqs	: None.
747 --
748 --	Version	: Current version	11.5
749 --	Notes	:
750 -- End of comments
751   PROCEDURE Reset_Sync_Registration (
752     pp_sync_label	IN  VARCHAR2
753    ,po_error_code       OUT NOCOPY NUMBER
754    ,po_error_msg	OUT NOCOPY VARCHAR2
755   );
756 
757 -- Start of comments
758 --	API name 	: RECALCULATE
759 --	Type		: Public
760 --	Function	: Recalculate timers
761 --	Pre-reqs	: None.
762 --
763 --	Version	: Current version	11.5
764 --	Notes	:
765 -- End of comments
766   PROCEDURE recalculate
767   (
768     p_reference_id  IN VARCHAR2
769     ,p_timer_message_code IN VARCHAR2
770     ,x_error_code OUT NOCOPY NUMBER
771     ,x_error_message OUT NOCOPY VARCHAR2
772   );
773 
774 -- Start of comments
775 --	API name 	: RECALCULATE_ALL
776 --	Type		: Public
777 --	Function	: Recalculate all timers.
778 --	Pre-reqs	: None.
779 --
780 --	Version	: Current version	11.5
781 --	Notes	:
782 -- End of comments
783   PROCEDURE recalculate_all
784   (
785     p_reference_id IN VARCHAR2
786     ,x_error_code OUT NOCOPY NUMBER
787     ,x_error_message OUT NOCOPY VARCHAR2
788   );
789 
790 -- Start of comments
791 --	API name 	: GET_TIMER_STATUS
792 --	Type		: Public
793 --	Function	: Get timer status using reference_id and timer message code.
794 --	Pre-reqs	: None.
795 --
796 --	Version	: Current version	11.5
797 --	Notes	:
798 -- End of comments
799   PROCEDURE get_timer_status
800   (
801     p_reference_id IN VARCHAR2
802     ,p_timer_message_code IN VARCHAR2
803     ,x_timer_id OUT NOCOPY NUMBER
804     ,x_status OUT NOCOPY VARCHAR2
805     ,x_error_code OUT NOCOPY NUMBER
806     ,x_error_message OUT NOCOPY VARCHAR2
807   );
808 
809 -- Start of comments
810 --	API name 	: UPDATE_TIMER_STATUS
811 --	Type		: Public
812 --	Function	: Update timer status using reference_id and timer_message_code.
813 --	Pre-reqs	: None.
814 --
815 --	Version	: Current version	11.5
816 --	Notes	:
817 -- End of comments
818   PROCEDURE update_timer_status
819   (
820     p_reference_id IN VARCHAR2
821     ,p_timer_message_code IN VARCHAR2
822     ,p_status IN VARCHAR2
823     ,x_error_code OUT NOCOPY NUMBER
824     ,x_error_message OUT NOCOPY VARCHAR2
825   );
826 
827 -- Start of comments
828 --	API name 	: REMOVE_TIMER
829 --	Type		: Public
830 --	Function	: Remove timer using reference_id and timer_message_code.
831 --	Pre-reqs	: None.
832 --
833 --	Version	: Current version	11.5
834 --	Notes	:
835 -- End of comments
836   PROCEDURE remove_timer
837   (
838     p_reference_id IN VARCHAR2
839     ,p_timer_message_code IN VARCHAR2
840     ,x_error_code OUT NOCOPY NUMBER
841     ,x_error_message OUT NOCOPY VARCHAR2
842   );
843 
844 -- Start of comments
845 --	API name 	: RESTART
846 --	Type		: Public
847 --	Function	: Restart a timer using a reference_id and timer_message_code.
848 --	Pre-reqs	: None.
849 --
850 --	Version	: Current version	11.5
851 --	Notes	:
852 -- End of comments
853   PROCEDURE restart
854   (
855     p_reference_id IN VARCHAR2
856     ,p_timer_message_code IN VARCHAR2
857     ,x_error_code OUT NOCOPY NUMBER
858     ,x_error_message OUT NOCOPY VARCHAR2
859   );
860 
861 -- Start of comments
862 --	API name 	: DEREGISTER
863 --	Type		: Public
864 --	Function	: Deregister timers for an order_id.
865 --	Pre-reqs	: None.
866 --
867 --	Version	: Current version	11.5
868 --	Notes	:
869 -- End of comments
870   PROCEDURE deregister
871   (
872     p_order_id IN NUMBER
873     ,x_error_code OUT NOCOPY NUMBER
874     ,x_error_message OUT NOCOPY VARCHAR2
875   );
876 
877 -- Start of comments
878 --	API name 	: RESTART_ALL
879 --	Type		: Public
880 --	Function	: Restart all timers using reference_id.
881 --	Pre-reqs	: None.
882 --
883 --	Version	: Current version	11.5
884 --	Notes	:
885 -- End of comments
886   PROCEDURE restart_all
887   (
888     p_reference_id IN VARCHAR2
889     ,x_error_code OUT NOCOPY NUMBER
890     ,x_error_message OUT NOCOPY VARCHAR2
891 
892   );
893 
894 -- Start of comments
895 --	API name 	: START_RELATED_TIMERS
896 --	Type		: Public
897 --	Function	: Start timers related to a message.
898 --	Pre-reqs	: None.
899 --
900 --	Version	: Current version	11.5
901 --	Notes	:
902 -- End of comments
903   PROCEDURE start_related_timers
904   (
905     p_message_code IN VARCHAR2
906     ,p_reference_id IN VARCHAR2
910     ,p_sender_name IN VARCHAR2 DEFAULT NULL
907     ,x_error_code OUT NOCOPY NUMBER
908     ,x_error_message OUT NOCOPY VARCHAR2
909     ,p_opp_reference_id IN VARCHAR2 DEFAULT NULL
911     ,p_recipient_name IN VARCHAR2 DEFAULT NULL
912     ,p_order_id IN NUMBER DEFAULT NULL
913     ,p_wi_instance_id IN NUMBER DEFAULT NULL
914     ,p_fa_instance_id IN NUMBER DEFAULT NULL
915   );
916 
917 -- Start of Comment
918 --	API name 	: Set_Order_Reference
919 --	Type		: Group
920 --	Function	: API to set the order reference information.
921 --	Pre-reqs	: None.
922 --  Notes		:
923 --	API to set the order reference information such as order
924 -- reference name, order reference value, service provider
925 -- order number, and service provider user ID
926 -- End of Comment
927  PROCEDURE Set_Order_Reference
928  (
929    p_order_id IN NUMBER,
930    p_order_ref_name IN VARCHAR2,
931    p_order_ref_value IN VARCHAR2,
932    p_sp_order_number IN VARCHAR2 DEFAULT NULL,
933    p_sp_user_id  IN NUMBER DEFAULT NULL,
934    x_return_code OUT NOCOPY NUMBER,
935    x_error_description OUT NOCOPY VARCHAR2
936   );
937 
938 -- Start of Comment
939 --	API name 	: XDP_SYNC_LINE_ITEM_PV
940 --	Type		: Group
941 --	Function	: API to change parameter values for line items according to their workitems
942 --	Parameters	:
943 --
944 --	IN			: p_line_item_id	line item id in XDP.
945 --	Pre-reqs	: None.
946 --  Notes		:
947 --
948 -- End of Comment
949   PROCEDURE XDP_SYNC_LINE_ITEM_PV(
950 		p_line_item_id IN XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID%TYPE,
951 		x_return_code OUT NOCOPY NUMBER,
952    		x_error_description OUT NOCOPY VARCHAR2
953   );
954 
955 
956 -- Start of Comment
957 --	API name 	: EvaluateWIParamsOnStart
958 --	Type		: Group
959 --	Function	: API to Evaluate all Workitem Parameters marked as
960 --			  "Upon Workitem Start"
961 --	Parameters	:
962 --
963 --	IN			: p_wi_instance_id	workitem instance id
964 --	Pre-reqs	: None.
965 --  Notes		:
966 --
967 -- End of Comment
968   PROCEDURE EvaluateWIParamsOnStart(p_wi_instance_id in number);
969 
970 END XDP_ENGINE;