DBA Data[Home] [Help]

APPS.CN_QUOTA_CATEGORIES_PUB dependencies on STANDARD

Line 29: -- Standard Start of API savepoint

25: G_CREATION_DATE DATE := sysdate;
26: G_CREATED_BY NUMBER := fnd_global.user_id;
27: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
28: BEGIN
29: -- Standard Start of API savepoint
30: SAVEPOINT Create_Quota_Category;
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call
33: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 31: -- Standard call to check for call compatibility.

27: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
28: BEGIN
29: -- Standard Start of API savepoint
30: SAVEPOINT Create_Quota_Category;
31: -- Standard call to check for call compatibility.
32: IF NOT FND_API.Compatible_API_Call
33: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
35: END IF;

Line 62: -- Standard check of p_commit.

58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60:
61: cn_quota_categories_pkg.insert_row(l_newrec);
62: -- Standard check of p_commit.
63: IF FND_API.To_Boolean( p_commit ) THEN
64: COMMIT WORK;
65: END IF;
66: FND_MSG_PUB.Count_And_Get(

Line 119: -- Standard Start of API savepoint

115: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
116: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
117:
118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT Update_Quota_Category;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call

Line 122: -- Standard call to check for call compatibility.

118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT Update_Quota_Category;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call
124: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;

Line 178: -- Standard check of p_commit.

174:
175: -- make sure the object version number hasn't changed in the meantime
176: cn_quota_categories_pkg.lock_update_row(l_newrec);
177:
178: -- Standard check of p_commit.
179: IF FND_API.To_Boolean( p_commit ) THEN
180: COMMIT WORK;
181: END IF;
182:

Line 231: -- Standard Start of API savepoint

227: l_count NUMBER;
228: qc_name CN_QUOTA_CATEGORIES.NAME%TYPE ;
229: BEGIN
230:
231: -- Standard Start of API savepoint
232: SAVEPOINT Delete_Quota_Category;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call
235: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 233: -- Standard call to check for call compatibility.

229: BEGIN
230:
231: -- Standard Start of API savepoint
232: SAVEPOINT Delete_Quota_Category;
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call
235: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;

Line 278: -- Standard check of p_commit.

274:
275: -- make sure the object version number hasn't changed in the meantime
276: cn_quota_categories_pkg.delete_row(p_quota_category_id);
277:
278: -- Standard check of p_commit.
279: IF FND_API.To_Boolean( p_commit ) THEN
280: COMMIT WORK;
281: END IF;
282:

Line 358: -- Standard call to check for call compatibility.

354: ORDER BY name;
355:
356: BEGIN
357: --
358: -- Standard call to check for call compatibility.
359: --
360: IF NOT FND_API.compatible_api_call
361: ( l_api_version ,p_api_version ,l_api_name,G_PKG_NAME )
362: THEN