1 PACKAGE HZ_GEO_STRUCTURE_LEVELS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHGSTTS.pls 120.1 2005/07/28 02:05:07 baianand noship $ */
3
4 PROCEDURE Insert_Row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_geography_id IN NUMBER,
7 x_geography_type IN VARCHAR2,
8 x_parent_geography_type IN VARCHAR2,
9 x_object_version_number IN NUMBER,
10 x_relationship_type_id IN NUMBER,
11 x_country_code IN VARCHAR2,
12 x_geography_element_column IN VARCHAR2,
13 x_created_by_module IN VARCHAR2,
14 x_application_id IN NUMBER,
15 x_program_login_id IN NUMBER,
16 x_addr_val_level IN VARCHAR2
17 );
18
19 PROCEDURE Update_Row (
20 x_rowid IN OUT NOCOPY VARCHAR2,
21 x_geography_id IN NUMBER,
22 x_geography_type IN VARCHAR2,
23 x_parent_geography_type IN VARCHAR2,
24 x_object_version_number IN NUMBER,
25 x_relationship_type_id IN NUMBER,
26 x_country_code IN VARCHAR2,
27 x_geography_element_column IN VARCHAR2,
28 x_created_by_module IN VARCHAR2,
29 x_application_id IN NUMBER,
30 x_program_login_id IN NUMBER
31 );
32
33 PROCEDURE Lock_Row (
34 x_rowid IN OUT NOCOPY VARCHAR2,
35 x_geography_id IN NUMBER,
36 x_geography_type IN VARCHAR2,
37 x_parent_geography_type IN VARCHAR2,
38 x_object_version_number IN NUMBER,
39 x_relationship_type_id IN NUMBER,
40 x_country_code IN VARCHAR2,
41 x_geography_element_column IN VARCHAR2,
42 x_created_by_module IN VARCHAR2,
43 x_last_updated_by IN NUMBER,
44 x_creation_date IN DATE,
45 x_created_by IN NUMBER,
46 x_last_update_date IN DATE,
47 x_last_update_login IN NUMBER,
48 x_application_id IN NUMBER,
49 x_program_id IN NUMBER,
50 x_program_login_id IN NUMBER,
51 x_program_application_id IN NUMBER,
52 x_request_id IN NUMBER
53 );
54
55 PROCEDURE Select_Row (
56 x_geography_id IN OUT NOCOPY NUMBER,
57 x_geography_type IN OUT NOCOPY VARCHAR2,
58 x_parent_geography_type IN OUT NOCOPY VARCHAR2,
59 x_object_version_number OUT NOCOPY NUMBER,
60 x_relationship_type_id OUT NOCOPY NUMBER,
61 x_country_code OUT NOCOPY VARCHAR2,
62 x_geography_element_column OUT NOCOPY VARCHAR2,
63 x_created_by_module OUT NOCOPY VARCHAR2,
64 x_application_id OUT NOCOPY NUMBER,
65 x_program_login_id OUT NOCOPY NUMBER
66 );
67
68 PROCEDURE Delete_Row (
69 x_geography_id IN NUMBER,
70 x_geography_type IN VARCHAR2,
71 x_parent_geography_type IN VARCHAR2
72 );
73
74 END HZ_GEO_STRUCTURE_LEVELS_PKG;