DBA Data[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,