DBA Data[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;