[Home] [Help]
PACKAGE: APPS.HZ_GEO_GET_PUB
Source
1 PACKAGE HZ_GEO_GET_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARHGEGES.pls 120.5 2005/08/30 18:02:51 baianand noship $ */
3
4 TYPE zone_rec_type IS RECORD(
5 zone_id NUMBER,
6 zone_name VARCHAR2(360),
7 zone_code VARCHAR2(30),
8 zone_type VARCHAR2(30));
9
10 TYPE zone_tbl_type IS TABLE OF zone_rec_type
11 INDEX BY BINARY_INTEGER;
12
13 PROCEDURE get_zone
14 (p_location_table_name IN VARCHAR2,
15 p_location_id IN VARCHAR2,
16 p_zone_type IN VARCHAR2,
17 p_date IN DATE,
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 x_zone_tbl OUT NOCOPY zone_tbl_type,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2);
23
24 function get_conc_name(l_geo_id IN NUMBER) return VARCHAR2;
25 END;