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.HR_ASSESSMENTS_SWI dependencies on HR_API

Line 49: ,p_validate in number default hr_api.g_false_num

45: ,p_attribute18 in varchar2 default null
46: ,p_attribute19 in varchar2 default null
47: ,p_attribute20 in varchar2 default null
48: ,p_object_version_number out nocopy number
49: ,p_validate in number default hr_api.g_false_num
50: ,p_effective_date in date
51: ,p_return_status out nocopy varchar2
52: ) is
53: --

Line 79: hr_api.constant_to_boolean

75: --
76: -- Convert constant values to their corresponding boolean value
77: --
78: l_validate :=
79: hr_api.constant_to_boolean
80: (p_constant_value => p_validate);
81: --
82: -- Register Surrogate ID or user key values
83: --

Line 184: (p_validate in number default hr_api.g_false_num

180: -- ----------------------------------------------------------------------------
181: -- |---------------------------< delete_assessment >--------------------------|
182: -- ----------------------------------------------------------------------------
183: PROCEDURE delete_assessment
184: (p_validate in number default hr_api.g_false_num
185: ,p_assessment_id in number
186: ,p_object_version_number in number
187: ,p_return_status out nocopy varchar2
188: ) is

Line 214: hr_api.constant_to_boolean

210: --
211: -- Convert constant values to their corresponding boolean value
212: --
213: l_validate :=
214: hr_api.constant_to_boolean
215: (p_constant_value => p_validate);
216: --
217: -- Register Surrogate ID or user key values
218: --

Line 279: ,p_assessment_type_id in number default hr_api.g_number

275: -- |---------------------------< update_assessment >--------------------------|
276: -- ----------------------------------------------------------------------------
277: PROCEDURE update_assessment
278: (p_assessment_id in number
279: ,p_assessment_type_id in number default hr_api.g_number
280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date

Line 280: ,p_assessment_group_id in number default hr_api.g_number

276: -- ----------------------------------------------------------------------------
277: PROCEDURE update_assessment
278: (p_assessment_id in number
279: ,p_assessment_type_id in number default hr_api.g_number
280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2

Line 281: ,p_assessment_period_start_date in date default hr_api.g_date

277: PROCEDURE update_assessment
278: (p_assessment_id in number
279: ,p_assessment_type_id in number default hr_api.g_number
280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number

Line 282: ,p_assessment_period_end_date in date default hr_api.g_date

278: (p_assessment_id in number
279: ,p_assessment_type_id in number default hr_api.g_number
280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2

Line 283: ,p_assessment_date in date default hr_api.g_date

279: ,p_assessment_type_id in number default hr_api.g_number
280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 284: ,p_comments in varchar2 default hr_api.g_varchar2

280: ,p_assessment_group_id in number default hr_api.g_number
281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 285: ,p_total_score in number default hr_api.g_number

281: ,p_assessment_period_start_date in date default hr_api.g_date
282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 286: ,p_status in varchar2 default hr_api.g_varchar2

282: ,p_assessment_period_end_date in date default hr_api.g_date
283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute_category in varchar2 default hr_api.g_varchar2

283: ,p_assessment_date in date default hr_api.g_date
284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute1 in varchar2 default hr_api.g_varchar2

284: ,p_comments in varchar2 default hr_api.g_varchar2
285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute2 in varchar2 default hr_api.g_varchar2

285: ,p_total_score in number default hr_api.g_number
286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute3 in varchar2 default hr_api.g_varchar2

286: ,p_status in varchar2 default hr_api.g_varchar2
287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute4 in varchar2 default hr_api.g_varchar2

287: ,p_attribute_category in varchar2 default hr_api.g_varchar2
288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute5 in varchar2 default hr_api.g_varchar2

288: ,p_attribute1 in varchar2 default hr_api.g_varchar2
289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute6 in varchar2 default hr_api.g_varchar2

289: ,p_attribute2 in varchar2 default hr_api.g_varchar2
290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute7 in varchar2 default hr_api.g_varchar2

290: ,p_attribute3 in varchar2 default hr_api.g_varchar2
291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute8 in varchar2 default hr_api.g_varchar2

291: ,p_attribute4 in varchar2 default hr_api.g_varchar2
292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute9 in varchar2 default hr_api.g_varchar2

292: ,p_attribute5 in varchar2 default hr_api.g_varchar2
293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute10 in varchar2 default hr_api.g_varchar2

293: ,p_attribute6 in varchar2 default hr_api.g_varchar2
294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute11 in varchar2 default hr_api.g_varchar2

294: ,p_attribute7 in varchar2 default hr_api.g_varchar2
295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute12 in varchar2 default hr_api.g_varchar2

295: ,p_attribute8 in varchar2 default hr_api.g_varchar2
296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute13 in varchar2 default hr_api.g_varchar2

296: ,p_attribute9 in varchar2 default hr_api.g_varchar2
297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute14 in varchar2 default hr_api.g_varchar2

297: ,p_attribute10 in varchar2 default hr_api.g_varchar2
298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute15 in varchar2 default hr_api.g_varchar2

298: ,p_attribute11 in varchar2 default hr_api.g_varchar2
299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute16 in varchar2 default hr_api.g_varchar2

299: ,p_attribute12 in varchar2 default hr_api.g_varchar2
300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute17 in varchar2 default hr_api.g_varchar2

300: ,p_attribute13 in varchar2 default hr_api.g_varchar2
301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2
308: ,p_object_version_number in out nocopy number

Line 305: ,p_attribute18 in varchar2 default hr_api.g_varchar2

301: ,p_attribute14 in varchar2 default hr_api.g_varchar2
302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2
308: ,p_object_version_number in out nocopy number
309: ,p_validate in number default hr_api.g_false_num

Line 306: ,p_attribute19 in varchar2 default hr_api.g_varchar2

302: ,p_attribute15 in varchar2 default hr_api.g_varchar2
303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2
308: ,p_object_version_number in out nocopy number
309: ,p_validate in number default hr_api.g_false_num
310: ,p_effective_date in date

Line 307: ,p_attribute20 in varchar2 default hr_api.g_varchar2

303: ,p_attribute16 in varchar2 default hr_api.g_varchar2
304: ,p_attribute17 in varchar2 default hr_api.g_varchar2
305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2
308: ,p_object_version_number in out nocopy number
309: ,p_validate in number default hr_api.g_false_num
310: ,p_effective_date in date
311: ,p_return_status out nocopy varchar2

Line 309: ,p_validate in number default hr_api.g_false_num

305: ,p_attribute18 in varchar2 default hr_api.g_varchar2
306: ,p_attribute19 in varchar2 default hr_api.g_varchar2
307: ,p_attribute20 in varchar2 default hr_api.g_varchar2
308: ,p_object_version_number in out nocopy number
309: ,p_validate in number default hr_api.g_false_num
310: ,p_effective_date in date
311: ,p_return_status out nocopy varchar2
312: ) is
313: --

Line 355: hr_api.constant_to_boolean

351: --
352: -- Convert constant values to their corresponding boolean value
353: --
354: l_validate :=
355: hr_api.constant_to_boolean
356: (p_constant_value => p_validate);
357: --
358: -- Register Surrogate ID or user key values
359: --

Line 455: ,p_validate in number default hr_api.g_false_num

451:
452: Procedure process_api
453: ( p_document in CLOB
454: ,p_return_status out nocopy VARCHAR2
455: ,p_validate in number default hr_api.g_false_num
456: ,p_effective_date in date default null
457: )
458: IS
459: l_postState VARCHAR2(2);