[Home] [Help]
PACKAGE: APPS.OZF_PRICE_LIST_REPORT_PVT
Source
1 PACKAGE OZF_PRICE_LIST_REPORT_PVT AS
2 /* $Header: ozfqprls.pls 120.0 2005/06/01 03:34:22 appldev noship $*/
3
4 TYPE sec_rec IS RECORD
5 (
6 parent_section_id NUMBER,
7 child_section_id NUMBER,
8 SORT_ORDER NUMBER,
9 LEAF VARCHAR2(1)
10 );
11
12 TYPE section_tbl_type IS TABLE OF sec_rec INDEX BY BINARY_INTEGER;
13
14 PROCEDURE get_section_heirarchy( p_section_id number , px_section_tbl OUT NOCOPY section_tbl_type) ;
15
16 END;