[Home] [Help]
62: l_atr_type varchar2(20);
63: l_return_value boolean;
64: --
65: begin
66: hr_utility.set_location('Entering:'|| l_func, 10);
67: l_return_value := false;
68: if(p_condition_id is null) then
69: hr_utility.set_location('Leaving:'|| l_func, 20);
70: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
65: begin
66: hr_utility.set_location('Entering:'|| l_func, 10);
67: l_return_value := false;
68: if(p_condition_id is null) then
69: hr_utility.set_location('Leaving:'|| l_func, 20);
70: fnd_message.set_name('PER','AME_400494_INVALID_CONDITION');
71: fnd_message.raise_error;
72: else
73: open csr_atr_type;
76: l_return_value := true;
77: end if;
78: close csr_atr_type;
79: end if;
80: hr_utility.set_location('Leaving:'|| l_func, 30);
81: return l_return_value;
82: end is_string_condition;
83: --
84: -- ----------------------------------------------------------------------------
119: l_end_date_chd date;
120: l_isStringCondition boolean;
121: --
122: begin
123: hr_utility.set_location('Entering:'|| l_proc, 10);
124: --
125: -- Issue a savepoint
126: --
127: savepoint create_ame_condition;
252: p_stv_object_version_number := l_object_version_number_chd;
253: p_stv_start_date := l_start_date_chd;
254: p_stv_end_date := l_end_date_chd;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: exception
258: when hr_api.validate_enabled then
259: --
260: -- As the Validate_Enabled exception has been raised
273: p_stv_start_date := null;
274: p_stv_end_date := null;
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 80);
278: when others then
279: --
280: -- A validation or unexpected error has occured
281: --
291: p_stv_object_version_number := null;
292: p_stv_start_date := null;
293: p_stv_end_date := null;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 90);
296: raise;
297: end create_ame_condition;
298: --
299: --
326: l_end_date_chd date;
327: l_string_value varchar2(4000);
328: --
329: begin
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Issue a savepoint
333: --
334: savepoint update_ame_condition;
405: --
406: p_start_date := l_start_date;
407: p_end_date := l_end_date;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
422: p_object_version_number := l_object_version_number;
423: p_start_date := null;
424: p_end_date := null;
425: --
426: hr_utility.set_location(' Leaving:'||l_proc, 80);
427: when others then
428: --
429: -- A validation or unexpected error has occured
430: --
436: p_object_version_number := l_object_version_number;
437: p_start_date := null;
438: p_end_date := null;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 90);
441: raise;
442: end update_ame_condition;
443: --
444: --
499: l_string_value_tab ame_util.longestStringList;
500: l_object_version_number_tab ame_util.idList;
501: --
502: begin
503: hr_utility.set_location('Entering:'|| l_proc, 10);
504: --
505: -- Issue a savepoint
506: --
507: savepoint delete_ame_condition;
597: p_start_date := l_start_date;
598: p_end_date := l_end_date;
599: --
600: end if;
601: hr_utility.set_location(' Leaving:'||l_proc, 70);
602: exception
603: when hr_api.validate_enabled then
604: --
605: -- As the Validate_Enabled exception has been raised
614: p_object_version_number := l_object_version_number;
615: p_start_date := null;
616: p_end_date := null;
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 80);
619: when others then
620: --
621: -- A validation or unexpected error has occured
622: --
628: p_object_version_number := l_object_version_number;
629: p_start_date := null;
630: p_end_date := null;
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 90);
633: raise;
634: end delete_ame_condition;
635: --
636: -- ----------------------------------------------------------------------------
653: l_start_date date;
654: l_end_date date;
655: --
656: begin
657: hr_utility.set_location('Entering:'|| l_proc, 10);
658: --
659: -- Issue a savepoint
660: --
661: savepoint create_ame_string_value;
717: p_object_version_number := l_object_version_number;
718: p_start_date := l_start_date;
719: p_end_date := l_end_date;
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 70);
722: exception
723: when hr_api.validate_enabled then
724: --
725: -- As the Validate_Enabled exception has been raised
734: p_object_version_number := null;
735: p_start_date := null;
736: p_end_date := null;
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 80);
739: when others then
740: --
741: -- A validation or unexpected error has occured
742: --
748: p_object_version_number := null;
749: p_start_date := null;
750: p_end_date := null;
751: --
752: hr_utility.set_location(' Leaving:'||l_proc, 90);
753: raise;
754: end create_ame_string_value;
755: --
756: --
774: l_start_date date;
775: l_end_date date;
776: --
777: begin
778: hr_utility.set_location('Entering:'|| l_proc, 10);
779: --
780: -- Issue a savepoint
781: --
782: savepoint delete_ame_string_value;
840: --
841: p_start_date := l_start_date;
842: p_end_date := l_end_date;
843: --
844: hr_utility.set_location(' Leaving:'||l_proc, 70);
845: exception
846: when hr_api.validate_enabled then
847: --
848: -- As the Validate_Enabled exception has been raised
857: p_object_version_number := l_object_version_number;
858: p_start_date := null;
859: p_end_date := null;
860: --
861: hr_utility.set_location(' Leaving:'||l_proc, 80);
862: when others then
863: --
864: -- A validation or unexpected error has occured
865: --
871: p_object_version_number := l_object_version_number;
872: p_start_date := null;
873: p_end_date := null;
874: --
875: hr_utility.set_location(' Leaving:'||l_proc, 90);
876: raise;
877: end delete_ame_string_value;
878: end AME_CONDITION_API;