36: l_effective_date date;
37: l_proc varchar2(72) := g_package||'create_assignment_details';
38: l_considered varchar2(30);
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Issue a savepoint
43: --
44: savepoint create_assignment_details;
46: -- Truncate the time portion from all IN date parameters
47: --
48: l_effective_date := trunc(p_effective_date);
49:
50: hr_utility.set_location(l_proc, 20);
51: --
52: -- set the value of considered, if qualified is not null.
53: --
54: if ( p_qualified <> null ) then
71: (p_module_name => 'create_assignment_details'
72: ,p_hook_type => 'BP'
73: );
74: end;
75: hr_utility.set_location(l_proc, 30);
76: --
77: -- Validation in addition to Row Handlers
78: --
79:
92: ,p_effective_start_date => l_effective_start_date
93: ,p_effective_end_date => l_effective_end_date
94: ,p_object_version_number => l_object_version_number
95: );
96: hr_utility.set_location(' Leaving:'||l_proc, 50);
97: --
98: -- Call After Process User Hook
99: --
100: begin
132: p_effective_start_date := l_effective_start_date;
133: p_effective_end_date := l_effective_end_date;
134: p_object_version_number := l_object_version_number;
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 70);
137: exception
138: when hr_api.validate_enabled then
139: --
140: -- As the Validate_Enabled exception has been raised
151: p_effective_start_date := null;
152: p_effective_end_date := null;
153: p_object_version_number := null;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 80);
156: when others then
157: --
158: -- A validation or unexpected error has occured
159: --
167: p_effective_start_date := null;
168: p_effective_end_date := null;
169: p_object_version_number := null;
170: --
171: hr_utility.set_location(' Leaving:'||l_proc, 90);
172: raise;
173: end create_assignment_details;
174: --
175: -- ----------------------------------------------------------------------------
204: l_effective_date date;
205: l_proc varchar2(72) := g_package||'update_assignment_details';
206: l_considered varchar2(30);
207: begin
208: hr_utility.set_location('Entering:'|| l_proc, 10);
209: --
210: -- Issue a savepoint
211: --
212: savepoint update_assignment_details;
217: --
218: l_assignment_details_id := p_assignment_details_id;
219: l_object_version_number := p_object_version_number;
220:
221: hr_utility.set_location(l_proc, 20);
222: --
223: -- set the value of considered, if qualified is not null.
224: --
225: if ( p_qualified <> hr_api.g_varchar2 ) then
247: (p_module_name => 'update_assignment_details'
248: ,p_hook_type => 'BP'
249: );
250: end;
251: hr_utility.set_location(l_proc, 30);
252: --
253: -- Validation in addition to Row Handlers
254: --
255:
269: ,p_effective_start_date => l_effective_start_date
270: ,p_effective_end_date => l_effective_end_date
271: ,p_object_version_number => l_object_version_number
272: );
273: hr_utility.set_location(' Leaving:'||l_proc, 50);
274: --
275: -- Call After Process User Hook
276: --
277: begin
310: p_details_version := l_details_version;
311: p_effective_start_date := l_effective_start_date;
312: p_effective_end_date := l_effective_end_date;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 70);
315: exception
316: when hr_api.validate_enabled then
317: --
318: -- As the Validate_Enabled exception has been raised
329: p_details_version := null;
330: p_effective_start_date := null;
331: p_effective_end_date := null;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 80);
334: when others then
335: --
336: -- A validation or unexpected error has occured
337: --
345: p_details_version := null;
346: p_effective_start_date := null;
347: p_effective_end_date := null;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 90);
350: raise;
351: end update_assignment_details;
352: --
353: --
373: --
374: Cursor C_Sel1 is select irc_assignment_details_s.nextval from sys.dual;
375: --
376: begin
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378: --
379: -- Issue a savepoint
380: --
381: savepoint copy_assignment_details;
418: --
419: END LOOP;
420: --
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 20);
423: exception
424: when hr_api.validate_enabled then
425: --
426: -- As the Validate_Enabled exception has been raised
427: -- we must rollback to the savepoint
428: --
429: rollback to copy_assignment_details;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 30);
432: when others then
433: --
434: -- A validation or unexpected error has occured
435: --
434: -- A validation or unexpected error has occured
435: --
436: rollback to copy_assignment_details;
437: --
438: hr_utility.set_location(' Leaving:'||l_proc, 40);
439: raise;
440: end copy_assignment_details;
441: --
442: end irc_assignment_details_api;