2079: -- (in timeout mode).
2080: if ((l_voting_option = 'REQUIRE_ALL_VOTES') or
2081: ((funcmode = wf_engine.eng_run) and
2082: (l_voting_option = 'WAIT_FOR_ALL_VOTES'))) then
2083: if (wf_notification.OpenNotificationsExist(l_group_id)) then
2084: resultout := wf_engine.eng_waiting;
2085: return;
2086: end if;
2087: end if;
2093: -- d. REQUIRE_ALL_VOTES and all votes are cast
2094: -- Tally votes.
2095: for result_rec in result_codes loop
2096: -- Tally Vote Count for this result code
2097: Wf_Notification.VoteCount(l_group_id,result_rec.result_code,
2098: l_code_count,l_per_of_total,l_per_of_vote);
2099:
2100: -- If this is timeout mode, then use the percent of votes cast so far.
2101: -- If this is run mode, then use the percent of total votes possible.
2145: resultout := wf_engine.eng_completed||':'||result;
2146: else
2147: -- If we get here no non-default results were satisfied.
2148: if (funcmode = wf_engine.eng_run and
2149: wf_notification.OpenNotificationsExist(l_group_id)) then
2150: -- Not timed out and still open notifications.
2151: -- Return waiting to continue voting.
2152: resultout := wf_engine.eng_waiting;
2153: elsif (default_result is not null) then
3000: i pls_integer;
3001:
3002: l_event_t wf_event_t;
3003: l_parmlist_t wf_parameter_list_t;
3004: l_cells wf_notification.tdType;
3005: j number;
3006: l_result varchar2(32000);
3007:
3008: begin
3040: --
3041: l_send_date := l_event_t.GetSendDate();
3042:
3043: IF l_send_date IS NOT NULL THEN
3044: l_send_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_send_date, null, true);
3045: END IF;
3046:
3047: l_receive_date := l_event_t.GetReceiveDate();
3048:
3046:
3047: l_receive_date := l_event_t.GetReceiveDate();
3048:
3049: IF l_receive_date IS NOT NULL THEN
3050: l_receive_date_text := WF_NOTIFICATION_UTIL.GetCalendarDate(-1, l_receive_date, null, true);
3051: END IF;
3052:
3053: --
3054: -- Get the Priority
3058: --
3059: -- Build up the PL/SQL Document depending on the User Mail Preference
3060: --
3061: -- bug 6955474
3062: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3063: --
3064: -- Build the Table
3065: if (display_type = wf_notification.doc_html) then
3066: i := 1;
3061: -- bug 6955474
3062: -- Using WF_NOTIFICATION.NTF_Table API to maintain consistency with BLAF
3063: --
3064: -- Build the Table
3065: if (display_type = wf_notification.doc_html) then
3066: i := 1;
3067: l_cells(i) := wf_core.translate('WF_EVENT_HEADING');
3068: l_cells(i) := 'S30%:'||l_cells(i);
3069:
3150: l_parmlist_t := l_event_t.getParameterList();
3151: if (l_parmlist_t is not null) then
3152: j := l_parmlist_t.FIRST;
3153: while (j <= l_parmlist_t.LAST) loop
3154: if (display_type = wf_notification.doc_html) then
3155: i := i + 1;
3156: l_cells(i) := 'S:'||wf_core.translate('WF_PARAMETER')||' : '||l_parmlist_t(j).getName();
3157:
3158: i := i + 1;
3166: j := l_parmlist_t.NEXT(j);
3167: end loop;
3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',
3167: end loop;
3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',
3175: rs => l_result);
3168: end if;
3169:
3170: if (display_type = wf_notification.doc_html) then
3171: document_type := wf_notification.doc_html;
3172: wf_notification.NTF_Table(cells => l_cells,
3173: col => 2,
3174: type => 'H',
3175: rs => l_result);
3176: -- Display title
3178: '
3436: l_item_key varchar2(240);
3437: l_subscription raw(16);
3438: l_params varchar2(4000);
3439: l_rule_func varchar2(240);
3440: l_cells wf_notification.tdType;
3441: l_cells2 wf_notification.tdType;
3442: i pls_integer;
3443: j pls_integer;
3444: l_document varchar2(32000);
3437: l_subscription raw(16);
3438: l_params varchar2(4000);
3439: l_rule_func varchar2(240);
3440: l_cells wf_notification.tdType;
3441: l_cells2 wf_notification.tdType;
3442: i pls_integer;
3443: j pls_integer;
3444: l_document varchar2(32000);
3445: l_sub_param_list wf_parameter_list_t;
3467: WHERE guid = l_subscription;
3468:
3469: l_sub_param_list := wf_event.GetParamListFromString(l_params);
3470:
3471: if (display_type = wf_notification.doc_html) then
3472: i := 1;
3473: l_cells(i) := 'S30%:'||wf_core.Translate('WF_PARAMETER');
3474:
3475: i := i + 1;
3483: -- meta-data store for WS definition
3484: if (l_sub_param_list is not null) then
3485: j := l_sub_param_list.FIRST;
3486: while (j is not null) loop
3487: if (display_type = wf_notification.doc_html) then
3488: i := i + 1;
3489: l_cells(i) := 'S:'||l_sub_param_list(j).getName();
3490:
3491: i := i + 1;
3506: l_sub_url := wf_engine.GetItemAttrText(itemtype => l_item_type,
3507: itemkey => l_item_key,
3508: aname => 'EVENT_SUBSCRIPTION');
3509:
3510: if (display_type = wf_notification.doc_html) then
3511: i := i + 1;
3512: l_cells(i) := 'S:'||wf_core.Translate('WF_INOKER_RULE_FUNC');
3513: i := i + 1;
3514: l_cells(i) := 'S:'||l_rule_func;
3524: i := i + 1;
3525: l_url := ''||wf_core.Translate('WF_CLICK_HERE')||'';
3526: l_cells(i) := 'S:'||l_url;
3527:
3528: wf_notification.Ntf_Table(l_cells, 2, 'H', l_result);
3529:
3530: -- Display title "Web Service Details"
3531: l_result := '
'||wf_core.Translate('WF_WEBSERVICE_DETAILS')||' |
'||wf_core.Translate('WF_ERROR_DETAILS') || 3615: ' |
'||l_result||' |