66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
104: End If;
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 15);
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
111: pqh_doa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
111: pqh_doa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
116: pqh_doa_shd.constraint_error
109: -- A check constraint has been violated
110: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
111: pqh_doa_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
116: pqh_doa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
116: pqh_doa_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;
121: End dt_update_dml;
230: l_dummy_version_number number;
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: If (p_datetrack_mode <> hr_api.g_correction) then
235: --
236: -- Update the current effective end date
237: --
238: pqh_doa_shd.upd_effective_end_date
243: ,p_validation_end_date => p_validation_end_date
244: ,p_object_version_number => l_dummy_version_number
245: );
246: --
247: If (p_datetrack_mode = hr_api.g_update_override) then
248: --
249: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
250: -- delete any future rows
251: --
413: );
414: --
415: exception
416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'PQH_DOCUMENT_ATTRIBUTES_F'
421: ,p_hook_type => 'AU');
415: exception
416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'PQH_DOCUMENT_ATTRIBUTES_F'
421: ,p_hook_type => 'AU');
422: --
423: end;
478: -- p_rec plsql record structure
479: -- to see if a system default is being used. If a system default
480: -- is being used then we must set to the 'current' argument value.
481: --
482: If (p_rec.document_id = hr_api.g_number) then
483: p_rec.document_id :=
484: pqh_doa_shd.g_old_rec.document_id;
485: End If;
486: If (p_rec.attribute_id = hr_api.g_number) then
482: If (p_rec.document_id = hr_api.g_number) then
483: p_rec.document_id :=
484: pqh_doa_shd.g_old_rec.document_id;
485: End If;
486: If (p_rec.attribute_id = hr_api.g_number) then
487: p_rec.attribute_id :=
488: pqh_doa_shd.g_old_rec.attribute_id;
489: End If;
490: If (p_rec.tag_name = hr_api.g_varchar2) then
486: If (p_rec.attribute_id = hr_api.g_number) then
487: p_rec.attribute_id :=
488: pqh_doa_shd.g_old_rec.attribute_id;
489: End If;
490: If (p_rec.tag_name = hr_api.g_varchar2) then
491: p_rec.tag_name :=
492: pqh_doa_shd.g_old_rec.tag_name;
493: End If;
494: --
585: (p_effective_date in date
586: ,p_datetrack_mode in varchar2
587: ,p_document_attribute_id in number
588: ,p_object_version_number in out NOCOPY number
589: ,p_document_id in number default hr_api.g_number
590: ,p_attribute_id in number default hr_api.g_number
591: ,p_tag_name in varchar2 default hr_api.g_varchar2
592: ,p_effective_start_date out NOCOPY date
593: ,p_effective_end_date out NOCOPY date
586: ,p_datetrack_mode in varchar2
587: ,p_document_attribute_id in number
588: ,p_object_version_number in out NOCOPY number
589: ,p_document_id in number default hr_api.g_number
590: ,p_attribute_id in number default hr_api.g_number
591: ,p_tag_name in varchar2 default hr_api.g_varchar2
592: ,p_effective_start_date out NOCOPY date
593: ,p_effective_end_date out NOCOPY date
594: ) is
587: ,p_document_attribute_id in number
588: ,p_object_version_number in out NOCOPY number
589: ,p_document_id in number default hr_api.g_number
590: ,p_attribute_id in number default hr_api.g_number
591: ,p_tag_name in varchar2 default hr_api.g_varchar2
592: ,p_effective_start_date out NOCOPY date
593: ,p_effective_end_date out NOCOPY date
594: ) is
595: --