89: *
90: * ARGUMENTS
91: * IN:
92: * p_init_msg_list Initialize message stack if it is set to
93: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
94: * p_master_relation_rec Geography type record.
95: * IN/OUT:
96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.
95: * IN/OUT:
96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.
96: * OUT:
97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.
104: *
97: * x_relationship_id Returns relationship_id for the relationship created.
98: * x_return_status Return status after the call. The status can
99: * be FND_API.G_RET_STS_SUCCESS (success),
100: * FND_API.G_RET_STS_ERROR (error),
101: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
102: * x_msg_count Number of messages in message stack.
103: * x_msg_data Message text if x_msg_count is 1.
104: *
105: * NOTES
109: *
110: */
111:
112: PROCEDURE create_master_relation (
113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114: p_master_relation_rec IN MASTER_RELATION_REC_TYPE,
115: x_relationship_id OUT NOCOPY NUMBER,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
129: *
130: * ARGUMENTS
131: * IN:
132: * p_init_msg_list Initialize message stack if it is set to
133: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
134: * p_master_relation_rec Geography type record.
135: * p_object_version_number Object version number of the row
136: * IN/OUT:
137: * OUT:
136: * IN/OUT:
137: * OUT:
138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.
137: * OUT:
138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.
145: *
138: *
139: * x_return_status Return status after the call. The status can
140: * be FND_API.G_RET_STS_SUCCESS (success),
141: * FND_API.G_RET_STS_ERROR (error),
142: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
143: * x_msg_count Number of messages in message stack.
144: * x_msg_data Message text if x_msg_count is 1.
145: *
146: * NOTES
150: *
151: */
152:
153: PROCEDURE update_relationship (
154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155: p_relationship_id IN NUMBER,
156: p_status IN VARCHAR2,
157: p_object_version_number IN OUT NOCOPY NUMBER,
158: x_return_status OUT NOCOPY VARCHAR2,
170: *
171: * ARGUMENTS
172: * IN:
173: * p_init_msg_list Initialize message stack if it is set to
174: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
175: * p_geo_identifier_rec Geo_identifier type record.
176: * IN/OUT:
177: * OUT:
178: *
176: * IN/OUT:
177: * OUT:
178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.
177: * OUT:
178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.
185: *
178: *
179: * x_return_status Return status after the call. The status can
180: * be FND_API.G_RET_STS_SUCCESS (success),
181: * FND_API.G_RET_STS_ERROR (error),
182: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
183: * x_msg_count Number of messages in message stack.
184: * x_msg_data Message text if x_msg_count is 1.
185: *
186: * NOTES
190: *
191: */
192:
193: PROCEDURE create_geo_identifier(
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2
208: *
209: * ARGUMENTS
210: * IN:
211: * p_init_msg_list Initialize message stack if it is set to
212: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
213: * p_geo_identifier_rec Geo_identifier type record.
214: *
215: * IN/OUT:
216: * p_object_version_number
218: *
219: * x_cp_request_id Concurrent Program Request Id, whenever CP
220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.
219: * x_cp_request_id Concurrent Program Request Id, whenever CP
220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.
227: *
220: * to update denormalized data gets kicked off.
221: * x_return_status Return status after the call. The status can
222: * be FND_API.G_RET_STS_SUCCESS (success),
223: * FND_API.G_RET_STS_ERROR (error),
224: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
225: * x_msg_count Number of messages in message stack.
226: * x_msg_data Message text if x_msg_count is 1.
227: *
228: * NOTES
233: * for Bug 457886
234: *
235: */
236: PROCEDURE update_geo_identifier (
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_geo_identifier_rec IN GEO_IDENTIFIER_REC_TYPE,
239: p_object_version_number IN OUT NOCOPY NUMBER,
240: x_cp_request_id OUT NOCOPY NUMBER,
241: x_return_status OUT NOCOPY VARCHAR2,
253: *
254: * ARGUMENTS
255: * IN:
256: * p_init_msg_list Initialize message stack if it is set to
257: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
258: * p_geography_id geography id
259: * p_identifier_type
260: * p_identifier_subtype
261: * p_identifier_value
262: *
263: * OUT:
264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.
263: * OUT:
264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.
271: *
264: *
265: * x_return_status Return status after the call. The status can
266: * be FND_API.G_RET_STS_SUCCESS (success),
267: * FND_API.G_RET_STS_ERROR (error),
268: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: * x_msg_count Number of messages in message stack.
270: * x_msg_data Message text if x_msg_count is 1.
271: *
272: * NOTES
276: *
277: */
278:
279: PROCEDURE delete_geo_identifier(
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_geography_id IN NUMBER,
282: p_identifier_type IN VARCHAR2,
283: p_identifier_subtype IN VARCHAR2,
284: p_identifier_value IN VARCHAR2,
299: *
300: * ARGUMENTS
301: * IN:
302: * p_init_msg_list Initialize message stack if it is set to
303: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
304: * p_master_geography_rec Master Geography type record.
305: * IN/OUT:
306: * OUT:
307: *
306: * OUT:
307: *
308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.
307: *
308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.
315: *
308: * x_geography_id Return ID of the geography being created.
309: * x_return_status Return status after the call. The status can
310: * be FND_API.G_RET_STS_SUCCESS (success),
311: * FND_API.G_RET_STS_ERROR (error),
312: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
313: * x_msg_count Number of messages in message stack.
314: * x_msg_data Message text if x_msg_count is 1.
315: *
316: * NOTES
320: *
321: */
322:
323: PROCEDURE create_master_geography(
324: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
325: p_master_geography_rec IN MASTER_GEOGRAPHY_REC_TYPE,
326: x_geography_id OUT NOCOPY NUMBER,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
339: *
340: * ARGUMENTS
341: * IN:
342: * p_init_msg_list Initialize message stack if it is set to
343: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
344: * p_master_geography_rec Master Geography type record.
345: *
346: * IN/OUT:
347: * p_object_version_number
347: * p_object_version_number
348: * OUT:
349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.
348: * OUT:
349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.
356: *
349: *
350: * x_return_status Return status after the call. The status can
351: * be FND_API.G_RET_STS_SUCCESS (success),
352: * FND_API.G_RET_STS_ERROR (error),
353: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
354: * x_msg_count Number of messages in message stack.
355: * x_msg_data Message text if x_msg_count is 1.
356: *
357: * NOTES
360: * 12-12-2002 Rekha Nalluri o Created.
361: *
362: */
363: PROCEDURE update_geography (
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
365: p_geography_id IN NUMBER,
366: p_end_date IN DATE,
367: p_geometry IN MDSYS.SDO_GEOMETRY,
368: p_timezone_code IN VARCHAR2,
382: *
383: * ARGUMENTS
384: * IN:
385: * p_init_msg_list Initialize message stack if it is set to
386: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
387: * p_geography_range_rec Geography range type record.
388: * IN/OUT:
389: * OUT:
390: *
388: * IN/OUT:
389: * OUT:
390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.
389: * OUT:
390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.
397: *
390: *
391: * x_return_status Return status after the call. The status can
392: * be FND_API.G_RET_STS_SUCCESS (success),
393: * FND_API.G_RET_STS_ERROR (error),
394: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
395: * x_msg_count Number of messages in message stack.
396: * x_msg_data Message text if x_msg_count is 1.
397: *
398: * NOTES
402: *
403: */
404:
405: PROCEDURE create_geography_range(
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_geography_range_rec IN GEOGRAPHY_RANGE_REC_TYPE,
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2
421: *
422: * ARGUMENTS
423: * IN:
424: * p_init_msg_list Initialize message stack if it is set to
425: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
426: * geography_id
427: * geography_from
428: * start_date
429: * end_date
432: * p_object_version_number
433: * OUT:
434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.
433: * OUT:
434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.
441: *
434: *
435: * x_return_status Return status after the call. The status can
436: * be FND_API.G_RET_STS_SUCCESS (success),
437: * FND_API.G_RET_STS_ERROR (error),
438: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
439: * x_msg_count Number of messages in message stack.
440: * x_msg_data Message text if x_msg_count is 1.
441: *
442: * NOTES
445: * 01-23-2003 Rekha Nalluri o Created.
446: *
447: */
448: PROCEDURE update_geography_range (
449: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
450: p_geography_id IN NUMBER,
451: p_geography_from IN VARCHAR2,
452: p_start_date IN DATE,
453: p_end_date IN DATE,
468: *
469: * ARGUMENTS
470: * IN:
471: * p_init_msg_list Initialize message stack if it is set to
472: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
473: * p_geography_id
474: * p_zone_relation_tbl Zone relation table of records.
475: * IN/OUT:
476: * OUT:
475: * IN/OUT:
476: * OUT:
477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.
476: * OUT:
477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.
484: *
477: *
478: * x_return_status Return status after the call. The status can
479: * be FND_API.G_RET_STS_SUCCESS (success),
480: * FND_API.G_RET_STS_ERROR (error),
481: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
482: * x_msg_count Number of messages in message stack.
483: * x_msg_data Message text if x_msg_count is 1.
484: *
485: * NOTES
489: *
490: */
491:
492: PROCEDURE create_zone_relation(
493: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
494: p_geography_id IN NUMBER,
495: p_zone_relation_tbl IN ZONE_RELATION_TBL_TYPE,
496: p_created_by_module IN VARCHAR2,
497: p_application_id IN NUMBER,
511: *
512: * ARGUMENTS
513: * IN:
514: * p_init_msg_list Initialize message stack if it is set to
515: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
516: * p_zone_type
517: * p_zone_name
518: * p_zone_code
519: * p_start_date
528: *
529: * OUT:
530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.
529: * OUT:
530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.
537: *
530: * x_return_status
531: * Return status after the call. The status can
532: * be FND_API.G_RET_STS_SUCCESS (success),
533: * FND_API.G_RET_STS_ERROR (error),
534: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
535: * x_msg_count Number of messages in message stack.
536: * x_msg_data Message text if x_msg_count is 1.
537: *
538: * NOTES
542: *
543: */
544:
545: PROCEDURE create_zone(
546: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
547: p_zone_type IN VARCHAR2,
548: p_zone_name IN VARCHAR2,
549: p_zone_code IN VARCHAR2,
550: p_zone_code_type IN VARCHAR2,