APPS.WF_DIAGNOSTICS dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 956: from wf_notification_attributes

952: select name name,
953: number_value num_val,
954: date_value date_val,
955: text_value txt_val
956: from wf_notification_attributes
957: where notification_id = p_nid;
958:
959: begin
960: dbms_lob.Trim(l_temp, 0);

Line 2904: -- using both wf_notification_attributes and wf_item_activity_statuses tables

2900: END Get_Ntf_Msg_From_In;
2901:
2902: --
2903: -- Bug 6677333: Modified the logic so that error message will be retrieved
2904: -- using both wf_notification_attributes and wf_item_activity_statuses tables
2905: --
2906: -- Get_Error_Ntf_Details
2907: -- Gets the Details of the Error Notification, if any
2908: function Get_Error_Ntf_Details(p_event_name in varchar2,

Line 2926: from wf_notifications wfn, wf_notification_attributes wfa, wf_notification_attributes wfna

2922: l_ntf_id number;
2923:
2924: cursor c_ntf is
2925: select wfn.notification_id nid, to_char(begin_date, 'DD-MON-YYYY HH:MI:SS') dt, subject ntf_sub
2926: from wf_notifications wfn, wf_notification_attributes wfa, wf_notification_attributes wfna
2927: where wfn.notification_id = wfa.notification_id and wfn.notification_id = wfna.notification_id
2928: and wfn.message_type = 'WFERROR'
2929: and wfn.message_name in ('DEFAULT_EVENT_ERROR' , 'DEFAULT_EVENT_EXT_ERROR')
2930: and wfa.name = 'EVENT_NAME'

Line 2939: from wf_notification_attributes

2935:
2936: cursor c_ntf_attr(p_nid in number) is
2937: select decode(name, 'ERROR_NAME', 'Error', 'ERROR_MESSAGE', 'Error Message',
2938: 'ERROR_STACK', 'Error Stack', name) name, text_value value
2939: from wf_notification_attributes
2940: where notification_id = p_nid
2941: and name in ('ERROR_NAME', 'ERROR_MESSAGE', 'ERROR_STACK');
2942:
2943: c_ntf_rec c_ntf%rowtype;