The following lines contain the word 'select', 'insert', 'update' or 'delete':
** user can see what they've selected.
*/
if (type = 'DOCUMENT') THEN
htp.formhidden ('h_fvalues', dvalue);
select MEANING, LOOKUP_CODE
from WF_LOOKUPS
where LOOKUP_TYPE = p_lookup_type
order by MEANING;
htf.formSelectOpen('h_fvalues');
htf.formSelectOption(i.meaning, 'SELECTED','VALUE="'||i.lookup_code||'"');
htf.formSelectOption(i.meaning,null,'VALUE="'||i.lookup_code||'"');
template := template||wf_core.newline||htf.formSelectClose;
select MEANING, LOOKUP_CODE
from WF_LOOKUPS
where LOOKUP_TYPE = p_lookup_type
order by MEANING;
select count(1)
into respcnt
from WF_LOOKUPS
where LOOKUP_TYPE = format;
** user that was selected. Since this could be a display name
** or an internal name, make sure to get the unique internal name
*/
l_attr_value := attr_value;
select WL.MEANING
into meaning
from WF_LOOKUPS WL
where WL.LOOKUP_TYPE = GetLookupMeaning.ltype
and WL.LOOKUP_CODE = GetLookupMeaning.lcode;
select count(1),max(NA.TEXT_VALUE)
into urlcnt, urlstrg
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 = 'URL';
select text_value
into buf
from WF_NOTIFICATION_ATTRIBUTES NA,
WF_MESSAGE_ATTRIBUTES_VL 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 = 'URL'
and ROWNUM = 1;
select FROM_USER, TO_USER, SUBJECT
into from_user, to_user, subject
from WF_NOTIFICATIONS
where NOTIFICATION_ID = nid;