[Home] [Help]
54: and column_name = p_column_name
55: and qualifier_name = p_qualifier_name;
56:
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_event_qualifier;
63: --
64: -- Truncate the time portion from all IN date parameters
65: --
66: l_effective_date := trunc(p_effective_date);
67: hr_utility.set_location(l_proc, 20);
68:
69:
70: --------------------------------------------------------
71: -- Check for unique qualifier name,table_id,column_name
113: ,p_hook_type => 'BP'
114: );
115: end;
116:
117: hr_utility.set_location(l_proc, 30);
118: --
119: -- Validation in addition to Row Handlers
120: --
121: hr_utility.set_location(l_proc, 40);
117: hr_utility.set_location(l_proc, 30);
118: --
119: -- Validation in addition to Row Handlers
120: --
121: hr_utility.set_location(l_proc, 40);
122:
123:
124: --
125: -- Process Logic
145: ,p_effective_start_date => l_effective_start_date
146: ,p_effective_end_date => l_effective_end_date
147: );
148: --
149: hr_utility.set_location(l_proc, 50);
150:
151: --
152: -- Call After Process User Hook
153: --
179: end;
180:
181: END IF; -- Only done insert and hooks if %notfound
182: close csr_valid_name;
183: hr_utility.set_location(l_proc, 60);
184:
185: --
186: -- When in validation only mode raise the Validate_Enabled exception
187: --
195: p_effective_start_date := l_effective_start_date;
196: p_effective_end_date := l_effective_end_date;
197: p_object_version_number := l_object_version_number;
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 70);
200: exception
201: when hr_api.validate_enabled then
202: --
203: -- As the Validate_Enabled exception has been raised
212: p_event_qualifier_id := null;
213: p_effective_start_date := null;
214: p_effective_end_date := null;
215: p_object_version_number := null;
216: hr_utility.set_location(' Leaving:'||l_proc, 80);
217: when others then
218: --
219: -- A validation or unexpected error has occured
220: --
222: p_event_qualifier_id := null;
223: p_effective_start_date := null;
224: p_effective_end_date := null;
225: p_object_version_number := null;
226: hr_utility.set_location(' Leaving:'||l_proc, 90);
227: raise;
228: end create_event_qualifier;
229: --
230:
269: --
270: l_object_version_number pay_event_qualifiers_f.object_version_number%TYPE;
271: --
272: begin
273: hr_utility.set_location('Entering:'|| l_proc, 10);
274: --
275: -- Issue a savepoint and assign in-out parameters to local variable
276: --
277:
281: --
282: -- Truncate the time portion from all IN date parameters
283: --
284: l_effective_date := trunc(p_effective_date);
285: hr_utility.set_location(l_proc, 20);
286: --
287: -- Call Before Process User Hook
288: --
289: begin
310: (p_module_name => 'update_event_qualifier'
311: ,p_hook_type => 'BP'
312: );
313: end;
314: hr_utility.set_location(l_proc, 30);
315: --
316: -- Validation in addition to Row Handlers
317: --
318: hr_utility.set_location(l_proc, 40);
314: hr_utility.set_location(l_proc, 30);
315: --
316: -- Validation in addition to Row Handlers
317: --
318: hr_utility.set_location(l_proc, 40);
319: --
320: -- Process Logic
321: --
322: -- Call the row handler
337: );
338: --
339:
340: --
341: hr_utility.set_location(l_proc, 50);
342: --
343: -- Call After Process User Hook
344: --
345: begin
368: (p_module_name => 'update_event_qualifier_a'
369: ,p_hook_type => 'AP'
370: );
371: end;
372: hr_utility.set_location(l_proc, 60);
373: --
374: -- When in validation only mode raise the Validate_Enabled exception
375: --
376: if p_validate then
382: p_effective_start_date := l_effective_start_date;
383: p_effective_end_date := l_effective_end_date;
384: p_object_version_number := p_object_version_number;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: exception
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised
398: --
399: p_object_version_number := l_object_version_number;
400: p_effective_start_date := null;
401: p_effective_end_date := null;
402: hr_utility.set_location(' Leaving:'||l_proc, 80);
403: when others then
404: --
405: -- A validation or unexpected error has occured
406: --
407: rollback to update_event_qualifier;
408: p_object_version_number := l_object_version_number;
409: p_effective_start_date := null;
410: p_effective_end_date := null;
411: hr_utility.set_location(' Leaving:'||l_proc, 90);
412: raise;
413: end update_event_qualifier;
414:
415:
442: l_validation_end_date date;
443: l_object_version_number pay_event_qualifiers_f.object_version_number%type;
444: --
445: begin
446: hr_utility.set_location('Entering:'|| l_proc, 5);
447: --
448: -- Issue a savepoint and assign in-out parameters to local variable
449: --
450: savepoint delete_event_qualifier;
449: --
450: savepoint delete_event_qualifier;
451: l_object_version_number := p_object_version_number;
452: --
453: hr_utility.set_location(l_proc, 10);
454: --
455: l_effective_date := trunc(p_effective_date);
456: --
457: -- Call Before Process User Hook
473: ,p_hook_type => 'BP'
474: );
475: end;
476: --
477: hr_utility.set_location(l_proc, 20);
478: --
479: -- Validation in addition to Row Handlers
480: --
481: hr_utility.set_location(l_proc, 30);
477: hr_utility.set_location(l_proc, 20);
478: --
479: -- Validation in addition to Row Handlers
480: --
481: hr_utility.set_location(l_proc, 30);
482: --
483: -- Lock the non-translated table row handler for ZAP datetrack delete mode
484: --
485: if p_datetrack_delete_mode = hr_api.g_zap then
504: ,p_effective_start_date => l_effective_start_date
505: ,p_effective_end_date => l_effective_end_date
506: );
507: --
508: hr_utility.set_location(l_proc, 50);
509: --
510: -- Call After Process User Hook
511: --
512: begin
521: ,p_effective_end_date => l_effective_end_date
522: );
523: --
524: end;
525: hr_utility.set_location(l_proc, 60);
526: --
527: -- When in validation only mode raise the Validate_Enabled exception
528: --
529: if p_validate then
535: p_object_version_number := p_object_version_number;
536: p_effective_start_date := l_effective_start_date;
537: p_effective_end_date := l_effective_end_date;
538: --
539: hr_utility.set_location(l_proc, 70);
540: exception
541: when hr_api.validate_enabled then
542: --
543: -- As the Validate_Enabled exception has been raised
560: ROLLBACK TO delete_event_qualifier;
561: p_object_version_number := l_object_version_number;
562: p_effective_start_date := null;
563: p_effective_end_date := null;
564: hr_utility.set_location(' Leaving:'||l_proc, 80);
565: raise;
566: --
567: end delete_event_qualifier;
568: -- ----------------------------------------------------------------------------