eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_ALERTS_PUB dependencies on WF_PARAMETER_LIST_T

Line 33: l_wf_parameter_list_t wf_parameter_list_t;

29: X_MSG_DATA VARCHAR2(200);
30: l_shift_start_date date;
31: l_minutes_before number;
32: l_send_date date;
33: l_wf_parameter_list_t wf_parameter_list_t;
34: l_wf_parameter_list_t_cp wf_parameter_list_t;
35: l_wf_parameter_t wf_parameter_t;
36: l_old_resource number;
37: l_new_resource number;

Line 34: l_wf_parameter_list_t_cp wf_parameter_list_t;

30: l_shift_start_date date;
31: l_minutes_before number;
32: l_send_date date;
33: l_wf_parameter_list_t wf_parameter_list_t;
34: l_wf_parameter_list_t_cp wf_parameter_list_t;
35: l_wf_parameter_t wf_parameter_t;
36: l_old_resource number;
37: l_new_resource number;
38: l_old_resource_type varchar2(100);

Line 246: l_wf_parameter_list_t := p_event.getParameterList();

242: begin
243:
244: l_event_name := p_event.getEventName();
245: l_task_asgn_id := p_event.GetValueForParameter('TASK_ASSIGNMENT_ID');
246: l_wf_parameter_list_t := p_event.getParameterList();
247:
248: -- create task assignment event
249: if (l_event_name = 'oracle.apps.jtf.cac.task.createTaskAssignment') then -- event type create
250:

Line 273: l_wf_parameter_list_t.EXTEND;

269:
270: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
271:
272: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
273: l_wf_parameter_list_t.EXTEND;
274: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
275:
276: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
277: l_wf_parameter_list_t.EXTEND;

Line 274: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

270: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
271:
272: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
273: l_wf_parameter_list_t.EXTEND;
274: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
275:
276: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
277: l_wf_parameter_list_t.EXTEND;
278: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 277: l_wf_parameter_list_t.EXTEND;

273: l_wf_parameter_list_t.EXTEND;
274: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
275:
276: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
277: l_wf_parameter_list_t.EXTEND;
278: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
279:
280: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
281: l_resource_id,

Line 278: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

274: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
275:
276: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
277: l_wf_parameter_list_t.EXTEND;
278: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
279:
280: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
281: l_resource_id,
282: l_resource_type_code,

Line 288: p_parameters => l_wf_parameter_list_t,

284: p_event.getEventKey());
285:
286: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
287: p_event_key => l_event_key,
288: p_parameters => l_wf_parameter_list_t,
289: p_send_date => l_send_date);
290:
291: end if;
292:

Line 317: l_wf_parameter_list_t.EXTEND;

313:
314: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
315:
316: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
317: l_wf_parameter_list_t.EXTEND;
318: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
319:
320: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
321: l_resource_id,

Line 318: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

314: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
315:
316: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
317: l_wf_parameter_list_t.EXTEND;
318: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
319:
320: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
321: l_resource_id,
322: l_resource_type_code,

Line 328: p_parameters => l_wf_parameter_list_t,

324: p_event.getEventKey());
325:
326: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
327: p_event_key => l_event_key,
328: p_parameters => l_wf_parameter_list_t,
329: p_send_date => l_send_date);
330:
331: end if;
332:

Line 369: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;

365:
366: -- create notification to new resource
367: if checkAlertsEnabled(l_new_resource, l_new_resource_type) then -- alerts enables?
368:
369: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
370: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
371: l_wf_parameter_list_t.EXTEND;
372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
373:

Line 371: l_wf_parameter_list_t.EXTEND;

367: if checkAlertsEnabled(l_new_resource, l_new_resource_type) then -- alerts enables?
368:
369: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
370: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
371: l_wf_parameter_list_t.EXTEND;
372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
373:
374: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
375: l_wf_parameter_list_t.EXTEND;

Line 372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

368:
369: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
370: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
371: l_wf_parameter_list_t.EXTEND;
372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
373:
374: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
375: l_wf_parameter_list_t.EXTEND;
376: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 375: l_wf_parameter_list_t.EXTEND;

371: l_wf_parameter_list_t.EXTEND;
372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
373:
374: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
375: l_wf_parameter_list_t.EXTEND;
376: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
377:
378:
379: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',

Line 376: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

372: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
373:
374: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
375: l_wf_parameter_list_t.EXTEND;
376: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
377:
378:
379: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
380: l_new_resource,

Line 387: p_parameters => l_wf_parameter_list_t,

383: p_event.getEventKey());
384:
385: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
386: p_event_key => l_event_key,
387: p_parameters => l_wf_parameter_list_t,
388: p_send_date => l_send_date
389: );
390:
391: end if; -- alerts enabled?

Line 397: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;

393: -- delete alert to old resource
394: if checkAlertsEnabled(l_old_resource, l_old_resource_type) then -- alerts enabled?
395:
396: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
397: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
398: l_wf_parameter_list_t.EXTEND;
399: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
400:
401: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',

Line 398: l_wf_parameter_list_t.EXTEND;

394: if checkAlertsEnabled(l_old_resource, l_old_resource_type) then -- alerts enabled?
395:
396: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
397: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
398: l_wf_parameter_list_t.EXTEND;
399: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
400:
401: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
402: l_old_resource,

Line 399: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

395:
396: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
397: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
398: l_wf_parameter_list_t.EXTEND;
399: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
400:
401: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
402: l_old_resource,
403: l_old_resource_type,

Line 409: p_parameters => l_wf_parameter_list_t,

405: p_event.getEventKey());
406:
407: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
408: p_event_key => l_event_key,
409: p_parameters => l_wf_parameter_list_t,
410: p_send_date => l_send_date);
411:
412: end if; -- alerts enabled?
413:

Line 447: l_wf_parameter_list_t.EXTEND;

443: l_scheduled_end_date);
444:
445: -- delete case
446: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
447: l_wf_parameter_list_t.EXTEND;
448: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
449:
450: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
451: l_resource_id,

Line 448: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

444:
445: -- delete case
446: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
447: l_wf_parameter_list_t.EXTEND;
448: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
449:
450: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
451: l_resource_id,
452: l_resource_type_code,

Line 458: p_parameters => l_wf_parameter_list_t,

454: p_event.getEventKey());
455:
456: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
457: p_event_key => l_event_key,
458: p_parameters => l_wf_parameter_list_t,
459: p_send_date => l_send_date);
460:
461: else -- not a cancel status
462:

Line 481: l_wf_parameter_list_t.EXTEND;

477: if l_assigned_status_flag = 'TRUE' then -- new assignment
478: -- status from non-assigned to assigned
479:
480: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
481: l_wf_parameter_list_t.EXTEND;
482: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
483:
484: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
485: l_wf_parameter_list_t.EXTEND;

Line 482: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

478: -- status from non-assigned to assigned
479:
480: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
481: l_wf_parameter_list_t.EXTEND;
482: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
483:
484: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
485: l_wf_parameter_list_t.EXTEND;
486: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 485: l_wf_parameter_list_t.EXTEND;

481: l_wf_parameter_list_t.EXTEND;
482: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
483:
484: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
485: l_wf_parameter_list_t.EXTEND;
486: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
487:
488: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
489: l_resource_id,

Line 486: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

482: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
483:
484: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
485: l_wf_parameter_list_t.EXTEND;
486: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
487:
488: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
489: l_resource_id,
490: l_resource_type_code,

Line 496: p_parameters => l_wf_parameter_list_t,

492: p_event.getEventKey());
493:
494: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
495: p_event_key => l_event_key,
496: p_parameters => l_wf_parameter_list_t,
497: p_send_date => l_send_date
498: );
499:
500: end if; -- new assignemnt over

Line 559: l_wf_parameter_list_t.EXTEND;

555: if l_priority_test = 'TRUE'
556: and checkAlertsEnabled(l_resource_id, l_resource_type_code) then -- create assignment notification
557:
558: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
559: l_wf_parameter_list_t.EXTEND;
560: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
561:
562: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
563: l_wf_parameter_list_t.EXTEND;

Line 560: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

556: and checkAlertsEnabled(l_resource_id, l_resource_type_code) then -- create assignment notification
557:
558: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
559: l_wf_parameter_list_t.EXTEND;
560: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
561:
562: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
563: l_wf_parameter_list_t.EXTEND;
564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 563: l_wf_parameter_list_t.EXTEND;

559: l_wf_parameter_list_t.EXTEND;
560: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
561:
562: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
563: l_wf_parameter_list_t.EXTEND;
564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
565:
566: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
567: l_wf_parameter_list_t.EXTEND;

Line 564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

560: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
561:
562: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
563: l_wf_parameter_list_t.EXTEND;
564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
565:
566: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
567: l_wf_parameter_list_t.EXTEND;
568: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 567: l_wf_parameter_list_t.EXTEND;

563: l_wf_parameter_list_t.EXTEND;
564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
565:
566: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
567: l_wf_parameter_list_t.EXTEND;
568: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
569:
570: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
571: l_resource_id,

Line 568: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

564: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
565:
566: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
567: l_wf_parameter_list_t.EXTEND;
568: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
569:
570: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
571: l_resource_id,
572: l_resource_type_code,

Line 578: p_parameters => l_wf_parameter_list_t,

574: p_event.getEventKey());
575:
576: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
577: p_event_key => l_event_key,
578: p_parameters => l_wf_parameter_list_t,
579: p_send_date => l_send_date
580: );
581:
582: end if; -- end of create assignment notification

Line 590: l_wf_parameter_list_t.EXTEND;

586: -- raise and sch_dates update alert
587: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
588:
589: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'SCH_UPDATE');
590: l_wf_parameter_list_t.EXTEND;
591: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
592:
593: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
594: l_wf_parameter_list_t.EXTEND;

Line 591: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

587: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
588:
589: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'SCH_UPDATE');
590: l_wf_parameter_list_t.EXTEND;
591: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
592:
593: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
594: l_wf_parameter_list_t.EXTEND;
595: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 594: l_wf_parameter_list_t.EXTEND;

590: l_wf_parameter_list_t.EXTEND;
591: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
592:
593: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
594: l_wf_parameter_list_t.EXTEND;
595: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
596:
597: l_event_key := getItemKey('oracle.apps.csf.updateScheduleDates',
598: l_resource_id,

Line 595: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

591: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
592:
593: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
594: l_wf_parameter_list_t.EXTEND;
595: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
596:
597: l_event_key := getItemKey('oracle.apps.csf.updateScheduleDates',
598: l_resource_id,
599: l_resource_type_code,

Line 605: p_parameters => l_wf_parameter_list_t,

601: p_event.getEventKey());
602:
603: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
604: p_event_key => l_event_key,
605: p_parameters => l_wf_parameter_list_t,
606: p_send_date => l_send_date
607: );
608:
609: end if;