1 package WF_PLUG as
2 /* $Header: wfplugs.pls 120.1 2005/07/02 02:50:43 appldev ship $ */
3
4 --
5 -- Types
6 --
7
8 -- column name array for the worklist
9 type column_name_array is table of varchar2(30) index by binary_integer;
10 -- column size array for the worklist
11 type column_size_array is table of varchar2(4) index by binary_integer;
12
13 TYPE wf_worklist_definition_record IS RECORD
14 (
15 ROW_ID ROWID,
16 PLUG_ID NUMBER,
17 USERNAME VARCHAR2(320),
18 DEFINITION_NAME VARCHAR2(30),
19 WHERE_STATUS VARCHAR2(30),
20 WHERE_FROM VARCHAR2(30),
21 WHERE_ITEM_TYPE VARCHAR2(8),
22 WHERE_NOTIF_TYPE VARCHAR2(30),
23 WHERE_SUBJECT VARCHAR2(240),
24 WHERE_SENT_START DATE,
25 WHERE_SENT_END DATE,
26 WHERE_DUE_START DATE,
27 WHERE_DUE_END DATE,
28 WHERE_PRIORITY VARCHAR2(10),
29 WHERE_NOTIF_DEL_BY_ME VARCHAR2(1),
30 ORDER_PRIMARY VARCHAR2(30),
31 ORDER_ASC_DESC VARCHAR2(4)
32 );
33
34 TYPE wf_worklist_col_def_record IS RECORD
35 (
36 ROW_ID ROWID,
37 PLUG_ID NUMBER,
38 USERNAME VARCHAR2(320),
39 COLUMN_NUMBER NUMBER,
40 COLUMN_NAME VARCHAR2(30),
41 COLUMN_SIZE NUMBER
42 );
43
44 TYPE wf_worklist_col_def_table IS TABLE OF
45 wf_plug.wf_worklist_col_def_record
46 INDEX BY BINARY_INTEGER;
47
48 --
49 -- WorkList
50 -- Construct the worklist (summary page) for user.
51 -- IN
52 -- orderkey - Key to order by (default PRIORITY)
53 -- Valid values are PRIORITY, MESSAGE_TYPE, SUBJECT, BEGIN_DATE,
54 -- DUE_DATE, END_DATE, STATUS.
55 -- status - Status to query (default OPEN)
56 -- Valid values are OPEN, CLOSED, CANCELED, ERROR.
57 -- If null query any status.
58 -- user - User to query notifications for. If null query current user.
59 -- Note: only WF_ADMIN_ROLE can query other than the current user.
60 --
61 procedure WorkList(
62 plug_id in varchar2 default null,
63 session_id in varchar2 default null,
64 display_name in varchar2 default null
65 );
66
67 /*===========================================================================
68 PROCEDURE NAME: edit_worklist_definition
69
70 DESCRIPTION: Allows you to modify the look and feel of your
71 worklist. This definition mechanism is used
72 for both the standard Worklist UI as well as the
73 plug UI.
74
75 If the p_plug_id = '0' then it assumes you are
76 defining the default look and feel for the
77 Worklist plug
78
79 If the p_username = '0' then it assumes you are
80 defining the default look and feel for the
81 standard Worklist UI.
82
83
84 PARAMETERS:
85
86 p_plug_id IN Unique identifier for this plug for a particular
87 home page
88
89 p_username IN Unique identifier for a given user for this definition
90 of the standard worklist ui.
91
92 ============================================================================*/
93 PROCEDURE edit_worklist_definition (p_plug_id IN VARCHAR2 DEFAULT null,
94 p_username IN VARCHAR2 DEFAULT null,
95 p_add_column IN VARCHAR2 DEFAULT '0');
96
97
98 /*===========================================================================
99 PROCEDURE NAME: submit_worklist_definition
100
101 DESCRIPTION: Saves the worklist definition in the database.
102
103 ============================================================================*/
104 PROCEDURE submit_worklist_definition (
105 plug_id IN VARCHAR2 DEFAULT NULL,
106 username IN VARCHAR2 DEFAULT NULL,
107 definition_name IN VARCHAR2 DEFAULT NULL,
108 column_name IN column_name_array,
109 status IN VARCHAR2 DEFAULT '*',
110 fromuser IN VARCHAR2 DEFAULT '*',
111 user IN VARCHAR2 DEFAULT NULL,
112 ittype IN VARCHAR2 DEFAULT '*',
113 msubject IN VARCHAR2 DEFAULT '*',
114 beg_sent IN VARCHAR2 DEFAULT '*',
115 end_sent IN VARCHAR2 DEFAULT '*',
116 beg_due IN VARCHAR2 DEFAULT '*',
117 end_due IN VARCHAR2 DEFAULT '*',
118 hpriority IN VARCHAR2 DEFAULT null,
119 mpriority IN VARCHAR2 DEFAULT null,
120 lpriority IN VARCHAR2 DEFAULT null,
121 delegated_by_me IN VARCHAR2 DEFAULT '0',
122 orderkey IN VARCHAR2 DEFAULT 'PRIORITY',
123 definition_exists IN VARCHAR2 DEFAULT 'N'
124 );
125
126 /*===========================================================================
127 PROCEDURE NAME: worklist_plug
128
129 DESCRIPTION: creates the worklist plug for the ICX folks for
130 the customizable home page
131
132 ============================================================================*/
133 PROCEDURE worklist_plug (
134 p_session_id IN VARCHAR2 DEFAULT NULL,
135 p_plug_id IN VARCHAR2 DEFAULT NULL,
136 p_display_name IN VARCHAR2 DEFAULT NULL,
137 p_delete IN VARCHAR2 DEFAULT 'N'
138 );
139
140 end WF_PLUG;