[Home] [Help]
APPS.IBY_TRXN_DOCUMENTS_PKG dependencies on DUAL
Line 106: SELECT iby_trxn_documentid_s.NEXTVAL INTO trxn_document_id_seq FROM dual;
102:
103: trxn_document_id_seq NUMBER;
104:
105: BEGIN
106: SELECT iby_trxn_documentid_s.NEXTVAL INTO trxn_document_id_seq FROM dual;
107:
108: docid_out := trxn_document_id_seq;
109:
110: -- CHANGE: CATCH EXCEPTION FOR DOC UNIQUENESS CONSTRAINTS
Line 141: SELECT iby_trxn_documentid_s.NEXTVAL INTO trxn_document_id_seq FROM dual;
137:
138: trxn_document_id_seq NUMBER;
139:
140: BEGIN
141: SELECT iby_trxn_documentid_s.NEXTVAL INTO trxn_document_id_seq FROM dual;
142:
143: docid_out := trxn_document_id_seq;
144: BEGIN
145: INSERT INTO iby_trxn_documents (trxnmid,doctype,document,object_version_number,