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

Line 41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),

37: OBJECT_VERSION_NUMBER,
38: CREATED_BY_MODULE,
39: APPLICATION_ID
40: ) VALUES (
41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),

Line 42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),

38: CREATED_BY_MODULE,
39: APPLICATION_ID
40: ) VALUES (
41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),

39: APPLICATION_ID
40: ) VALUES (
41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),

41: DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
42: decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
43: decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
44: HZ_UTILITY_V2PUB.CREATED_BY,
45: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
46: HZ_UTILITY_V2PUB.CREATION_DATE,
47: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
48: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
49: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

50: HZ_UTILITY_V2PUB.REQUEST_ID,
51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
57: HZ_UTILITY_V2PUB.APPLICATION_ID
58: ) RETURNING

Line 55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

51: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
57: HZ_UTILITY_V2PUB.APPLICATION_ID
58: ) RETURNING
59: WORK_CLASS_ID

Line 56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

52: HZ_UTILITY_V2PUB.PROGRAM_ID,
53: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
54: decode( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
55: decode( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
56: decode( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
57: HZ_UTILITY_V2PUB.APPLICATION_ID
58: ) RETURNING
59: WORK_CLASS_ID
60: INTO

Line 128: WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),

124: BEGIN
125: Update HZ_WORK_CLASS
126: SET
127:
128: WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),
129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

Line 129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),

125: Update HZ_WORK_CLASS
126: SET
127:
128: WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),
129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),

Line 130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),

126: SET
127:
128: WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),
129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780

Line 133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),

129: LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
130: WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
131: -- Bug 3032780
132: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
133: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
134: -- Bug 3032780
135: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
136: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
137: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),

139: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
146: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
147: where rowid = X_RowId;

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

140: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
146: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
147: where rowid = X_RowId;
148:

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

141: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
142: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
143: STATUS =decode(x_STATUS, NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
144: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
145: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
146: APPLICATION_ID=HZ_UTILITY_V2PUB.APPLICATION_ID
147: where rowid = X_RowId;
148:
149: If (SQL%NOTFOUND) then

Line 251: NVL(work_class_id, FND_API.G_MISS_NUM),

247: ) IS
248: BEGIN
249:
250: SELECT
251: NVL(work_class_id, FND_API.G_MISS_NUM),
252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),

Line 252: NVL(level_of_experience, FND_API.G_MISS_CHAR),

248: BEGIN
249:
250: SELECT
251: NVL(work_class_id, FND_API.G_MISS_NUM),
252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),

Line 253: NVL(work_class_name, FND_API.G_MISS_CHAR),

249:
250: SELECT
251: NVL(work_class_id, FND_API.G_MISS_NUM),
252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),
257: NVL(created_by_module, FND_API.G_MISS_CHAR)

Line 254: NVL(employment_history_id, FND_API.G_MISS_NUM),

250: SELECT
251: NVL(work_class_id, FND_API.G_MISS_NUM),
252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),
257: NVL(created_by_module, FND_API.G_MISS_CHAR)
258: INTO

Line 255: NVL(status, FND_API.G_MISS_CHAR),

251: NVL(work_class_id, FND_API.G_MISS_NUM),
252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),
257: NVL(created_by_module, FND_API.G_MISS_CHAR)
258: INTO
259: x_work_class_id,

Line 256: NVL(application_id, FND_API.G_MISS_NUM),

252: NVL(level_of_experience, FND_API.G_MISS_CHAR),
253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),
257: NVL(created_by_module, FND_API.G_MISS_CHAR)
258: INTO
259: x_work_class_id,
260: x_level_of_experience,

Line 257: NVL(created_by_module, FND_API.G_MISS_CHAR)

253: NVL(work_class_name, FND_API.G_MISS_CHAR),
254: NVL(employment_history_id, FND_API.G_MISS_NUM),
255: NVL(status, FND_API.G_MISS_CHAR),
256: NVL(application_id, FND_API.G_MISS_NUM),
257: NVL(created_by_module, FND_API.G_MISS_CHAR)
258: INTO
259: x_work_class_id,
260: x_level_of_experience,
261: x_work_class_name,

Line 276: RAISE FND_API.G_EXC_ERROR;

272: --2890664, Changed this token
273: FND_MESSAGE.SET_TOKEN('RECORD', 'WORK_CLASS_REC');
274: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_work_class_id));
275: FND_MSG_PUB.ADD;
276: RAISE FND_API.G_EXC_ERROR;
277:
278: END Select_Row;
279:
280: END HZ_WORK_CLASS_PKG;