APPS.HZ_CLASS_CATEGORIES_PKG dependencies on HZ_CLASS_CATEGORIES

Line 1: PACKAGE BODY HZ_CLASS_CATEGORIES_PKG AS

1: PACKAGE BODY HZ_CLASS_CATEGORIES_PKG AS
2: /*$Header: ARHCSCTB.pls 115.9 2002/11/21 20:33:45 sponnamb ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_CLASS_CATEGORY IN VARCHAR2,

Line 17: INSERT INTO HZ_CLASS_CATEGORIES (

13: ) IS
14:
15: BEGIN
16:
17: INSERT INTO HZ_CLASS_CATEGORIES (
18: CLASS_CATEGORY,
19: ALLOW_MULTI_PARENT_FLAG,
20: ALLOW_MULTI_ASSIGN_FLAG,
21: CREATED_BY,

Line 63: UPDATE HZ_CLASS_CATEGORIES SET

59: ) IS
60:
61: BEGIN
62:
63: UPDATE HZ_CLASS_CATEGORIES SET
64: ALLOW_MULTI_PARENT_FLAG = DECODE( X_ALLOW_MULTI_PARENT_FLAG, NULL, ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_PARENT_FLAG ),
65: ALLOW_MULTI_ASSIGN_FLAG = DECODE( X_ALLOW_MULTI_ASSIGN_FLAG, NULL, ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_ASSIGN_FLAG ),
66: ALLOW_LEAF_NODE_ONLY_FLAG = DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, NULL, ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
67: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 99: SELECT * FROM HZ_CLASS_CATEGORIES

95: X_DELIMITER IN VARCHAR2
96: ) IS
97:
98: CURSOR C IS
99: SELECT * FROM HZ_CLASS_CATEGORIES
100: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
101: FOR UPDATE NOWAIT;
102: Recinfo C%ROWTYPE;
103:

Line 192: FROM HZ_CLASS_CATEGORIES

188: X_ALLOW_LEAF_NODE_ONLY_FLAG,
189: X_CREATED_BY_MODULE,
190: X_APPLICATION_ID,
191: X_DELIMITER
192: FROM HZ_CLASS_CATEGORIES
193: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;
194:
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN

Line 211: DELETE FROM HZ_CLASS_CATEGORIES

207: ) IS
208:
209: BEGIN
210:
211: DELETE FROM HZ_CLASS_CATEGORIES
212: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;
213:
214: IF ( SQL%NOTFOUND ) THEN
215: RAISE NO_DATA_FOUND;

Line 220: END HZ_CLASS_CATEGORIES_PKG;

216: END IF;
217:
218: END Delete_Row;
219:
220: END HZ_CLASS_CATEGORIES_PKG;