[Home] [Help]
PACKAGE: APPS.AMS_PRICE_LIST_REPORT_PVT
Source
1 PACKAGE ams_price_list_report_pvt AUTHID CURRENT_USER AS
2 /* $Header: amsqprls.pls 115.0 2001/09/05 14:54:14 pkm ship $*/
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 section_tbl_type) ;
15
16 END;