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
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
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: );
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: