DBA Data[Home] [Help]

APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG dependencies on WF_NOTIFICATION

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

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

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

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:

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

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);

Line 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 ');

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

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);

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

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:

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

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);

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

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:

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

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;

Line 342: Wf_Notification.Denormalize_Notification(l_nid);

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)

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

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);

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

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 ');

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

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);

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

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:

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

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);

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

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:

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

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;

Line 380: Wf_Notification.Denormalize_Notification(l_nid);

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) */