APPS.OKC_CONTRACT_SEQ_PVT dependencies on FND_DOCUMENT_SEQUENCES

Line 281: l_docseq_name fnd_document_sequences.name%TYPE;

277: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
278: --
279: l_lsqv_rec lsqv_rec_type := p_lsqv_rec;
280: l_seq number;
281: l_docseq_name fnd_document_sequences.name%TYPE;
282: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%TYPE;
283: l_set_of_books_id okx_organization_defs_v.set_of_books_id%TYPE;
284: l_return_status VARCHAR2(1);
285: l_row_notfound Boolean;

Line 282: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%TYPE;

278: --
279: l_lsqv_rec lsqv_rec_type := p_lsqv_rec;
280: l_seq number;
281: l_docseq_name fnd_document_sequences.name%TYPE;
282: l_doc_sequence_id fnd_document_sequences.doc_sequence_id%TYPE;
283: l_set_of_books_id okx_organization_defs_v.set_of_books_id%TYPE;
284: l_return_status VARCHAR2(1);
285: l_row_notfound Boolean;
286: --

Line 308: from fnd_document_sequences

304: -- cursor to get the doc_sequence_id, used in the simple api
305: --
306: cursor c2 is
307: select doc_sequence_id
308: from fnd_document_sequences
309: where name = l_docseq_name;
310: --
311: -- cursor to get the set of books id
312: --

Line 347: -- Populate fnd_document_sequences table

343: If l_row_notfound Then
344: --
345: -- If doc sequence does not exist, do the AOL setup here first
346: -- First create the document sequence details.
347: -- Populate fnd_document_sequences table
348: --
349: select okc_k_seq_lines_s1.nextval into l_seq from dual;
350: l_docseq_name := Fnd_Profile.Value('OKC_DOC_SEQUENCE_NAME') ||
351: To_Char(l_seq);