672: p_event,
673: res,
674: executed);
675: if (not executed) then
676: -- p_rule_func came from WF_EVENT_SUBSCRIPTIONS.Rule_Function or
677: -- WF_EVENT_SUBSCRIPTIONS.Java_Rule_Func
678: myfunc := p_rule_func;
679: -- BINDVAR_SCAN_IGNORE
680: cmd := 'begin :v1 := '||myfunc||'(:v2, :v3); end;';
673: res,
674: executed);
675: if (not executed) then
676: -- p_rule_func came from WF_EVENT_SUBSCRIPTIONS.Rule_Function or
677: -- WF_EVENT_SUBSCRIPTIONS.Java_Rule_Func
678: myfunc := p_rule_func;
679: -- BINDVAR_SCAN_IGNORE
680: cmd := 'begin :v1 := '||myfunc||'(:v2, :v3); end;';
681: execute immediate cmd using in out res,
1920: eguid raw(16);
1921: l_skip_sub raw(16);
1922: event_count NUMBER;
1923: l_rule_func varchar2(300);
1924: l_source_type wf_event_subscriptions.source_type%type;
1925: l_phase wf_event_subscriptions.phase%type;
1926: l_rule_data wf_event_subscriptions.rule_data%type;
1927: l_priority wf_event_subscriptions.priority%type;
1928: l_on_error wf_event_subscriptions.on_error_code%type;
1921: l_skip_sub raw(16);
1922: event_count NUMBER;
1923: l_rule_func varchar2(300);
1924: l_source_type wf_event_subscriptions.source_type%type;
1925: l_phase wf_event_subscriptions.phase%type;
1926: l_rule_data wf_event_subscriptions.rule_data%type;
1927: l_priority wf_event_subscriptions.priority%type;
1928: l_on_error wf_event_subscriptions.on_error_code%type;
1929: --Bug 2437354
1922: event_count NUMBER;
1923: l_rule_func varchar2(300);
1924: l_source_type wf_event_subscriptions.source_type%type;
1925: l_phase wf_event_subscriptions.phase%type;
1926: l_rule_data wf_event_subscriptions.rule_data%type;
1927: l_priority wf_event_subscriptions.priority%type;
1928: l_on_error wf_event_subscriptions.on_error_code%type;
1929: --Bug 2437354
1930: trig_savepoint exception;
1923: l_rule_func varchar2(300);
1924: l_source_type wf_event_subscriptions.source_type%type;
1925: l_phase wf_event_subscriptions.phase%type;
1926: l_rule_data wf_event_subscriptions.rule_data%type;
1927: l_priority wf_event_subscriptions.priority%type;
1928: l_on_error wf_event_subscriptions.on_error_code%type;
1929: --Bug 2437354
1930: trig_savepoint exception;
1931: pragma exception_init(trig_savepoint, -04092);
1924: l_source_type wf_event_subscriptions.source_type%type;
1925: l_phase wf_event_subscriptions.phase%type;
1926: l_rule_data wf_event_subscriptions.rule_data%type;
1927: l_priority wf_event_subscriptions.priority%type;
1928: l_on_error wf_event_subscriptions.on_error_code%type;
1929: --Bug 2437354
1930: trig_savepoint exception;
1931: pragma exception_init(trig_savepoint, -04092);
1932: