1 PACKAGE wf_item_attributes_vl_pub AUTHID CURRENT_USER AS
2 /* $Header: wfdefs.pls 115.18 2002/12/03 01:12:21 dlam ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: wf_item_attributes_vl_pub
6
7 DESCRIPTION:
8
9 OWNER: GKELLNER
10
11 TABLES/RECORDS:
12
13 PROCEDURES/FUNCTIONS:
14
15 ============================================================================*/
16
17
18 /*===========================================================================
19
20 PL*SQL TABLE NAME: wf_item_attributes_vl_tbl_type
21
22 DESCRIPTION: Stores a list of item attribute definitions for
23 the selected item type.
24
25 ============================================================================*/
26 TYPE wf_item_attributes_vl_rec_type IS RECORD
27 (
28 row_id ROWID,
29 item_type VARCHAR2(8),
30 name VARCHAR2(30),
31 sequence NUMBER,
32 type VARCHAR2(8),
33 protect_level NUMBER,
34 custom_level NUMBER,
35 subtype VARCHAR2(8),
36 format VARCHAR2(240),
37 lookup_type_display_name VARCHAR2(80),
38 lookup_code_display_name VARCHAR2(80),
39 text_default VARCHAR2(4000),
40 number_default NUMBER,
41 date_default DATE,
42 display_name VARCHAR2(80),
43 description VARCHAR2(240)
44 );
45
46 TYPE wf_item_attributes_vl_tbl_type IS TABLE OF
47 wf_item_attributes_vl_pub.wf_item_attributes_vl_rec_type
48 INDEX BY BINARY_INTEGER;
49
50 /*===========================================================================
51 PROCEDURE NAME: fetch_item_attributes
52
53 DESCRIPTION: Fetches all the attributes for a given item type
54 into a p_wf_item_attributes_vl_tbl table based on the
55 item type internal eight character name. This function
56 can also retrieve a single item attribute definition if
57 the internal name along with the item type name is
58 provided. This is especially useful if you wish to
59 display the details for a single attribute when it
60 is referenced from some drilldown mechanism.
61
62 PARAMETERS:
63
64 p_item_type IN Internal name of the item type
65
66 p_name IN (optional)
67 Internal name of the item attribute
68
69 p_wf_item_attributes_vl_tbl OUT
70 The pl*sql table with the detailed definition of
71 the item attributes
72
73 ============================================================================*/
74 PROCEDURE fetch_item_attributes
75 (p_item_type IN VARCHAR2,
76 p_name IN VARCHAR2,
77 p_wf_item_attributes_vl_tbl OUT NOCOPY wf_item_attributes_vl_pub.wf_item_attributes_vl_tbl_type);
78
79 /*===========================================================================
80 PROCEDURE NAME: fetch_item_attribute_display
81
82 DESCRIPTION: fetch the item attribute display name based on an item
83 type and an item attribute internal name
84
85 PARAMETERS:
86 p_item_type IN
87 Internal name of the item type
88
89 p_internal_name IN
90 Internal name of the item attribute
91
92 p_display_name IN
93 Display name of the item attribute
94 ============================================================================*/
95 PROCEDURE fetch_item_attribute_display (p_item_type IN VARCHAR2,
96 p_internal_name IN VARCHAR2,
97 p_display_name OUT NOCOPY VARCHAR2);
98
99 /*===========================================================================
100 PROCEDURE NAME: draw_item_attribute_list
101
102 DESCRIPTION: Shows the display name of an item attribute as a
103 html view as a part of a hierical summary list of
104 an item type. This function uses the htp to
105 generate its html output.
106
107 PARAMETERS:
108
109 p_wf_item_attributes_vl_tbl IN
110 The pl*sql table with the detailed definition of
111 the item attributes
112
113 p_effective_date IN
114 The effective date that was requested.
115 This is required if you would like to create
116 hotlinks between a summary frame view and your
117 detail frame view. Since the listing are usually
118 implemented as frames the links need to include
119 all the attributes that were used to generate those
120 frames.
121
122 p_indent_level IN
123 How many spaces would you like to indent this
124 listing from the left border of the screen.
125
126 ============================================================================*/
127 PROCEDURE draw_item_attribute_list
128 (p_wf_item_attributes_vl_tbl IN wf_item_attributes_vl_pub.wf_item_attributes_vl_tbl_type,
129 p_effective_date IN DATE,
130 p_indent_level IN NUMBER);
131
132 /*===========================================================================
133 PROCEDURE NAME: draw_item_attribute_details
134
135 DESCRIPTION: Shows all the details of an item attrribute as a
136 html view. This function uses the htp to
137 generate its html output.
138
139 PARAMETERS:
140
141 p_wf_item_attributes_vl_tbl IN
142 The pl*sql table with the detailed definition of
143 the item attributes
144
145 p_indent_level IN
146 How many space would you like to indent this
147 listing from the left border of the screen.
148
149 ============================================================================*/
150 PROCEDURE draw_item_attribute_details
151 (p_wf_item_attributes_vl_tbl IN wf_item_attributes_vl_pub.wf_item_attributes_vl_tbl_type,
152 p_indent_level IN NUMBER);
153
154 END wf_item_attributes_vl_pub;