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.CN_QUOTA_CATEGORIES_PUB dependencies on CN_QUOTA_CATEGORIES

Line 1: PACKAGE BODY cn_quota_categories_pub AS

1: PACKAGE BODY cn_quota_categories_pub AS
2: -- $Header: cnpqcatb.pls 115.10 2003/01/25 00:09:12 fmburu ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_QUOTA_CATEGORIES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpqcatb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_QUOTA_CATEGORIES_PUB';

1: PACKAGE BODY cn_quota_categories_pub AS
2: -- $Header: cnpqcatb.pls 115.10 2003/01/25 00:09:12 fmburu ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_QUOTA_CATEGORIES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpqcatb.pls';
6:
7: PROCEDURE Create_Quota_Category(
8: p_api_version IN NUMBER,

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 53: FROM cn_quota_categories

49:
50: -- make sure that same name is not existing.
51: SELECT count(quota_category_id)
52: INTO l_count
53: FROM cn_quota_categories
54: WHERE UPPER(name) = UPPER(l_newrec.name);
55: IF l_count > 0 THEN
56: FND_MESSAGE.SET_NAME ('CN','CN_QUOTA_CATEGORY_DUP');
57: FND_MSG_PUB.Add;

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 112: l_old_name cn_quota_categories.name%type ;

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;
115: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
116: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

Line 139: FROM cn_quota_categories

135:
136: -- make sure record to be updated exists.
137: SELECT count(quota_category_id)
138: INTO l_count
139: FROM cn_quota_categories
140: WHERE quota_category_id = p_rec.quota_category_id;
141: IF (l_count = 0) THEN
142: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_UPDATE_REC');
143: FND_MSG_PUB.ADD;

Line 157: FROM cn_quota_categories

153:
154: IF (l_count > 0) THEN
155: SELECT NAME
156: INTO l_old_name
157: FROM cn_quota_categories
158: WHERE quota_category_id = p_rec.quota_category_id;
159:
160: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
161: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', l_old_name);

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 228: qc_name CN_QUOTA_CATEGORIES.NAME%TYPE ;

224:
225: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Quota_Category';
226: l_api_version CONSTANT NUMBER := 1.0;
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;

Line 249: FROM cn_quota_categories

245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: -- make sure record to be deleted exists.
247: SELECT count(quota_category_id)
248: INTO l_count
249: FROM cn_quota_categories
250: WHERE quota_category_id = p_quota_category_id;
251: IF (l_count = 0) THEN
252: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_DELETE_REC');
253: FND_MSG_PUB.ADD;

Line 266: FROM CN_QUOTA_CATEGORIES

262:
263: IF (l_count > 0) THEN
264: SELECT NAME
265: INTO qc_name
266: FROM CN_QUOTA_CATEGORIES
267: WHERE quota_category_id = p_quota_category_id;
268:
269: FND_MESSAGE.SET_NAME('CN', 'CN_RECORD_EXISTS_ERR');
270: FND_MESSAGE.SET_TOKEN('QUOTA_CAT_NAME', qc_name);

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;

Line 350: FROM cn_quota_categories cn_cat

346: Nvl(cn_cat.compute_flag,'N') compute_flag,
347: cn_cat.object_version_number,
348: cn_cat.interval_type_id,
349: cn_cat.quota_unit_code
350: FROM cn_quota_categories cn_cat
351: WHERE upper(name) like upper(p_search_name)
352: AND type = p_search_type
353: AND quota_unit_code = p_search_unit
354: ORDER BY name;

Line 460: END cn_quota_categories_pub;

456: p_encoded => FND_API.G_FALSE
457: );
458: END;
459:
460: END cn_quota_categories_pub;
461: