DBA Data[Home] [Help]

APPS.OKC_CONTRACT_DOCS_GRP dependencies on DUAL

Line 105: SELECT fnd_attached_documents_s.nextval FROM dual;

101: l_parent_attached_doc_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%TYPE := p_parent_attached_doc_id;
102: l_seq_num FND_ATTACHED_DOCUMENTS.SEQ_NUM%TYPE := 0;
103:
104: CURSOR l_attachment_id_csr IS
105: SELECT fnd_attached_documents_s.nextval FROM dual;
106:
107: CURSOR seq_csr(l_entity_name VARCHAR2, l_pk1_value VARCHAR2,
108: l_pk2_value NUMBER, l_pk3_value NUMBER) IS
109: SELECT max(seq_num) s_num