163: close csr_name;
164:
165: if l_wf_role is not null --Added IF as part of bug#12569947.
166: then
167: i:=wf_notification.send(l_wf_role
168: ,'HRCKLTSK'
169: ,'TASK_REQUEST_MSG'
170: ,null
171: ,null
173: ,null
174: );
175:
176:
177: wf_notification.setAttrText(i,'PERSON',l_full_name );
178: wf_notification.setAttrText(i,'TASK',p_rec.task_name );
179: wf_notification.setAttrText(i,'TASK_DESCRIPTION',p_rec.description );
180: wf_notification.setAttrDate(i,'TARGETDATE', p_rec.target_end_date );
181:
174: );
175:
176:
177: wf_notification.setAttrText(i,'PERSON',l_full_name );
178: wf_notification.setAttrText(i,'TASK',p_rec.task_name );
179: wf_notification.setAttrText(i,'TASK_DESCRIPTION',p_rec.description );
180: wf_notification.setAttrDate(i,'TARGETDATE', p_rec.target_end_date );
181:
182: end if;
175:
176:
177: wf_notification.setAttrText(i,'PERSON',l_full_name );
178: wf_notification.setAttrText(i,'TASK',p_rec.task_name );
179: wf_notification.setAttrText(i,'TASK_DESCRIPTION',p_rec.description );
180: wf_notification.setAttrDate(i,'TARGETDATE', p_rec.target_end_date );
181:
182: end if;
183: -- end fix9383452
176:
177: wf_notification.setAttrText(i,'PERSON',l_full_name );
178: wf_notification.setAttrText(i,'TASK',p_rec.task_name );
179: wf_notification.setAttrText(i,'TASK_DESCRIPTION',p_rec.description );
180: wf_notification.setAttrDate(i,'TARGETDATE', p_rec.target_end_date );
181:
182: end if;
183: -- end fix9383452
184: --