DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on WF_NOTIFICATION

Line 868: l_message_name wf_notifications.message_name%TYPE;

864: l_forward_role wf_roles.name%TYPE;
865: l_valid_user VARCHAR2(1);
866: l_due_date DATE;
867: l_priority NUMBER;
868: l_message_name wf_notifications.message_name%TYPE;
869: l_message_type wf_notifications.message_type%TYPE;
870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:

Line 869: l_message_type wf_notifications.message_type%TYPE;

865: l_valid_user VARCHAR2(1);
866: l_due_date DATE;
867: l_priority NUMBER;
868: l_message_name wf_notifications.message_name%TYPE;
869: l_message_type wf_notifications.message_type%TYPE;
870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:
873: l_approver_record ame_util.approverRecord2;

Line 870: l_user_role wf_notifications.recipient_role%TYPE;

866: l_due_date DATE;
867: l_priority NUMBER;
868: l_message_name wf_notifications.message_name%TYPE;
869: l_message_type wf_notifications.message_type%TYPE;
870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:
873: l_approver_record ame_util.approverRecord2;
874: l_forwardee_record ame_util.approverRecord2;

Line 871: l_ntf_status wf_notifications.status%TYPE;

867: l_priority NUMBER;
868: l_message_name wf_notifications.message_name%TYPE;
869: l_message_type wf_notifications.message_type%TYPE;
870: l_user_role wf_notifications.recipient_role%TYPE;
871: l_ntf_status wf_notifications.status%TYPE;
872:
873: l_approver_record ame_util.approverRecord2;
874: l_forwardee_record ame_util.approverRecord2;
875: l_user_id fnd_user.user_id%TYPE;

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

889: FROM fnd_user usr
890: WHERE usr.email_address = p_user_email;
891: BEGIN
892: l_nid := wf_engine.context_nid;
893: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
894: l_trx_id := wf_engine.GetItemAttrNumber
895: (itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'TRX_ID');

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

1033: ELSE
1034: -- Get the role of the person to whom the notification was originally
1035: -- assigned
1036:
1037: wf_notification.getInfo(l_nid, l_user_role, l_message_type,
1038: l_message_name, l_priority,
1039: l_due_date, l_ntf_status);
1040:
1041: l_approver_record.approval_status := AME_UTIL.forwardStatus;