[Home] [Help]
38: and p_effective_date between effective_start_date and effective_end_date;
39: --
40: begin
41: l_proc := g_package||'create_dummy_rec';
42: hr_utility.set_location('Entering:'|| l_proc, 5);
43: --
44: open c1;
45: fetch c1 into l_effective_start_date,l_effective_end_date,
46: l_short_name,l_document_name,l_file_id,l_formula_id,l_object_version_number,l_document_category,l_lob_code,l_language,l_territory;
109: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;
110: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;
111: --
112: begin
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Issue a savepoint
116: --
117: savepoint CREATE_PRINT_DOCUMENT;
207: p_object_version_number := l_object_version_number;
208: p_effective_start_date := l_effective_start_date;
209: p_effective_end_date := l_effective_end_date;
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 70);
212: exception
213: when hr_api.validate_enabled then
214: --
215: -- As the Validate_Enabled exception has been raised
224: p_document_id := null;
225: p_object_version_number := null;
226: p_effective_start_date := null;
227: p_effective_end_date := null;
228: hr_utility.set_location(' Leaving:'||l_proc, 80);
229: --
230: when others then
231: --
232: -- A validation or unexpected error has occured
236: p_effective_start_date := null;
237: p_effective_end_date := null;
238:
239: rollback to CREATE_PRINT_DOCUMENT;
240: hr_utility.set_location(' Leaving:'||l_proc, 90);
241: raise;
242: end create_print_document;
243:
244: --
322: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;
323: l_object_version_number number := p_object_version_number;
324: --
325: begin
326: hr_utility.set_location('Entering:'|| l_proc, 10);
327: --
328: -- Issue a savepoint
329: --
330: savepoint UPDATE_PRINT_DOCUMENT;
424: p_object_version_number := l_object_version_number;
425: p_effective_start_date := l_effective_start_date;
426: p_effective_end_date := l_effective_end_date;
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 70);
429: exception
430: when hr_api.validate_enabled then
431: --
432: -- As the Validate_Enabled exception has been raised
441: -- p_document_id := null;
442: p_object_version_number := null;
443: p_effective_start_date := null;
444: p_effective_end_date := null;
445: hr_utility.set_location(' Leaving:'||l_proc, 80);
446: --
447: when others then
448: --
449: -- A validation or unexpected error has occured
453: p_effective_start_date := null;
454: p_effective_end_date := null;
455:
456: rollback to UPDATE_PRINT_DOCUMENT;
457: hr_utility.set_location(' Leaving:'||l_proc, 90);
458: raise;
459: end update_print_document;
460: --
461: --
551: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;
552: l_object_version_number number := p_object_version_number;
553: --
554: begin
555: hr_utility.set_location('Entering:'|| l_proc, 10);
556: --
557: -- Issue a savepoint
558: --
559: savepoint DELETE_PRINT_DOCUMENT;
622: p_effective_start_date := l_effective_start_date;
623: p_effective_end_date := l_effective_end_date;
624: --
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 70);
627: exception
628: when hr_api.validate_enabled then
629: --
630: -- As the Validate_Enabled exception has been raised
639: p_object_version_number := l_object_version_number;
640: p_effective_start_date := null;
641: p_effective_end_date := null;
642: --
643: hr_utility.set_location(' Leaving:'||l_proc, 80);
644: when others then
645: --
646: -- A validation or unexpected error has occured
647: --
649: p_effective_start_date := null;
650: p_effective_end_date := null;
651:
652: rollback to DELETE_PRINT_DOCUMENT;
653: hr_utility.set_location(' Leaving:'||l_proc, 90);
654: raise;
655: --
656: end delete_print_document;
657: --