1244: BEGIN
1245:
1246: SELECT oe_msg_id_S.NEXTVAL
1247: INTO l_transaction_id
1248: FROM dual;
1249:
1250: END;
1251:
1252: insert into OE_PROCESSING_MSGS
1841: --5121760
1842: SELECT fnd_date.chardt_to_date(p_creation_date_from),
1843: fnd_date.chardt_to_date(p_creation_date_to)
1844: INTO l_creation_date_from,l_creation_date_to
1845: FROM DUAL;
1846: IF p_message_source_code IS NOT NULL THEN
1847: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':message_source_code',p_message_source_code);
1848: END IF;
1849: