PACKAGE: APPS.WF_WORKLIST_ENGINE

Source

1 package WF_WORKLIST_ENGINE AUTHID CURRENT_USER as
2 /* $Header: wfwrks.pls 120.1 2005/07/02 02:53:07 appldev ship $ */
3 
4 type colRecType is record (
5   name       varchar2(320),
6   def_type   varchar2(8),            /* SELECT, WHERE, ORDER */
7   value_type varchar2(8),            /* NUMBER, VARCHAR, DATE */
8   col_type   varchar2(8),            /* BASE, SEND, RESPOND */
9   text_value   varchar2(4000)
10 );
11 
12 type colTabType is table of colRecType index by binary_integer;
13 
14 type wrkRecType is record (
15   nid        number,
16   priority   number,
17   locked_by  varchar2(320),
18   status     varchar2(8),
19   language   varchar2(4),
20   result_type varchar2(30),
21   more_resp_req  boolean,
22   attach_present boolean,
23   col01      varchar2(4000),
24   col02      varchar2(4000),
25   col03      varchar2(4000),
26   col04      varchar2(4000),
27   col05      varchar2(4000),
28   col06      varchar2(4000),
29   col07      varchar2(4000),
30   col08      varchar2(4000),
31   col09      varchar2(4000),
32   col10      varchar2(4000),
33   col11      varchar2(4000),
34   col12      varchar2(4000),
35   col13      varchar2(4000),
36   col14      varchar2(4000),
37   col15      varchar2(4000),
38   col16      varchar2(4000),
39   col17      varchar2(4000),
40   col18      varchar2(4000),
41   col19      varchar2(4000),
42   col20      varchar2(4000),
43   col21      varchar2(4000),
44   col22      varchar2(4000),
45   col23      varchar2(4000),
46   col24      varchar2(4000),
47   col25      varchar2(4000),
48   col26      varchar2(4000),
49   col27      varchar2(4000),
50   col28      varchar2(4000),
51   col29      varchar2(4000),
52   col30      varchar2(4000)
53 );
54 
55 type wrkTabType is table of wrkRecType index by binary_integer;
56 
57 debug boolean := FALSE;
58 max_expand_roles pls_integer := 10;  -- maximum number of roles got expanded
59 
60 --
61 -- List
62 --   Populate a plsql table with query values.
63 -- IN
64 --   startrow   - the Nth row that you want to start your query.
65 --   numrow     - the number of rows that you want to get back.
66 --   colin      - column definition including query criteria.
67 -- OUT
68 --   totalrow   - total number of rows returned by such query.
69 --   colout     - plsql table contains the query values.
70 --
71 procedure List(
72   startrow   in  number,
73   numrow     in  number,
74   colin      in  colTabType,
75   totalrow   out nocopy number,
76   colout     out nocopy wrkTabType);
77 
78 --
79 -- Debug_On
80 --   Turn on debug info.  You must set serveroutput on in sqlplus session.
81 --
82 procedure debug_on;
83 
84 --
85 -- Debug_Off
86 --   Turn off debug info.
87 --
88 procedure debug_off;
89 
90 --
91 -- GetRoleClause3 (Internal Public)
92 --   For use only by "Advanced Worklist" in Self Service Framework.
93 --   Based on GetRoleClause and GetRoleClause2
94 --   Returns the expanded roles list separated by commas.
95 --
96 function GetRoleClause3(
97 name   in varchar2
98 ) return varchar2;
99 
100 end WF_WORKLIST_ENGINE;