59: *
60: * ARGUMENTS
61: * IN:
62: * p_init_msg_list Initialize message stack if it is set to
63: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
64: * p_geography_type_rec Geography type record.
65: * IN/OUT:
66: * OUT:
67: * x_return_status Return status after the call. The status can
64: * p_geography_type_rec Geography type record.
65: * IN/OUT:
66: * OUT:
67: * x_return_status Return status after the call. The status can
68: * be FND_API.G_RET_STS_SUCCESS (success),
69: * FND_API.G_RET_STS_ERROR (error),
70: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
71: * x_msg_count Number of messages in message stack.
72: * x_msg_data Message text if x_msg_count is 1.
65: * IN/OUT:
66: * OUT:
67: * x_return_status Return status after the call. The status can
68: * be FND_API.G_RET_STS_SUCCESS (success),
69: * FND_API.G_RET_STS_ERROR (error),
70: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
71: * x_msg_count Number of messages in message stack.
72: * x_msg_data Message text if x_msg_count is 1.
73: *
66: * OUT:
67: * x_return_status Return status after the call. The status can
68: * be FND_API.G_RET_STS_SUCCESS (success),
69: * FND_API.G_RET_STS_ERROR (error),
70: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
71: * x_msg_count Number of messages in message stack.
72: * x_msg_data Message text if x_msg_count is 1.
73: *
74: * NOTES
79: *
80: */
81:
82: PROCEDURE create_geography_type (
83: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84: p_geography_type_rec IN GEOGRAPHY_TYPE_REC_TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2
97: *
98: * ARGUMENTS
99: * IN:
100: * p_init_msg_list Initialize message stack if it is set to
101: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
102: * p_geo_structure_rec Geography structure type record.
103:
104: * IN/OUT:
105: * OUT:
103:
104: * IN/OUT:
105: * OUT:
106: * x_return_status Return status after the call. The status can
107: * be FND_API.G_RET_STS_SUCCESS (success),
108: * FND_API.G_RET_STS_ERROR (error),
109: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
110: * x_msg_count Number of messages in message stack.
111: * x_msg_data Message text if x_msg_count is 1.
104: * IN/OUT:
105: * OUT:
106: * x_return_status Return status after the call. The status can
107: * be FND_API.G_RET_STS_SUCCESS (success),
108: * FND_API.G_RET_STS_ERROR (error),
109: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
110: * x_msg_count Number of messages in message stack.
111: * x_msg_data Message text if x_msg_count is 1.
112: *
105: * OUT:
106: * x_return_status Return status after the call. The status can
107: * be FND_API.G_RET_STS_SUCCESS (success),
108: * FND_API.G_RET_STS_ERROR (error),
109: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
110: * x_msg_count Number of messages in message stack.
111: * x_msg_data Message text if x_msg_count is 1.
112: *
113: * NOTES
119: */
120:
121:
122: PROCEDURE create_geo_structure(
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
124: p_geo_structure_rec IN GEO_STRUCTURE_REC_TYPE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2
138: *
139: * ARGUMENTS
140: * IN:
141: * p_init_msg_list Initialize message stack if it is set to
142: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
143: * p_geo_structure_rec Geography structure type record.
144:
145: * IN/OUT:
146: *
145: * IN/OUT:
146: *
147: * OUT:
148: * x_return_status Return status after the call. The status can
149: * be FND_API.G_RET_STS_SUCCESS (success),
150: * FND_API.G_RET_STS_ERROR (error),
151: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
152: * x_msg_count Number of messages in message stack.
153: * x_msg_data Message text if x_msg_count is 1.
146: *
147: * OUT:
148: * x_return_status Return status after the call. The status can
149: * be FND_API.G_RET_STS_SUCCESS (success),
150: * FND_API.G_RET_STS_ERROR (error),
151: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
152: * x_msg_count Number of messages in message stack.
153: * x_msg_data Message text if x_msg_count is 1.
154: *
147: * OUT:
148: * x_return_status Return status after the call. The status can
149: * be FND_API.G_RET_STS_SUCCESS (success),
150: * FND_API.G_RET_STS_ERROR (error),
151: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
152: * x_msg_count Number of messages in message stack.
153: * x_msg_data Message text if x_msg_count is 1.
154: *
155: * NOTES
160: *
161: */
162:
163: PROCEDURE delete_geo_structure(
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_geography_id IN NUMBER,
166: p_geography_type IN VARCHAR2,
167: p_parent_geography_type IN VARCHAR2,
168: x_return_status OUT NOCOPY VARCHAR2,
180: *
181: * ARGUMENTS
182: * IN:
183: * p_init_msg_list Initialize message stack if it is set to
184: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
185: * p_geography_rel_type_rec Geography Relationship type record.
186: * IN/OUT:
187: * OUT:
188: * x_return_status Return status after the call. The status can
185: * p_geography_rel_type_rec Geography Relationship type record.
186: * IN/OUT:
187: * OUT:
188: * x_return_status Return status after the call. The status can
189: * be FND_API.G_RET_STS_SUCCESS (success),
190: * FND_API.G_RET_STS_ERROR (error),
191: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
192: * x_msg_count Number of messages in message stack.
193: * x_msg_data Message text if x_msg_count is 1.
186: * IN/OUT:
187: * OUT:
188: * x_return_status Return status after the call. The status can
189: * be FND_API.G_RET_STS_SUCCESS (success),
190: * FND_API.G_RET_STS_ERROR (error),
191: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
192: * x_msg_count Number of messages in message stack.
193: * x_msg_data Message text if x_msg_count is 1.
194: *
187: * OUT:
188: * x_return_status Return status after the call. The status can
189: * be FND_API.G_RET_STS_SUCCESS (success),
190: * FND_API.G_RET_STS_ERROR (error),
191: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
192: * x_msg_count Number of messages in message stack.
193: * x_msg_data Message text if x_msg_count is 1.
194: *
195: * NOTES
200: *
201: */
202:
203: PROCEDURE create_geo_rel_type(
204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205: p_geo_rel_type_rec IN GEO_REL_TYPE_REC_TYPE,
206: x_relationship_type_id OUT NOCOPY NUMBER,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
220: *
221: * ARGUMENTS
222: * IN:
223: * p_init_msg_list Initialize message stack if it is set to
224: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
225: * p_zone_type_rec Zone_type type record.
226: * included_geography_type incl_geo_type_tbl_type,
227: * IN/OUT:
228: * OUT:
227: * IN/OUT:
228: * OUT:
229: *
230: * x_return_status Return status after the call. The status can
231: * be FND_API.G_RET_STS_SUCCESS (success),
232: * FND_API.G_RET_STS_ERROR (error),
233: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
234: * x_msg_count Number of messages in message stack.
235: * x_msg_data Message text if x_msg_count is 1.
228: * OUT:
229: *
230: * x_return_status Return status after the call. The status can
231: * be FND_API.G_RET_STS_SUCCESS (success),
232: * FND_API.G_RET_STS_ERROR (error),
233: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
234: * x_msg_count Number of messages in message stack.
235: * x_msg_data Message text if x_msg_count is 1.
236: *
229: *
230: * x_return_status Return status after the call. The status can
231: * be FND_API.G_RET_STS_SUCCESS (success),
232: * FND_API.G_RET_STS_ERROR (error),
233: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
234: * x_msg_count Number of messages in message stack.
235: * x_msg_data Message text if x_msg_count is 1.
236: *
237: * NOTES
241: *
242: */
243:
244: PROCEDURE create_zone_type(
245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
246: p_zone_type_rec IN ZONE_TYPE_REC_TYPE,
247: p_included_geography_type IN INCL_GEO_TYPE_TBL_TYPE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
262: *
263: * ARGUMENTS
264: * IN:
265: * p_init_msg_list Initialize message stack if it is set to
266: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
267: * p_geographytype Geography type.
268: * p_limited_by_geography_id
269: * p_postal_code_range_flag
270: * IN/OUT:
270: * IN/OUT:
271: * p_object_version_number object version number of the row being updated
272: * OUT:
273: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * x_msg_count Number of messages in message stack.
278: * x_msg_data Message text if x_msg_count is 1.
271: * p_object_version_number object version number of the row being updated
272: * OUT:
273: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * x_msg_count Number of messages in message stack.
278: * x_msg_data Message text if x_msg_count is 1.
279: *
272: * OUT:
273: * x_return_status Return status after the call. The status can
274: * be FND_API.G_RET_STS_SUCCESS (success),
275: * FND_API.G_RET_STS_ERROR (error),
276: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
277: * x_msg_count Number of messages in message stack.
278: * x_msg_data Message text if x_msg_count is 1.
279: *
280: * NOTES
285: *
286: */
287:
288: PROCEDURE update_zone_type(
289: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
290: p_zone_type_rec IN ZONE_TYPE_REC_TYPE,
291: p_included_geography_type IN INCL_GEO_TYPE_TBL_TYPE,
292: p_object_version_number IN OUT NOCOPY NUMBER,
293: x_return_status OUT NOCOPY VARCHAR2,