[Home] [Help]
58: l_text varchar2(2000);
59: l_message varchar2(10);
60: --
61: cursor get_seq is
62: select per_wf_events_s.nextval from dual;
63: --
64: l_proc varchar2(72):=' hr_assignment_beO.update_cwk_asg_criteria_a';
65: begin
66: hr_utility.set_location('Entering: '||l_proc,10);
65: begin
66: hr_utility.set_location('Entering: '||l_proc,10);
67: -- check the status of the business event
68: l_event_name:='oracle.apps.per.api.assignment.update_cwk_asg_criteria';
69: l_message:=wf_event.test(l_event_name);
70: --
71: if (l_message='MESSAGE') then
72: hr_utility.set_location(l_proc,20);
73: --
308: if p_effective_start_date is not NULL and
309: p_effective_start_date > trunc(SYSDATE) and
310: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
311: -- raise the event with the event data, with send date set to effective date
312: wf_event.raise(p_event_name=>l_event_name
313: ,p_event_key=>l_event_key
314: ,p_event_data=>l_event_data
315: ,p_send_date => p_effective_start_date);
316: --
315: ,p_send_date => p_effective_start_date);
316: --
317: else
318: -- raise the event with the event data
319: wf_event.raise(p_event_name=>l_event_name
320: ,p_event_key=>l_event_key
321: ,p_event_data=>l_event_data);
322: end if;
323: elsif (l_message='KEY') then
330: p_effective_start_date > trunc(SYSDATE) and
331: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then
332: -- this is a key event, so just raise the event
333: -- without the event data, with send date set to effective date
334: wf_event.raise(p_event_name=>l_event_name
335: ,p_event_key=>l_event_key
336: ,p_send_date => p_effective_start_date);
337: --
338: else
337: --
338: else
339: -- this is a key event, so just raise the event
340: -- without the event data
341: wf_event.raise(p_event_name=>l_event_name
342: ,p_event_key=>l_event_key);
343: end if;
344: elsif (l_message='NONE') then
345: hr_utility.set_location(l_proc,40);