[Home] [Help]
PACKAGE: APPS.IEU_NEXT_WORK_IEUSCPOP
Source
1 PACKAGE IEU_NEXT_WORK_IEUSCPOP AUTHID CURRENT_USER AS
2 /* $Header: IEUGNWDS.pls 115.3 2003/12/31 20:15:29 fsuthar noship $ */
3
4 TYPE IEU_WR_ITEM_DATA_REC is RECORD
5 (
6 WORK_ITEM_ID NUMBER(15),
7 WORKITEM_OBJ_CODE VARCHAR2(30),
8 WORKITEM_PK_ID NUMBER(15),
9 PRIORITY_LEVEL NUMBER(3),
10 DUE_DATE DATE,
11 OWNER_ID NUMBER,
12 OWNER_TYPE VARCHAR2(25),
13 ASSIGNEE_ID NUMBER,
14 ASSIGNEE_TYPE VARCHAR2(25),
15 SOURCE_OBJECT_TYPE_CODE VARCHAR2(30),
16 RESCHEDULE_TIME DATE,
17 WS_ID NUMBER,
18 DISTRIBUTION_STATUS_ID NUMBER,
19 WORK_ITEM_NUMBER VARCHAR2(64)
20 );
21
22 TYPE IEU_WR_ITEM_DATA IS
23 TABLE OF IEU_WR_ITEM_DATA_REC INDEX BY BINARY_INTEGER;
24
25 TYPE l_get_work IS REF CURSOR;
26
27 PROCEDURE EXECUTE_NEXT_WORK_PROC
28 ( p_resource_id IN number,
29 p_ws_id_str IN VARCHAR2,
30 p_disp_cnt IN number,
31 x_wr_item_data_list IN OUT nocopy IEU_NEXT_WORK_IEUSCPOP.IEU_WR_ITEM_DATA
32 );
33
34 procedure WORK_SOURCE_PROFILE_ENABLED
35 (p_name IN varchar2,
36 p_user_id IN number,
37 p_responsibility_id IN number,
38 p_application_id IN number,
39 x_enabled_flag out nocopy varchar2);
40
41 END IEU_NEXT_WORK_IEUSCPOP;