[Home] [Help]
PACKAGE: APPS.XDPCORE_WI
Source
1 PACKAGE XDPCORE_WI AUTHID CURRENT_USER AS
2 /* $Header: XDPCORWS.pls 120.2 2005/07/10 23:43:48 appldev noship $ */
3
4
5
6 e_NullValueException EXCEPTION;
7
8 x_ErrMsg VARCHAR2(2000);
9 x_DebugMsg VARCHAR2(2000);
10 g_WIInstance_ID_in_Error VARCHAR2(100);
11
12
13
14 cursor c_WIList (OrderID number, LineItemID number, prov_seq number) is
15 select WORKITEM_INSTANCE_ID, WORKITEM_ID, PRIORITY, WI_SEQUENCE
16 from XDP_FULFILL_WORKLIST
17 where ORDER_ID = OrderID
18 and LINE_ITEM_ID = LineItemID
19 and status_code = 'STANDBY'
20 and WI_SEQUENCE = (
21 select MIN(WI_SEQUENCE)
22 from XDP_FULFILL_WORKLIST
23 where ORDER_ID = OrderID
24 and LINE_ITEM_ID = LineItemID
25 and status_code = 'STANDBY'
26 and WI_SEQUENCE > prov_seq);
27
28
29 Procedure CreateWorkitemProcess (wftype in varchar2,
30 parentitemtype in varchar2,
31 parentitemkey in varchar2,
32 itemtype in varchar2,
33 itemkeyPrefix in varchar2,
34 itemkey OUT NOCOPY varchar2,
35 workflowprocessname in varchar2,
36 OrderID in number,
37 LineItemID in number,
38 WorkitemID in number,
39 WIInstanceID in number,
40 WFMaster in varchar2,
41 ErrCode OUT NOCOPY number,
42 ErrStr OUT NOCOPY varchar2);
43
44
45 -- ARE_ALL_WIS_DONE
46 -- Resultout
47 -- Activity Performed - Activity was completed without any errors
48 --
49 -- Your Description here:
50
51
52 Procedure ARE_ALL_WIS_DONE (itemtype in varchar2,
53 itemkey in varchar2,
54 actid in number,
55 funcmode in varchar2,
56 resultout OUT NOCOPY varchar2);
57
58
59
60
61 -- INITIALIZE_WI_LIST
62 -- Resultout
63 -- Activity Performed - Activity was completed without any errors
64 --
65 -- Your Description here:
66
67
68 Procedure INITIALIZE_WI_LIST (itemtype in varchar2,
69 itemkey in varchar2,
70 actid in number,
71 funcmode in varchar2,
72 resultout OUT NOCOPY varchar2);
73
74
75
76 -- CONTINUE_WORKITEM
77 -- Resultout
78 -- Activity Performed - Activity was completed without any errors
79 --
80 -- Your Description here:
81
82
83 Procedure CONTINUE_WORKITEM (itemtype in varchar2,
84 itemkey in varchar2,
85 actid in number,
86 funcmode in varchar2,
87 resultout OUT NOCOPY varchar2);
88
89
90 -- INITIALIZE_WORKITEM_PROCESS
91 -- Resultout
92 -- Activity Performed - Activity was completed without any errors
93 --
94 -- Your Description here:
95
96
97 Procedure INITIALIZE_WORKITEM_PROCESS (itemtype in varchar2,
98 itemkey in varchar2,
99 actid in number,
100 funcmode in varchar2,
101 resultout OUT NOCOPY varchar2);
102
103
104 -- LAUNCH_WORKITEM_PROCESS
105 -- Resultout
106 -- Activity Performed - Activity was completed without any errors
107 --
108 -- Your Description here:
109
110
111 Procedure LAUNCH_WORKITEM_PROCESS (itemtype in varchar2,
112 itemkey in varchar2,
113 actid in number,
114 funcmode in varchar2,
115 resultout OUT NOCOPY varchar2);
116
117
118 -- LAUNCH_WI_SEQ_PROCESS
119 -- Resultout
120 -- Activity Performed - Activity was completed without any errors
121 --
122 -- Your Description here:
123
124
125 Procedure LAUNCH_WI_SEQ_PROCESS (itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 funcmode in varchar2,
129 resultout OUT NOCOPY varchar2);
130
131
132
133
134 -- LAUNCH_WI_SERVICE_PROCESS
135 -- Resultout
136 -- Activity Performed - Activity was completed without any errors
137 --
138 -- Your Description here:
139
140
141 Procedure LAUNCH_WI_SERVICE_PROCESS (itemtype in varchar2,
142 itemkey in varchar2,
143 actid in number,
144 funcmode in varchar2,
145 resultout OUT NOCOPY varchar2);
146
147 --Evaluate ALL WI Parameters for all Workitems at one go..
148 Procedure EVALUATE_ALL_WIS_PARAMS (itemtype in varchar2,
149 itemkey in varchar2,
150 actid in number,
151 funcmode in varchar2,
152 resultout OUT NOCOPY varchar2);
153
154 --Evaluate WI parameters of a given WI
155 Procedure EVALUATE_WI_PARAMS (itemtype in varchar2,
156 itemkey in varchar2,
157 actid in number,
158 funcmode in varchar2,
159 resultout OUT NOCOPY varchar2);
160
161 Procedure EvaluateWIParamsOnStart(WIInstanceID in number);
162
163 Function GET_WI_RESPONSIBILITY (itemtype in varchar2,
164 itemkey in varchar2 ) return varchar2;
165
166 Procedure GET_ONSTART_WI_PARAMS (itemtype in varchar2,
167 itemkey in varchar2,
168 actid in number,
169 funcmode in varchar2,
170 resultout OUT NOCOPY varchar2 ) ;
171
172 Procedure LAUNCH_ALL_IND_WIS (itemtype in varchar2,
173 itemkey in varchar2,
174 actid in number,
175 funcmode in varchar2,
176 resultout OUT NOCOPY varchar2 );
177
178
179 Procedure INITIALIZE_DEP_WI_PROCESS (itemtype in varchar2,
180 itemkey in varchar2,
181 actid in number,
182 funcmode in varchar2,
183 resultout OUT NOCOPY varchar2 );
184
185
186 Procedure RESOLVE_IND_DEP_WIS (itemtype in varchar2,
187 itemkey in varchar2,
188 actid in number,
189 funcmode in varchar2,
190 resultout OUT NOCOPY varchar2 );
191
192 Procedure OVERRIDE_WI_PARAM (itemtype in varchar2,
193 itemkey in varchar2,
194 actid in number,
195 funcmode in varchar2,
196 resultout OUT NOCOPY varchar2 );
197
198 Function get_display_name( p_WIInstanceID IN NUMBER) return varchar2;
199
200 End XDPCORE_WI;