35:
36: l_effective_date date;
37: l_proc varchar2(72) := g_package||'create_assignment_details';
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint create_assignment_details;
45: -- Truncate the time portion from all IN date parameters
46: --
47: l_effective_date := trunc(p_effective_date);
48:
49: hr_utility.set_location(l_proc, 20);
50: --
51: -- Call Before Process User Hook
52: --
53: begin
62: (p_module_name => 'create_assignment_details'
63: ,p_hook_type => 'BP'
64: );
65: end;
66: hr_utility.set_location(l_proc, 30);
67: --
68: -- Validation in addition to Row Handlers
69: --
70:
83: ,p_effective_start_date => l_effective_start_date
84: ,p_effective_end_date => l_effective_end_date
85: ,p_object_version_number => l_object_version_number
86: );
87: hr_utility.set_location(' Leaving:'||l_proc, 50);
88: --
89: -- Call After Process User Hook
90: --
91: begin
123: p_effective_start_date := l_effective_start_date;
124: p_effective_end_date := l_effective_end_date;
125: p_object_version_number := l_object_version_number;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 70);
128: exception
129: when hr_api.validate_enabled then
130: --
131: -- As the Validate_Enabled exception has been raised
142: p_effective_start_date := null;
143: p_effective_end_date := null;
144: p_object_version_number := null;
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 80);
147: when others then
148: --
149: -- A validation or unexpected error has occured
150: --
158: p_effective_start_date := null;
159: p_effective_end_date := null;
160: p_object_version_number := null;
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 90);
163: raise;
164: end create_assignment_details;
165: --
166: -- ----------------------------------------------------------------------------
194:
195: l_effective_date date;
196: l_proc varchar2(72) := g_package||'update_assignment_details';
197: begin
198: hr_utility.set_location('Entering:'|| l_proc, 10);
199: --
200: -- Issue a savepoint
201: --
202: savepoint update_assignment_details;
207: --
208: l_assignment_details_id := p_assignment_details_id;
209: l_object_version_number := p_object_version_number;
210:
211: hr_utility.set_location(l_proc, 20);
212: --
213: -- Call Before Process User Hook
214: --
215: begin
229: (p_module_name => 'update_assignment_details'
230: ,p_hook_type => 'BP'
231: );
232: end;
233: hr_utility.set_location(l_proc, 30);
234: --
235: -- Validation in addition to Row Handlers
236: --
237:
251: ,p_effective_start_date => l_effective_start_date
252: ,p_effective_end_date => l_effective_end_date
253: ,p_object_version_number => l_object_version_number
254: );
255: hr_utility.set_location(' Leaving:'||l_proc, 50);
256: --
257: -- Call After Process User Hook
258: --
259: begin
292: p_details_version := l_details_version;
293: p_effective_start_date := l_effective_start_date;
294: p_effective_end_date := l_effective_end_date;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 70);
297: exception
298: when hr_api.validate_enabled then
299: --
300: -- As the Validate_Enabled exception has been raised
311: p_details_version := null;
312: p_effective_start_date := null;
313: p_effective_end_date := null;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 80);
316: when others then
317: --
318: -- A validation or unexpected error has occured
319: --
327: p_details_version := null;
328: p_effective_start_date := null;
329: p_effective_end_date := null;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 90);
332: raise;
333: end update_assignment_details;
334: --
335: end irc_assignment_details_api;