DBA Data[Home] [Help]

APPS.HR_ASSESSMENT_TYPES_API dependencies on HR_API

Line 123: when hr_api.cannot_find_prog_unit then

119: ,p_available_flag => p_available_flag
120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_assessment_type',
126: p_hook_type => 'BP'
127: );

Line 124: hr_api.cannot_find_prog_unit_error

120: ,p_effective_date => p_effective_date
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'create_assessment_type',
126: p_hook_type => 'BP'
127: );
128: end;

Line 237: when hr_api.cannot_find_prog_unit then

233: ,p_available_flag => p_available_flag
234: ,p_effective_date => p_effective_date
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'create_assessment_type',
240: p_hook_type => 'AP'
241: );

Line 238: hr_api.cannot_find_prog_unit_error

234: ,p_effective_date => p_effective_date
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'create_assessment_type',
240: p_hook_type => 'AP'
241: );
242: end;

Line 249: raise hr_api.validate_enabled;

245: --
246: -- When in validation only mode raise the Validate_Enabled exception
247: --
248: if p_validate then
249: raise hr_api.validate_enabled;
250: end if;
251: --
252: -- Set all output arguments
253: --

Line 259: when hr_api.validate_enabled then

255: p_object_version_number := l_object_version_number;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 11);
258: exception
259: when hr_api.validate_enabled then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --

Line 294: p_name in varchar2 default hr_api.g_varchar2,

290: -- ---------------------------------------------------------------------------
291: --
292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,

Line 295: p_description in varchar2 default hr_api.g_varchar2,

291: --
292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,

Line 296: p_rating_scale_id in number default hr_api.g_number,

292: procedure update_assessment_type
293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,

Line 297: p_weighting_scale_id in number default hr_api.g_number,

293: (p_assessment_type_id in number,
294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,

Line 298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,

294: p_name in varchar2 default hr_api.g_varchar2,
295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,

Line 299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,

295: p_description in varchar2 default hr_api.g_varchar2,
296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,

Line 300: p_assessment_classification in varchar2 default hr_api.g_varchar2,

296: p_rating_scale_id in number default hr_api.g_number,
297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,

Line 301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,

297: p_weighting_scale_id in number default hr_api.g_number,
298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,

Line 302: p_date_from in date default hr_api.g_date,

298: p_rating_scale_comment in varchar2 default hr_api.g_varchar2,
299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,

Line 303: p_date_to in date default hr_api.g_date,

299: p_weighting_scale_comment in varchar2 default hr_api.g_varchar2,
300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,

Line 304: p_comments in varchar2 default hr_api.g_varchar2,

300: p_assessment_classification in varchar2 default hr_api.g_varchar2,
301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,

Line 305: p_instructions in varchar2 default hr_api.g_varchar2,

301: p_display_assessment_comments in varchar2 default hr_api.g_varchar2,
302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,

Line 306: p_weighting_classification in varchar2 default hr_api.g_varchar2,

302: p_date_from in date default hr_api.g_date,
303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --

Line 307: p_line_score_formula in varchar2 default hr_api.g_varchar2,

303: p_date_to in date default hr_api.g_date,
304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 308: p_total_score_formula in varchar2 default hr_api.g_varchar2,

304: p_comments in varchar2 default hr_api.g_varchar2,
305: p_instructions in varchar2 default hr_api.g_varchar2,
306: p_weighting_classification in varchar2 default hr_api.g_varchar2,
307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 311: p_attribute_category in varchar2 default hr_api.g_varchar2,

307: p_line_score_formula in varchar2 default hr_api.g_varchar2,
308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 312: p_attribute1 in varchar2 default hr_api.g_varchar2,

308: p_total_score_formula in varchar2 default hr_api.g_varchar2,
309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 313: p_attribute2 in varchar2 default hr_api.g_varchar2,

309: p_object_version_number in out nocopy number,
310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 314: p_attribute3 in varchar2 default hr_api.g_varchar2,

310: --
311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 315: p_attribute4 in varchar2 default hr_api.g_varchar2,

311: p_attribute_category in varchar2 default hr_api.g_varchar2,
312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 316: p_attribute5 in varchar2 default hr_api.g_varchar2,

312: p_attribute1 in varchar2 default hr_api.g_varchar2,
313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 317: p_attribute6 in varchar2 default hr_api.g_varchar2,

313: p_attribute2 in varchar2 default hr_api.g_varchar2,
314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 318: p_attribute7 in varchar2 default hr_api.g_varchar2,

314: p_attribute3 in varchar2 default hr_api.g_varchar2,
315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 319: p_attribute8 in varchar2 default hr_api.g_varchar2,

315: p_attribute4 in varchar2 default hr_api.g_varchar2,
316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 320: p_attribute9 in varchar2 default hr_api.g_varchar2,

316: p_attribute5 in varchar2 default hr_api.g_varchar2,
317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 321: p_attribute10 in varchar2 default hr_api.g_varchar2,

317: p_attribute6 in varchar2 default hr_api.g_varchar2,
318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 322: p_attribute11 in varchar2 default hr_api.g_varchar2,

318: p_attribute7 in varchar2 default hr_api.g_varchar2,
319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 323: p_attribute12 in varchar2 default hr_api.g_varchar2,

319: p_attribute8 in varchar2 default hr_api.g_varchar2,
320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 324: p_attribute13 in varchar2 default hr_api.g_varchar2,

320: p_attribute9 in varchar2 default hr_api.g_varchar2,
321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 325: p_attribute14 in varchar2 default hr_api.g_varchar2,

321: p_attribute10 in varchar2 default hr_api.g_varchar2,
322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 326: p_attribute15 in varchar2 default hr_api.g_varchar2,

322: p_attribute11 in varchar2 default hr_api.g_varchar2,
323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 327: p_attribute16 in varchar2 default hr_api.g_varchar2,

323: p_attribute12 in varchar2 default hr_api.g_varchar2,
324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 328: p_attribute17 in varchar2 default hr_api.g_varchar2,

324: p_attribute13 in varchar2 default hr_api.g_varchar2,
325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,

Line 329: p_attribute18 in varchar2 default hr_api.g_varchar2,

325: p_attribute14 in varchar2 default hr_api.g_varchar2,
326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,

Line 330: p_attribute19 in varchar2 default hr_api.g_varchar2,

326: p_attribute15 in varchar2 default hr_api.g_varchar2,
327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,

Line 331: p_attribute20 in varchar2 default hr_api.g_varchar2,

327: p_attribute16 in varchar2 default hr_api.g_varchar2,
328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,

Line 332: p_type in varchar2 default hr_api.g_varchar2,

328: p_attribute17 in varchar2 default hr_api.g_varchar2,
329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,

Line 333: p_line_score_formula_id in number default hr_api.g_number,

329: p_attribute18 in varchar2 default hr_api.g_varchar2,
330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date

Line 334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,

330: p_attribute19 in varchar2 default hr_api.g_varchar2,
331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date
338: ) is

Line 335: p_available_flag in varchar2 default hr_api.g_varchar2,

331: p_attribute20 in varchar2 default hr_api.g_varchar2,
332: p_type in varchar2 default hr_api.g_varchar2,
333: p_line_score_formula_id in number default hr_api.g_number,
334: p_default_job_competencies in varchar2 default hr_api.g_varchar2,
335: p_available_flag in varchar2 default hr_api.g_varchar2,
336: p_validate in boolean default false,
337: p_effective_date in date
338: ) is
339: --

Line 403: when hr_api.cannot_find_prog_unit then

399: p_available_flag => p_available_flag,
400: p_effective_date => p_effective_date
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_assessment_type',
406: p_hook_type => 'BP'
407: );

Line 404: hr_api.cannot_find_prog_unit_error

400: p_effective_date => p_effective_date
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'update_assessment_type',
406: p_hook_type => 'BP'
407: );
408: end;

Line 518: when hr_api.cannot_find_prog_unit then

514: p_available_flag => p_available_flag,
515: p_effective_date => p_effective_date
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'update_assessment_type',
521: p_hook_type => 'AP'
522: );

Line 519: hr_api.cannot_find_prog_unit_error

515: p_effective_date => p_effective_date
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'update_assessment_type',
521: p_hook_type => 'AP'
522: );
523: end;

Line 530: raise hr_api.validate_enabled;

526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
530: raise hr_api.validate_enabled;
531: end if;
532: --
533: -- Set all output arguments. l_object_version_number now has the new
534: -- object version number as the update was successful

Line 540: when hr_api.validate_enabled then

536: p_object_version_number := l_object_version_number;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 11);
539: exception
540: when hr_api.validate_enabled then
541: --
542: -- As the Validate_Enabled exception has been raised
543: -- we must rollback to the savepoint
544: --

Line 602: when hr_api.cannot_find_prog_unit then

598: p_assessment_type_id => p_assessment_type_id
599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_assessment_type',
605: p_hook_type => 'BP'
606: );

Line 603: hr_api.cannot_find_prog_unit_error

599: ,p_object_version_number => p_object_version_number
600: );
601: exception
602: when hr_api.cannot_find_prog_unit then
603: hr_api.cannot_find_prog_unit_error
604: (p_module_name => 'delete_assessment_type',
605: p_hook_type => 'BP'
606: );
607: end;

Line 636: when hr_api.cannot_find_prog_unit then

632: p_assessment_type_id => p_assessment_type_id
633: ,p_object_version_number => p_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'delete_assessment_type',
639: p_hook_type => 'AP'
640: );

Line 637: hr_api.cannot_find_prog_unit_error

633: ,p_object_version_number => p_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'delete_assessment_type',
639: p_hook_type => 'AP'
640: );
641: end;

Line 648: raise hr_api.validate_enabled;

644: --
645: -- When in validation only mode raise the Validate_Enabled exception
646: --
647: if p_validate then
648: raise hr_api.validate_enabled;
649: end if;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 11);
652: exception

Line 653: when hr_api.validate_enabled then

649: end if;
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 11);
652: exception
653: when hr_api.validate_enabled then
654: --
655: -- As the Validate_Enabled exception has been raised
656: -- we must rollback to the savepoint
657: --