595: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
596: --
597: if p_effective_start_date is not NULL and
598: p_effective_start_date > trunc(SYSDATE) and
599: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
600: -- raise the event with the event data, with send date set to effective date
601: wf_event.raise(p_event_name=>l_event_name
602: ,p_event_key=>l_event_key
603: ,p_event_data=>l_event_data
616: fetch get_seq into l_event_key;
617: close get_seq;
618: if p_effective_start_date is not NULL and
619: p_effective_start_date > trunc(SYSDATE) and
620: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
621: -- this is a key event, so just raise the event
622: -- without the event data, with send date set to effective date
623: wf_event.raise(p_event_name=>l_event_name
624: ,p_event_key=>l_event_key