APPS.PQH_DOCUMENTS_API dependencies on PQH_DOCUMENTS_F

Line 36: from pqh_documents_f

32: --
33: cursor c1 is
34: select effective_start_date,effective_end_date,short_name,document_name,
35: file_id,formula_id,object_version_number,document_category,lob_code,language,territory
36: from pqh_documents_f
37: where document_id = p_document_id
38: and p_effective_date between effective_start_date and effective_end_date;
39: --
40: begin

Line 107: l_document_id pqh_documents_f.document_id%TYPE;

103: -- Declare cursors and local variables
104: --
105: l_proc varchar2(72) := g_package||'CREATE_PRINT_DOCUMENT';
106:
107: l_document_id pqh_documents_f.document_id%TYPE;
108: l_object_version_number pqh_documents_f.object_version_number%TYPE;
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: --

Line 108: l_object_version_number pqh_documents_f.object_version_number%TYPE;

104: --
105: l_proc varchar2(72) := g_package||'CREATE_PRINT_DOCUMENT';
106:
107: l_document_id pqh_documents_f.document_id%TYPE;
108: l_object_version_number pqh_documents_f.object_version_number%TYPE;
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

Line 109: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;

105: l_proc varchar2(72) := g_package||'CREATE_PRINT_DOCUMENT';
106:
107: l_document_id pqh_documents_f.document_id%TYPE;
108: l_object_version_number pqh_documents_f.object_version_number%TYPE;
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);

Line 110: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;

106:
107: l_document_id pqh_documents_f.document_id%TYPE;
108: l_object_version_number pqh_documents_f.object_version_number%TYPE;
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: --

Line 321: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;

317: --
318:
319: l_proc varchar2(72) := g_package||'UPDATE_PRINT_DOCUMENT';
320:
321: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;
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

Line 322: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;

318:
319: l_proc varchar2(72) := g_package||'UPDATE_PRINT_DOCUMENT';
320:
321: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;
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);

Line 550: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;

546: -- Declare cursors and local variables
547: --
548:
549: l_proc varchar2(72) := g_package||'DELETE_PRINT_DOCUMENT';
550: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;
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

Line 551: l_effective_end_date pqh_documents_f.effective_end_date%TYPE;

547: --
548:
549: l_proc varchar2(72) := g_package||'DELETE_PRINT_DOCUMENT';
550: l_effective_start_date pqh_documents_f.effective_start_date%TYPE;
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);