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

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

29: CREATED_BY_MODULE,
30: APPLICATION_ID
31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
35: DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),

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

30: APPLICATION_ID
31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
35: DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),
38: HZ_UTILITY_V2PUB.CREATED_BY,

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

31: )
32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
35: DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),
38: HZ_UTILITY_V2PUB.CREATED_BY,
39: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),

32: VALUES (
33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
35: DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),
38: HZ_UTILITY_V2PUB.CREATED_BY,
39: HZ_UTILITY_V2PUB.CREATION_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),

33: DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
34: DECODE( X_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
35: DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
36: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
37: DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),
38: HZ_UTILITY_V2PUB.CREATED_BY,
39: HZ_UTILITY_V2PUB.CREATION_DATE,
40: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
41: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

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

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

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

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

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

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

Line 64: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),

60:
61: BEGIN
62:
63: UPDATE HZ_CLASS_CODE_RELATIONS SET
64: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
65: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

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

64: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
65: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
69: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
70: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
71: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
72: AND CLASS_CODE = X_CLASS_CODE

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

65: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
69: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
70: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
71: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
72: AND CLASS_CODE = X_CLASS_CODE
73: AND SUB_CLASS_CODE = X_SUB_CLASS_CODE

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

66: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
68: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
69: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
70: APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
71: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
72: AND CLASS_CODE = X_CLASS_CODE
73: AND SUB_CLASS_CODE = X_SUB_CLASS_CODE
74: AND START_DATE_ACTIVE = X_START_DATE_ACTIVE;

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

174:
175: BEGIN
176:
177: SELECT
178: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),

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

175: BEGIN
176:
177: SELECT
178: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),

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

176:
177: SELECT
178: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

Line 181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),

177: SELECT
178: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
185: INTO

Line 182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),

178: NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
185: INTO
186: X_CLASS_CATEGORY,

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

179: NVL( CLASS_CODE, FND_API.G_MISS_CHAR ),
180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
185: INTO
186: X_CLASS_CATEGORY,
187: X_CLASS_CODE,

Line 184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )

180: NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
181: NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
182: NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
183: NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
184: NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
185: INTO
186: X_CLASS_CATEGORY,
187: X_CLASS_CODE,
188: X_SUB_CLASS_CODE,

Line 205: RAISE FND_API.G_EXC_ERROR;

201: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
202: FND_MESSAGE.SET_TOKEN( 'RECORD', 'class_code_relation_rec');
203: FND_MESSAGE.SET_TOKEN( 'VALUE', X_CLASS_CATEGORY );
204: FND_MSG_PUB.ADD;
205: RAISE FND_API.G_EXC_ERROR;
206:
207: END Select_Row;
208:
209: PROCEDURE Delete_Row (