[Home] [Help]
275: callback cb,
276: context ctx,
277: responder resp,
278: subject subj
279: from wf_notifications
280: where notification_id = p_nid;
281:
282: l_ntf_rec c_ntf%rowtype;
283: l_cells tdType;
374: l_temp varchar2(32000);
375: l_cnt number := 0;
376: cursor c_grp_ntf is
377: select NOTIFICATION_ID, RECIPIENT_ROLE, STATUS, MAIL_STATUS, BEGIN_DATE, END_DATE
378: from WF_NOTIFICATIONS
379: where GROUP_ID=p_nid and
380: GROUP_ID<>NOTIFICATION_ID;
381: i number := 0;
382:
438: l_temp varchar2(32000);
439:
440: CURSOR user_curs IS
441: SELECT wur.user_name
442: FROM wf_user_roles wur, wf_notifications wn
443: WHERE wur.role_name = wn.recipient_role
444: AND wn.notification_id = p_nid;
445:
446: l_cells tdType;
538: l_cells(9) := '5%:Installed';
539:
540: SELECT recipient_role
541: INTO l_role
542: FROM wf_notifications
543: WHERE notification_id = p_nid;
544:
545: Wf_Directory.GetRoleInfoMail(l_role, l_dname, l_email, l_npref, l_lang, l_terr,
546: l_orig_sys, l_orig_id, l_install);
754: l_cells(9) := '5%:Installed';
755:
756: SELECT more_info_role
757: INTO l_role
758: FROM wf_notifications
759: WHERE notification_id = p_nid;
760:
761: if (l_role is not null) then
762:
814: wra.type,
815: nvl(nvl(wra.text_value, to_char(wra.number_value)), to_char(wra.date_value)) value
816: FROM wf_routing_rules wr,
817: wf_routing_rule_attributes wra,
818: wf_notifications wn
819: WHERE wr.rule_id = wra.rule_id (+)
820: AND (wr.role = wn.recipient_role or wr.action_argument = wn.recipient_role)
821: AND wn.notification_id = p_nid;
822:
885: wma.text_default) value,
886: wma.format format
887: from wf_message_attributes wma,
888: wf_message_attributes_tl wmat,
889: wf_notifications wn
890: where wma.message_name = wmat.message_name
891: and wma.message_type = wmat.message_type
892: and wma.name = wmat.name
893: and wmat.language = userenv('LANG')
1037: i := 4;
1038:
1039: select message_type, message_name, language
1040: into l_msg_type, l_msg_name, l_lang_code
1041: from wf_notifications
1042: where notification_id = p_nid;
1043:
1044: begin
1045:
1476: l_cells.DELETE;
1477:
1478: select status, mail_status, message_type, message_name, recipient_role
1479: into l_status, l_mstatus, l_msg_type, l_msg_name, l_recip_role
1480: from wf_notifications
1481: where notification_id = p_nid;
1482:
1483: if (l_mstatus not in ('MAIL')) then
1484: wf_mail.test_flag := TRUE;
1978:
1979: begin
1980: select recipient_role, message_type
1981: into l_role, l_msg_type
1982: from wf_notifications
1983: where notification_id = p_nid;
1984: exception
1985: when others then
1986: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
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'
2956:
2957: SELECT wn.notification_id, to_char(wn.begin_date, 'DD-MON-YYYY HH:MI:SS'), subject,
2958: error_message, error_name, error_stack
2959: INTO l_nid, l_date, l_subject, l_err_msg, l_err_name, l_err_stack
2960: FROM wf_notifications wn,
2961: wf_item_activity_statuses wias
2962: WHERE wn.notification_id = l_ntf_id
2963: AND wias.notification_id = l_ntf_id
2964: AND wn.message_type = wias.item_type
3084:
3085: begin
3086: select null
3087: into l_dummy
3088: from wf_notifications
3089: where notification_id = p_nid;
3090: exception
3091: when NO_DATA_FOUND then
3092: l_cells(1) := 'WH:Notification Id '||p_nid||' has been purged and is not available in the Database.';
3139: -- which mail status is null and no
3140: begin
3141: select count(1)
3142: into l_group_cnt
3143: from WF_NOTIFICATIONS
3144: where GROUP_ID=p_nid;
3145: end;
3146: if l_group_cnt>1 then
3147: g_group_ntf := TRUE;