230: -- object by creating a record in AMS_ACT_METRICS_ALL.
231: -- Parameters
232: -- IN p_api_version IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional
234: -- Default := FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default := FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default := FND_API.G_VALID_LEVEL_FULL
232: -- IN p_api_version IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional
234: -- Default := FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default := FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default := FND_API.G_VALID_LEVEL_FULL
239: -- p_act_metric_rec IN act_metric_rec_type Required
240: -- OUT x_return_status OUT VARCHAR2
234: -- Default := FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default := FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default := FND_API.G_VALID_LEVEL_FULL
239: -- p_act_metric_rec IN act_metric_rec_type Required
240: -- OUT x_return_status OUT VARCHAR2
241: -- x_msg_count OUT NUMBER
242: -- x_msg_data OUT VARCHAR2
247:
248:
249: PROCEDURE Create_ActMetric (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
252: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
253: --p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
254: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
255:
248:
249: PROCEDURE Create_ActMetric (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
252: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
253: --p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
254: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
255:
256: x_return_status OUT NOCOPY VARCHAR2,
249: PROCEDURE Create_ActMetric (
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
252: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
253: --p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
254: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
255:
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
252: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
253: --p_commit IN VARCHAR2 := Fnd_Api.G_TRUE,
254: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
255:
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
269: -- object by creating a record in AMS_ACT_METRICS_ALL.
270: -- Parameters
271: -- IN p_api_version IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional
273: -- Default := FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default := FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default := FND_API.G_VALID_LEVEL_FULL
271: -- IN p_api_version IN NUMBER Required
272: -- p_init_msg_list IN VARCHAR2 Optional
273: -- Default := FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default := FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default := FND_API.G_VALID_LEVEL_FULL
278: -- p_act_metric_rec IN act_metric_rec_type Required
279: -- OUT x_return_status OUT VARCHAR2
273: -- Default := FND_API.G_FALSE
274: -- p_commit IN VARCHAR2 Optional
275: -- Default := FND_API.G_FALSE
276: -- p_validation_level IN NUMBER Optional
277: -- Default := FND_API.G_VALID_LEVEL_FULL
278: -- p_act_metric_rec IN act_metric_rec_type Required
279: -- OUT x_return_status OUT VARCHAR2
280: -- x_msg_count OUT NUMBER
281: -- x_msg_data OUT VARCHAR2
286:
287:
288: PROCEDURE Update_ActMetric (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293:
294: x_return_status OUT NOCOPY VARCHAR2,
287:
288: PROCEDURE Update_ActMetric (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293:
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
288: PROCEDURE Update_ActMetric (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
291: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
292: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
293:
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
306: -- object by creating a record in AMS_ACT_METRICS_ALL.
307: -- Parameters
308: -- IN p_api_version IN NUMBER Required
309: -- p_init_msg_list IN VARCHAR2 Optional
310: -- Default := FND_API.G_FALSE
311: -- p_commit IN VARCHAR2 Optional
312: -- Default := FND_API.G_FALSE
313: -- p_arc_act_metric_used_by IN VARCHAR2 Required
314: -- p_act_metric_used_by_id IN NUMBER Required
308: -- IN p_api_version IN NUMBER Required
309: -- p_init_msg_list IN VARCHAR2 Optional
310: -- Default := FND_API.G_FALSE
311: -- p_commit IN VARCHAR2 Optional
312: -- Default := FND_API.G_FALSE
313: -- p_arc_act_metric_used_by IN VARCHAR2 Required
314: -- p_act_metric_used_by_id IN NUMBER Required
315: -- p_activity_metric_id IN NUMBER NULL (never set!)
316: -- OUT x_return_status OUT VARCHAR2
322: -- End of comments
323:
324: PROCEDURE Delete_ActMetric (
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
327: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
328:
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
323:
324: PROCEDURE Delete_ActMetric (
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
327: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
328:
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2,
344: -- object by creating a record in AMS_ACT_METRICS_ALL.
345: -- Parameters
346: -- IN p_api_version IN NUMBER Required
347: -- p_init_msg_list IN VARCHAR2 Optional
348: -- Default := FND_API.G_FALSE
349: -- p_commit IN VARCHAR2 Optional
350: -- Default := FND_API.G_FALSE
351: -- p_activity_metric_id IN NUMBER Required
352: -- p_object_version_number IN NUMBER
346: -- IN p_api_version IN NUMBER Required
347: -- p_init_msg_list IN VARCHAR2 Optional
348: -- Default := FND_API.G_FALSE
349: -- p_commit IN VARCHAR2 Optional
350: -- Default := FND_API.G_FALSE
351: -- p_activity_metric_id IN NUMBER Required
352: -- p_object_version_number IN NUMBER
353: -- OUT x_return_status OUT VARCHAR2
354: -- x_msg_count OUT NUMBER
359: -- End of comments
360:
361: PROCEDURE Delete_ActMetric (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
364: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
365:
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
360:
361: PROCEDURE Delete_ActMetric (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
364: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
365:
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,
378: -- Function Lock the given row in AMS_ACT_METRICS_ALL.
379: -- Parameters
380: -- IN p_api_version IN NUMBER Required
381: -- p_init_msg_list IN VARCHAR2 Optional
382: -- Default := FND_API.G_FALSE
383: -- p_commit IN VARCHAR2 Optional
384: -- Default := FND_API.G_FALSE
385: -- p_activity_metric_id IN NUMBER Required
386: -- p_object_version_number IN NUMBER Required
380: -- IN p_api_version IN NUMBER Required
381: -- p_init_msg_list IN VARCHAR2 Optional
382: -- Default := FND_API.G_FALSE
383: -- p_commit IN VARCHAR2 Optional
384: -- Default := FND_API.G_FALSE
385: -- p_activity_metric_id IN NUMBER Required
386: -- p_object_version_number IN NUMBER Required
387: -- OUT x_return_status OUT VARCHAR2
388: -- x_msg_count OUT NUMBER
394:
395:
396: PROCEDURE Lock_ActMetric (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
399:
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
413: -- objects.
414: -- Parameters
415: -- IN p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Optional
417: -- Default := FND_API.G_FALSE
418: -- p_commit IN VARCHAR2 Optional
419: -- Default := FND_API.G_FALSE
420: -- p_validation_level IN NUMBER Optional
421: -- Default := FND_API.G_VALID_LEVEL_FULL
415: -- IN p_api_version IN NUMBER Required
416: -- p_init_msg_list IN VARCHAR2 Optional
417: -- Default := FND_API.G_FALSE
418: -- p_commit IN VARCHAR2 Optional
419: -- Default := FND_API.G_FALSE
420: -- p_validation_level IN NUMBER Optional
421: -- Default := FND_API.G_VALID_LEVEL_FULL
422: -- p_act_metric_rec IN act_metric_rec_type Required
423: -- OUT x_return_status OUT VARCHAR2
417: -- Default := FND_API.G_FALSE
418: -- p_commit IN VARCHAR2 Optional
419: -- Default := FND_API.G_FALSE
420: -- p_validation_level IN NUMBER Optional
421: -- Default := FND_API.G_VALID_LEVEL_FULL
422: -- p_act_metric_rec IN act_metric_rec_type Required
423: -- OUT x_return_status OUT VARCHAR2
424: -- x_msg_count OUT NUMBER
425: -- x_msg_data OUT VARCHAR2
430:
431:
432: PROCEDURE Validate_ActMetric (
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
435: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
436:
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
431:
432: PROCEDURE Validate_ActMetric (
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
435: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
436:
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
509: -- metric that is associated with the given business
510: -- entity.
511: -- Parameters
512: -- IN p_api_version IN NUMBER
513: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
515: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
516: -- p_arc_act_metric_used_by IN VARCHAR2 Required
517: -- p_act_metric_used_by_id IN NUMBER Required
510: -- entity.
511: -- Parameters
512: -- IN p_api_version IN NUMBER
513: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
515: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
516: -- p_arc_act_metric_used_by IN VARCHAR2 Required
517: -- p_act_metric_used_by_id IN NUMBER Required
518: -- p_metric_id IN NUMBER Required
511: -- Parameters
512: -- IN p_api_version IN NUMBER
513: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
515: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
516: -- p_arc_act_metric_used_by IN VARCHAR2 Required
517: -- p_act_metric_used_by_id IN NUMBER Required
518: -- p_metric_id IN NUMBER Required
519: -- p_func_committed_value IN NUMBER Required
526: -- End of comments
527:
528: PROCEDURE SetCommittedVal (
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
531: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
532: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
533:
534: x_return_status OUT NOCOPY VARCHAR2,
527:
528: PROCEDURE SetCommittedVal (
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
531: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
532: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
533:
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
528: PROCEDURE SetCommittedVal (
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
531: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
532: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
533:
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
606: -- End of comments
607: --
608: PROCEDURE Invalidate_Rollup(
609: p_api_version IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
611: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
612:
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,
607: --
608: PROCEDURE Invalidate_Rollup(
609: p_api_version IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
611: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
612:
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,
615: x_msg_data OUT NOCOPY VARCHAR2,
631: -- End of comments
632: --
633: PROCEDURE Post_Costs (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
636: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
637: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
638:
639: x_return_status OUT NOCOPY VARCHAR2,
632: --
633: PROCEDURE Post_Costs (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
636: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
637: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
638:
639: x_return_status OUT NOCOPY VARCHAR2,
640: x_msg_count OUT NOCOPY NUMBER,
633: PROCEDURE Post_Costs (
634: p_api_version IN NUMBER,
635: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
636: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
637: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
638:
639: x_return_status OUT NOCOPY VARCHAR2,
640: x_msg_count OUT NOCOPY NUMBER,
641: x_msg_data OUT NOCOPY VARCHAR2,
682: p_from_currency IN VARCHAR2,
683: p_to_currency IN VARCHAR2,
684: p_conv_date IN DATE DEFAULT SYSDATE,
685: p_amounts IN OUT NOCOPY CURRENCY_TABLE,
686: p_round IN VARCHAR2 DEFAULT FND_API.G_TRUE
687: );
688: PROCEDURE Convert_Currency_Object (
689: x_return_status OUT NOCOPY VARCHAR2,
690: p_object_id IN NUMBER,
690: p_object_id IN NUMBER,
691: p_object_type IN VARCHAR2,
692: p_conv_date IN DATE DEFAULT SYSDATE,
693: p_amounts IN OUT NOCOPY CURRENCY_TABLE,
694: p_round IN VARCHAR2 DEFAULT FND_API.G_TRUE
695: );
696:
697: -- ---------------------------------------------------------------------
698: -- PROCEDURE
751: -- 27-NOV-2001 dmvincen Created.
752: ---------------------------------------------------------------------
753: PROCEDURE GET_RESULTS(
754: p_api_version IN NUMBER,
755: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
756: x_return_status OUT NOCOPY VARCHAR2,
757: x_msg_count OUT NOCOPY NUMBER,
758: x_msg_data OUT NOCOPY VARCHAR2,
759:
786:
787:
788: procedure copy_act_metrics (
789: p_api_version IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
792: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
793: p_source_object_type IN VARCHAR2,
794: p_source_object_id IN NUMBER,
787:
788: procedure copy_act_metrics (
789: p_api_version IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
792: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
793: p_source_object_type IN VARCHAR2,
794: p_source_object_id IN NUMBER,
795: p_target_object_id IN NUMBER,
788: procedure copy_act_metrics (
789: p_api_version IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
792: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
793: p_source_object_type IN VARCHAR2,
794: p_source_object_id IN NUMBER,
795: p_target_object_id IN NUMBER,
796: x_return_status OUT NOCOPY VARCHAR2,
810: --======================================================================
811:
812: procedure validate_objects(
813: p_api_version IN NUMBER,
814: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
815: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
816: p_source_object_type IN VARCHAR2,
817: p_source_object_id IN NUMBER,
818: p_target_object_id IN NUMBER,
811:
812: procedure validate_objects(
813: p_api_version IN NUMBER,
814: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
815: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
816: p_source_object_type IN VARCHAR2,
817: p_source_object_id IN NUMBER,
818: p_target_object_id IN NUMBER,
819: x_return_status OUT NOCOPY VARCHAR2,
823:
824:
825: FUNCTION Lock_Object(
826: p_api_version IN NUMBER,
827: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
828: p_arc_act_metric_used_by IN VARCHAR2,
829: p_act_metric_used_by_id IN NUMBER,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,
847: -- 30-Jan-2004 choang Created.
848: --
849: PROCEDURE delete_actmetrics_assoc (
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
853: p_object_type IN VARCHAR2,
854: p_object_id IN NUMBER,
855: x_return_status OUT NOCOPY VARCHAR2,
848: --
849: PROCEDURE delete_actmetrics_assoc (
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
853: p_object_type IN VARCHAR2,
854: p_object_id IN NUMBER,
855: x_return_status OUT NOCOPY VARCHAR2,
856: x_msg_count OUT NOCOPY NUMBER,