[Home] [Help]
153: x_activity_metric_fact_id OUT NOCOPY NUMBER
154: )
155: IS
156: --
157: -- Standard API information constants.
158: --
159: L_API_VERSION CONSTANT NUMBER := 1.0;
160: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_ACTMETRICFACT';
161: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
198: FND_MSG_PUB.Initialize;
199: END IF;
200:
201: --
202: -- Standard check for API version compatibility.
203: --
204: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
205: p_api_version,
206: L_API_NAME,
540: -- End API Body.
541: --
542:
543: --
544: -- Standard check for commit request.
545: --
546: IF FND_API.To_Boolean (p_commit) THEN
547: COMMIT WORK;
548: END IF;
547: COMMIT WORK;
548: END IF;
549:
550: --
551: -- Standard API to get message count, and if 1,
552: -- set the message data OUT NOCOPY variable.
553: --
554: FND_MSG_PUB.Count_And_Get (
555: p_count => x_msg_count,
661: FND_MSG_PUB.Initialize;
662: END IF;
663:
664: --
665: -- Standard check for API version compatibility.
666: --
667: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
668: p_api_version,
669: L_API_NAME,
896: COMMIT;
897: END IF;
898:
899: --
900: -- Standard API to get message count, and if 1,
901: -- set the message data OUT NOCOPY variable.
902: --
903: FND_MSG_PUB.Count_And_Get (
904: p_count => x_msg_count,
1743: FND_MSG_PUB.Initialize;
1744: END IF;
1745:
1746: --
1747: -- Standard check for API version compatibility.
1748: --
1749: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
1750: p_api_version,
1751: L_API_NAME,
1821: -- End API Body.
1822: --
1823:
1824: --
1825: -- Standard API to get message count, and if 1,
1826: -- set the message data OUT NOCOPY variable.
1827: --
1828: FND_MSG_PUB.Count_And_Get (
1829: p_count => x_msg_count,
2205: p_act_metric_fact_rec IN act_metric_fact_rec_type,
2206: x_return_status OUT NOCOPY VARCHAR2
2207: )
2208: IS
2209: l_item_name VARCHAR2(30); -- Used to standardize error messages.
2210: l_act_metric_fact_rec act_metric_fact_rec_type := p_act_metric_fact_rec;
2211: l_return_status VARCHAR2(1);
2212:
2213:
2899: p_formula_rec IN ozf_formula_rec_type,
2900: x_return_status OUT NOCOPY VARCHAR2
2901: )
2902: IS
2903: l_item_name VARCHAR2(30); -- Used to standardize error messages.
2904: l_formula_rec ozf_formula_rec_type := p_formula_rec;
2905: l_return_status VARCHAR2(1);
2906:
2907: BEGIN
2952: p_formula_entry_rec IN ozf_formula_entry_rec_type,
2953: x_return_status OUT NOCOPY VARCHAR2
2954: )
2955: IS
2956: l_item_name VARCHAR2(30); -- Used to standardize error messages.
2957: l_formula_entry_rec ozf_formula_entry_rec_type := p_formula_entry_rec;
2958: l_return_status VARCHAR2(1);
2959:
2960:
3287: FND_MSG_PUB.Initialize;
3288: END IF;
3289:
3290: --
3291: -- Standard check for API version compatibility.
3292: --
3293: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
3294: p_api_version,
3295: L_API_NAME,
3361: -- End API Body.
3362: --
3363:
3364: --
3365: -- Standard API to get message count, and if 1,
3366: -- set the message data OUT variable.
3367: --
3368: FND_MSG_PUB.Count_And_Get (
3369: p_count => x_msg_count,
3449: FND_MSG_PUB.Initialize;
3450: END IF;
3451:
3452: --
3453: -- Standard check for API version compatibility.
3454: --
3455: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
3456: p_api_version,
3457: L_API_NAME,
3523: -- End API Body.
3524: --
3525:
3526: --
3527: -- Standard API to get message count, and if 1,
3528: -- set the message data OUT variable.
3529: --
3530: FND_MSG_PUB.Count_And_Get (
3531: p_count => x_msg_count,
3595: x_formula_id OUT NOCOPY NUMBER
3596: ) IS
3597:
3598: --
3599: -- Standard API information constants.
3600: --
3601: L_API_VERSION CONSTANT NUMBER := 1.0;
3602: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_FORMULA';
3603: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
3635: FND_MSG_PUB.Initialize;
3636: END IF;
3637:
3638: --
3639: -- Standard check for API version compatibility.
3640: --
3641: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
3642: p_api_version,
3643: L_API_NAME,
3775: -- End API Body.
3776: --
3777:
3778: --
3779: -- Standard check for commit request.
3780: --
3781: IF FND_API.To_Boolean (p_commit) THEN
3782: COMMIT WORK;
3783: END IF;
3782: COMMIT WORK;
3783: END IF;
3784:
3785: --
3786: -- Standard API to get message count, and if 1,
3787: -- set the message data OUT variable.
3788: --
3789: FND_MSG_PUB.Count_And_Get (
3790: p_count => x_msg_count,
3871: x_formula_entry_id OUT NOCOPY NUMBER
3872: ) IS
3873:
3874: --
3875: -- Standard API information constants.
3876: --
3877: L_API_VERSION CONSTANT NUMBER := 1.0;
3878: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_FORMULA_ENTRY';
3879: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
3911: FND_MSG_PUB.Initialize;
3912: END IF;
3913:
3914: --
3915: -- Standard check for API version compatibility.
3916: --
3917: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
3918: p_api_version,
3919: L_API_NAME,
4055: -- End API Body.
4056: --
4057:
4058: --
4059: -- Standard check for commit request.
4060: --
4061: IF FND_API.To_Boolean (p_commit) THEN
4062: COMMIT WORK;
4063: END IF;
4062: COMMIT WORK;
4063: END IF;
4064:
4065: --
4066: -- Standard API to get message count, and if 1,
4067: -- set the message data OUT variable.
4068: --
4069: FND_MSG_PUB.Count_And_Get (
4070: p_count => x_msg_count,
4173: FND_MSG_PUB.Initialize;
4174: END IF;
4175:
4176: --
4177: -- Standard check for API version compatibility.
4178: --
4179: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
4180: p_api_version,
4181: L_API_NAME,
4237: END IF;
4238:
4239:
4240: --
4241: -- Standard API to get message count, and if 1,
4242: -- set the message data OUT variable.
4243: --
4244: FND_MSG_PUB.Count_And_Get (
4245: p_count => x_msg_count,