APPS.CN_QUOTA_CATEGORIES_PUB dependencies on CN_QUOTA_CATEGORIES_PKG

Line 20: l_newrec CN_QUOTA_CATEGORIES_PKG.quota_categories_rec_type;

16: x_quota_category_id OUT NOCOPY NUMBER) IS
17:
18: l_api_name CONSTANT VARCHAR2(30) := 'Create_Quota_Category';
19: l_api_version CONSTANT NUMBER := 1.0;
20: l_newrec CN_QUOTA_CATEGORIES_PKG.quota_categories_rec_type;
21: l_count NUMBER;
22:
23: G_LAST_UPDATE_DATE DATE := sysdate;
24: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

Line 61: cn_quota_categories_pkg.insert_row(l_newrec);

57: FND_MSG_PUB.Add;
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;

Line 110: l_newrec CN_QUOTA_CATEGORIES_PKG.quota_categories_rec_type;

106: x_msg_data OUT NOCOPY VARCHAR2) IS
107:
108: l_api_name CONSTANT VARCHAR2(30) := 'Update_Quota_Category';
109: l_api_version CONSTANT NUMBER := 1.0;
110: l_newrec CN_QUOTA_CATEGORIES_PKG.quota_categories_rec_type;
111: l_count NUMBER;
112: l_old_name cn_quota_categories.name%type ;
113:
114: G_LAST_UPDATE_DATE DATE := sysdate;

Line 176: cn_quota_categories_pkg.lock_update_row(l_newrec);

172: l_newrec.quota_unit_code := p_rec.quota_unit_code;
173: l_newrec.object_version_number := p_rec.object_version_number;
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;

Line 276: cn_quota_categories_pkg.delete_row(p_quota_category_id);

272: RAISE FND_API.G_EXC_ERROR ;
273: END IF;
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;