25: -- Declare cursors and local variables
26: --
27: l_proc varchar2(72) := g_package||'CREATE_DOCUMENT_ATTRIBUTE';
28:
29: l_document_attribute_id pqh_document_attributes_f.document_attribute_id%TYPE;
30: l_object_version_number pqh_document_attributes_f.object_version_number%TYPE;
31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;
32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;
33: --
26: --
27: l_proc varchar2(72) := g_package||'CREATE_DOCUMENT_ATTRIBUTE';
28:
29: l_document_attribute_id pqh_document_attributes_f.document_attribute_id%TYPE;
30: l_object_version_number pqh_document_attributes_f.object_version_number%TYPE;
31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;
32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;
33: --
34: begin
27: l_proc varchar2(72) := g_package||'CREATE_DOCUMENT_ATTRIBUTE';
28:
29: l_document_attribute_id pqh_document_attributes_f.document_attribute_id%TYPE;
30: l_object_version_number pqh_document_attributes_f.object_version_number%TYPE;
31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;
32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;
33: --
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
28:
29: l_document_attribute_id pqh_document_attributes_f.document_attribute_id%TYPE;
30: l_object_version_number pqh_document_attributes_f.object_version_number%TYPE;
31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;
32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;
33: --
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
167: --
168:
169: l_proc varchar2(72) := g_package||'UPDATE_DOCUMENT_ATTRIBUTE';
170:
171: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;
172: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
173: l_object_version_number number := p_object_version_number;
174: --
175: begin
168:
169: l_proc varchar2(72) := g_package||'UPDATE_DOCUMENT_ATTRIBUTE';
170:
171: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;
172: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
173: l_object_version_number number := p_object_version_number;
174: --
175: begin
176: hr_utility.set_location('Entering:'|| l_proc, 10);
334: -- Declare cursors and local variables
335: --
336:
337: l_proc varchar2(72) := g_package||'DELETE_DOCUMENT_ATTRIBUTE';
338: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;
339: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
340: l_object_version_number number := p_object_version_number;
341: --
342: begin
335: --
336:
337: l_proc varchar2(72) := g_package||'DELETE_DOCUMENT_ATTRIBUTE';
338: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;
339: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;
340: l_object_version_number number := p_object_version_number;
341: --
342: begin
343: hr_utility.set_location('Entering:'|| l_proc, 10);