DBA Data[Home] [Help]

APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on WF_NOTIFICATION

Line 238: /* The following 2 cursors will get the task resource information required to send WF notifications */

234: AND a.task_id = l_task_id;
235:
236: cs_sr_check_nonFS_type_rec cs_sr_check_nonFS_type_csr%ROWTYPE;
237:
238: /* The following 2 cursors will get the task resource information required to send WF notifications */
239: CURSOR cs_sr_get_task_assignee_id_csr IS
240: SELECT b.source_id
241: FROM jtf_task_assignments a, jtf_rs_resource_extns b
242: WHERE a.resource_id = b.resource_id(+) AND

Line 324: /* Send WF notifications to task owner.. */

320: -- nvl(cs_sr_get_status_flags_rec.end_date_type, ' ') = 'SCHEDULED_END'
321: ) THEN
322:
323:
324: /* Send WF notifications to task owner.. */
325: OPEN cs_sr_get_task_owner_id_csr;
326: FETCH cs_sr_get_task_owner_id_csr INTO l_task_owner_id;
327: CLOSE cs_sr_get_task_owner_id_csr;
328:

Line 344: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,

340:
341: IF (l_owner_role IS NOT NULL) THEN
342:
343:
344: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
345: msg_type => 'SERVEREQ',
346: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
347:
348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);

Line 348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);

344: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
345: msg_type => 'SERVEREQ',
346: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
347:
348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');

Line 349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);

345: msg_type => 'SERVEREQ',
346: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
347:
348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);

Line 350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);

346: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
347:
348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
354:

Line 351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);

347:
348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
354:
355: Wf_Notification.Denormalize_Notification(l_nid);

Line 352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');

348: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
354:
355: Wf_Notification.Denormalize_Notification(l_nid);
356:

Line 353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);

349: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
350: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
354:
355: Wf_Notification.Denormalize_Notification(l_nid);
356:
357: END IF;

Line 355: Wf_Notification.Denormalize_Notification(l_nid);

351: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
352: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','owned by ');
353: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
354:
355: Wf_Notification.Denormalize_Notification(l_nid);
356:
357: END IF;
358:
359: END IF ; -- End of IF(l_task_owner_id is not null)

Line 383: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,

379:
380: IF (l_owner_role IS NOT NULL) THEN
381:
382:
383: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
384: msg_type => 'SERVEREQ',
385: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);

Line 386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);

382:
383: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
384: msg_type => 'SERVEREQ',
385: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');

Line 387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);

383: l_nid := WF_NOTIFICATION.Send(role => l_owner_role,
384: msg_type => 'SERVEREQ',
385: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);

Line 388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);

384: msg_type => 'SERVEREQ',
385: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
392:

Line 389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);

385: msg_name => 'CS_SR_NOTIFY_TASK_RESOURCES');
386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
392:
393: Wf_Notification.Denormalize_Notification(l_nid);

Line 390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');

386: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NUMBER',cs_sr_check_nonFS_type_rec.task_number);
387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
392:
393: Wf_Notification.Denormalize_Notification(l_nid);
394:

Line 391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);

387: WF_NOTIFICATION.setattrtext(l_nid,'TASK_NAME',cs_sr_check_nonFS_type_rec.task_name);
388: WF_NOTIFICATION.setattrtext(l_nid,'TASK_DESCRIPTION',cs_sr_check_nonFS_type_rec.description);
389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
392:
393: Wf_Notification.Denormalize_Notification(l_nid);
394:
395: END IF;

Line 393: Wf_Notification.Denormalize_Notification(l_nid);

389: WF_NOTIFICATION.setattrtext(l_nid,'TASK_RESOURCE_NAME',l_owner_name);
390: WF_NOTIFICATION.setattrtext(l_nid,'ASSOCIATION_TYPE','assigned to ');
391: WF_NOTIFICATION.setattrtext(l_nid,'TASK_STATUS',l_task_status);
392:
393: Wf_Notification.Denormalize_Notification(l_nid);
394:
395: END IF;
396:
397: END IF; /* end of IF(l_task_assignee_id is not null) */