117: END IF;
118: BEGIN
119: SELECT MSGID
120: INTO l_xmlg_msgid 121: FROM ECX_DOCLOGS dlogs 122: WHERE dlogs.TRANSACTION_TYPE = l_xmlg_transaction_type AND
123: dlogs.TRANSACTION_SUBTYPE = l_xmlg_transaction_subtype AND
124: dlogs.DIRECTION = 'OUT' AND
125: dlogs.DOCUMENT_NUMBER = l_xmlg_doc_id AND