The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(1) into member_count
from WF_EVENTS
where GUID = x_guid
and CUSTOMIZATION_LEVEL in ('C','L');
select count(1) into member_count
from WF_EVENT_SUBSCRIPTIONS
where EVENT_FILTER_GUID = x_guid;
select count(1) into member_count
from WF_EVENT_SUBSCRIPTIONS
where SYSTEM_GUID = x_guid;
select count(1) into member_count
from WF_SYSTEMS
where MASTER_GUID = x_guid;
select count(1) into member_count
from WF_EVENT_SUBSCRIPTIONS
where SOURCE_AGENT_GUID = x_guid
or OUT_AGENT_GUID = x_guid
or TO_AGENT_GUID = x_guid;
select count(1) into member_count
from WF_EVENT_SUBSCRIPTIONS
where GUID = x_guid
and CUSTOMIZATION_LEVEL in ('C','L');
select count(1) into member_count
from WF_AGENTS
where SYSTEM_GUID = x_guid;
select count(1) into member_count
from wf_event_groups
where member_guid = x_guid;
select count(*) into l_count
from wf_systems
where guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
select count(*) into l_count
from wf_agents
where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
select count(*) into l_count
from wf_events;
select count(*) into l_count
from wf_event_subscriptions
where system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
from WF_EVENTS_VL
where (xt = '*' or TYPE = xt)
and (xdn is null or lower(DISPLAY_NAME) like '%'||lower(xdn)||'%')
and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
and (xs = '*' or STATUS = xs)
order by NAME;
dTab(i).selectable := FALSE;
hTab(i).value := 'Wf_Event_Html.DeleteEvent?h_guid=';
select GUID, DISPLAY_NAME, NAME, MASTER_GUID
from WF_SYSTEMS
where (xdn is null or lower(DISPLAY_NAME) like '%'||lower(xdn)||'%')
and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
and (mguid is null or MASTER_GUID = mguid)
order by NAME;
select hextoraw(TEXT)
into l_localsys
from WF_RESOURCES
where NAME = 'WF_SYSTEM_GUID'
and LANGUAGE = userenv('LANG');
select NAME
into l_mname
from WF_SYSTEMS
where GUID = asystem.master_guid;
dTab(i).selectable := FALSE;
select count(1) into acnt
from WF_EVENT_SUBSCRIPTIONS
where SYSTEM_GUID = asystem.guid;
hTab(i).value := 'Wf_Event_Html.DeleteSystem?h_guid=';
select A.GUID, A.NAME, A.PROTOCOL, A.ADDRESS,
S.NAME SYSTEM_NAME,
A.DIRECTION, A.STATUS
from WF_AGENTS A, WF_SYSTEMS S
where (xn is null or lower(A.NAME) like '%'||lower(xn)||'%')
and (xp is null or A.PROTOCOL = xp)
and (xa is null or A.ADDRESS = xa)
and (sguid is null or S.GUID = sguid)
and A.SYSTEM_GUID = S.GUID
and (xd = '*' or A.DIRECTION = xd)
and (xs = '*' or A.STATUS = xs)
order by SYSTEM_NAME, A.NAME, A.ADDRESS, A.PROTOCOL;
dTab(i).selectable := FALSE;
hTab(i).value := 'Wf_Event_Html.DeleteAgent?h_guid=';
select ES.GUID,
ES.SYSTEM_GUID, ES.SOURCE_TYPE, ES.EVENT_FILTER_GUID,
ES.STATUS,
ES.OUT_AGENT_GUID, ES.TO_AGENT_GUID,
ES.RULE_FUNCTION, ES.WF_PROCESS_TYPE, ES.WF_PROCESS_NAME,
SY.NAME SYSTEM_NAME, E.NAME EVENT_NAME
from WF_EVENT_SUBSCRIPTIONS ES, WF_EVENTS E, WF_SYSTEMS SY
where (eguid is null or ES.EVENT_FILTER_GUID = eguid)
and (xt = '*' or ES.SOURCE_TYPE = xt)
and (sguid is null or ES.SYSTEM_GUID = sguid)
and (xs = '*' or ES.STATUS = xs)
and E.GUID (+)= ES.EVENT_FILTER_GUID
and SY.GUID (+)= ES.SYSTEM_GUID
order by SYSTEM_NAME, EVENT_NAME, ES.PHASE;
select NAME
into l_name
from WF_SYSTEMS
where GUID = l_sguid;
select NAME
into l_name
from WF_EVENTS
where GUID = l_eguid;
select S.NAME
into dTab(i).col03
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = ssr.out_agent_guid
and A.SYSTEM_GUID = S.GUID;
select NAME
into dTab(i).col03
from WF_AGENTS
where GUID = ssr.out_agent_guid;
select A.NAME||'@'||dTab(i).col03
into dTab(i).col03
from WF_AGENTS A
where A.GUID = ssr.out_agent_guid;
select S.NAME
into dTab(i).col04
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = ssr.to_agent_guid
and A.SYSTEM_GUID = S.GUID;
select A.NAME
into dTab(i).col04
from WF_AGENTS A
where A.GUID = ssr.to_agent_guid;
select A.NAME||'@'||dTab(i).col04
into dTab(i).col04
from WF_AGENTS A
where A.GUID = ssr.to_agent_guid;
dTab(i).selectable := FALSE;
hTab(i).value := 'Wf_Event_Html.DeleteSubscription?h_guid=';
template varchar2(4000); -- Use for construct form select list
select_enable varchar2(8);
select_disable varchar2(8);
select_event varchar2(8) := 'SELECTED';
select_group varchar2(8);
select_custom_core varchar2(8);
select_custom_limit varchar2(8);
select_custom_extend varchar2(8);
select_custom_user varchar2(8);
select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
where EG.GROUP_GUID = h_guid
and E.GUID = EG.MEMBER_GUID;
select NAME, DISPLAY_NAME, DESCRIPTION, TYPE, STATUS,
GENERATE_FUNCTION, OWNER_NAME, OWNER_TAG, NVL(CUSTOMIZATION_LEVEL, 'L')
into l_name, l_dname, l_desc, l_type, l_status,
l_gfunc, l_ownname, l_owntag, l_customization_level
from WF_EVENTS_VL
where GUID = h_guid;
select_enable := 'SELECTED';
select_disable := null;
select_enable := null;
select_disable := 'SELECTED';
select_custom_core := 'SELECTED';
select_custom_limit := null;
select_custom_extend := null;
select_custom_user := null;
select_custom_core := null;
select_custom_limit := 'SELECTED';
select_custom_extend := null;
select_custom_user := null;
select_custom_core := null;
select_custom_limit := null;
select_custom_extend := null;
select_custom_user := 'SELECTED';
select_group := 'SELECTED';
select_event := null;
select count(1) into eventcount
from WF_EVENT_GROUPS
where GROUP_GUID = h_guid;
template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('ENABLED'),
select_enable,'VALUE="ENABLED"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('DISABLED'),
select_disable,'VALUE="DISABLED"')
||wf_core.newline||
htf.formSelectClose;
template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_C'),
select_custom_core,'VALUE="C"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_L'),
select_custom_limit,'VALUE="L"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_U'),
select_custom_user,'VALUE="U"')
||wf_core.newline||
htf.formSelectClose;
dTab(i).col01:= '';
dTab(i).selectable := TRUE;
'Wf_Event_Html.SubmitSelectedGEvents',
cmethod=>'Post',
cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
hTab(i).value := null; -- delete is not allowed here
wf_core.translate('SELECT_ALL'),
wfa_html.image_loc,
null,
wf_core.translate('SELECT_ALL'));
wf_core.translate('UNSELECT_ALL'),
wfa_html.image_loc,
null,
wf_core.translate('UNSELECT_ALL'));
'javascript:document.WF_GROUP_EDIT.action.value=''DELETE'';'||
wf_core.translate('DELETE'),
wfa_html.image_loc,
null,
wf_core.translate('DELETE'));
h_func in varchar2 default 'DELETE',
h_display_name in varchar2 default null,
h_name in varchar2 default null,
h_status in varchar2 default '*',
h_type in varchar2 default '*'
)
is
-- addable event cursor
-- all events meet the query criteria excluding the group itself
cursor aevcurs is
select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
from WF_EVENTS_VL
where (h_type = '*' or TYPE = h_type)
and (h_display_name is null or lower(DISPLAY_NAME) like
'%'||lower(h_display_name)||'%')
and (h_name is null or lower(NAME) like '%'||lower(h_name)||'%')
and (h_status = '*' or STATUS = h_status)
and GUID <> h_guid
order by NAME;
select E.GUID, E.DISPLAY_NAME, E.NAME, E.STATUS
from WF_EVENTS_VL E, WF_EVENT_GROUPS EG
where EG.GROUP_GUID = h_guid
and E.GUID = EG.MEMBER_GUID;
select NAME, DISPLAY_NAME
into l_name, l_dname
from WF_EVENTS_VL
where GUID = h_guid;
htp.tableData(cvalue=>wf_core.translate('WFE_ADD_SELECTED_TO_GRP'),
calign=>'Left',cattributes=>'id=""');
if (h_func = 'DELETE') then
for event in devcurs loop
i := i+1;
dTab(i).selectable := TRUE;
dTab(i).selectable := TRUE;
'Wf_Event_Html.SubmitSelectedGEvents',
cmethod=>'Get',
cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
wf_core.translate('SELECT_ALL'), null);
wf_core.translate('UNSELECT_ALL'), null);
if (h_func = 'DELETE') then
-- Delete Screen
-- Allow user to delete selected events
-- or add some more event through the find screen.
htp.p('');
Line: 2262
'javascript:document.WF_GROUP_EDIT.action.value=''DELETE'';'||
Line: 2264
wf_core.translate('DELETE_SELECTED'),
wfa_html.image_loc,
null,
wf_core.translate('DELETE_SELECTED'));
Line: 2286
wf_core.translate('ADD_SELECTED'),
wfa_html.image_loc,
null,
wf_core.translate('ADD_SELECTED'));
Line: 2324
template varchar2(4000); -- Use for construct form select list
Line: 2374
select NAME, DISPLAY_NAME, DESCRIPTION, MASTER_GUID
into l_name, l_dname, l_desc, l_mguid
from WF_SYSTEMS
where GUID = h_guid;
Line: 2386
select NAME
into l_mname
from WF_SYSTEMS
where GUID = l_mguid;
Line: 2553
template varchar2(4000); -- Use for construct form select list
Line: 2573
select_in varchar2(8);
Line: 2574
select_out varchar2(8);
Line: 2575
select_enable varchar2(8);
Line: 2576
select_disable varchar2(8);
Line: 2579
select LOOKUP_CODE, MEANING
from WF_LOOKUPS
where LOOKUP_TYPE = 'WF_AQ_PROTOCOLS'
order by lookup_code desc;
Line: 2584
selected boolean := FALSE; -- indicator if a lookup has been selected.
Line: 2623
select A.NAME, A.DISPLAY_NAME, A.DESCRIPTION, A.PROTOCOL, A.ADDRESS,
A.SYSTEM_GUID, A.QUEUE_HANDLER, A.QUEUE_NAME,
A.DIRECTION, A.STATUS, S.NAME
into l_name, l_dname, l_desc, l_protocol, l_address,
l_sysguid, l_qhandler, l_qname,
l_direction, l_status, l_system
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = h_guid
and A.SYSTEM_GUID = S.GUID;
Line: 2640
select_in := 'SELECTED';
Line: 2643
select_out := 'SELECTED';
Line: 2649
select_enable := 'SELECTED';
Line: 2650
select_disable := null;
Line: 2652
select_enable := null;
Line: 2653
select_disable := 'SELECTED';
Line: 2716
template := htf.formSelectOpen('h_protocol',cattributes=>'id="i_protocol"')
||wf_core.newline;
Line: 2721
template := template||htf.formSelectOption(prtr.meaning, 'SELECTED',
'VALUE="'||prtr.lookup_code||'"')||wf_core.newline;
Line: 2723
selected := TRUE;
Line: 2725
template := template||htf.formSelectOption(prtr.meaning, '',
'VALUE="'||prtr.lookup_code||'"')||wf_core.newline;
Line: 2729
if (not selected) then
template := template||htf.formSelectOption(prtr.meaning, 'SELECTED',
'VALUE="'||prtr.lookup_code||'"')||wf_core.newline;
Line: 2732
selected := TRUE;
Line: 2734
template := template||htf.formSelectOption(prtr.meaning, '',
'VALUE="'||prtr.lookup_code||'"')||wf_core.newline;
Line: 2741
if (not selected) then
template := template||htf.formSelectOption(l_protocol, 'SELECTED',
'VALUE="'||l_protocol||'"')||wf_core.newline;
Line: 2744
selected := TRUE;
Line: 2746
template := template||htf.formSelectClose;
Line: 2822
template := htf.formSelectOpen('h_direction', cattributes=>'id="i_direction"')||wf_core.newline||
/*
htf.formSelectOption(wf_core.translate('ANY'),
select_any,'VALUE="ANY"')
||wf_core.newline||
*/
htf.formSelectOption(wf_core.translate('IN'),
select_in,'VALUE="IN"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('OUT'),
select_out,'VALUE="OUT"')
||wf_core.newline||
htf.formSelectClose;
Line: 2843
template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('ENABLED'),
select_enable,'VALUE="ENABLED"')||
wf_core.newline||
htf.formSelectOption(wf_core.translate('DISABLED'),
select_disable,'VALUE="DISABLED"')
||wf_core.newline||
htf.formSelectClose;
Line: 2922
template varchar2(4000); -- Use for construct form select list
Line: 2951
select_enable varchar2(8);
Line: 2952
select_disable varchar2(8);
Line: 2953
select_any varchar2(8);
Line: 2954
select_local varchar2(8);
Line: 2955
select_external varchar2(8);
Line: 2956
select_error varchar2(8);
Line: 2957
select_key varchar2(8);
Line: 2958
select_message varchar2(8);
Line: 2959
select_function varchar2(8);
Line: 2960
select_agent varchar2(8);
Line: 2961
select_workflow varchar2(8);
Line: 2962
select_low varchar2(8);
Line: 2963
select_high varchar2(8);
Line: 2964
select_normal varchar2(8);
Line: 2966
select_custom_core varchar2(8);
Line: 2967
select_custom_limit varchar2(8);
Line: 2968
select_custom_extend varchar2(8);
Line: 2969
select_custom_user varchar2(8);
Line: 3037
select SYSTEM_GUID,
SOURCE_TYPE,
SOURCE_AGENT_GUID,
EVENT_FILTER_GUID,
PHASE,
STATUS,
OWNER_NAME,
OWNER_TAG,
RULE_DATA,
RULE_FUNCTION,
OUT_AGENT_GUID,
TO_AGENT_GUID,
PRIORITY,
WF_PROCESS_TYPE,
WF_PROCESS_NAME,
PARAMETERS,
CUSTOMIZATION_LEVEL,
DESCRIPTION
into l_sysguid,
l_srctype,
l_srcagnguid,
l_evtguid,
l_phase,
l_status,
l_ownname,
l_owntag,
l_ruled,
l_rulef,
l_outagnguid,
l_toagnguid,
l_priority,
l_wfptype,
l_wfpname,
l_param,
l_customization_level,
l_desc
from WF_EVENT_SUBSCRIPTIONS
where GUID = h_guid;
Line: 3084
select_external := 'SELECTED';
Line: 3086
select_local := 'SELECTED';
Line: 3088
select_error := 'SELECTED';
Line: 3093
select_enable := 'SELECTED';
Line: 3095
select_disable := 'SELECTED';
Line: 3100
select_message := 'SELECTED';
Line: 3102
select_key := 'SELECTED';
Line: 3107
select_custom_core := 'SELECTED';
Line: 3108
select_custom_limit := null;
Line: 3109
select_custom_extend := null;
Line: 3110
select_custom_user := null;
Line: 3112
select_custom_core := null;
Line: 3113
select_custom_limit := 'SELECTED';
Line: 3114
select_custom_extend := null;
Line: 3115
select_custom_user := null;
Line: 3117
select_custom_core := null;
Line: 3118
select_custom_limit := null;
Line: 3119
select_custom_extend := null;
Line: 3120
select_custom_user := 'SELECTED';
Line: 3125
select_high := 'SELECTED';
Line: 3128
select_low := 'SELECTED';
Line: 3131
select_normal := 'SELECTED';
Line: 3143
select NAME
into l_system_name
from WF_SYSTEMS
where GUID = l_sysguid;
Line: 3160
select NAME
into l_event_name
from WF_EVENTS_VL
where GUID = l_evtguid;
Line: 3176
select A.NAME||'@'||S.NAME
into l_srcagn_dname
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = l_srcagnguid
and A.SYSTEM_GUID (+)= S.GUID;
Line: 3192
select A.NAME||'@'||S.NAME
into l_outagn_dname
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = l_outagnguid
and A.SYSTEM_GUID (+)= S.GUID;
Line: 3208
select A.NAME||'@'||S.NAME
into l_toagn_dname
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = l_toagnguid
and A.SYSTEM_GUID (+)= S.GUID;
Line: 3225
select DISPLAY_NAME
into l_wfptype_dname
from WF_ITEM_TYPES_VL
where NAME = l_wfptype;
Line: 3243
select_local := 'SELECTED';
Line: 3244
select_enable := 'SELECTED';
Line: 3245
select_normal := 'SELECTED';
Line: 3250
select NAME
into l_system_name
from WF_SYSTEMS
where GUID = h_sguid;
Line: 3266
select NAME
into l_event_name
from WF_EVENTS_VL
where GUID = h_eguid;
Line: 3346
template := htf.formSelectOpen('h_source_type',cattributes=>'id="i_source_type"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('LOCAL'),
select_local,'VALUE="LOCAL"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('EXTERNAL'),
select_external,'VALUE="EXTERNAL"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('ERROR'),
select_error,'VALUE="ERROR"')
||wf_core.newline||
htf.formSelectClose;
Line: 3446
template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('ENABLED'),
select_enable,'VALUE="ENABLED"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('DISABLED'),
select_disable,'VALUE="DISABLED"')
||wf_core.newline||
htf.formSelectClose;
Line: 3463
template := htf.formSelectOpen('h_rule_data',cattributes=>'id="i_rule_data"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('KEY'),
select_key,'VALUE="KEY"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('MESSAGE'),
select_message,'VALUE="MESSAGE"')
||wf_core.newline||
htf.formSelectClose;
Line: 3629
template := htf.formSelectOpen('h_priority',cattributes=>'id="i_priority"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('NORMAL'),
select_normal,'VALUE='||l_normal)
||wf_core.newline||
htf.formSelectOption(wf_core.translate('HIGH'),
select_high,'VALUE='||l_high)
||wf_core.newline||
htf.formSelectOption(wf_core.translate('LOW'),
select_low,'VALUE='||l_low)
||wf_core.newline||
htf.formSelectClose;
Line: 3696
template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_C'),
select_custom_core,'VALUE="C"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_L'),
select_custom_limit,'VALUE="L"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_U'),
select_custom_user,'VALUE="U"')
||wf_core.newline||
htf.formSelectClose;
Line: 3716
template := htf.formSelectOpen('h_custom_level',cattributes=>'id="i_custom_level"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_C'),
select_custom_core,'VALUE="C"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('WFE_CUSTOM_LEVEL_L'),
select_custom_limit,'VALUE="L"')
||wf_core.newline||
htf.formSelectClose;
Line: 3871
Wf_Events_Pkg.Update_Row(
X_GUID=>l_guid,
X_NAME=>h_name,
X_TYPE=>h_type,
X_STATUS=>h_status,
X_GENERATE_FUNCTION=>h_generate_function,
X_OWNER_NAME=>h_owner_name,
X_OWNER_TAG=>h_owner_tag,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description,
X_CUSTOMIZATION_LEVEL=>h_custom_level,
X_LICENSED_FLAG=>'N'
);
Line: 3889
Wf_Events_Pkg.Insert_Row(
X_ROWID=>row_id,
X_GUID=>l_guid,
X_NAME=>h_name,
X_TYPE=>h_type,
X_STATUS=>h_status,
X_GENERATE_FUNCTION=>h_generate_function,
X_OWNER_NAME=>h_owner_name,
X_OWNER_TAG=>h_owner_tag,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description,
X_CUSTOMIZATION_LEVEL=>h_custom_level,
X_LICENSED_FLAG=>'N'
);
Line: 3932
procedure SubmitSelectedGEvents(
h_gguid in raw,
h_guids in hguid_array,
action in varchar2,
url in varchar2)
is
l_guid raw(16);
Line: 3940
if (h_guids.COUNT = 1 and (action = 'DELETE' or action = 'ADD')) then
wf_core.raise('WFE_EVENT_NOVALUE');
Line: 3948
elsif (action = 'DELETE') then
l_guid := hextoraw(h_guids(2));
Line: 3950
Wf_Event_Html.DeleteSelectedGEvents(h_gguid, h_guids);
Line: 3952
Wf_Event_Html.AddSelectedGEvents(h_gguid, h_guids);
Line: 3960
wf_core.context('WF_EVENT_HTML', 'SubmitSelectedGEvents',
rawtohex(h_gguid), url);
Line: 3963
end SubmitSelectedGEvents;
Line: 4013
Wf_Systems_Pkg.Update_Row(
X_GUID=>l_guid,
X_NAME=>h_name,
X_MASTER_GUID=>l_mguid,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description
);
Line: 4025
Wf_Systems_Pkg.Insert_Row(
X_ROWID=>row_id,
X_GUID=>l_guid,
X_NAME=>h_name,
X_MASTER_GUID=>l_mguid,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description
);
Line: 4105
Wf_Agents_Pkg.Update_Row (
X_GUID=>l_guid,
X_NAME=>upper(h_name),
X_SYSTEM_GUID=>l_system_guid,
X_PROTOCOL=>h_protocol,
X_ADDRESS=>h_address,
X_QUEUE_HANDLER=>upper(h_qhandler),
X_QUEUE_NAME=>upper(h_qname),
X_DIRECTION=>h_direction,
X_STATUS=>h_status,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description
);
Line: 4123
Wf_Agents_Pkg.Insert_Row (
X_ROWID=>row_id,
X_GUID=>l_guid,
X_NAME=>upper(h_name),
X_SYSTEM_GUID=>l_system_guid,
X_PROTOCOL=>h_protocol,
X_ADDRESS=>h_address,
X_QUEUE_HANDLER=>upper(h_qhandler),
X_QUEUE_NAME=>upper(h_qname),
X_DIRECTION=>h_direction,
X_STATUS=>h_status,
X_DISPLAY_NAME=>h_display_name,
X_DESCRIPTION=>h_description
);
Line: 4246
Wf_Event_Subscriptions_Pkg.Update_Row (
X_GUID=>l_guid,
X_SYSTEM_GUID=>l_sysguid,
X_SOURCE_TYPE=>h_source_type,
X_SOURCE_AGENT_GUID=>l_fagnguid,
X_EVENT_FILTER_GUID=>l_evtguid,
X_PHASE=>l_phase,
X_STATUS=>h_status,
X_RULE_DATA=>h_rule_data,
X_OUT_AGENT_GUID=>l_oagnguid,
X_TO_AGENT_GUID=>l_tagnguid,
X_PRIORITY=>l_priority,
X_RULE_FUNCTION=>h_rule_function,
X_WF_PROCESS_TYPE=>h_wfptype,
X_WF_PROCESS_NAME=>h_wfpname,
X_PARAMETERS=>h_parameters,
X_OWNER_NAME=>h_owner_name,
X_OWNER_TAG=>h_owner_tag,
X_CUSTOMIZATION_LEVEL=>h_custom_level,
X_DESCRIPTION=>h_description
);
Line: 4271
Wf_Event_Subscriptions_Pkg.Insert_Row (
X_ROWID=>row_id,
X_GUID=>l_guid,
X_SYSTEM_GUID=>l_sysguid,
X_SOURCE_TYPE=>h_source_type,
X_SOURCE_AGENT_GUID=>l_fagnguid,
X_EVENT_FILTER_GUID=>l_evtguid,
X_PHASE=>l_phase,
X_STATUS=>h_status,
X_RULE_DATA=>h_rule_data,
X_OUT_AGENT_GUID=>l_oagnguid,
X_TO_AGENT_GUID=>l_tagnguid,
X_PRIORITY=>l_priority,
X_RULE_FUNCTION=>h_rule_function,
X_WF_PROCESS_TYPE=>h_wfptype,
X_WF_PROCESS_NAME=>h_wfpname,
X_PARAMETERS=>h_parameters,
X_OWNER_NAME=>h_owner_name,
X_OWNER_TAG=>h_owner_tag,
X_CUSTOMIZATION_LEVEL=>h_custom_level,
X_DESCRIPTION=>h_description
);
Line: 4319
template varchar2(4000); -- Use for construct form select list
Line: 4327
select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
from WF_EVENTS_VL
where TYPE = 'EVENT'
and (h_display_name is null or lower(DISPLAY_NAME) like
'%'||lower(h_display_name)||'%')
and (h_name is null or lower(NAME) like '%'||lower(h_name)||'%')
and (h_status = '*' or STATUS = h_status)
order by NAME;
Line: 4341
selected boolean := FALSE;
Line: 4366
select NAME into l_name
from WF_EVENTS
where GUID = x_gguid;
Line: 4447
template := htf.formSelectOpen('h_status',cattributes=>'id="i_status"')
||wf_core.newline;
Line: 4451
template := template||htf.formSelectOption(wf_core.translate('ANY'),
'SELECTED','VALUE="*"')||wf_core.newline;
Line: 4453
selected := TRUE;
Line: 4455
template := template||htf.formSelectOption(wf_core.translate('ANY'),
null,'VALUE="*"')||wf_core.newline;
Line: 4459
template := template||htf.formSelectOption(wf_core.translate('ENABLED'),
'SELECTED','VALUE="ENABLED"')||wf_core.newline;
Line: 4461
selected := TRUE;
Line: 4463
template := template||htf.formSelectOption(wf_core.translate('ENABLED'),
null,'VALUE="ENABLED"')||wf_core.newline;
Line: 4466
if (selected) then
template := template||htf.formSelectOption(wf_core.translate('DISABLED'),
null,'VALUE="DISABLED"');
Line: 4470
template := template||htf.formSelectOption(wf_core.translate('DISABLED'),
'SELECTED','VALUE="DISABLED"');
Line: 4472
selected := TRUE;
Line: 4474
template := template||wf_core.newline||htf.formSelectClose;
Line: 4487
template := htf.formSelectOpen('h_type',cattributes=>'id="i_type"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('ANY'),
'SELECTED','VALUE="*"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('EVENT'),
null,'VALUE="EVENT"')
||wf_core.newline||
htf.formSelectOption(wf_core.translate('GROUP'),
null,'VALUE="GROUP"')
||wf_core.newline||
htf.formSelectClose;
Line: 4550
dTab(i).selectable := TRUE;
Line: 4557
'Wf_Event_Html.SubmitSelectedGEvents',
cmethod=>'Post',
cattributes=>'TARGET="_top" NAME="WF_GROUP_EDIT"');
Line: 4603
wf_core.translate('SELECT_ALL'),
wfa_html.image_loc,
null,
wf_core.translate('SELECT_ALL'));
Line: 4611
wf_core.translate('UNSELECT_ALL'),
wfa_html.image_loc,
null,
wf_core.translate('UNSELECT_ALL'));
Line: 4686
procedure DeleteEvent(
h_guid in raw default null)
is
l_type varchar2(8);
Line: 4692
select MEMBER_GUID
from WF_EVENT_GROUPS
where GROUP_GUID = xguid;
Line: 4699
select TYPE into l_type
from WF_EVENTS
where GUID = h_guid
and TYPE = 'EVENT';
Line: 4707
Wf_Event_Groups_Pkg.Delete_Row(
x_group_guid=>h_guid,
x_member_guid=>evtr.MEMBER_GUID
);
Line: 4714
Wf_Events_Pkg.Delete_Row(h_guid);
Line: 4723
wf_core.context('WF_EVENT_HTML', 'DeleteEvent', rawtohex(h_guid));
Line: 4725
end DeleteEvent;
Line: 4734
procedure DeleteSystem(
h_guid in raw default null)
is
begin
if (isDeletable(h_guid, 'SYSTEM')) then
Wf_Systems_Pkg.Delete_Row(h_guid);
Line: 4751
wf_core.context('WF_EVENT_HTML', 'DeleteSystem', rawtohex(h_guid));
Line: 4753
end DeleteSystem;
Line: 4762
procedure DeleteAgent(
h_guid in raw default null)
is
begin
if (isDeletable(h_guid, 'AGENT')) then
Wf_Agents_Pkg.Delete_Row(h_guid);
Line: 4779
wf_core.context('WF_EVENT_HTML', 'DeleteAgent', rawtohex(h_guid));
Line: 4781
end DeleteAgent;
Line: 4789
procedure DeleteSubscription(
h_guid in raw default null)
is
begin
if (isDeletable(h_guid, 'SUBSCRIPTION')) then
Wf_Event_Subscriptions_Pkg.Delete_Row(h_guid);
Line: 4806
wf_core.context('WF_EVENT_HTML', 'DeleteSubscription', rawtohex(h_guid));
Line: 4808
end DeleteSubscription;
Line: 4828
select GUID, NAME, DISPLAY_NAME
from WF_EVENTS_VL
where (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%'
and (display_name LIKE LOWER(SUBSTR(c_find_criteria, 1, 2))||'%'
or display_name LIKE LOWER(SUBSTR(c_find_criteria, 1, 1))||
UPPER(SUBSTR(c_find_criteria, 2, 1))||'%'
or display_name LIKE INITCAP(SUBSTR(c_find_criteria, 1, 2))||'%'
or display_name LIKE UPPER(SUBSTR(c_find_criteria, 1, 2))||'%'))
or
(UPPER(name) LIKE UPPER(c_find_criteria)||'%'
and (name LIKE LOWER(SUBSTR(c_find_criteria, 1, 2))||'%'
or name LIKE LOWER(SUBSTR(c_find_criteria, 1, 1))||
UPPER(SUBSTR(c_find_criteria, 2, 1))||'%'
or name LIKE INITCAP(SUBSTR(c_find_criteria, 1, 2))||'%'
or name LIKE UPPER(SUBSTR(c_find_criteria, 1, 2))||'%'))
order by NAME;
Line: 4862
select count(*) into l_total_rows
from WF_EVENTS_VL
where (upper(DISPLAY_NAME) like upper(p_display_value)||'%'
and (DISPLAY_NAME like lower(substr(p_display_value, 1, 2))||'%'
or DISPLAY_NAME like lower(substr(p_display_value, 1, 1))||
upper(SUBSTR(p_display_value, 2, 1))||'%'
or DISPLAY_NAME like initcap(substr(p_display_value, 1, 2))||'%'
or DISPLAY_NAME like upper(substr(p_display_value, 1, 2))||'%'))
or
(upper(NAME) like upper(p_display_value)||'%'
and (NAME like lower(substr(p_display_value, 1, 2))||'%'
or NAME like lower(substr(p_display_value, 1, 1))||
upper(substr(p_display_value, 2, 1))||'%'
or NAME like initcap(substr(p_display_value, 1, 2))||'%'
or NAME like upper(substr(p_display_value, 1, 2))||'%'));
Line: 4899
select GUID, NAME, DISPLAY_NAME
into l_guid, l_name, l_display_name
from WF_EVENTS_VL
where GUID = p_hidden_value;
Line: 4913
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open evcurs (p_display_value);
Line: 4932
** entered so present a no rows found and use the lov icon to select
** value
** If ii=1 then one row is found then you've got the right value
** If ii=2 then more than one row was found so check to see if the display
** value taht was selected is not unique in the LOV (Person Name) and
** that the LOV was used so the Hidden value has been set to a unique
** value. If it comes up with more than 1 in this case then present
** the please use lov icon to select value.
*/
if (ii = 2) then
select count(*)
into ii
from WF_EVENTS_VL
where NAME = p_display_value;
Line: 4979
select GUID, NAME, DISPLAY_NAME
from WF_SYSTEMS
where UPPER(display_name) LIKE UPPER(c_find_criteria)||'%'
or
UPPER(name) LIKE UPPER(c_find_criteria)||'%'
order by NAME;
Line: 5003
select count(*) into l_total_rows
from WF_SYSTEMS
where upper(DISPLAY_NAME) like upper(p_display_value)||'%'
or
upper(NAME) like upper(p_display_value)||'%';
Line: 5030
select GUID, NAME, DISPLAY_NAME
into l_guid, l_name, l_display_name
from WF_SYSTEMS
where GUID = p_hidden_value;
Line: 5044
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open mycurs (p_display_value);
Line: 5063
** entered so present a no rows found and use the lov icon to select
** value
** If ii=1 then one row is found then you've got the right value
** If ii=2 then more than one row was found so check to see if the display
** value taht was selected is not unique in the LOV (Person Name) and
** that the LOV was used so the Hidden value has been set to a unique
** value. If it comes up with more than 1 in this case then present
** the please use lov icon to select value.
*/
if (ii = 2) then
select count(*)
into ii
from WF_SYSTEMS
where NAME = p_display_value;
Line: 5113
select A.GUID, A.DISPLAY_NAME, A.NAME||'@'||S.NAME
from WF_AGENTS A, WF_SYSTEMS S
where UPPER(a.name) LIKE UPPER(c_find_criteria)||'%'
and UPPER(a.name) <> 'WF_DEFERRED'
and A.SYSTEM_GUID = S.GUID
and (p_param1 is null or direction = p_param1 or direction = 'ANY')
and (sguid is null or system_guid = sguid)
order by ADDRESS;
Line: 5146
select min(GUID) into l_sguid
from WF_SYSTEMS
where NAME = l_sname;
Line: 5160
select count(*) into l_total_rows
from WF_AGENTS A, WF_SYSTEMS S
where upper(A.NAME) like upper(l_aname)||'%'
and A.SYSTEM_GUID = S.GUID
and (p_param1 is null or A.DIRECTION = p_param1)
and (l_sguid is null or A.SYSTEM_GUID = l_sguid);
Line: 5188
select A.GUID, A.DISPLAY_NAME, A.NAME||'@'||S.NAME
into l_guid, l_dname, l_disp
from WF_AGENTS A, WF_SYSTEMS S
where A.GUID = p_hidden_value
and A.SYSTEM_GUID (+)= S.GUID;
Line: 5203
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open mycurs (l_aname, l_sguid);
Line: 5222
** entered so present a no rows found and use the lov icon to select
** value
** If ii=1 then one row is found then you've got the right value
** If ii=2 then more than one row was found so check to see if the display
** value taht was selected is not unique in the LOV (Person Name) and
** that the LOV was used so the Hidden value has been set to a unique
** value. If it comes up with more than 1 in this case then present
** the please use lov icon to select value.
*/
if (ii = 2) then
select count(*)
into ii
from WF_AGENTS
where NAME = l_aname;
Line: 5269
select NAME, DISPLAY_NAME
from WF_ITEM_TYPES_VL
where (UPPER(DISPLAY_NAME) LIKE UPPER(c_find_criteria)||'%'
or
NAME LIKE UPPER(c_find_criteria)||'%')
and NAME not in ('WFSTD','WFMAIL', 'SYSERROR')
order by NAME;
Line: 5293
select count(*) into l_total_rows
from WF_ITEM_TYPES_VL
where (upper(DISPLAY_NAME) like upper(p_display_value)||'%'
or
NAME like upper(p_display_value)||'%')
and NAME not in ('WFSTD', 'WFERROR', 'WFMAIL', 'SYSERROR');
Line: 5321
select NAME, DISPLAY_NAME
into l_name, l_display_name
from WF_ITEM_TYPES_VL
where upper(DISPLAY_NAME) = upper(p_hidden_value);
Line: 5335
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open mycurs (p_display_value);
Line: 5354
** entered so present a no rows found and use the lov icon to select
** value
** If ii=1 then one row is found then you've got the right value
** If ii=2 then more than one row was found so check to see if the display
** value taht was selected is not unique in the LOV (Person Name) and
** that the LOV was used so the Hidden value has been set to a unique
** value. If it comes up with more than 1 in this case then present
** the please use lov icon to select value.
*/
if (ii = 2) then
select count(*)
into ii
from WF_ITEM_TYPES_VL
where NAME = p_display_value;
Line: 5402
select PROCESS_NAME, DISPLAY_NAME
from WF_RUNNABLE_PROCESSES_V
where PROCESS_NAME LIKE UPPER(c_find_criteria)||'%'
and ITEM_TYPE = p_param1
order by PROCESS_NAME;
Line: 5427
select count(*) into l_total_rows
from WF_RUNNABLE_PROCESSES_V
where PROCESS_NAME like upper(p_display_value)||'%'
and ITEM_TYPE = p_param1;
Line: 5453
select PROCESS_NAME, DISPLAY_NAME
into l_name, l_display_name
from WF_RUNNABLE_PROCESSES_V
where PROCESS_NAME = upper(p_display_value)
and ITEM_TYPE = p_param1;
Line: 5468
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open mycurs (p_display_value);
Line: 5487
** entered so present a no rows found and use the lov icon to select
** value
** If ii=1 then one row is found then you've got the right value
** If ii=2 then more than one row was found so check to see if the display
** value taht was selected is not unique in the LOV (Person Name) and
** that the LOV was used so the Hidden value has been set to a unique
** value. If it comes up with more than 1 in this case then present
** the please use lov icon to select value.
*/
if (ii = 2) then
select count(*)
into ii
from WF_RUNNABLE_PROCESSES_V
where PROCESS_NAME = p_display_value
and ITEM_TYPE = p_param1;
Line: 5547
select min(GUID)
into l_guid
from WF_EVENTS
where GUID = l_upper_name;
Line: 5561
select count(1)
into l_names_count
from WF_EVENTS
where NAME = p_name;
Line: 5568
select GUID
into p_guid
from WF_EVENTS
where NAME = p_name;
Line: 5577
select count(1)
into l_dnames_count
from WF_EVENTS_VL
where DISPLAY_NAME = p_name;
Line: 5584
select GUID
into p_guid
from WF_EVENTS_VL
where DISPLAY_NAME = p_name;
Line: 5648
select min(GUID)
into l_guid
from WF_SYSTEMS
where GUID = l_upper_name;
Line: 5662
select count(1)
into l_names_count
from WF_SYSTEMS
where NAME = p_name;
Line: 5669
select GUID
into p_guid
from WF_SYSTEMS
where NAME = p_name;
Line: 5678
select count(1)
into l_dnames_count
from WF_SYSTEMS
where DISPLAY_NAME = p_name;
Line: 5685
select GUID
into p_guid
from WF_SYSTEMS
where DISPLAY_NAME = p_name;
Line: 5754
select GUID
into l_sguid
from WF_SYSTEMS
where NAME = l_system_name;
Line: 5768
select min(GUID)
into l_guid
from WF_AGENTS
where NAME = l_upper_name
and (l_sguid is null or SYSTEM_GUID = l_sguid);
Line: 5783
select count(1)
into l_names_count
from WF_AGENTS
where NAME = l_upper_name
and (l_sguid is null or SYSTEM_GUID = l_sguid);
Line: 5791
select GUID
into p_guid
from WF_AGENTS
where NAME = l_upper_name
and (l_sguid is null or SYSTEM_GUID = l_sguid);
Line: 5830
procedure AddSelectedGEvents(
h_gguid in raw,
h_guids in hguid_array)
is
cnt number;
Line: 5839
select count(1) into cnt
from WF_EVENTS
where GUID = h_gguid
and TYPE = 'GROUP';
Line: 5852
Wf_Event_Groups_Pkg.Insert_Row(
x_rowid=>row_id,
x_group_guid=>h_gguid,
x_member_guid=>hextoraw(h_guids(i))
);
Line: 5867
wf_core.context('WF_EVENT_HTML', 'AddSelectedGEvents', rawtohex(h_gguid));
Line: 5869
end AddSelectedGEvents;
Line: 5879
procedure DeleteSelectedGEvents(
h_gguid in raw,
h_guids in hguid_array)
is
i pls_integer;
Line: 5888
Wf_Event_Groups_Pkg.Delete_Row(
x_group_guid=>h_gguid,
x_member_guid=>hextoraw(h_guids(i))
);
Line: 5897
wf_core.raise('WFE_DELETE_FAIL');
Line: 5902
wf_core.context('WF_EVENT_HTML','DeleteSelectedGEvents',rawtohex(h_gguid));
Line: 5904
end DeleteSelectedGEvents;
Line: 5974
template varchar2(4000); -- Use for construct form select list
Line: 6055
select guid
from wf_agents
where system_guid = l_system_guid
and direction = 'IN'
and status = 'ENABLED';
Line: 6140
select wfa.protocol,
wfa.direction,
wfa.display_name,
substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME,
wfa.queue_name SCHEMA_QUEUE_NAME,
aq.queue_table QUEUE_TABLE,
upper(wfa.queue_handler) QUEUE_HANDLER
from wf_agents wfa ,
all_queues aq
where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
--and upper(wfa.queue_handler) = 'WF_EVENT_QH'
and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)
order by queue_name;
Line: 6238
l_sqlstmt := 'SELECT COUNT(*) FROM '||queues.queue_table||
' WHERE Q_NAME = :b1';
Line: 6266
SELECT queue_name
INTO l_default_queue
FROM wf_agents
WHERE name = 'WF_ERROR'
AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
Line: 6288
SELECT queue_name
INTO l_default_queue
FROM wf_agents
WHERE name = 'ECX_INBOUND'
AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
Line: 6312
SELECT queue_name
INTO l_default_queue
FROM wf_agents
WHERE name = 'ECX_TRANSACTION'
AND system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
Line: 6373
template varchar2(4000); -- Use for construct form select list
Line: 6380
select
substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
from wf_agents wfa ,
all_queues aq
where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
and aq.name like nvl(p_queue_name,'%')
and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)
order by queue_name;
Line: 6393
select GUID, DISPLAY_NAME, NAME, TYPE, STATUS
from WF_EVENTS_VL
where TYPE = 'EVENT'
order by NAME;
Line: 6447
htp.formSelectOpen(cname=>'p_queue_name',cattributes=>'id="i_queue_name"');
Line: 6449
htp.formSelectOption(cvalue=>i.queue_name
,cattributes=>'value='||i.queue_name);
Line: 6452
htp.formSelectClose;
Line: 6479
template := htf.formSelectOpen('p_message_status',
cattributes=>'id="i_message_status"')||wf_core.newline;
Line: 6482
template := template||htf.formSelectOption(wf_core.translate('ANY'),
null,'VALUE="ANY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('READY'),
'SELECTED','VALUE="READY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('WAIT'),
null,'VALUE="WAIT"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('PROCESSED'),
null,'VALUE="PROCESSED"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('EXPIRED'),
null,'VALUE="EXPIRED"');
Line: 6492
template := template||wf_core.newline||htf.formSelectClose;
Line: 6540
template varchar2(4000); -- Use for construct form select list
Line: 6546
select
substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
from wf_agents wfa ,
all_queues aq
where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
and aq.name like nvl(p_queue_name,'%')
and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)
order by queue_name;
Line: 6605
htp.formSelectOpen(cname=>'p_queue_name',cattributes=>'id="i_queue_name"');
Line: 6607
htp.formSelectOption(cvalue=>i.queue_name
,cattributes=>'value='||i.queue_name);
Line: 6610
htp.formSelectClose;
Line: 6648
template := htf.formSelectOpen('p_message_status',
cattributes=>'id="i_message_status"')||wf_core.newline;
Line: 6651
template := template||htf.formSelectOption(wf_core.translate('ANY'),
null,'VALUE="ANY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('READY'),
'SELECTED','VALUE="READY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('WAIT'),
null,'VALUE="WAIT"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('PROCESSED'),
null,'VALUE="PROCESSED"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('EXPIRED'),
null,'VALUE="EXPIRED"');
Line: 6661
template := template||wf_core.newline||htf.formSelectClose;
Line: 6709
template varchar2(4000); -- Use for construct form select list
Line: 6715
select
substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) QUEUE_NAME
from wf_agents wfa ,
all_queues aq
where wfa.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))
and aq.name = substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1)
and aq.name like nvl(p_queue_name,'%')
and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1)
order by queue_name;
Line: 6774
htp.formSelectOpen(cname=>'p_queue_name',cattributes=>'id="i_queue_name"');
Line: 6776
htp.formSelectOption(cvalue=>i.queue_name
,cattributes=>'value='||i.queue_name);
Line: 6779
htp.formSelectClose;
Line: 6795
template := htf.formSelectOpen('p_message_status',
cattributes=>'id="i_message_status"')||wf_core.newline;
Line: 6798
template := template||htf.formSelectOption(wf_core.translate('ANY'),
null,'VALUE="ANY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('READY'),
'SELECTED','VALUE="READY"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('WAIT'),
null,'VALUE="WAIT"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('PROCESSED'),
null,'VALUE="PROCESSED"')||wf_core.newline||
htf.formSelectOption(wf_core.translate('EXPIRED'),
null,'VALUE="EXPIRED"');
Line: 6808
template := template||wf_core.newline||htf.formSelectClose;
Line: 7022
select aq.queue_table
into l_qtable
from wf_agents wfa ,
all_queues aq
where aq.name = p_queue_name
and substr(wfa.queue_name,instr(wfa.queue_name,'.',1)+1) = aq.name
and aq.owner = substr(wfa.queue_name,1,instr(wfa.queue_name,'.',1)-1);
Line: 7071
'SELECT msgid, state, user_data FROM '||l_qtable||
' WHERE q_name in(:1,:2)'
using p_queue_name, l_exceptionQueue;
Line: 7076
'SELECT msgid, state, user_data FROM '||l_qtable||
' WHERE STATE = :1 AND q_name in (:2,:3)'
using l_state,p_queue_name, l_exceptionQueue;
Line: 7297
SELECT 1
INTO l_dummy
FROM all_queue_tables
WHERE owner = l_owner
AND queue_table = l_queue_table
AND rownum = 1;
Line: 7312
l_sqlstmt := 'SELECT user_data FROM '||p_queue_table
||' WHERE MSGID = :b';
Line: 7576
PROCEDURE updateToFWKEvtSubscriptionUrl(oldUrl in varchar2,
newUrl out nocopy varchar2,
errorCode out nocopy pls_integer) is
guid varchar2(4000);
Line: 7589
end updateToFWKEvtSubscriptionUrl;
Line: 7600
PROCEDURE updateToFWKEvtDataUrl(oldUrl in varchar2,
newUrl out nocopy varchar2,
errorCode out nocopy pls_integer) is
eventAttribute varchar2(4000);
Line: 7621
end updateToFWKEvtDataUrl;