221: AND a.task_id = l_task_id;
222:
223: cs_sr_check_nonFS_type_rec cs_sr_check_nonFS_type_csr%ROWTYPE;
224:
225: /* The following 2 cursors will get the task resource information required to send WF notifications */
226: CURSOR cs_sr_get_task_assignee_id_csr IS
227: SELECT b.source_id
228: FROM jtf_task_assignments a, jtf_rs_resource_extns b
229: WHERE a.resource_id = b.resource_id(+) AND
307: -- nvl(cs_sr_get_status_flags_rec.end_date_type, ' ') = 'SCHEDULED_END'
308: ) THEN
309:
310:
311: /* Send WF notifications to task owner.. */
312: OPEN cs_sr_get_task_owner_id_csr;
313: FETCH cs_sr_get_task_owner_id_csr INTO l_task_owner_id;
314: CLOSE cs_sr_get_task_owner_id_csr;
315:
327:
328: IF (l_owner_role IS NOT NULL) THEN
329:
330:
331: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
332: msg_type => 'SERVEREQ',
333: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
334:
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
331: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
332: msg_type => 'SERVEREQ',
333: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
334:
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
332: msg_type => 'SERVEREQ',
333: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
334:
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
333: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
334:
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
341:
334:
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
341:
342: Wf_Notification.Denormalize_Notification(l_nid);
335: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
341:
342: Wf_Notification.Denormalize_Notification(l_nid);
343:
336: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
337: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
341:
342: Wf_Notification.Denormalize_Notification(l_nid);
343:
344: END IF;
338: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
339: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
340: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
341:
342: Wf_Notification.Denormalize_Notification(l_nid);
343:
344: END IF;
345:
346: END IF ; -- End of IF(l_task_owner_id is not null)
366:
367: IF (l_owner_role IS NOT NULL) THEN
368:
369:
370: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
371: msg_type => 'SERVEREQ',
372: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
369:
370: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
371: msg_type => 'SERVEREQ',
372: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
370: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
371: msg_type => 'SERVEREQ',
372: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
371: msg_type => 'SERVEREQ',
372: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
379:
372: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
379:
380: Wf_Notification.Denormalize_Notification(l_nid);
373: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
379:
380: Wf_Notification.Denormalize_Notification(l_nid);
381:
374: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
375: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
379:
380: Wf_Notification.Denormalize_Notification(l_nid);
381:
382: END IF;
376: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
377: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
378: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
379:
380: Wf_Notification.Denormalize_Notification(l_nid);
381:
382: END IF;
383:
384: END IF; /* end of IF(l_task_assignee_id is not null) */