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_CATEGORY_USES_PKG dependencies on FND_API

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

27: CREATED_BY_MODULE,
28: APPLICATION_ID
29: )
30: VALUES (
31: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
32: DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),
33: DECODE( X_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
34: DECODE( X_ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
35: HZ_UTILITY_V2PUB.CREATED_BY,

Line 32: DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),

28: APPLICATION_ID
29: )
30: VALUES (
31: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
32: DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),
33: DECODE( X_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
34: DECODE( X_ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
35: HZ_UTILITY_V2PUB.CREATED_BY,
36: HZ_UTILITY_V2PUB.CREATION_DATE,

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

29: )
30: VALUES (
31: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
32: DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),
33: DECODE( X_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
34: DECODE( X_ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
35: HZ_UTILITY_V2PUB.CREATED_BY,
36: HZ_UTILITY_V2PUB.CREATION_DATE,
37: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

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

30: VALUES (
31: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
32: DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),
33: DECODE( X_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
34: DECODE( X_ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
35: HZ_UTILITY_V2PUB.CREATED_BY,
36: HZ_UTILITY_V2PUB.CREATION_DATE,
37: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

36: HZ_UTILITY_V2PUB.CREATION_DATE,
37: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
39: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
40: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
41: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
42: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
43: );
44:

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

37: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
38: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
39: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
40: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
41: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
42: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
43: );
44:
45: END Insert_Row;

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

38: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
39: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
40: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
41: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
42: DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
43: );
44:
45: END Insert_Row;
46:

Line 60: COLUMN_NAME = DECODE( X_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),

56:
57: BEGIN
58:
59: UPDATE HZ_CLASS_CATEGORY_USES SET
60: COLUMN_NAME = DECODE( X_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
61: ADDITIONAL_WHERE_CLAUSE = DECODE( X_ADDITIONAL_WHERE_CLAUSE, NULL, ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
62: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
63: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
64: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 61: ADDITIONAL_WHERE_CLAUSE = DECODE( X_ADDITIONAL_WHERE_CLAUSE, NULL, ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),

57: BEGIN
58:
59: UPDATE HZ_CLASS_CATEGORY_USES SET
60: COLUMN_NAME = DECODE( X_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
61: ADDITIONAL_WHERE_CLAUSE = DECODE( X_ADDITIONAL_WHERE_CLAUSE, NULL, ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
62: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
63: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
64: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
65: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

61: ADDITIONAL_WHERE_CLAUSE = DECODE( X_ADDITIONAL_WHERE_CLAUSE, NULL, ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
62: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
63: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
64: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
65: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
66: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
67: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
68: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
69: AND OWNER_TABLE = X_OWNER_TABLE;

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

62: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
63: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
64: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
65: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
66: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
67: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
68: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
69: AND OWNER_TABLE = X_OWNER_TABLE;
70:

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

63: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
64: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
65: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
66: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
67: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
68: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
69: AND OWNER_TABLE = X_OWNER_TABLE;
70:
71: IF ( SQL%NOTFOUND ) THEN

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

164:
165: BEGIN
166:
167: SELECT
168: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

Line 169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),

165: BEGIN
166:
167: SELECT
168: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),

166:
167: SELECT
168: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
174: INTO

Line 171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),

167: SELECT
168: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
174: INTO
175: X_CLASS_CATEGORY,

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

168: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
174: INTO
175: X_CLASS_CATEGORY,
176: X_OWNER_TABLE,

Line 173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

169: NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
170: NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
171: NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
172: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
173: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
174: INTO
175: X_CLASS_CATEGORY,
176: X_OWNER_TABLE,
177: X_COLUMN_NAME,

Line 191: RAISE FND_API.G_EXC_ERROR;

187: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
188: FND_MESSAGE.SET_TOKEN( 'RECORD', 'class_category_use_rec');
189: FND_MESSAGE.SET_TOKEN( 'VALUE', X_CLASS_CATEGORY );
190: FND_MSG_PUB.ADD;
191: RAISE FND_API.G_EXC_ERROR;
192:
193: END Select_Row;
194:
195: PROCEDURE Delete_Row (