702: p_event,
703: res,
704: executed);
705: if (not executed) then
706: -- p_rule_func came from WF_EVENT_SUBSCRIPTIONS.Rule_Function or
707: -- WF_EVENT_SUBSCRIPTIONS.Java_Rule_Func
708: myfunc := p_rule_func;
709: -- BINDVAR_SCAN_IGNORE
710: cmd := 'begin :v1 := '||myfunc||'(:v2, :v3); end;';
703: res,
704: executed);
705: if (not executed) then
706: -- p_rule_func came from WF_EVENT_SUBSCRIPTIONS.Rule_Function or
707: -- WF_EVENT_SUBSCRIPTIONS.Java_Rule_Func
708: myfunc := p_rule_func;
709: -- BINDVAR_SCAN_IGNORE
710: cmd := 'begin :v1 := '||myfunc||'(:v2, :v3); end;';
711: execute immediate cmd using in out res,
1977: eguid raw(16);
1978: l_skip_sub raw(16);
1979: event_count NUMBER;
1980: l_rule_func varchar2(300);
1981: l_source_type wf_event_subscriptions.source_type%type;
1982: l_phase wf_event_subscriptions.phase%type;
1983: l_rule_data wf_event_subscriptions.rule_data%type;
1984: l_priority wf_event_subscriptions.priority%type;
1985: l_on_error wf_event_subscriptions.on_error_code%type;
1978: l_skip_sub raw(16);
1979: event_count NUMBER;
1980: l_rule_func varchar2(300);
1981: l_source_type wf_event_subscriptions.source_type%type;
1982: l_phase wf_event_subscriptions.phase%type;
1983: l_rule_data wf_event_subscriptions.rule_data%type;
1984: l_priority wf_event_subscriptions.priority%type;
1985: l_on_error wf_event_subscriptions.on_error_code%type;
1986: --Bug 2437354
1979: event_count NUMBER;
1980: l_rule_func varchar2(300);
1981: l_source_type wf_event_subscriptions.source_type%type;
1982: l_phase wf_event_subscriptions.phase%type;
1983: l_rule_data wf_event_subscriptions.rule_data%type;
1984: l_priority wf_event_subscriptions.priority%type;
1985: l_on_error wf_event_subscriptions.on_error_code%type;
1986: --Bug 2437354
1987: trig_savepoint exception;
1980: l_rule_func varchar2(300);
1981: l_source_type wf_event_subscriptions.source_type%type;
1982: l_phase wf_event_subscriptions.phase%type;
1983: l_rule_data wf_event_subscriptions.rule_data%type;
1984: l_priority wf_event_subscriptions.priority%type;
1985: l_on_error wf_event_subscriptions.on_error_code%type;
1986: --Bug 2437354
1987: trig_savepoint exception;
1988: pragma exception_init(trig_savepoint, -04092);
1981: l_source_type wf_event_subscriptions.source_type%type;
1982: l_phase wf_event_subscriptions.phase%type;
1983: l_rule_data wf_event_subscriptions.rule_data%type;
1984: l_priority wf_event_subscriptions.priority%type;
1985: l_on_error wf_event_subscriptions.on_error_code%type;
1986: --Bug 2437354
1987: trig_savepoint exception;
1988: pragma exception_init(trig_savepoint, -04092);
1989: