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.WF_STANDARD dependencies on WF_NOTIFICATIONS

Line 3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;

3719: l_parmlist_t wf_parameter_list_t;
3720:
3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;

Line 3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;

3720:
3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
3728: l_responder WF_LOCAL_ROLES.NAME%TYPE;

Line 3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;

3721:
3722: l_nid number;
3723: l_subject WF_NOTIFICATIONS.SUBJECT%TYPE;
3724: l_messageType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3725: l_messageName WF_NOTIFICATIONS.MESSAGE_NAME%TYPE;
3726: l_recipient WF_LOCAL_ROLES.NAME%TYPE;
3727: l_recipient_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;
3728: l_responder WF_LOCAL_ROLES.NAME%TYPE;
3729: l_responder_dispname WF_LOCAL_ROLES.DISPLAY_NAME%TYPE;

Line 3798: from wf_notifications

3794: l_nid := l_event_t.getValueForParameter('NOTIFICATION_ID');
3795:
3796: select message_type, message_name, subject, recipient_role, responder
3797: into l_messageType, l_messageName, l_subject, l_recipient, l_responder
3798: from wf_notifications
3799: where notification_id = l_nid;
3800:
3801: l_responder_dispname := WF_DIRECTORY.GetRoleDisplayName(l_responder);
3802: l_recipient_dispname := WF_DIRECTORY.GetRoleDisplayName(l_recipient);

Line 3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;

3903: l_event_t wf_event_t;
3904: l_paramlist wf_parameter_list_t := null;
3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;

Line 3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;

3904: l_paramlist wf_parameter_list_t := null;
3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3912: l_result varchar2(20);

Line 3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;

3905: l_nid number;
3906: l_user WF_LOCAL_ROLES.NAME%TYPE;
3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3912: l_result varchar2(20);
3913: l_err_nid number;

Line 3943: from wf_notifications

3939: begin
3940:
3941: select message_type, item_key, context
3942: into l_itemtype, l_itemkey, l_context
3943: from wf_notifications
3944: where notification_id = l_nid;
3945:
3946: -- extract the activity id
3947: l_actid := to_number(SubStr(l_context, instr(l_context,':',1,2)+1));