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_EMPLOYMENT_HISTORY_PKG dependencies on HZ_UTILITY_V2PUB

Line 90: HZ_UTILITY_V2PUB.CREATED_BY,

86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),

Line 91: HZ_UTILITY_V2PUB.CREATION_DATE,

87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

Line 93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 97: HZ_UTILITY_V2PUB.REQUEST_ID,

93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),

Line 98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 99: HZ_UTILITY_V2PUB.PROGRAM_ID,

95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),

Line 100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),

Line 105: HZ_UTILITY_V2PUB.APPLICATION_ID,

101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),

Line 231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE

Line 236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE
240:

Line 237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE
240:
241: where rowid = X_RowId;

Line 238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

234: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE
240:
241: where rowid = X_RowId;
242:

Line 239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE

235: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
236: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
237: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
238: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
239: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE
240:
241: where rowid = X_RowId;
242:
243: If (SQL%NOTFOUND) then