DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on WF_NOTIFICATION

Line 826: l_message_name wf_notifications.message_name%TYPE;

822: l_forward_role wf_roles.name%TYPE;
823: l_valid_user VARCHAR2(1);
824: l_due_date DATE;
825: l_priority NUMBER;
826: l_message_name wf_notifications.message_name%TYPE;
827: l_message_type wf_notifications.message_type%TYPE;
828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:

Line 827: l_message_type wf_notifications.message_type%TYPE;

823: l_valid_user VARCHAR2(1);
824: l_due_date DATE;
825: l_priority NUMBER;
826: l_message_name wf_notifications.message_name%TYPE;
827: l_message_type wf_notifications.message_type%TYPE;
828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:
831: l_approver_record ame_util.approverRecord2;

Line 828: l_user_role wf_notifications.recipient_role%TYPE;

824: l_due_date DATE;
825: l_priority NUMBER;
826: l_message_name wf_notifications.message_name%TYPE;
827: l_message_type wf_notifications.message_type%TYPE;
828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:
831: l_approver_record ame_util.approverRecord2;
832: l_forwardee_record ame_util.approverRecord2;

Line 829: l_ntf_status wf_notifications.status%TYPE;

825: l_priority NUMBER;
826: l_message_name wf_notifications.message_name%TYPE;
827: l_message_type wf_notifications.message_type%TYPE;
828: l_user_role wf_notifications.recipient_role%TYPE;
829: l_ntf_status wf_notifications.status%TYPE;
830:
831: l_approver_record ame_util.approverRecord2;
832: l_forwardee_record ame_util.approverRecord2;
833: l_user_id fnd_user.user_id%TYPE;

Line 842: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');

838: WHERE usr.user_name = p_user_name;
839:
840: BEGIN
841: l_nid := wf_engine.context_nid;
842: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
843: l_trx_id := wf_engine.GetItemAttrNumber
844: (itemtype => itemtype,
845: itemkey => itemkey,
846: aname => 'TRX_ID');

Line 947: wf_notification.getInfo(l_nid, l_user_role, l_message_type,

943: ELSE
944: -- Get the role of the person to whom the notification was originally
945: -- assigned
946:
947: wf_notification.getInfo(l_nid, l_user_role, l_message_type,
948: l_message_name, l_priority,
949: l_due_date, l_ntf_status);
950:
951: