PACKAGE: APPS.HZ_GEO_GET_PUB

Source

1 PACKAGE HZ_GEO_GET_PUB 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;