[Home] [Help]
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: --
85: per_res_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: --
85: per_res_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: --
90: per_res_shd.constraint_error
83: -- A check constraint has been violated
84: --
85: per_res_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: --
90: per_res_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.parent_integrity_violated Then
88: -- Parent integrity has been violated
89: --
90: per_res_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: --
95: per_res_shd.constraint_error
88: -- Parent integrity has been violated
89: --
90: per_res_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: --
95: per_res_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: --
95: per_res_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When Others Then
98: --
99: Raise;
100: End update_dml;
261: null;
262: --
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'PER_CAGR_ENTITLEMENT_RESULTS'
269: ,p_hook_type => 'AU');
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'PER_CAGR_ENTITLEMENT_RESULTS'
269: ,p_hook_type => 'AU');
270: --
271: end;
327: -- p_rec plsql record structure
328: -- to see if a system default is being used. If a system default
329: -- is being used then we must set to the 'current' argument value.
330: --
331: If (p_rec.assignment_id = hr_api.g_number) then
332: p_rec.assignment_id :=
333: per_res_shd.g_old_rec.assignment_id;
334: End If;
335: If (p_rec.start_date = hr_api.g_date) then
331: If (p_rec.assignment_id = hr_api.g_number) then
332: p_rec.assignment_id :=
333: per_res_shd.g_old_rec.assignment_id;
334: End If;
335: If (p_rec.start_date = hr_api.g_date) then
336: p_rec.start_date :=
337: per_res_shd.g_old_rec.start_date;
338: End If;
339: If (p_rec.end_date = hr_api.g_date) then
335: If (p_rec.start_date = hr_api.g_date) then
336: p_rec.start_date :=
337: per_res_shd.g_old_rec.start_date;
338: End If;
339: If (p_rec.end_date = hr_api.g_date) then
340: p_rec.end_date :=
341: per_res_shd.g_old_rec.end_date;
342: End If;
343: If (p_rec.collective_agreement_id = hr_api.g_number) then
339: If (p_rec.end_date = hr_api.g_date) then
340: p_rec.end_date :=
341: per_res_shd.g_old_rec.end_date;
342: End If;
343: If (p_rec.collective_agreement_id = hr_api.g_number) then
344: p_rec.collective_agreement_id :=
345: per_res_shd.g_old_rec.collective_agreement_id;
346: End If;
347: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then
343: If (p_rec.collective_agreement_id = hr_api.g_number) then
344: p_rec.collective_agreement_id :=
345: per_res_shd.g_old_rec.collective_agreement_id;
346: End If;
347: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then
348: p_rec.cagr_entitlement_item_id :=
349: per_res_shd.g_old_rec.cagr_entitlement_item_id;
350: End If;
351: If (p_rec.element_type_id = hr_api.g_number) then
347: If (p_rec.cagr_entitlement_item_id = hr_api.g_number) then
348: p_rec.cagr_entitlement_item_id :=
349: per_res_shd.g_old_rec.cagr_entitlement_item_id;
350: End If;
351: If (p_rec.element_type_id = hr_api.g_number) then
352: p_rec.element_type_id :=
353: per_res_shd.g_old_rec.element_type_id;
354: End If;
355: If (p_rec.input_value_id = hr_api.g_number) then
351: If (p_rec.element_type_id = hr_api.g_number) then
352: p_rec.element_type_id :=
353: per_res_shd.g_old_rec.element_type_id;
354: End If;
355: If (p_rec.input_value_id = hr_api.g_number) then
356: p_rec.input_value_id :=
357: per_res_shd.g_old_rec.input_value_id;
358: End If;
359: If (p_rec.cagr_api_id = hr_api.g_number) then
355: If (p_rec.input_value_id = hr_api.g_number) then
356: p_rec.input_value_id :=
357: per_res_shd.g_old_rec.input_value_id;
358: End If;
359: If (p_rec.cagr_api_id = hr_api.g_number) then
360: p_rec.cagr_api_id :=
361: per_res_shd.g_old_rec.cagr_api_id;
362: End If;
363: If (p_rec.cagr_api_param_id = hr_api.g_number) then
359: If (p_rec.cagr_api_id = hr_api.g_number) then
360: p_rec.cagr_api_id :=
361: per_res_shd.g_old_rec.cagr_api_id;
362: End If;
363: If (p_rec.cagr_api_param_id = hr_api.g_number) then
364: p_rec.cagr_api_param_id :=
365: per_res_shd.g_old_rec.cagr_api_param_id;
366: End If;
367: If (p_rec.category_name = hr_api.g_varchar2) then
363: If (p_rec.cagr_api_param_id = hr_api.g_number) then
364: p_rec.cagr_api_param_id :=
365: per_res_shd.g_old_rec.cagr_api_param_id;
366: End If;
367: If (p_rec.category_name = hr_api.g_varchar2) then
368: p_rec.category_name :=
369: per_res_shd.g_old_rec.category_name;
370: End If;
371: If (p_rec.cagr_entitlement_id = hr_api.g_number) then
367: If (p_rec.category_name = hr_api.g_varchar2) then
368: p_rec.category_name :=
369: per_res_shd.g_old_rec.category_name;
370: End If;
371: If (p_rec.cagr_entitlement_id = hr_api.g_number) then
372: p_rec.cagr_entitlement_id :=
373: per_res_shd.g_old_rec.cagr_entitlement_id;
374: End If;
375: If (p_rec.cagr_entitlement_line_id = hr_api.g_number) then
371: If (p_rec.cagr_entitlement_id = hr_api.g_number) then
372: p_rec.cagr_entitlement_id :=
373: per_res_shd.g_old_rec.cagr_entitlement_id;
374: End If;
375: If (p_rec.cagr_entitlement_line_id = hr_api.g_number) then
376: p_rec.cagr_entitlement_line_id :=
377: per_res_shd.g_old_rec.cagr_entitlement_line_id;
378: End If;
379: If (p_rec.value = hr_api.g_varchar2) then
375: If (p_rec.cagr_entitlement_line_id = hr_api.g_number) then
376: p_rec.cagr_entitlement_line_id :=
377: per_res_shd.g_old_rec.cagr_entitlement_line_id;
378: End If;
379: If (p_rec.value = hr_api.g_varchar2) then
380: p_rec.value :=
381: per_res_shd.g_old_rec.value;
382: End If;
383: If (p_rec.units_of_measure = hr_api.g_varchar2) then
379: If (p_rec.value = hr_api.g_varchar2) then
380: p_rec.value :=
381: per_res_shd.g_old_rec.value;
382: End If;
383: If (p_rec.units_of_measure = hr_api.g_varchar2) then
384: p_rec.units_of_measure :=
385: per_res_shd.g_old_rec.units_of_measure;
386: End If;
387: If (p_rec.range_from = hr_api.g_varchar2) then
383: If (p_rec.units_of_measure = hr_api.g_varchar2) then
384: p_rec.units_of_measure :=
385: per_res_shd.g_old_rec.units_of_measure;
386: End If;
387: If (p_rec.range_from = hr_api.g_varchar2) then
388: p_rec.range_from :=
389: per_res_shd.g_old_rec.range_from;
390: End If;
391: If (p_rec.range_to = hr_api.g_varchar2) then
387: If (p_rec.range_from = hr_api.g_varchar2) then
388: p_rec.range_from :=
389: per_res_shd.g_old_rec.range_from;
390: End If;
391: If (p_rec.range_to = hr_api.g_varchar2) then
392: p_rec.range_to :=
393: per_res_shd.g_old_rec.range_to;
394: End If;
395: If (p_rec.grade_spine_id = hr_api.g_number) then
391: If (p_rec.range_to = hr_api.g_varchar2) then
392: p_rec.range_to :=
393: per_res_shd.g_old_rec.range_to;
394: End If;
395: If (p_rec.grade_spine_id = hr_api.g_number) then
396: p_rec.grade_spine_id :=
397: per_res_shd.g_old_rec.grade_spine_id;
398: End If;
399: If (p_rec.parent_spine_id = hr_api.g_number) then
395: If (p_rec.grade_spine_id = hr_api.g_number) then
396: p_rec.grade_spine_id :=
397: per_res_shd.g_old_rec.grade_spine_id;
398: End If;
399: If (p_rec.parent_spine_id = hr_api.g_number) then
400: p_rec.parent_spine_id :=
401: per_res_shd.g_old_rec.parent_spine_id;
402: End If;
403: If (p_rec.step_id = hr_api.g_number) then
399: If (p_rec.parent_spine_id = hr_api.g_number) then
400: p_rec.parent_spine_id :=
401: per_res_shd.g_old_rec.parent_spine_id;
402: End If;
403: If (p_rec.step_id = hr_api.g_number) then
404: p_rec.step_id :=
405: per_res_shd.g_old_rec.step_id;
406: End If;
407: If (p_rec.from_step_id = hr_api.g_number) then
403: If (p_rec.step_id = hr_api.g_number) then
404: p_rec.step_id :=
405: per_res_shd.g_old_rec.step_id;
406: End If;
407: If (p_rec.from_step_id = hr_api.g_number) then
408: p_rec.from_step_id :=
409: per_res_shd.g_old_rec.from_step_id;
410: End If;
411: If (p_rec.to_step_id = hr_api.g_number) then
407: If (p_rec.from_step_id = hr_api.g_number) then
408: p_rec.from_step_id :=
409: per_res_shd.g_old_rec.from_step_id;
410: End If;
411: If (p_rec.to_step_id = hr_api.g_number) then
412: p_rec.to_step_id :=
413: per_res_shd.g_old_rec.to_step_id;
414: End If;
415: If (p_rec.beneficial_flag = hr_api.g_varchar2) then
411: If (p_rec.to_step_id = hr_api.g_number) then
412: p_rec.to_step_id :=
413: per_res_shd.g_old_rec.to_step_id;
414: End If;
415: If (p_rec.beneficial_flag = hr_api.g_varchar2) then
416: p_rec.beneficial_flag :=
417: per_res_shd.g_old_rec.beneficial_flag;
418: End If;
419: If (p_rec.oipl_id = hr_api.g_number) then
415: If (p_rec.beneficial_flag = hr_api.g_varchar2) then
416: p_rec.beneficial_flag :=
417: per_res_shd.g_old_rec.beneficial_flag;
418: End If;
419: If (p_rec.oipl_id = hr_api.g_number) then
420: p_rec.oipl_id :=
421: per_res_shd.g_old_rec.oipl_id;
422: End If;
423: If (p_rec.chosen_flag = hr_api.g_varchar2) then
419: If (p_rec.oipl_id = hr_api.g_number) then
420: p_rec.oipl_id :=
421: per_res_shd.g_old_rec.oipl_id;
422: End If;
423: If (p_rec.chosen_flag = hr_api.g_varchar2) then
424: p_rec.chosen_flag :=
425: per_res_shd.g_old_rec.chosen_flag;
426: End If;
427: If (p_rec.column_type = hr_api.g_varchar2) then
423: If (p_rec.chosen_flag = hr_api.g_varchar2) then
424: p_rec.chosen_flag :=
425: per_res_shd.g_old_rec.chosen_flag;
426: End If;
427: If (p_rec.column_type = hr_api.g_varchar2) then
428: p_rec.column_type :=
429: per_res_shd.g_old_rec.column_type;
430: End If;
431: If (p_rec.column_size = hr_api.g_number) then
427: If (p_rec.column_type = hr_api.g_varchar2) then
428: p_rec.column_type :=
429: per_res_shd.g_old_rec.column_type;
430: End If;
431: If (p_rec.column_size = hr_api.g_number) then
432: p_rec.column_size :=
433: per_res_shd.g_old_rec.column_size;
434: End If;
435: If (p_rec.business_group_id = hr_api.g_number) then
431: If (p_rec.column_size = hr_api.g_number) then
432: p_rec.column_size :=
433: per_res_shd.g_old_rec.column_size;
434: End If;
435: If (p_rec.business_group_id = hr_api.g_number) then
436: p_rec.business_group_id :=
437: per_res_shd.g_old_rec.business_group_id;
438: End If;
439: If (p_rec.legislation_code = hr_api.g_varchar2) then
435: If (p_rec.business_group_id = hr_api.g_number) then
436: p_rec.business_group_id :=
437: per_res_shd.g_old_rec.business_group_id;
438: End If;
439: If (p_rec.legislation_code = hr_api.g_varchar2) then
440: p_rec.legislation_code :=
441: per_res_shd.g_old_rec.legislation_code;
442: End If;
443: If (p_rec.eligy_prfl_id = hr_api.g_number) then
439: If (p_rec.legislation_code = hr_api.g_varchar2) then
440: p_rec.legislation_code :=
441: per_res_shd.g_old_rec.legislation_code;
442: End If;
443: If (p_rec.eligy_prfl_id = hr_api.g_number) then
444: p_rec.eligy_prfl_id :=
445: per_res_shd.g_old_rec.eligy_prfl_id;
446: End If;
447: If (p_rec.formula_id = hr_api.g_number) then
443: If (p_rec.eligy_prfl_id = hr_api.g_number) then
444: p_rec.eligy_prfl_id :=
445: per_res_shd.g_old_rec.eligy_prfl_id;
446: End If;
447: If (p_rec.formula_id = hr_api.g_number) then
448: p_rec.formula_id :=
449: per_res_shd.g_old_rec.formula_id;
450: End If;
451: --
505: Procedure upd
506: (p_effective_date in date
507: ,p_cagr_entitlement_result_id in number
508: ,p_object_version_number in out nocopy number
509: ,p_chosen_flag in varchar2 default hr_api.g_varchar2
510: ) is
511: --
512: l_rec per_res_shd.g_rec_type;
513: l_proc varchar2(72) := g_package||'upd';
520: --
521: l_rec :=
522: per_res_shd.convert_args
523: (p_cagr_entitlement_result_id
524: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
521: l_rec :=
522: per_res_shd.convert_args
523: (p_cagr_entitlement_result_id
524: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
522: per_res_shd.convert_args
523: (p_cagr_entitlement_result_id
524: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
523: (p_cagr_entitlement_result_id
524: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
524: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
525: ,hr_api.g_date
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
526: ,hr_api.g_date
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
527: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
528: ,hr_api.g_number
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
529: ,hr_api.g_number
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
530: ,hr_api.g_number
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
531: ,hr_api.g_number
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
532: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
533: ,hr_api.g_varchar2
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
534: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
535: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
536: ,hr_api.g_varchar2
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
537: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
538: ,hr_api.g_varchar2
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
539: ,hr_api.g_varchar2
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
540: ,hr_api.g_number
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
541: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
542: ,hr_api.g_number
543: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
544: ,hr_api.g_number
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
545: ,hr_api.g_varchar2
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
546: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
554: ,hr_api.g_number
547: ,p_chosen_flag -- this and ovn are only attributes that can be updated
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
554: ,hr_api.g_number
555: ,p_object_version_number
548: ,hr_api.g_varchar2
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
554: ,hr_api.g_number
555: ,p_object_version_number
556: );
549: ,hr_api.g_number
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
554: ,hr_api.g_number
555: ,p_object_version_number
556: );
557: --
550: ,hr_api.g_number
551: ,hr_api.g_number
552: ,hr_api.g_varchar2
553: ,hr_api.g_number
554: ,hr_api.g_number
555: ,p_object_version_number
556: );
557: --
558: -- Having converted the arguments into the