[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select RECIPIENT_ROLE, ORIGINAL_RECIPIENT
into recipient, orig_recipient
from WF_NOTIFICATIONS WN
where WN.NOTIFICATION_ID = nid;
select ORIG_SYSTEM, ORIG_SYSTEM_ID
into uos, uosid
from WF_USERS
where NAME = username
and ORIG_SYSTEM not in ('HZ_PARTY','CUST_CONT')
and rownum < 2;
select 1
into dummy
from sys.dual
where exists (
select null
from WF_USER_ROLES
where USER_ORIG_SYSTEM = uos
and USER_ORIG_SYSTEM_ID = uosid
and USER_NAME = username
and ROLE_ORIG_SYSTEM = ros
and ROLE_ORIG_SYSTEM_ID = rosid
and ROLE_NAME = recipient
union all
select null
from WF_USER_ROLES
where USER_ORIG_SYSTEM = uos
and USER_ORIG_SYSTEM_ID = uosid
and USER_NAME = username
and ROLE_ORIG_SYSTEM = oos
and ROLE_ORIG_SYSTEM_ID = oosid
and ROLE_NAME = orig_recipient
);
select WN.STATUS,
WN.RECIPIENT_ROLE,
WN.ORIGINAL_RECIPIENT,
WN.PRIORITY,
WN.BEGIN_DATE,
WN.DUE_DATE,
WN.END_DATE,
WIT.DISPLAY_NAME message_type,
WL.MEANING disp_status,
WN.USER_COMMENT,
WN.FROM_USER,
WN.TO_USER,
WN.SUBJECT,
WN.LANGUAGE
from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
where WN.NOTIFICATION_ID = to_number(nid)
and WN.MESSAGE_TYPE = WIT.NAME
and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
and WN.STATUS = WL.LOOKUP_CODE;
select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
WNA.TEXT_VALUE
from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
WF_MESSAGE_ATTRIBUTES_VL WMA
where WNA.NOTIFICATION_ID = nid
and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
and WMA.NAME = WNA.NAME
and WMA.TYPE IN ('DOCUMENT', 'URL')
and WMA.ATTACH = 'Y'
and WNA.TEXT_VALUE IS NOT NULL
and WMA.SUBTYPE = 'SEND'
order by length(WNA.NAME) desc;
select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
WNA.TEXT_VALUE
from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
WF_MESSAGE_ATTRIBUTES_VL WMA
where WNA.NOTIFICATION_ID = nid
and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
and WN.MESSAGE_NAME = WMA.MESSAGE_NAME
and WMA.NAME = WNA.NAME
and WMA.TYPE = 'FORM'
and WNA.TEXT_VALUE IS NOT NULL
and WMA.SUBTYPE = 'SEND'
order by length(WNA.NAME) desc;
select MA.NAME,
MA.DISPLAY_NAME,
MA.DESCRIPTION,
-- remove quotes for onmouse over java func
replace(MA.DESCRIPTION,'''') description2,
NA.TEXT_VALUE,
NA.NUMBER_VALUE,
NA.DATE_VALUE,
MA.TYPE,
MA.FORMAT
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE <> 'FORM'
and ((resultflag = 'RESULT' and MA.NAME = 'RESULT') or
(resultflag <> 'RESULT' and MA.NAME <> 'RESULT'))
and MA.TYPE = decode(typeflag, '', MA.TYPE, typeflag)
order by MA.SEQUENCE;
select MA.NAME,
MA.DISPLAY_NAME,
MA.DESCRIPTION,
-- remove quotes for onmouse over java func
replace(MA.DESCRIPTION,'''') description2,
NA.TEXT_VALUE
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE = 'FORM'
order by MA.SEQUENCE;
select MA.DISPLAY_NAME,
MA.DESCRIPTION,
MA.TYPE,
MA.FORMAT
into dispname, description, attrtype, format
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = to_number(AttributeInfo.nid)
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.NAME = AttributeInfo.name;
select WLT.DISPLAY_NAME
into dlookup
from WF_LOOKUP_TYPES WLT
where WLT.LOOKUP_TYPE = AttributeInfo.format;
select count(1)
into urlcnt
from WF_MESSAGE_ATTRIBUTES MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = nid
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE = 'URL';
select count(1)
into respcnt
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = nid
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE <> 'FORM'
and MA.NAME <> 'RESULT';
select count(1)
into longcnt
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES MA,
WF_NOTIFICATIONS N
where N.NOTIFICATION_ID = nid
and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
and MA.MESSAGE_NAME = N.MESSAGE_NAME
and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
and MA.NAME = NA.NAME
and MA.SUBTYPE = 'RESPOND'
and MA.TYPE = 'VARCHAR2'
and decode(MA.TYPE, 'VARCHAR2', nvl(to_number(MA.FORMAT), 2000), 0) > 80;
procedure SubmitSelectedResponse(
nids in Name_Array,
close in varchar2,
forward in varchar2,
showto in varchar2,
nkey in varchar2)
as
begin
null;
end SubmitSelectedResponse;
wf_core.raise('WFNTF_NO_SELECT');
SELECT USERENV('LANG')
INTO l_lang
FROM DUAL;
SELECT
name,
display_name
FROM wf_roles
WHERE upper(name) like upper(c_find_criteria)
AND upper(name) not like '~WF_ADHOC-%'
AND status <> 'INACTIVE'
ORDER BY name;
SELECT COUNT(*)
INTO l_row_count
FROM wf_roles
WHERE upper(name) like upper(p_find_criteria)||'%'
AND upper(name) not like '~WF_ADHOC-%'
AND status <> 'INACTIVE';
SELECT
name,
display_name
FROM wf_role_lov_vl
where status <> 'INACTIVE'
and (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%')
order by display_name;
select count(*)
into l_total_rows
FROM wf_role_lov_vl
where status <> 'INACTIVE'
and (UPPER(display_name) LIKE UPPER(p_display_value)||'%');
** If its more than 1 then check to see if they used the LOV to select
** the value
*/
open c_user_lov (p_display_value);
** 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
-- copy logic from wf_directory.getroleinfo2
colon := instr(p_display_value,':');
select count(*)
into ii
from WF_ROLES
where NAME = p_display_value
and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
'HZ_GROUP','CUST_CONT');
select count(*)
into ii
from WF_ROLES
where NAME = p_display_value
and ORIG_SYSTEM = substr(p_display_value, 1, colon-1)
and ORIG_SYSTEM_ID = substr(p_display_value, colon+1);
** used the LOV to select the name and then blanked out the display
** name then make sure here to blank out the insternal name and return
*/
if (p_display_name is null) then
p_user_name := NULL;
select count(1)
into l_names_count
from wf_role_lov_vl
where display_name = p_display_name;
select name
into l_name
from wf_role_lov_vl
where display_name = p_display_name;
** used the lov to select the name in which case the combination
** of the display name and the user name should be unique
*/
else
-- copy logic from wf_directory.getroleinfo2
l_colon := instr(p_user_name,':');
select count(1)
into l_names_count
from WF_ROLES
where NAME = p_user_name
and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
'HZ_GROUP','CUST_CONT')
and DISPLAY_NAME = p_display_name;
select count(1)
into l_names_count
from WF_ROLES
where NAME = p_user_name
and ORIG_SYSTEM = substr(p_user_name, 1, l_colon-1)
and ORIG_SYSTEM_ID = l_orig_system_id
and DISPLAY_NAME = p_display_name;