APPS.WF_DIAGNOSTICS dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 882: from wf_notification_attributes

878: select name name,
879: number_value num_val,
880: date_value date_val,
881: text_value txt_val
882: from wf_notification_attributes
883: where notification_id = p_nid;
884:
885: begin
886: dbms_lob.Trim(l_temp, 0);

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

2673: i pls_integer := 1;
2674:
2675: cursor c_ntf is
2676: select wfn.notification_id nid, to_char(begin_date, 'DD-MON-YYYY HH:MI:SS') dt, subject ntf_sub
2677: from wf_notifications wfn, wf_notification_attributes wfa, wf_notification_attributes wfna
2678: where wfn.notification_id=wfa.notification_id and wfn.notification_id=wfna.notification_id
2679: and wfn.message_type = 'WFERROR'
2680: and wfn.message_name = 'DEFAULT_EVENT_ERROR'
2681: and wfa.name = 'EVENT_NAME'

Line 2690: from wf_notification_attributes

2686:
2687: cursor c_ntf_attr(p_nid in number) is
2688: select decode(name, 'ERROR_NAME', 'Error', 'ERROR_MESSAGE', 'Error Message',
2689: 'ERROR_STACK', 'Error Stack', name) name, text_value value
2690: from wf_notification_attributes
2691: where notification_id = p_nid
2692: and name in ('ERROR_NAME', 'ERROR_MESSAGE', 'ERROR_STACK');
2693:
2694: c_ntf_rec c_ntf%rowtype;