[Home] [Help]
113: --
114: INSERT INTO iby_trxn_documents (trxnmid,doctype,document,object_version_number,last_update_date,last_updated_by,creation_date,created_by,last_update_login,trxn_document_id, payment_instruction_id)
115: -- object version number is 0 as the document is empty
116: --
117: VALUES (trxnmid_in,doctype_in,empty_clob(),0,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,trxn_document_id_seq, NULL);
118: COMMIT;
119: END CreateDocument;
120:
121: /*
151: -- FZ 8/28/2005. This should not be a problem
152: -- for funds capture code as the doctype (100)
153: -- is for R12 disbursement only
154: VALUES (p_payment_instruction_id,p_doctype,p_doc,1,
155: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.login_id,
156: trxn_document_id_seq, p_payment_instruction_id);
157: EXCEPTION
158: when DUP_VAL_ON_INDEX then null;
159: END;
298: IF (read_only_in=C_FETCH_READWRITE) THEN
299: -- not read only so we update the last change information
300: --
301: UPDATE iby_trxn_documents
302: SET object_version_number=object_version_number+1, last_update_date=sysdate,last_updated_by=fnd_global.user_id,last_update_login=fnd_global.login_id
303: WHERE (trxnmid=trxnmid_in) AND (doctype=doctype_in);
304: COMMIT;
305:
306: SELECT document INTO document_out
362: /*
363: -- not read only so we update the last change information
364: --
365: UPDATE iby_trxn_documents
366: SET object_version_number=object_version_number+1, last_update_date=sysdate,last_updated_by=fnd_global.user_id,last_update_login=fnd_global.login_id
367: WHERE (payment_instruction_id=p_payment_instruction_id) AND (doctype=p_doctype);
368: COMMIT;
369:
370: SELECT document INTO document_out