26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;
27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
28: --
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: savepoint CREATE_SOLUTIONS_SELECTED;
33: --
34: -- Register user key values
91: -- Set all output arguments
92: --
93: p_object_version_number := l_object_version_number;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 70);
96: exception
97: when hr_api.validate_enabled then
98: --
99: -- As the Validate_Enabled exception has been raised
106: -- when validation only mode is being used.)
107: --
108: p_object_version_number := null;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 80);
111: when others then
112: --
113: -- A validation or unexpected error has occured
114: --
112: --
113: -- A validation or unexpected error has occured
114: --
115: rollback to CREATE_SOLUTIONS_SELECTED;
116: hr_utility.set_location(' Leaving:'||l_proc, 90);
117: raise;
118: end CREATE_SOLUTIONS_SELECTED;
119: --
120:
137: l_effective_date date;
138: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
139: --
140: begin
141: hr_utility.set_location('Entering:'|| l_proc, 10);
142: --
143: savepoint UPDATE_SOLUTIONS_SELECTED;
144: --
145: -- Store initial value for OVN in out parameter.
200: -- Set all output arguments
201: --
202: p_object_version_number := l_object_version_number;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 70);
205: exception
206: when hr_api.validate_enabled then
207: --
208: -- As the Validate_Enabled exception has been raised
213: -- Only set output warning arguments
214: -- (Any key or derived arguments must be set to null
215: -- when validation only mode is being used.)
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 80);
218: when others then
219: --
220: -- A validation or unexpected error has occured
221: --
219: --
220: -- A validation or unexpected error has occured
221: --
222: rollback to UPDATE_SOLUTIONS_SELECTED;
223: hr_utility.set_location(' Leaving:'||l_proc, 90);
224: raise;
225: end UPDATE_SOLUTIONS_SELECTED;
226:
227:
241: --
242: l_proc varchar2(72) := g_package||'DELETE_SOLUTIONS_SELECTED';
243: --
244: begin
245: hr_utility.set_location('Entering:'|| l_proc, 10);
246: --
247: savepoint DELETE_SOLUTIONS_SELECTED;
248: --
249: -- Call Before Process User Hook
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: exception
296: when hr_api.validate_enabled then
297: --
298: -- As the Validate_Enabled exception has been raised
299: -- we must rollback to the savepoint
300: --
301: rollback to DELETE_SOLUTIONS_SELECTED;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 80);
304: when others then
305: --
306: rollback to DELETE_SOLUTIONS_SELECTED;
307: --
304: when others then
305: --
306: rollback to DELETE_SOLUTIONS_SELECTED;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 90);
309: --
310: raise;
311: --
312: end DELETE_SOLUTIONS_SELECTED;