[Home] [Help]
102: COMMIT;
103: END IF;
104:
105: --
106: -- Standard API to get message count, and if 1,
107: -- set the message data OUT NOCOPY variable.
108: --
109: Fnd_Msg_Pub.Count_And_Get (
110: p_count => x_msg_count,
278: -- NOTES
279: --
280: -- HISTORY
281: -- 05/26/1999 choang Created.
282: -- 10/9/1999 ptendulk Modified According to new Standards
283: -- 14/Apr-2000 tdonohoe@us Added new columns for 11.5.2 into insert statement.
284: -- 06-28-2000 rchahal@us Modified to allow metric creation for Fund.
285: -- 07/11/2000 svatsa@us Updated the API to allow for creating Summary ActMetric
286: -- for a given metric_id.
301: )
302:
303: IS
304: --
305: -- Standard API information constants.
306: --
307: L_API_VERSION CONSTANT NUMBER := 1.0;
308: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_ActMetric2';
309: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
342: Fnd_Msg_Pub.Initialize;
343: END IF;
344:
345: --
346: -- Standard check for API version compatibility.
347: --
348: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
349: p_api_version,
350: L_API_NAME,
629: -- End API Body.
630: --
631:
632: --
633: -- Standard check for commit request.
634: --
635: --IF Fnd_Api.To_Boolean (p_commit) THEN
636: -- COMMIT WORK;
637: --END IF;
636: -- COMMIT WORK;
637: --END IF;
638:
639: --
640: -- Standard API to get message count, and if 1,
641: -- set the message data OUT NOCOPY variable.
642: --
643: --Fnd_Msg_Pub.Count_And_Get (
644: -- p_count => x_msg_count,
699: -- NOTES
700: --
701: -- HISTORY
702: -- 05/26/1999 choang Created.
703: -- 10/9/1999 ptendulk Modified According to new Standards
704: -- 17-Apr-2000 tdonohoe Added new columns to Update statement to
705: -- support 11.5.2 release.
706: -- 05/07/2001 huili@ Added invalidating corresponding variable metrics
707: -- End of comments
754: Fnd_Msg_Pub.Initialize;
755: END IF;
756:
757: --
758: -- Standard check for API version compatibility.
759: --
760: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
761: p_api_version,
762: L_API_NAME,
933: COMMIT;
934: END IF;
935:
936: --
937: -- Standard API to get message count, and if 1,
938: -- set the message data OUT variable.
939: --
940: Fnd_Msg_Pub.Count_And_Get (
941: p_count => x_msg_count,
993: -- NOTES
994: --
995: -- HISTORY
996: -- 05/26/1999 choang Created.
997: -- 10/9/1999 ptendulk Modified according to new standards
998: --
999: -- End of comments
1000:
1001: PROCEDURE Validate_ActMetric (
1031: Fnd_Msg_Pub.Initialize;
1032: END IF;
1033:
1034: --
1035: -- Standard check for API version compatibility.
1036: --
1037: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1038: p_api_version,
1039: L_API_NAME,
1094: -- End API Body.
1095: --
1096:
1097: --
1098: -- Standard API to get message count, and if 1,
1099: -- set the message data OUT NOCOPY variable.
1100: --
1101: Fnd_Msg_Pub.Count_And_Get (
1102: p_count => x_msg_count,
1148: -- NOTES
1149: --
1150: -- HISTORY
1151: -- 05/26/1999 choang Created.
1152: -- 10/9/1999 ptendulk Modified According to new standards.
1153: --
1154: -- End of comments.
1155:
1156: PROCEDURE Check_Req_ActMetrics_Items (
1384: -- NOTES
1385: --
1386: -- HISTORY
1387: -- 05/26/1999 choang Created.
1388: -- 10/9/1999 ptendulk Modified According to new Standards
1389: -- 05/08/2000 tdonohoe Modified, do not perform Metric_Id Check if the Activity Metric
1390: -- is associated with a Forecast.
1391: -- 06-28-2000 rchahal@us Modified to allow metric creation for Fund.
1392: --
1396: p_act_metric_rec IN act_metric_rec_type,
1397: x_return_status OUT NOCOPY VARCHAR2
1398: )
1399: IS
1400: l_item_name VARCHAR2(30); -- Used to standardize error messages.
1401: l_act_metrics_rec act_metric_rec_type := p_act_metric_rec;
1402: l_return_status VARCHAR2(1);
1403:
1404: l_table_name VARCHAR2(30);