1 PACKAGE HZ_ADDRESS_USAGES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHGNRRS.pls 120.0 2005/07/28 02:17:13 baianand noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_usage_id IN OUT NOCOPY NUMBER,
7 x_map_id IN NUMBER,
8 x_usage_code IN VARCHAR2,
9 x_status_flag IN VARCHAR2,
10 x_object_version_number IN NUMBER,
11 x_created_by_module IN VARCHAR2,
12 x_application_id IN NUMBER
13 );
14
15 PROCEDURE Update_Row (
16 x_rowid IN OUT NOCOPY VARCHAR2,
17 x_usage_id IN NUMBER,
18 x_map_id IN NUMBER,
19 x_usage_code IN VARCHAR2,
20 x_status_flag IN VARCHAR2,
21 x_object_version_number IN NUMBER,
22 x_created_by_module IN VARCHAR2,
23 x_application_id IN NUMBER
24 );
25
26 PROCEDURE Lock_Row (
27 x_rowid IN OUT NOCOPY VARCHAR2,
28 x_usage_id IN NUMBER,
29 x_map_id IN NUMBER,
30 x_usage_code IN VARCHAR2,
31 x_status_flag IN VARCHAR2,
32 x_created_by IN NUMBER,
33 x_creation_date IN DATE,
34 x_last_updated_by IN NUMBER,
35 x_last_update_date IN DATE,
36 x_last_update_login IN NUMBER,
37 x_object_version_number IN NUMBER,
38 x_created_by_module IN VARCHAR2,
39 x_application_id IN NUMBER
40 );
41
42 PROCEDURE Select_Row (
43 x_usage_id IN OUT NOCOPY NUMBER,
44 x_map_id OUT NOCOPY NUMBER,
45 x_usage_code OUT NOCOPY VARCHAR2,
46 x_status_flag OUT NOCOPY VARCHAR2,
47 x_object_version_number OUT NOCOPY NUMBER,
48 x_created_by_module OUT NOCOPY VARCHAR2,
49 x_application_id OUT NOCOPY NUMBER
50 );
51
52 PROCEDURE Delete_Row (
53 x_usage_id IN NUMBER
54 );
55
56 END HZ_ADDRESS_USAGES_PKG;