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.HZ_CLASS_CATEGORIES_PKG dependencies on FND_API

Line 33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),

29: APPLICATION_ID,
30: DELIMITER
31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_PARENT_FLAG ),
35: DECODE( X_ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_ASSIGN_FLAG ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 34: DECODE( X_ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_PARENT_FLAG ),

30: DELIMITER
31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_PARENT_FLAG ),
35: DECODE( X_ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_ASSIGN_FLAG ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 35: DECODE( X_ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_ASSIGN_FLAG ),

31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_PARENT_FLAG ),
35: DECODE( X_ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_MULTI_ASSIGN_FLAG ),
36: HZ_UTILITY_V2PUB.CREATED_BY,
37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),

37: HZ_UTILITY_V2PUB.CREATION_DATE,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )

Line 42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

38: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )
46: );

Line 43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

39: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )
46: );
47:

Line 44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

40: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )
46: );
47:
48: END Insert_Row;

Line 45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )

41: DECODE( X_ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR, NULL, X_ALLOW_LEAF_NODE_ONLY_FLAG ),
42: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
43: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
44: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
45: DECODE( X_DELIMITER, FND_API.G_MISS_CHAR, '/', NULL,'/',X_DELIMITER )
46: );
47:
48: END Insert_Row;
49:

Line 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 ),

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,
68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 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 ),

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,
68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 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 ),

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,
68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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,
68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
71: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
72: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID,FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
73: DELIMITER = DECODE( X_DELIMITER, NULL, DELIMITER, FND_API.G_MISS_CHAR, '/', X_DELIMITER )
74: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;

Line 71: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

67: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
71: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
72: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID,FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
73: DELIMITER = DECODE( X_DELIMITER, NULL, DELIMITER, FND_API.G_MISS_CHAR, '/', X_DELIMITER )
74: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;
75:

Line 72: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID,FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

68: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
71: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
72: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID,FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
73: DELIMITER = DECODE( X_DELIMITER, NULL, DELIMITER, FND_API.G_MISS_CHAR, '/', X_DELIMITER )
74: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;
75:
76: IF ( SQL%NOTFOUND ) THEN

Line 73: DELIMITER = DECODE( X_DELIMITER, NULL, DELIMITER, FND_API.G_MISS_CHAR, '/', X_DELIMITER )

69: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
70: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
71: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
72: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID,FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
73: DELIMITER = DECODE( X_DELIMITER, NULL, DELIMITER, FND_API.G_MISS_CHAR, '/', X_DELIMITER )
74: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY;
75:
76: IF ( SQL%NOTFOUND ) THEN
77: RAISE NO_DATA_FOUND;

Line 177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),

173:
174: BEGIN
175:
176: SELECT
177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),

174: BEGIN
175:
176: SELECT
177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

Line 179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),

175:
176: SELECT
177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
183: NVL( DELIMITER, FND_API.G_MISS_CHAR )

Line 180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),

176: SELECT
177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
183: NVL( DELIMITER, FND_API.G_MISS_CHAR )
184: INTO

Line 181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

177: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
183: NVL( DELIMITER, FND_API.G_MISS_CHAR )
184: INTO
185: X_CLASS_CATEGORY,

Line 182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),

178: NVL( ALLOW_MULTI_PARENT_FLAG, FND_API.G_MISS_CHAR ),
179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
183: NVL( DELIMITER, FND_API.G_MISS_CHAR )
184: INTO
185: X_CLASS_CATEGORY,
186: X_ALLOW_MULTI_PARENT_FLAG,

Line 183: NVL( DELIMITER, FND_API.G_MISS_CHAR )

179: NVL( ALLOW_MULTI_ASSIGN_FLAG, FND_API.G_MISS_CHAR ),
180: NVL( ALLOW_LEAF_NODE_ONLY_FLAG, FND_API.G_MISS_CHAR ),
181: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
182: NVL( APPLICATION_ID, FND_API.G_MISS_NUM ),
183: NVL( DELIMITER, FND_API.G_MISS_CHAR )
184: INTO
185: X_CLASS_CATEGORY,
186: X_ALLOW_MULTI_PARENT_FLAG,
187: X_ALLOW_MULTI_ASSIGN_FLAG,

Line 201: RAISE FND_API.G_EXC_ERROR;

197: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
198: FND_MESSAGE.SET_TOKEN( 'RECORD', 'class_category_rec');
199: FND_MESSAGE.SET_TOKEN( 'VALUE', X_CLASS_CATEGORY );
200: FND_MSG_PUB.ADD;
201: RAISE FND_API.G_EXC_ERROR;
202:
203: END Select_Row;
204:
205: PROCEDURE Delete_Row (