eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ADI_MEDIA_PLANNER_PVT dependencies on AMS_ACTMETRIC_PVT

Line 20: TYPE actmetrics_tab_t IS TABLE OF AMS_ActMetric_PVT.act_metric_rec_type

16: --
17: -- ===============================================================
18:
19: /* ############ Private TYPE Declarations ############### */
20: TYPE actmetrics_tab_t IS TABLE OF AMS_ActMetric_PVT.act_metric_rec_type
21: INDEX BY BINARY_INTEGER;
22:
23: /* ############ Global Variable Declarations ############### */
24: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 229: l_act_metric_rec AMS_ActMetric_PVT.act_metric_rec_type;

225: l_msg_count NUMBER;
226: l_msg_data VARCHAR2(4000);
227: l_table_of_metrics actmetrics_tab_t;
228:
229: l_act_metric_rec AMS_ActMetric_PVT.act_metric_rec_type;
230: x_activity_metric_id NUMBER;
231:
232: CURSOR c_met(p_metric_id IN NUMBER,
233: p_arc_act_metric_used_by IN VARCHAR2,

Line 359: AMS_ActMetric_PVT.Create_ActMetric (

355: p_media_planner_rec.object_type;
356: l_act_metric_rec.application_id := 530;
357: x_activity_metric_id := NULL;
358:
359: AMS_ActMetric_PVT.Create_ActMetric (
360: p_api_version => 1.0,
361: p_init_msg_list => FND_API.G_FALSE,
362: p_commit => FND_API.G_FALSE,
363: p_validation_level => Fnd_Api.G_Valid_Level_Full,

Line 401: Ams_Actmetric_Pvt.update_actmetric (

397: l_act_metric_rec.arc_act_metric_used_by := NULL;
398:
399: ELSE
400: -- invoke update metric API
401: Ams_Actmetric_Pvt.update_actmetric (
402: p_api_version => 1.0,
403: p_init_msg_list => FND_API.G_FALSE,
404: p_commit => FND_API.G_FALSE,
405: p_act_metric_rec => l_table_of_metrics(i),

Line 608: l_act_metric_rec AMS_ActMetric_PVT.act_metric_rec_type;

604: p_interface_rec IN ams_adi_media_planner%ROWTYPE,
605: x_actmetric_table OUT NOCOPY actmetrics_tab_t
606: )
607: IS
608: l_act_metric_rec AMS_ActMetric_PVT.act_metric_rec_type;
609: BEGIN
610:
611: -- Clear the table.
612: x_actmetric_table.delete;

Line 620: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

616: p_interface_rec.METRIC_ID_101 IS NOT NULL THEN
617:
618: -- Records in this list are for updating. All fields are defaulted
619: -- to G_MISS... values.
620: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
621: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_101;
622: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_101;
623: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_101;
624: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_101;

Line 632: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

628: END IF;
629:
630: IF p_interface_rec.ACT_METRIC_ID_102 IS NOT NULL OR
631: p_interface_rec.METRIC_ID_102 IS NOT NULL THEN
632: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
633: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_102;
634: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_102;
635: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_102;
636: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_102;

Line 643: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

639: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
640: END IF;
641:
642: IF p_interface_rec.ACT_METRIC_ID_103 IS NOT NULL OR p_interface_rec.METRIC_ID_103 IS NOT NULL THEN
643: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
644: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_103;
645: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_103;
646: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_103;
647: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_103;

Line 654: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

650: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
651: END IF;
652:
653: IF p_interface_rec.ACT_METRIC_ID_104 IS NOT NULL OR p_interface_rec.METRIC_ID_104 IS NOT NULL THEN
654: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
655: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_104;
656: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_104;
657: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_104;
658: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_104;

Line 665: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

661: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
662: END IF;
663:
664: IF p_interface_rec.ACT_METRIC_ID_105 IS NOT NULL OR p_interface_rec.METRIC_ID_105 IS NOT NULL THEN
665: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
666: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_105;
667: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_105;
668: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_105;
669: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_105;

Line 676: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

672: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
673: END IF;
674:
675: IF p_interface_rec.ACT_METRIC_ID_106 IS NOT NULL OR p_interface_rec.METRIC_ID_106 IS NOT NULL THEN
676: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
677: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_106;
678: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_106;
679: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_106;
680: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_106;

Line 687: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

683: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
684: END IF;
685:
686: IF p_interface_rec.ACT_METRIC_ID_107 IS NOT NULL OR p_interface_rec.METRIC_ID_107 IS NOT NULL THEN
687: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
688: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_107;
689: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_107;
690: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_107;
691: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_107;

Line 698: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

694: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
695: END IF;
696:
697: IF p_interface_rec.ACT_METRIC_ID_108 IS NOT NULL OR p_interface_rec.METRIC_ID_108 IS NOT NULL THEN
698: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
699: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_108;
700: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_108;
701: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_108;
702: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_108;

Line 709: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

705: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
706: END IF;
707:
708: IF p_interface_rec.ACT_METRIC_ID_109 IS NOT NULL OR p_interface_rec.METRIC_ID_109 IS NOT NULL THEN
709: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
710: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_109;
711: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_109;
712: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_109;
713: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_109;

Line 720: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

716: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
717: END IF;
718:
719: IF p_interface_rec.ACT_METRIC_ID_110 IS NOT NULL OR p_interface_rec.METRIC_ID_110 IS NOT NULL THEN
720: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
721: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_110;
722: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_110;
723: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_110;
724: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_110;

Line 733: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

729: --Fixed Manual Metrics End
730:
731: --Variable Manual Metrics Start
732: IF p_interface_rec.ACT_METRIC_ID_201 IS NOT NULL OR p_interface_rec.METRIC_ID_201 IS NOT NULL THEN
733: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
734: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_201;
735: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_201;
736: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_201;
737: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_201;

Line 744: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

740: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
741: END IF;
742:
743: IF p_interface_rec.ACT_METRIC_ID_202 IS NOT NULL OR p_interface_rec.METRIC_ID_202 IS NOT NULL THEN
744: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
745: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_202;
746: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_202;
747: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_202;
748: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_202;

Line 755: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

751: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
752: END IF;
753:
754: IF p_interface_rec.ACT_METRIC_ID_203 IS NOT NULL OR p_interface_rec.METRIC_ID_203 IS NOT NULL THEN
755: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
756: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_203;
757: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_203;
758: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_203;
759: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_203;

Line 766: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

762: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
763: END IF;
764:
765: IF p_interface_rec.ACT_METRIC_ID_204 IS NOT NULL OR p_interface_rec.METRIC_ID_204 IS NOT NULL THEN
766: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
767: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_204;
768: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_204;
769: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_204;
770: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_204;

Line 777: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

773: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
774: END IF;
775:
776: IF p_interface_rec.ACT_METRIC_ID_205 IS NOT NULL OR p_interface_rec.METRIC_ID_205 IS NOT NULL THEN
777: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
778: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_205;
779: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_205;
780: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_205;
781: l_act_metric_rec.trans_actual_value := p_interface_rec.METRIC_ACTUAL_205;

Line 791: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

787: --Variable Manual Metrics End
788:
789: --Fixed Functional Metrics Start Only Forecast Value can be manually updated for Functional Metrics
790: IF p_interface_rec.ACT_METRIC_ID_301 IS NOT NULL OR p_interface_rec.METRIC_ID_301 IS NOT NULL THEN
791: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
792: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_301;
793: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_301;
794: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_301;
795: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_301;

Line 801: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

797: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
798: END IF;
799:
800: IF p_interface_rec.ACT_METRIC_ID_302 IS NOT NULL OR p_interface_rec.METRIC_ID_302 IS NOT NULL THEN
801: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
802: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_302;
803: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_302;
804: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_302;
805: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_302;

Line 811: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

807: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
808: END IF;
809:
810: IF p_interface_rec.ACT_METRIC_ID_303 IS NOT NULL OR p_interface_rec.METRIC_ID_303 IS NOT NULL THEN
811: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
812: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_303;
813: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_303;
814: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_303;
815: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_303;

Line 821: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

817: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
818: END IF;
819:
820: IF p_interface_rec.ACT_METRIC_ID_304 IS NOT NULL OR p_interface_rec.METRIC_ID_304 IS NOT NULL THEN
821: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
822: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_304;
823: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_304;
824: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_304;
825: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_304;

Line 831: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

827: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
828: END IF;
829:
830: IF p_interface_rec.ACT_METRIC_ID_305 IS NOT NULL OR p_interface_rec.METRIC_ID_305 IS NOT NULL THEN
831: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
832: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_305;
833: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_305;
834: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_305;
835: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_305;

Line 841: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

837: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
838: END IF;
839:
840: IF p_interface_rec.ACT_METRIC_ID_306 IS NOT NULL OR p_interface_rec.METRIC_ID_306 IS NOT NULL THEN
841: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
842: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_306;
843: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_306;
844: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_306;
845: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_306;

Line 851: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

847: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
848: END IF;
849:
850: IF p_interface_rec.ACT_METRIC_ID_307 IS NOT NULL OR p_interface_rec.METRIC_ID_307 IS NOT NULL THEN
851: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
852: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_307;
853: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_307;
854: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_307;
855: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_307;

Line 861: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

857: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
858: END IF;
859:
860: IF p_interface_rec.ACT_METRIC_ID_308 IS NOT NULL OR p_interface_rec.METRIC_ID_308 IS NOT NULL THEN
861: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
862: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_308;
863: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_308;
864: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_308;
865: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_308;

Line 871: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

867: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
868: END IF;
869:
870: IF p_interface_rec.ACT_METRIC_ID_309 IS NOT NULL OR p_interface_rec.METRIC_ID_309 IS NOT NULL THEN
871: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
872: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_309;
873: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_309;
874: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_309;
875: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_309;

Line 881: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

877: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
878: END IF;
879:
880: IF p_interface_rec.ACT_METRIC_ID_310 IS NOT NULL OR p_interface_rec.METRIC_ID_310 IS NOT NULL THEN
881: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
882: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_310;
883: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_310;
884: l_act_metric_rec.trans_forecasted_value := p_interface_rec.METRIC_FORECAST_310;
885: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_310;

Line 894: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

890:
891: --Variable Functional Metrics Start
892: --For variable functional metrics, the user can update the unit forecast value only and the actual value is calculated by the system.
893: IF p_interface_rec.ACT_METRIC_ID_401 IS NOT NULL OR p_interface_rec.METRIC_ID_401 IS NOT NULL THEN
894: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
895: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_401;
896: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_401;
897: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_401;
898: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_401;

Line 904: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

900: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
901: END IF;
902:
903: IF p_interface_rec.ACT_METRIC_ID_402 IS NOT NULL OR p_interface_rec.METRIC_ID_402 IS NOT NULL THEN
904: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
905: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_402;
906: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_402;
907: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_402;
908: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_402;

Line 914: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

910: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
911: END IF;
912:
913: IF p_interface_rec.ACT_METRIC_ID_403 IS NOT NULL OR p_interface_rec.METRIC_ID_403 IS NOT NULL THEN
914: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
915: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_403;
916: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_403;
917: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_403;
918: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_403;

Line 924: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

920: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
921: END IF;
922:
923: IF p_interface_rec.ACT_METRIC_ID_404 IS NOT NULL OR p_interface_rec.METRIC_ID_404 IS NOT NULL THEN
924: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
925: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_404;
926: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_404;
927: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_404;
928: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_404;

Line 934: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

930: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
931: END IF;
932:
933: IF p_interface_rec.ACT_METRIC_ID_405 IS NOT NULL OR p_interface_rec.METRIC_ID_405 IS NOT NULL THEN
934: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
935: l_act_metric_rec.activity_metric_id := p_interface_rec.ACT_METRIC_ID_405;
936: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_405;
937: l_act_metric_rec.forecasted_variable_value := p_interface_rec.METRIC_FORECAST_UNIT_405;
938: l_act_metric_rec.object_version_number := p_interface_rec.OBJECT_VERSION_NUMBER_405;

Line 947: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

943:
944: --formula metrics start
945: -- BUG4475733: Set activity_metric_id to null for creation.
946: IF p_interface_rec.METRIC_ID_501 IS NOT NULL THEN
947: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
948: l_act_metric_rec.activity_metric_id := NULL;
949: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_501;
950: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
951: END IF;

Line 954: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

950: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
951: END IF;
952:
953: IF p_interface_rec.METRIC_ID_502 IS NOT NULL THEN
954: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
955: l_act_metric_rec.activity_metric_id := NULL;
956: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_502;
957: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
958: END IF;

Line 961: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

957: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
958: END IF;
959:
960: IF p_interface_rec.METRIC_ID_503 IS NOT NULL THEN
961: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
962: l_act_metric_rec.activity_metric_id := NULL;
963: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_503;
964: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
965: END IF;

Line 968: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

964: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
965: END IF;
966:
967: IF p_interface_rec.METRIC_ID_504 IS NOT NULL THEN
968: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
969: l_act_metric_rec.activity_metric_id := NULL;
970: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_504;
971: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
972: END IF;

Line 975: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);

971: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
972: END IF;
973:
974: IF p_interface_rec.METRIC_ID_505 IS NOT NULL THEN
975: AMS_ActMetric_PVT.Init_ActMetric_Rec(l_act_metric_rec);
976: l_act_metric_rec.activity_metric_id := NULL;
977: l_act_metric_rec.metric_id := p_interface_rec.METRIC_ID_505;
978: x_actmetric_table(x_actmetric_table.COUNT) := l_act_metric_rec;
979: END IF;