APPS.PQH_DOCUMENT_ATTRIBUTES_API dependencies on PQH_DOCUMENT_ATTRIBUTES_F

Line 29: l_document_attribute_id pqh_document_attributes_f.document_attribute_id%TYPE;

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: --

Line 30: l_object_version_number pqh_document_attributes_f.object_version_number%TYPE;

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

Line 31: l_effective_start_date pqh_document_attributes_f.effective_start_date%TYPE;

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);

Line 32: l_effective_end_date pqh_document_attributes_f.effective_end_date%TYPE;

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: --

Line 171: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;

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

Line 172: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;

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);

Line 338: l_effective_start_date pqh_DOCUMENT_ATTRIBUTES_f.effective_start_date%TYPE;

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

Line 339: l_effective_end_date pqh_DOCUMENT_ATTRIBUTES_f.effective_end_date%TYPE;

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);