DBA Data[Home] [Help]

PACKAGE: APPS.WF_ITEM_TYPES_VL_PUB

Source


1 PACKAGE wf_item_types_vl_pub AUTHID CURRENT_USER AS
2 /* $Header: wfdefs.pls 115.18 2002/12/03 01:12:21 dlam ship $  */
3 
4 
5 /*===========================================================================
6   PACKAGE NAME:         wf_item_types_vl_pub
7 
8   DESCRIPTION:
9 
10   OWNER:                GKELLNER
11 
12   TABLES/RECORDS:
13 
14   PROCEDURES/FUNCTIONS:
15 
16   MODIFICATION LOG: 01/2002 JWSMITH BUG 2001012 - Increase read_role,
17                     write_role, execute_role to varchar2(320)
18 
19 ============================================================================*/
20 
21 /*===========================================================================
22 
23   PL*SQL TABLE NAME:    wf_item_types_vl_tbl_type
24 
25   DESCRIPTION:          Stores a list of item types or workflow definitions.
26                         Typically you will only ever have one row in
27                         this table as it is the master for all the objects
28                         within this workflow definition.
29 
30 ============================================================================*/
31 
32 TYPE wf_item_types_vl_rec_type IS RECORD
33 (
34  ROW_ID                          ROWID,
35  NAME                            VARCHAR2(8),
36  PROTECT_LEVEL                   NUMBER,
37  CUSTOM_LEVEL                    NUMBER,
38  WF_SELECTOR                     VARCHAR2(240),
39  READ_ROLE                       VARCHAR2(320),
40  WRITE_ROLE                      VARCHAR2(320),
41  EXECUTE_ROLE                    VARCHAR2(320),
42  DISPLAY_NAME                    VARCHAR2(80),
43  DESCRIPTION                     VARCHAR2(240)
44 );
45 
46  TYPE wf_item_types_vl_tbl_type IS TABLE OF
47     wf_item_types_vl_pub.wf_item_types_vl_rec_type
48  INDEX BY BINARY_INTEGER;
49 
50 
51 /*===========================================================================
52   PROCEDURE NAME:       fetch_item_type
53 
54   DESCRIPTION:          Fetches all the properties of a given item type
55                         into a wf_item_types_vl_tbl_type table based on the
56                         item type internal eight character name.
57 
58   PARAMETERS:
59 
60         p_name IN       Internal name of the item type
61 
62         p_wf_item_types_vl_tbl OUT
63                         The pl*sql table with the detailed definition of
64                         the item type
65 
66 ============================================================================*/
67  PROCEDURE fetch_item_type
68      (p_name                   IN  VARCHAR2,
69       p_wf_item_types_vl_tbl   OUT NOCOPY wf_item_types_vl_pub.wf_item_types_vl_tbl_type);
70 
71 /*===========================================================================
72   PROCEDURE NAME:       draw_item_type_list
73 
74   DESCRIPTION:          Shows the display name of an item type as a
75                         html view as a part of a hierical summary list of
76                         an item type.  This function uses the htp to
77                         generate its html output.
78 
79   PARAMETERS:
80 
81         p_wf_item_types_vl_tbl IN
82                         The pl*sql table with the detailed definition of
83                         the item type
84 
85         p_effective_date IN
86                         The effective date that was requested.
87                         This is required if you would like to create
88                         hotlinks between a summary frame view and your
89                         detail frame view.  Since the listing are usually
90                         implemented as frames the links need to include
91                         all the attributes that were used to generate those
92                         frames.
93 
94         p_indent_level IN
95                         How many spaces would you like to indent this
96                         listing from the left border of the screen.
97 
98 ============================================================================*/
99  PROCEDURE draw_item_type_list
100      (p_wf_item_types_vl_tbl
101            IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
102       p_effective_date            IN DATE,
103       p_indent_level              IN NUMBER);
104 
105 /*===========================================================================
106   PROCEDURE NAME:       draw_item_type_details
107 
108   DESCRIPTION:          Shows all the details of an item type as a
109                         html view.  This function uses the htp to
110                         generate its html output.
111 
112   PARAMETERS:
113 
114         p_wf_item_types_vl_tbl IN
115                         The pl*sql table with the detailed definition of
116                         the item type
117 
118         p_indent_level IN
119                         How many space would you like to indent this
120                         listing from the left border of the screen.
121 
122 ============================================================================*/
123  PROCEDURE draw_item_type_details
124      (p_wf_item_types_vl_tbl   IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
125       p_indent_level        IN NUMBER);
126 
127 
128 END wf_item_types_vl_pub;