1 PACKAGE XNP_WF_SYNC AUTHID CURRENT_USER AS
2 /* $Header: XNPSYNCS.pls 120.2 2006/02/13 07:55:53 dputhiye ship $ */
3
4 -- Synchronise a workflow process
5 --
6 PROCEDURE process_sync (
7 itemtype IN VARCHAR2
8 ,itemkey IN VARCHAR2
9 ,actid IN NUMBER
10 ,funcmode IN VARCHAR2
11 ,resultout OUT NOCOPY VARCHAR2
12 );
13
14 -- Register an order for Synchronisation
15 --
16 PROCEDURE Sync_Register (
17 pp_order_id IN NUMBER
18 ,po_error_code OUT NOCOPY NUMBER
19 ,po_error_msg OUT NOCOPY VARCHAR2
20 );
21
22 -- Set the status of a Synchronisation Request to ERROR
23 --
24 PROCEDURE Raise_Sync_Error (
25 itemtype IN VARCHAR2
26 ,itemkey IN VARCHAR2
27 ,actid IN NUMBER
28 ,funcmode IN VARCHAR2
29 ,resultout OUT NOCOPY VARCHAR2
30 );
31
32 -- Default Processing Logic for SYNC_ERR Event
33 --
34 PROCEDURE Process_Sync_Err (
35 p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE
36 ,x_error_code OUT NOCOPY NUMBER
37 ,x_error_message OUT NOCOPY VARCHAR2
38 );
39
40 -- Default Processing Logic for SYNC_TIMER Event
41 --
42 PROCEDURE Process_Sync_Timer (
43 p_msg_header IN XNP_MESSAGE.MSG_HEADER_REC_TYPE
44 ,x_error_code OUT NOCOPY NUMBER
45 ,x_error_message OUT NOCOPY VARCHAR2
46 );
47
48 -- Procedure to reset a Synchronisation request
49 --
50 PROCEDURE Reset_Sync_Register (
51 pp_sync_label IN VARCHAR2
52 ,po_error_code OUT NOCOPY NUMBER
53 ,po_error_msg OUT NOCOPY VARCHAR2
54 );
55
56 -- Packaged activity for the following activities
57 -- IS_LAST_SYNC and PROCESS_SYNC
58 --
59 PROCEDURE synchronize (
60 itemtype IN VARCHAR2
61 ,itemkey IN VARCHAR2
62 ,actid IN NUMBER
63 ,funcmode IN VARCHAR2
64 ,resultout OUT NOCOPY VARCHAR2
65 );
66
67 -- Checks if the work flow invoking this procedure is
68 -- the last one to synchronize. Uses the parties_not_in_sync
69 -- column in xnp_sync_registration table to determine.
70 --
71 PROCEDURE is_last_sync (
72 itemtype IN VARCHAR2
73 ,itemkey IN VARCHAR2
74 ,actid IN NUMBER
75 ,funcmode IN VARCHAR2
76 ,resultout OUT NOCOPY VARCHAR2
77 );
78
79 -- Sets the SDP_RESULT_CODE workflow item attribute
80 --
81 PROCEDURE set_result_code (
82 p_itemtype IN VARCHAR2
83 ,p_itemkey IN VARCHAR2
84 ,p_result_value IN VARCHAR2
85 );
86
87 -- Workflow activity for sync notification
88 --
89 PROCEDURE syncnotif ( itemtype in varchar2,
90 itemkey in VARCHAR2,
91 actid in NUMBER,
92 funcmode in VARCHAR2,
93 result OUT NOCOPY VARCHAR2
94 ) ;
95 END xnp_wf_sync;