90: ,p_attribute20 => p_attribute20
91: ,p_effective_date => trunc(p_effective_date)
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_CAGR_GRADE_STRUCTURES'
98: ,p_hook_type => 'BP'
91: ,p_effective_date => trunc(p_effective_date)
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_CAGR_GRADE_STRUCTURES'
98: ,p_hook_type => 'BP'
99: );
167: ,p_attribute20 => p_attribute20
168: ,p_effective_date => trunc(p_effective_date)
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CAGR_GRADE_SRUCTURE'
174: ,p_hook_type => 'AP'
175: );
168: ,p_effective_date => trunc(p_effective_date)
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_CAGR_GRADE_SRUCTURE'
174: ,p_hook_type => 'AP'
175: );
176: --
182: --
183: -- When in validation only mode raise the Validate_Enabled exception
184: --
185: if p_validate then
186: raise hr_api.validate_enabled;
187: end if;
188: --
189: -- Set all output arguments
190: --
194: hr_utility.set_location(' Leaving:'||l_proc, 70);
195: --
196: exception
197: --
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised
201: -- we must rollback to the savepoint
202: --
230: procedure update_cagr_grade_structures
231: (p_validate in boolean default false
232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
231: (p_validate in boolean default false
232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
232: ,p_cagr_grade_structure_id in number
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
233: ,p_object_version_number in out nocopy number
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
234: ,p_dynamic_insert_allowed in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
235: ,p_attribute_category in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
236: ,p_attribute1 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
237: ,p_attribute2 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
238: ,p_attribute3 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
239: ,p_attribute4 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
240: ,p_attribute5 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
241: ,p_attribute6 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
242: ,p_attribute7 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
243: ,p_attribute8 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
244: ,p_attribute9 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
245: ,p_attribute10 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
246: ,p_attribute11 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
247: ,p_attribute12 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
248: ,p_attribute13 in varchar2 default hr_api.g_varchar2
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
249: ,p_attribute14 in varchar2 default hr_api.g_varchar2
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is
250: ,p_attribute15 in varchar2 default hr_api.g_varchar2
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is
258: --
251: ,p_attribute16 in varchar2 default hr_api.g_varchar2
252: ,p_attribute17 in varchar2 default hr_api.g_varchar2
253: ,p_attribute18 in varchar2 default hr_api.g_varchar2
254: ,p_attribute19 in varchar2 default hr_api.g_varchar2
255: ,p_attribute20 in varchar2 default hr_api.g_varchar2
256: ,p_effective_date in date
257: ) is
258: --
259: -- Declare cursors and local variables
308: ,p_attribute20 => p_attribute20
309: ,p_effective_date => trunc(p_effective_date)
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
315: ,p_hook_type => 'BP'
316: );
309: ,p_effective_date => trunc(p_effective_date)
310: );
311: exception
312: when hr_api.cannot_find_prog_unit then
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
315: ,p_hook_type => 'BP'
316: );
317: --
380: ,p_attribute20 => p_attribute20
381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
387: ,p_hook_type => 'AP'
388: );
381: ,p_effective_date => trunc(p_effective_date)
382: );
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'UPDATE_CAGR_GRADE_STRUCTURES'
387: ,p_hook_type => 'AP'
388: );
389: --
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then
399: raise hr_api.validate_enabled;
400: end if;
401: --
402: -- Set all output arguments
403: --
406: hr_utility.set_location(' Leaving:'||l_proc, 70);
407: --
408: exception
409: --
410: when hr_api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --
474: ,p_object_version_number => p_object_version_number
475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'DELETE_CAGR_GRADES_STRUCTURES'
481: ,p_hook_type => 'BP'
482: );
475: ,p_effective_date => trunc(p_effective_date)
476: );
477: exception
478: when hr_api.cannot_find_prog_unit then
479: hr_api.cannot_find_prog_unit_error
480: (p_module_name => 'DELETE_CAGR_GRADES_STRUCTURES'
481: ,p_hook_type => 'BP'
482: );
483: --
502: ,p_object_version_number => l_object_version_number
503: ,p_effective_date => trunc(p_effective_date)
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_CAGR_GRADE_STRUCTURES'
509: ,p_hook_type => 'AP'
510: );
503: ,p_effective_date => trunc(p_effective_date)
504: );
505: exception
506: when hr_api.cannot_find_prog_unit then
507: hr_api.cannot_find_prog_unit_error
508: (p_module_name => 'DELETE_CAGR_GRADE_STRUCTURES'
509: ,p_hook_type => 'AP'
510: );
511: --
517: --
518: -- When in validation only mode raise the Validate_Enabled exception
519: --
520: if p_validate then
521: raise hr_api.validate_enabled;
522: end if;
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 70);
525: --
524: hr_utility.set_location(' Leaving:'||l_proc, 70);
525: --
526: exception
527: --
528: when hr_api.validate_enabled then
529: --
530: -- As the Validate_Enabled exception has been raised
531: -- we must rollback to the savepoint
532: --