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 255: l_wf_parameter_list_t := p_event.getParameterList();

251: begin
252:
253: l_event_name := p_event.getEventName();
254: l_task_asgn_id := p_event.GetValueForParameter('TASK_ASSIGNMENT_ID');
255: l_wf_parameter_list_t := p_event.getParameterList();
256:
257: -- create task assignment event
258: if (l_event_name = 'oracle.apps.jtf.cac.task.createTaskAssignment') then -- event type create
259:

Line 282: l_wf_parameter_list_t.EXTEND;

278:
279: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
280:
281: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
282: l_wf_parameter_list_t.EXTEND;
283: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
284:
285: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
286: l_wf_parameter_list_t.EXTEND;

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

279: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
280:
281: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
282: l_wf_parameter_list_t.EXTEND;
283: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
284:
285: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
286: l_wf_parameter_list_t.EXTEND;
287: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 286: l_wf_parameter_list_t.EXTEND;

282: l_wf_parameter_list_t.EXTEND;
283: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
284:
285: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
286: l_wf_parameter_list_t.EXTEND;
287: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
288:
289: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
290: l_resource_id,

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

283: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
284:
285: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
286: l_wf_parameter_list_t.EXTEND;
287: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
288:
289: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
290: l_resource_id,
291: l_resource_type_code,

Line 297: p_parameters => l_wf_parameter_list_t,

293: p_event.getEventKey());
294:
295: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
296: p_event_key => l_event_key,
297: p_parameters => l_wf_parameter_list_t,
298: p_send_date => l_send_date);
299:
300: end if;
301:

Line 326: l_wf_parameter_list_t.EXTEND;

322:
323: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
324:
325: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
326: l_wf_parameter_list_t.EXTEND;
327: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
328:
329: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
330: l_resource_id,

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

323: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
324:
325: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
326: l_wf_parameter_list_t.EXTEND;
327: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
328:
329: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
330: l_resource_id,
331: l_resource_type_code,

Line 337: p_parameters => l_wf_parameter_list_t,

333: p_event.getEventKey());
334:
335: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
336: p_event_key => l_event_key,
337: p_parameters => l_wf_parameter_list_t,
338: p_send_date => l_send_date);
339:
340: end if;
341:

Line 378: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;

374:
375: -- create notification to new resource
376: if checkAlertsEnabled(l_new_resource, l_new_resource_type) then -- alerts enables?
377:
378: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
379: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
380: l_wf_parameter_list_t.EXTEND;
381: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
382:

Line 380: l_wf_parameter_list_t.EXTEND;

376: if checkAlertsEnabled(l_new_resource, l_new_resource_type) then -- alerts enables?
377:
378: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
379: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
380: l_wf_parameter_list_t.EXTEND;
381: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
382:
383: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
384: l_wf_parameter_list_t.EXTEND;

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

377:
378: l_wf_parameter_list_t_cp := l_wf_parameter_list_t;
379: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
380: l_wf_parameter_list_t.EXTEND;
381: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
382:
383: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
384: l_wf_parameter_list_t.EXTEND;
385: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 384: l_wf_parameter_list_t.EXTEND;

380: l_wf_parameter_list_t.EXTEND;
381: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
382:
383: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
384: l_wf_parameter_list_t.EXTEND;
385: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
386:
387:
388: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',

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

381: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
382:
383: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
384: l_wf_parameter_list_t.EXTEND;
385: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
386:
387:
388: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
389: l_new_resource,

Line 396: p_parameters => l_wf_parameter_list_t,

392: p_event.getEventKey());
393:
394: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
395: p_event_key => l_event_key,
396: p_parameters => l_wf_parameter_list_t,
397: p_send_date => l_send_date
398: );
399:
400: end if; -- alerts enabled?

Line 406: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;

402: -- delete alert to old resource
403: if checkAlertsEnabled(l_old_resource, l_old_resource_type) then -- alerts enabled?
404:
405: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
406: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
407: l_wf_parameter_list_t.EXTEND;
408: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
409:
410: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',

Line 407: l_wf_parameter_list_t.EXTEND;

403: if checkAlertsEnabled(l_old_resource, l_old_resource_type) then -- alerts enabled?
404:
405: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
406: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
407: l_wf_parameter_list_t.EXTEND;
408: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
409:
410: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
411: l_old_resource,

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

404:
405: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE_FOR_UPDATE');
406: l_wf_parameter_list_t := l_wf_parameter_list_t_cp;
407: l_wf_parameter_list_t.EXTEND;
408: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
409:
410: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
411: l_old_resource,
412: l_old_resource_type,

Line 418: p_parameters => l_wf_parameter_list_t,

414: p_event.getEventKey());
415:
416: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
417: p_event_key => l_event_key,
418: p_parameters => l_wf_parameter_list_t,
419: p_send_date => l_send_date);
420:
421: end if; -- alerts enabled?
422:

Line 456: l_wf_parameter_list_t.EXTEND;

452: l_scheduled_end_date);
453:
454: -- delete case
455: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
456: l_wf_parameter_list_t.EXTEND;
457: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
458:
459: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
460: l_resource_id,

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

453:
454: -- delete case
455: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'DELETE');
456: l_wf_parameter_list_t.EXTEND;
457: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
458:
459: l_event_key := getItemKey('oracle.apps.csf.deleteTaskAssignment',
460: l_resource_id,
461: l_resource_type_code,

Line 467: p_parameters => l_wf_parameter_list_t,

463: p_event.getEventKey());
464:
465: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
466: p_event_key => l_event_key,
467: p_parameters => l_wf_parameter_list_t,
468: p_send_date => l_send_date);
469:
470: else -- not a cancel status
471:

Line 490: l_wf_parameter_list_t.EXTEND;

486: if l_assigned_status_flag = 'TRUE' then -- new assignment
487: -- status from non-assigned to assigned
488:
489: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
490: l_wf_parameter_list_t.EXTEND;
491: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
492:
493: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
494: l_wf_parameter_list_t.EXTEND;

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

487: -- status from non-assigned to assigned
488:
489: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
490: l_wf_parameter_list_t.EXTEND;
491: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
492:
493: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
494: l_wf_parameter_list_t.EXTEND;
495: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 494: l_wf_parameter_list_t.EXTEND;

490: l_wf_parameter_list_t.EXTEND;
491: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
492:
493: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
494: l_wf_parameter_list_t.EXTEND;
495: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
496:
497: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
498: l_resource_id,

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

491: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
492:
493: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_new_asgnmnt_status_id));
494: l_wf_parameter_list_t.EXTEND;
495: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
496:
497: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
498: l_resource_id,
499: l_resource_type_code,

Line 505: p_parameters => l_wf_parameter_list_t,

501: p_event.getEventKey());
502:
503: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
504: p_event_key => l_event_key,
505: p_parameters => l_wf_parameter_list_t,
506: p_send_date => l_send_date
507: );
508:
509: end if; -- new assignemnt over

Line 569: l_wf_parameter_list_t.EXTEND;

565: if l_priority_test = 'TRUE'
566: and checkAlertsEnabled(l_resource_id, l_resource_type_code) then -- create assignment notification
567:
568: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
569: l_wf_parameter_list_t.EXTEND;
570: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
571:
572: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
573: l_wf_parameter_list_t.EXTEND;

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

566: and checkAlertsEnabled(l_resource_id, l_resource_type_code) then -- create assignment notification
567:
568: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'CREATE');
569: l_wf_parameter_list_t.EXTEND;
570: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
571:
572: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
573: l_wf_parameter_list_t.EXTEND;
574: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 573: l_wf_parameter_list_t.EXTEND;

569: l_wf_parameter_list_t.EXTEND;
570: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
571:
572: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
573: l_wf_parameter_list_t.EXTEND;
574: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
575:
576: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
577: l_wf_parameter_list_t.EXTEND;

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

570: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
571:
572: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
573: l_wf_parameter_list_t.EXTEND;
574: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
575:
576: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
577: l_wf_parameter_list_t.EXTEND;
578: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 577: l_wf_parameter_list_t.EXTEND;

573: l_wf_parameter_list_t.EXTEND;
574: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
575:
576: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
577: l_wf_parameter_list_t.EXTEND;
578: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
579:
580: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
581: l_resource_id,

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

574: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
575:
576: l_wf_parameter_t := wf_parameter_t('ORG_TASK_ASSGN_STS_ID', to_char(l_org_assignment_status_id));
577: l_wf_parameter_list_t.EXTEND;
578: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
579:
580: l_event_key := getItemKey('oracle.apps.csf.createTaskAssignment',
581: l_resource_id,
582: l_resource_type_code,

Line 588: p_parameters => l_wf_parameter_list_t,

584: p_event.getEventKey());
585:
586: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
587: p_event_key => l_event_key,
588: p_parameters => l_wf_parameter_list_t,
589: p_send_date => l_send_date
590: );
591:
592: end if; -- end of create assignment notification

Line 600: l_wf_parameter_list_t.EXTEND;

596: -- raise and sch_dates update alert
597: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
598:
599: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'SCH_UPDATE');
600: l_wf_parameter_list_t.EXTEND;
601: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
602:
603: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
604: l_wf_parameter_list_t.EXTEND;

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

597: if checkAlertsEnabled(l_resource_id, l_resource_type_code) then
598:
599: l_wf_parameter_t := wf_parameter_t('CSF_EVENT_TYPE', 'SCH_UPDATE');
600: l_wf_parameter_list_t.EXTEND;
601: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
602:
603: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
604: l_wf_parameter_list_t.EXTEND;
605: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;

Line 604: l_wf_parameter_list_t.EXTEND;

600: l_wf_parameter_list_t.EXTEND;
601: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
602:
603: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
604: l_wf_parameter_list_t.EXTEND;
605: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
606:
607: l_event_key := getItemKey('oracle.apps.csf.updateScheduleDates',
608: l_resource_id,

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

601: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
602:
603: l_wf_parameter_t := wf_parameter_t('TASK_ASSIGNMENT_ID', to_char(l_task_asgn_id));
604: l_wf_parameter_list_t.EXTEND;
605: l_wf_parameter_list_t(l_wf_parameter_list_t.count()) := l_wf_parameter_t;
606:
607: l_event_key := getItemKey('oracle.apps.csf.updateScheduleDates',
608: l_resource_id,
609: l_resource_type_code,

Line 615: p_parameters => l_wf_parameter_list_t,

611: p_event.getEventKey());
612:
613: wf_event.raise(p_event_name => 'oracle.apps.csf.alerts.sendNotification',
614: p_event_key => l_event_key,
615: p_parameters => l_wf_parameter_list_t,
616: p_send_date => l_send_date
617: );
618:
619: end if;