[Home] [Help]
66: l_text varchar2(2000);
67: l_message varchar2(10);
68: --
69: cursor get_seq is
70: select per_wf_events_s.nextval from dual;
71: --
72: l_proc varchar2(72):=' hr_assignment_be3.update_emp_asg_criteria_a';
73: begin
74: hr_utility.set_location('Entering: '||l_proc,10);
73: begin
74: hr_utility.set_location('Entering: '||l_proc,10);
75: -- check the status of the business event
76: l_event_name:='oracle.apps.per.api.assignment.update_emp_asg_criteria';
77: l_message:=wf_event.test(l_event_name);
78: --
79: if (l_message='MESSAGE') then
80: hr_utility.set_location(l_proc,20);
81: --
348: if p_effective_start_date is not NULL and
349: p_effective_start_date > trunc(SYSDATE) and
350: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
351: -- raise the event with the event data, with send date set to effective date
352: wf_event.raise(p_event_name=>l_event_name
353: ,p_event_key=>l_event_key
354: ,p_event_data=>l_event_data
355: ,p_send_date => p_effective_start_date);
356: --
355: ,p_send_date => p_effective_start_date);
356: --
357: else
358: -- raise the event with the event data
359: wf_event.raise(p_event_name=>l_event_name
360: ,p_event_key=>l_event_key
361: ,p_event_data=>l_event_data);
362: end if;
363: elsif (l_message='KEY') then
370: p_effective_start_date > trunc(SYSDATE) and
371: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
372: -- this is a key event, so just raise the event
373: -- without the event data, with send date set to effective date
374: wf_event.raise(p_event_name=>l_event_name
375: ,p_event_key=>l_event_key
376: ,p_send_date => p_effective_start_date);
377: --
378: else
377: --
378: else
379: -- this is a key event, so just raise the event
380: -- without the event data
381: wf_event.raise(p_event_name=>l_event_name
382: ,p_event_key=>l_event_key);
383: end if;
384: elsif (l_message='NONE') then
385: hr_utility.set_location(l_proc,40);