[Home] [Help]
PACKAGE: APPS.HZ_ADDRESS_USAGES_PUB
Source
1 PACKAGE HZ_ADDRESS_USAGES_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARHGNRSS.pls 120.1 2005/08/25 00:15:06 baianand noship $ */
3
4 TYPE address_usages_rec_type IS RECORD (
5 map_id NUMBER,
6 usage_code VARCHAR2(30),
7 status_flag VARCHAR2(1),
8 created_by_module VARCHAR2(150),
9 application_id NUMBER
10 );
11
12 TYPE address_usage_dtls_rec_type IS RECORD (
13 geography_type VARCHAR2(30),
14 created_by_module VARCHAR2(150),
15 application_id NUMBER
16 );
17
18 TYPE address_usage_dtls_tbl_type IS TABLE of address_usage_dtls_rec_type INDEX BY BINARY_INTEGER;
19
20 PROCEDURE create_address_usages
21 (p_address_usages_rec IN address_usages_rec_type,
22 p_address_usage_dtls_tbl IN address_usage_dtls_tbl_type,
23 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24 x_usage_id OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29 PROCEDURE update_address_usages
30 (p_usage_id IN NUMBER,
31 p_map_id IN NUMBER,
32 p_usage_code IN VARCHAR2,
33 p_status_flag IN VARCHAR2,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 x_object_version_number IN OUT NOCOPY NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40 PROCEDURE create_address_usage_dtls
41 (p_usage_id IN NUMBER,
42 p_address_usage_dtls_tbl IN address_usage_dtls_tbl_type,
43 x_usage_dtl_id OUT NOCOPY NUMBER,
44 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2
48 );
49 PROCEDURE delete_address_usages(
50 p_usage_id IN NUMBER,
51 p_address_usage_dtls_tbl IN address_usage_dtls_tbl_type,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 END HZ_ADDRESS_USAGES_PUB;