DBA Data[Home] [Help]

PACKAGE: APPS.HZ_GEO_STRUCTURE_LEVELS_PKG

Source


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;