APPS.AZW_UTIL dependencies on WF_NOTIFICATIONS

Line 538: comment wf_notifications.user_comment%TYPE;

534:
535: cur_act_label wf_process_activities.instance_label%TYPE;
536: cur_process_name wf_process_activities.process_name%TYPE;
537: cur_notification_id wf_item_activity_statuses_v.notification_id%TYPE;
538: comment wf_notifications.user_comment%TYPE;
539:
540: BEGIN
541:
542: result := 'FALSE';

Line 549: from wf_notifications wn

545: FETCH wf_act_c INTO pre_act_label, pre_process_name, pre_notification_id;
546: if wf_act_c%FOUND then
547: --Get the previous comment
548: select wn.user_comment into comment
549: from wf_notifications wn
550: where wn.notification_id = pre_notification_id;
551:
552: --Cancel the current message
553: --Deliver the previous message

Line 560: update wf_notifications

556: --Store the comment into the new notification
557: close wf_act_c;
558: open wf_act_c;
559: FETCH wf_act_c INTO cur_act_label, cur_process_name, cur_notification_id;
560: update wf_notifications
561: set user_comment = comment
562: where notification_id = cur_notification_id;
563:
564: result := 'TRUE';