[Home] [Help]
PACKAGE: APPS.IEU_UWQ_GET_NEXT_WORK_PVT
Source
1 PACKAGE IEU_UWQ_GET_NEXT_WORK_PVT AUTHID CURRENT_USER AS
2 /* $Header: IEUVGNWS.pls 120.3 2006/03/08 21:35:11 msathyan noship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'IEU_UWQ_GET_NEXT_WORK_PVT';
5
6 TYPE IEU_UWQ_BINDVAR_REC is RECORD
7 ( BIND_NAME VARCHAR2(1000),
8 VALUE VARCHAR2(1000) );
9
10 TYPE IEU_UWQ_BINDVAR_LIST IS
11 TABLE OF IEU_UWQ_BINDVAR_REC INDEX BY BINARY_INTEGER;
12
13
14
15 TYPE IEU_UWQ_NEXTWORK_ITEM_REC is RECORD
16 ( WORK_ITEM_ID NUMBER := null,
17 PRIORITY_LEVEL NUMBER := null,
18 DUE_DATE VARCHAR2(30) := null,
19 WORKITEM_OBJ_CODE VARCHAR2(30) := null
20 );
21
22 TYPE IEU_UWQ_NEXTWORK_ITEM_LIST IS
23 TABLE OF IEU_UWQ_NEXTWORK_ITEM_REC INDEX BY BINARY_INTEGER;
24
25 TYPE IEU_UWQM_ITEM_DATA_REC is RECORD
26 (
27 WORK_ITEM_ID NUMBER(15),
28 WORKITEM_OBJ_CODE VARCHAR2(30),
29 WORKITEM_PK_ID NUMBER(15),
30 STATUS_ID NUMBER(15),
31 PRIORITY_ID NUMBER(15),
32 PRIORITY_LEVEL NUMBER(3),
33 PRIORITY VARCHAR2(80),
34 DUE_DATE DATE,
35 TITLE VARCHAR2(1990),
36 PARTY_ID NUMBER(15),
37 OWNER_ID NUMBER,
38 OWNER_TYPE VARCHAR2(25),
39 ASSIGNEE_ID NUMBER,
40 ASSIGNEE_TYPE VARCHAR2(25),
41 SOURCE_OBJECT_ID NUMBER,
42 SOURCE_OBJECT_TYPE_CODE VARCHAR2(30),
43 OWNER_TYPE_ACTUAL VARCHAR2(30),
44 ASSIGNEE_TYPE_ACTUAL VARCHAR2(30),
45 APPLICATION_ID NUMBER,
46 IEU_ENUM_TYPE_UUID VARCHAR2(38),
47 STATUS_UPDATE_USER_ID NUMBER,
48 WORK_ITEM_NUMBER VARCHAR2(30),
49 RESCHEDULE_TIME DATE,
50 WORK_TYPE VARCHAR2(80),
51 STATUS_CODE VARCHAR2(80)
52 );
53
54 TYPE IEU_UWQM_ITEM_DATA IS
55 TABLE OF IEU_UWQM_ITEM_DATA_REC INDEX BY BINARY_INTEGER;
56
57 TYPE l_get_work IS REF CURSOR;
58
59
60 TYPE IEU_WR_ITEM_DATA_REC is RECORD
61 (
62 WORK_ITEM_ID NUMBER(15),
63 WORKITEM_OBJ_CODE VARCHAR2(30),
64 WORKITEM_PK_ID NUMBER(15),
65 STATUS_ID NUMBER(15),
66 PRIORITY_ID NUMBER(15),
67 PRIORITY_LEVEL NUMBER(3),
68 PRIORITY_CODE VARCHAR2(30),
69 DUE_DATE DATE,
70 TITLE VARCHAR2(1990),
71 PARTY_ID NUMBER(15),
72 OWNER_ID NUMBER,
73 OWNER_TYPE VARCHAR2(25),
74 ASSIGNEE_ID NUMBER,
75 ASSIGNEE_TYPE VARCHAR2(25),
76 SOURCE_OBJECT_ID NUMBER,
77 SOURCE_OBJECT_TYPE_CODE VARCHAR2(30),
78 APPLICATION_ID NUMBER,
79 IEU_ENUM_TYPE_UUID VARCHAR2(38),
80 WORK_ITEM_NUMBER VARCHAR2(30),
81 RESCHEDULE_TIME DATE,
82 WS_ID NUMBER
83 );
84
85 TYPE IEU_WR_ITEM_DATA IS
86 TABLE OF IEU_WR_ITEM_DATA_REC INDEX BY BINARY_INTEGER;
87
88
89 TYPE IEU_WR_ITEM_ACT_DATA_REC is RECORD
90 (
91 IEU_OBJECT_FUNCTION VARCHAR2(30),
92 IEU_OBJECT_PARAMETERS VARCHAR2(2000),
93 IEU_MEDIA_TYPE_UUID NUMBER,
94 IEU_PARAM_PK_VALUE VARCHAR2(40),
95 IEU_PARAM_PK_COL VARCHAR2(40),
96 WORK_ITEM_ID NUMBER(15),
97 WORKITEM_OBJ_CODE VARCHAR2(30),
98 WORKITEM_PK_ID NUMBER(15),
99 STATUS_ID NUMBER(15),
100 PRIORITY_ID NUMBER(15),
101 PRIORITY_LEVEL NUMBER(3),
102 DUE_DATE DATE,
103 TITLE VARCHAR2(1990),
104 PARTY_ID NUMBER(15),
105 OWNER_ID NUMBER,
106 OWNER_TYPE VARCHAR2(25),
107 ASSIGNEE_ID NUMBER,
108 ASSIGNEE_TYPE VARCHAR2(25),
109 SOURCE_OBJECT_ID NUMBER,
110 SOURCE_OBJECT_TYPE_CODE VARCHAR2(30),
111 APPLICATION_ID NUMBER,
112 IEU_ACTION_OBJECT_CODE VARCHAR2(60),
113 IEU_ENUM_TYPE_UUID VARCHAR2(38),
114 WORK_ITEM_NUMBER VARCHAR2(30),
115 RESCHEDULE_TIME DATE,
116 IEU_GET_NEXTWORK_FLAG VARCHAR2(10),
117 WS_ID NUMBER
118 );
119
120 TYPE IEU_WR_ITEM_ACT_DATA_LIST IS
121 TABLE OF IEU_WR_ITEM_ACT_DATA_REC INDEX BY BINARY_INTEGER;
122
123 TYPE IEU_WS_DETAILS_REC is RECORD
124 (
125 WS_CODE IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE
126 );
127
128 TYPE IEU_WS_DETAILS_LIST IS
129 TABLE OF IEU_WS_DETAILS_REC INDEX BY BINARY_INTEGER;
130
131 TYPE IEU_GRP_ID_REC is RECORD
132 (
133 GROUP_ID JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE
134 );
135
136 TYPE IEU_GRP_ID_LIST IS
137 TABLE OF IEU_GRP_ID_REC INDEX BY BINARY_INTEGER;
138
139 PROCEDURE GET_NEXT_WORKITEM
140 ( p_api_version IN NUMBER,
141 p_resource_id IN NUMBER,
142 p_user_id IN NUMBER,
143 x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 x_return_status OUT NOCOPY VARCHAR2);
147
148 PROCEDURE GET_WORKITEM_ACTION_FUNC_DATA
149 ( p_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.ieu_uwqm_item_data_rec,
150 x_workitem_action_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA );
151
152 PROCEDURE GET_NEXT_WORK_ITEM_CONT
153 (p_release_api_version IN NUMBER,
154 p_next_work_api_version IN NUMBER,
155 p_workitem_obj_code IN VARCHAR2,
156 p_workitem_pk_id IN NUMBER,
157 p_work_item_id IN NUMBER,
158 p_user_id IN NUMBER,
159 p_resource_id IN NUMBER,
160 p_worklist_cont_mode IN VARCHAR2,
161 x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
162 x_release_return_status OUT NOCOPY VARCHAR2,
163 x_release_msg_count OUT NOCOPY NUMBER,
164 x_release_msg_data OUT NOCOPY VARCHAR2,
165 x_nw_return_status OUT NOCOPY VARCHAR2,
166 x_nw_msg_count OUT NOCOPY NUMBER,
167 x_nw_msg_data OUT NOCOPY VARCHAR2);
168
169 PROCEDURE GET_WORKLIST_QUEUE
170 ( p_api_version IN NUMBER,
171 p_resource_id IN NUMBER,
172 p_user_id IN NUMBER,
173 p_no_of_recs IN NUMBER,
174 x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQM_ITEM_DATA,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 x_return_status OUT NOCOPY VARCHAR2);
178
179 FUNCTION GET_WORKLIST_QUEUE_COUNT
180 ( p_resource_id IN NUMBER,
181 p_status_id IN NUMBER,
182 p_node_type IN NUMBER)
183 RETURN NUMBER;
184
185 PROCEDURE DISTRIBUTE_AND_DELIVER_WR_ITEM
186 ( p_api_version IN NUMBER,
187 p_resource_id IN NUMBER,
188 p_language IN VARCHAR2,
189 p_source_lang IN VARCHAR2,
190 p_dist_from_extra_where_clause IN VARCHAR2,
191 p_dist_to_extra_where_clause IN VARCHAR2,
192 p_bindvar_from_list IN IEU_UWQ_BINDVAR_LIST,
193 p_bindvar_to_list IN IEU_UWQ_BINDVAR_LIST,
194 x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 x_return_status OUT NOCOPY VARCHAR2);
198
199 PROCEDURE DISTRIBUTE_WR_ITEMS
200 ( p_api_version IN NUMBER,
201 p_resource_id IN NUMBER,
202 p_language IN VARCHAR2,
203 p_source_lang IN VARCHAR2,
204 p_num_of_dist_items IN NUMBER, -- Number of Items Requested to be Distributed
205 p_extra_where_clause IN VARCHAR2,
206 p_bindvar_list IN IEU_UWQ_BINDVAR_LIST,
207 x_uwqm_workitem_data OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST,
208 x_num_of_items_distributed OUT NOCOPY NUMBER, -- Number of Items finally Distributed
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 x_return_status OUT NOCOPY VARCHAR2);
212
213 PROCEDURE GET_DIST_WR_ITEMS
214 ( p_api_version IN NUMBER,
215 p_resource_id IN NUMBER,
216 p_language IN VARCHAR2,
217 p_source_lang IN VARCHAR2,
218 p_num_of_dist_items IN NUMBER,
219 p_extra_where_clause IN VARCHAR2,
220 p_bindvar_list IN IEU_UWQ_BINDVAR_LIST,
221 x_uwqm_workitem_data OUT NOCOPY SYSTEM.WR_ITEM_DATA_NST,
222 x_num_of_items_distributed OUT NOCOPY NUMBER,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2);
226
227 PROCEDURE SET_WR_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
228 p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
229 p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
230 x_ctr IN OUT NOCOPY NUMBER,
231 x_uwqm_workitem_data IN OUT NOCOPY IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_ACT_DATA_LIST);
232
233 PROCEDURE SET_DIST_AND_DEL_ITEM_DATA_REC( p_var_in_type_code IN VARCHAR2,
234 p_dist_workitem_data IN SYSTEM.WR_ITEM_DATA_NST,
235 p_dist_del_workitem_data IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WR_ITEM_DATA_REC,
236 x_ctr IN OUT NOCOPY NUMBER,
237 x_workitem_action_data IN OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA);
238
239 PROCEDURE GET_WS_WHERE_CLAUSE
240 (p_type IN VARCHAR2,
241 p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
242 p_resource_id IN NUMBER,
243 x_dist_from_where OUT NOCOPY VARCHAR2,
244 x_dist_to_where OUT NOCOPY VARCHAR2,
245 x_bindvar_from_list OUT NOCOPY IEU_UWQ_BINDVAR_LIST,
246 x_bindvar_to_list OUT NOCOPY IEU_UWQ_BINDVAR_LIST);
247
248 PROCEDURE CLEANUP_DISTRIBUTING_STATUS
249 (
250 P_resource_id IN NUMBER,
251 X_MSG_DATA OUT NOCOPY VARCHAR2,
252 X_RETURN_STATUS OUT NOCOPY VARCHAR2
253 );
254
255 PROCEDURE GET_WS_WHERE_CLAUSE
256 (p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
257 p_resource_id IN NUMBER,
258 x_dist_from_where OUT NOCOPY VARCHAR2,
259 x_dist_to_where OUT NOCOPY VARCHAR2);
260
261 end IEU_UWQ_GET_NEXT_WORK_PVT;
262