[Home] [Help]
PACKAGE: APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT
Source
1 PACKAGE HZ_GEO_STRUCTURE_VALIDATE_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHGSTVS.pls 115.0 2003/02/01 02:36:24 rnalluri noship $ */
3
4 --------------------------------------
5 -- public procedures and functions
6 --------------------------------------
7
8 /**
9 * PROCEDURE validate_geography_type
10 *
11 * DESCRIPTION
12 * Validate Geography type.
13 *
14 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15 *
16 * ARGUMENTS
17 * IN:
18 * p_geography_type Geography Type to validate
19 * p_master_ref_flag Geography Use flag
20 *
21 * IN/OUT:
22 * x_return_status Return status.
23 *
24 * NOTES
25 *
26 *
27 * MODIFICATION HISTORY
28 *
29 * 11-05-2002 Rekha Nalluri o Created.
30 *
31 */
32
33 PROCEDURE validate_geography_type (
34 p_geography_type IN VARCHAR2,
35 p_master_ref_flag IN VARCHAR2,
36 x_return_status IN OUT NOCOPY VARCHAR2
37 );
38
39 -- validate geography_id
40
41 PROCEDURE validate_geography_id (
42 p_geography_id IN NUMBER,
43 p_master_ref_flag IN VARCHAR2,
44 x_return_status IN OUT NOCOPY VARCHAR2
45 );
46
47
48 -- PROCEDURE validate_geo_rel_type
49 --
50 -- DESCRIPTION
51 -- Validates geography relationship type record. Checks for
52 --
53 -- uniqueness
54 -- lookups
55 -- mandatory columns
56 --
57 --
58 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
59 --
60 -- ARGUMENTS
61 -- IN:
62 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
63 -- p_geo_rel_type_rec geography relationship type record.
64 --
65 -- IN/OUT:
66 -- x_return_status Return status after the call. The status can
67 -- be FND_API.G_RET_STS_SUCCESS (success),
68 -- FND_API.G_RET_STS_ERROR (error),
69 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
70 --
71 -- NOTES
72 --
73 -- MODIFICATION HISTORY
74 --
75 -- 11-11-2002 Rekha Nalluri o Created.
76 --
77 --
78
79 PROCEDURE validate_geo_rel_type (
80 p_create_update_flag IN VARCHAR2,
81 p_geo_rel_type_rec IN HZ_GEOGRAPHY_STRUCTURE_PUB.geo_rel_type_rec_type,
82 x_return_status IN OUT NOCOPY VARCHAR2
83 );
84
85
86 -- PROCEDURE validate_geo_structure
87 --
88 -- DESCRIPTION
89 -- Validates geography structure record. Checks for
90 --
91 -- uniqueness
92 -- lookups
93 -- mandatory columns
94 --
95 --
96 -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
97 --
98 -- ARGUMENTS
99 -- IN:
100 -- p_create_update_flag Create update flag. 'C' = create. 'U' = update.
101 -- p_geo_structure_rec geography structure type record.
102 --
103 -- IN/OUT:
104 -- x_return_status Return status after the call. The status can
105 -- be FND_API.G_RET_STS_SUCCESS (success),
106 -- FND_API.G_RET_STS_ERROR (error),
107 -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
108 --
109 -- NOTES
110 --
111 -- MODIFICATION HISTORY
112 --
113 -- 11-15-2002 Rekha Nalluri o Created.
114 --
115 --
116
117 PROCEDURE validate_geo_structure (
118 p_create_update_flag IN VARCHAR2,
119 p_geo_structure_rec IN HZ_GEOGRAPHY_STRUCTURE_PUB.geo_structure_rec_type,
120 x_return_status IN OUT NOCOPY VARCHAR2
121 );
122
123
124 /**
125 * PROCEDURE validate_zone_type
126 *
127 * DESCRIPTION
128 * Validate Zone type.
129 *
130 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
131 *
132 * ARGUMENTS
133 * IN:
134 * p_geography_type Geography Type to validate
135 * p_geography_use Geography Usage
136 * p_limited_by_geography_id
137 * p_incl_geo_type Included geography type
138 *
139 * IN/OUT:
140 * x_return_status Return status.
141 *
142 * NOTES
143 *
144 *
145 * MODIFICATION HISTORY
146 *
147 * 01-09-2003 Rekha Nalluri o Created.
148 *
149 */
150
151 PROCEDURE validate_zone_type (
152 p_zone_type_rec IN HZ_GEOGRAPHY_STRUCTURE_PUB.ZONE_TYPE_REC_TYPE,
153 p_create_update_flag IN VARCHAR2,
154 x_return_status IN OUT NOCOPY VARCHAR2
155 );
156
157 END HZ_GEO_STRUCTURE_VALIDATE_PVT;