1: PACKAGE BODY wf_item_types_vl_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_item_types_vl_pub
1: PACKAGE BODY wf_item_types_vl_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_item_types_vl_pub
6:
7: DESCRIPTION:
8:
9: OWNER: GKELLNER
31:
32: ============================================================================*/
33: PROCEDURE fetch_item_type
34: (p_name IN VARCHAR2,
35: p_wf_item_types_vl_tbl OUT NOCOPY wf_item_types_vl_pub.wf_item_types_vl_tbl_type) IS
36:
37: l_record_num NUMBER := 0;
38:
39: BEGIN
65: WHERE name = p_name;
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: Wf_Core.Context('wf_item_types_vl_pub', 'fetch_item_type', p_name);
70: wf_item_definition.Error;
71:
72: END fetch_item_type;
73:
81:
82: ============================================================================*/
83: PROCEDURE draw_item_type_list
84: (p_wf_item_types_vl_tbl
85: IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
86: p_effective_date IN DATE,
87: p_indent_level IN NUMBER) IS
88:
89: l_record_num NUMBER;
113: END LOOP;
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: Wf_Core.Context('wf_item_types_vl_pub', 'draw_item_type_list');
118: wf_item_definition.Error;
119:
120: END draw_item_type_list;
121:
130: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
131:
132: ============================================================================*/
133: PROCEDURE draw_item_type_details
134: (p_wf_item_types_vl_tbl IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
135: p_indent_level IN NUMBER) IS
136:
137: l_record_num NUMBER;
138: ii NUMBER := 0;
225: END LOOP;
226:
227: EXCEPTION
228: WHEN OTHERS THEN
229: Wf_Core.Context('wf_item_types_vl_pub', 'draw_item_type_details');
230: wf_item_definition.Error;
231:
232: END draw_item_type_details;
233:
230: wf_item_definition.Error;
231:
232: END draw_item_type_details;
233:
234: END wf_item_types_vl_pub;