1 PACKAGE wf_lookup_types_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_lookup_types_pub
6
7 DESCRIPTION:
8
9 OWNER: GKELLNER
10
11 TABLES/RECORDS:
12
13 PROCEDURES/FUNCTIONS:
14
15 ============================================================================*/
16
17 /*===========================================================================
18
19 PL*SQL TABLE NAME: wf_lookup_types_tbl_type
20
21 DESCRIPTION: Stores a list of lookup type definitions for
22 the selected item type.
23
24 ============================================================================*/
25 TYPE wf_lookup_types_rec_type IS RECORD
26 (
27 ROW_ID ROWID,
28 LOOKUP_TYPE VARCHAR2(30),
29 ITEM_TYPE VARCHAR2(8),
30 PROTECT_LEVEL NUMBER,
31 CUSTOM_LEVEL NUMBER,
32 DISPLAY_NAME VARCHAR2(80),
33 DESCRIPTION VARCHAR2(240)
34 );
35
36 TYPE wf_lookup_types_tbl_type IS TABLE OF
37 wf_lookup_types_pub.wf_lookup_types_rec_type
38 INDEX BY BINARY_INTEGER;
39
40
41 /*===========================================================================
42
43 PL*SQL TABLE NAME: wf_lookups_tbl_type
44
45 DESCRIPTION: Stores a list of lookups based on the
46 fetch_lookups cursor shown above.
47
48 ============================================================================*/
49 TYPE wf_lookups_rec_type IS RECORD
50 (
51 lookup_type_display_name VARCHAR2(80),
52 item_type VARCHAR2(8),
53 row_id ROWID,
54 lookup_type VARCHAR2(30),
55 lookup_code VARCHAR2(30),
56 protect_level NUMBER,
57 custom_level NUMBER,
58 meaning VARCHAR2(80),
59 description VARCHAR2(240)
60 );
61
62 TYPE wf_lookups_tbl_type IS TABLE OF
63 wf_lookup_types_pub.wf_lookups_rec_type
64 INDEX BY BINARY_INTEGER;
65
66 /*===========================================================================
67 PROCEDURE NAME: fetch_lookup_types
68
69 DESCRIPTION: Fetches all the lookup types for a given item type
70 into a p_wf_lookup_types_vl_tbl table based on the
71 item type internal eight character name. This function
72 can also retrieve a single lookup type definition if
73 the internal name along with the item type name is
74 provided. This is especially useful if you wish to
75 display the details for a single lookup type when it
76 is referenced from some drilldown mechanism.
77
78 PARAMETERS:
79
80 p_item_type IN Internal name of the item type
81
82 p_name IN (optional)
83 Internal name of the lookup type
84
85 p_wf_lookup_types_tbl OUT
86 The pl*sql table with the detailed definition of
87 the lookup types
88
89 p_wf_lookups_tbl OUT
90 The pl*sql table with the detailed definition of
91 the lookups
92
93 ============================================================================*/
94 PROCEDURE fetch_lookup_types
95 (p_item_type IN VARCHAR2,
96 p_lookup_type IN VARCHAR2,
97 p_wf_lookup_types_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookup_types_tbl_type,
98 p_wf_lookups_tbl OUT NOCOPY wf_lookup_types_pub.wf_lookups_tbl_type);
99
100 /*===========================================================================
101 PROCEDURE NAME: fetch_lookup_display
102
103 DESCRIPTION: fetch the lookup type display name and the lookup code
104 display name based on a lookup type internal name and
105 lookup code internal name
106
107 PARAMETERS:
108
109 p_type_internal_name IN
110 Internal name of the lookup type
111
112 p_type_internal_code IN
113 Internal name of the lookup code
114
115 p_type_display_name IN
116 Display name of the lookup type
117
118 p_code_display_name IN
119 Display name of the lookup code
120 ============================================================================*/
121 PROCEDURE fetch_lookup_display (p_type_internal_name IN VARCHAR2,
122 p_code_internal_name IN VARCHAR2,
123 p_type_display_name OUT NOCOPY VARCHAR2,
124 p_code_display_name OUT NOCOPY VARCHAR2);
125
126 /*===========================================================================
127 PROCEDURE NAME: draw_lookup_type_list
128
129 DESCRIPTION: Shows the display name of lookup type as a
130 html view as a part of a hierical summary list of
131 an item type. This function uses the htp to
132 generate its html output.
133
134 PARAMETERS:
135
136 p_wf_lookup_types_tbl IN
137 The pl*sql table with the detailed definition of
138 the lookup types
139
140 p_wf_lookups_tbl IN
141 The pl*sql table with the detailed definition of
142 the lookups
143
144 p_effective_date IN
145 The effective date that was requested.
146 This is required if you would like to create
147 hotlinks between a summary frame view and your
148 detail frame view. Since the listing are usually
149 implemented as frames the links need to include
150 all the attributes that were used to generate those
151 frames.
152
153 p_indent_level IN
154 How many spaces would you like to indent this
155 listing from the left border of the screen.
156
157 ============================================================================*/
158 PROCEDURE draw_lookup_type_list
159 (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,
160 p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
161 p_effective_date IN DATE,
162 p_indent_level IN NUMBER);
163
164
165 /*===========================================================================
166 PROCEDURE NAME: draw_lookup_list
167
168 DESCRIPTION: Shows the display name of lookups as a
169 html view as a part of a hierical summary list of
170 an item type. This function uses the htp to
171 generate its html output.
172
173 PARAMETERS:
174
175 p_wf_lookups_tbl IN
176 The pl*sql table with the detailed definition of
177 the lookups
178
179 p_effective_date IN
180 The effective date that was requested.
181 This is required if you would like to create
182 hotlinks between a summary frame view and your
183 detail frame view. Since the listing are usually
184 implemented as frames the links need to include
185 all the attributes that were used to generate those
186 frames.
187
188 p_indent_level IN
189 How many spaces would you like to indent this
190 listing from the left border of the screen.
191
192 ============================================================================*/
193 PROCEDURE draw_lookup_list
194 (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
195 p_effective_date IN DATE,
196 p_indent_level IN NUMBER);
197
198
199 /*===========================================================================
200 PROCEDURE NAME: draw_lookup_type_details
201
202 DESCRIPTION: Shows all the details of an lookup type as a
203 html view. This function uses the htp to
204 generate its html output.
205
206 PARAMETERS:
207
208 p_wf_lookup_type_tbl IN
209 The pl*sql table with the detailed definition of
210 the lookup type
211
212 p_wf_lookups_tbl IN
213 The pl*sql table with the detailed definition of
214 the lookups
215
216 p_indent_level IN
217 How many space would you like to indent this
218 listing from the left border of the screen.
219
220 ============================================================================*/
221 PROCEDURE draw_lookup_type_details
222 (p_wf_lookup_types_tbl IN wf_lookup_types_pub.wf_lookup_types_tbl_type,
223 p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
224 p_indent_level IN NUMBER);
225
226 /*===========================================================================
227 PROCEDURE NAME: draw_lookup_details
228
229 DESCRIPTION: Shows all the details of a lookup as a
230 html view. This function uses the htp to
231 generate its html output.
232
233 PARAMETERS:
234
235 p_wf_lookups_tbl IN
236 The pl*sql table with the detailed definition of
237 the lookups
238
239 p_indent_level IN
240 How many space would you like to indent this
241 listing from the left border of the screen.
242
243 ============================================================================*/
244 PROCEDURE draw_lookup_details
245 (p_wf_lookups_tbl IN wf_lookup_types_pub.wf_lookups_tbl_type,
246 p_indent_level IN NUMBER);
247
248 END wf_lookup_types_pub;