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