[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
c_update => FALSE);
SELECT DISTINCT wav.item_type, wav.name, wav.version
INTO parent_type, parent_name, parent_version
FROM wf_process_activities wpa,
wf_activities wav
WHERE wpa.activity_item_type = x_base_type
AND wpa.activity_name = x_base_name
AND wav.item_type = wpa.process_item_type
AND wav.name = wpa.process_name
AND wav.name = temp_name
AND wav.begin_date <= start_date
AND (wav.end_date IS NULL
OR wav.end_date > start_date);
SELECT version
INTO base_version
FROM wf_activities
WHERE item_type = x_base_type
AND name = x_base_name
AND begin_date <= start_date
AND (end_date IS NULL
OR end_date > start_date);
SELECT wav.item_type,
wav.name,
wav.display_name,
wav.version,
wav.type,
wav.icon_name,
wpa.instance_id,
NVL(wpa.start_end,' ') start_end,
DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities wav2
WHERE wpa.process_item_type = x_parent_type /* check parent activity */
AND wpa.process_name = x_parent_name
AND wav2.item_type = wpa.process_item_type
AND wav2.name = wpa.process_name
AND wav2.version = wpa.process_version
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wpa.activity_item_type = x_base_type /* find base activity */
AND wpa.activity_name = x_base_name
AND wav.item_type = wpa.activity_item_type
AND wav.name = wpa.activity_name
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date);
SELECT wav.item_type,
wav.name,
wav.display_name,
wav.version,
wav.type,
wav.icon_name,
wpa.instance_id,
NVL(wpa.start_end,' ') start_end,
wpa.icon_geometry
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities wav2
WHERE wpa.process_item_type = x_base_type /* check base activity */
AND wpa.process_name = x_base_name
AND wpa.process_version = x_base_version /* must have version */
AND wav2.item_type = wpa.process_item_type
AND wav2.name = wpa.process_name
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wav.item_type = wpa.activity_item_type /* find all activities */
AND wav.name = wpa.activity_name
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date);
SELECT wpa.icon_geometry from_icon,
wpa.instance_id from_instance,
DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
'*', ' ',
wf_core.activity_result(wav2.result_type,wat.result_code))
label,
wpa2.icon_geometry to_icon,
wpa2.instance_id to_instance,
wat.arrow_geometry
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities_vl wav2,
wf_activity_transitions wat,
wf_process_activities wpa2
WHERE wpa.process_item_type = x_base_type /* check base activity */
AND wpa.process_name = x_base_name
AND wpa.process_version = x_base_version
AND wav.item_type = wpa.process_item_type
AND wav.name = wpa.process_name
AND wav.version = wpa.process_version
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date)
AND wav2.item_type = wpa.activity_item_type /* check activities */
AND wav2.name = wpa.activity_name /* get label */
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wat.from_process_activity = wpa.instance_id
AND wpa2.instance_id = wat.to_process_activity;
c_update => FALSE);
SELECT root_activity, root_activity_version, begin_date
INTO base_name, base_version, start_date
FROM wf_items
WHERE item_type = x_item_type
AND item_key = x_item_key;
SELECT wav.item_type,
wav.name,
wav.display_name,
wav.version,
wav.type,
wav.icon_name,
wpa.instance_id,
DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry,
DECODE(wf_core.activity_result(wav.result_type,wpa.default_result),
'', ' ',
wf_core.activity_result(wav.result_type,wpa.default_result))
usage_result,
DECODE(wias.activity_status, '', ' ', wias.activity_status)
activity_status
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities_vl wav2,
wf_item_activity_statuses wias
WHERE wpa.process_item_type = x_item_type -- check parent activity
AND wpa.process_name = x_parent_name
AND wav2.item_type = wpa.process_item_type
AND wav2.name = wpa.process_name
AND wav2.version = wpa.process_version
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wpa.activity_item_type = x_base_type -- find base activity
AND wpa.activity_name = x_base_name
AND wav.item_type = wpa.activity_item_type
AND wav.name = wpa.activity_name
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date)
AND wias.item_type (+) = x_item_type -- find base status
AND wias.item_key (+) = x_item_key
AND wias.process_activity (+) = wpa.instance_id;
SELECT wav.item_type,
wav.name,
wav.display_name,
wav.version,
wav.type,
wav.icon_name,
wpa.instance_id,
DECODE(wpa.start_end, '', ' ', wpa.start_end) start_end,
wpa.icon_geometry,
DECODE(wf_core.activity_result(wav.result_type, wpa.default_result),
'', ' ',
wf_core.activity_result(wav.result_type, wpa.default_result))
usage_result,
DECODE(wias.activity_status, '', ' ', wias.activity_status)
activity_status
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities_vl wav2,
wf_item_activity_statuses wias
WHERE wpa.process_item_type = x_base_type /* check base activity */
AND wpa.process_name = x_base_name
AND wav2.item_type = wpa.process_item_type
AND wav2.name = wpa.process_name
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wav2.version = wpa.process_version
AND wav.item_type = wpa.activity_item_type /* find all activities */
AND wav.name = wpa.activity_name
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date)
AND wias.item_type (+) = x_item_type /* find activity status */
AND wias.item_key (+) = x_item_key
AND wias.process_activity (+) = wpa.instance_id;
SELECT wpa.icon_geometry from_icon,
wpa.instance_id from_instance,
DECODE(wf_core.activity_result(wav2.result_type,wat.result_code),
'*',' ',
wf_core.activity_result(wav2.result_type,wat.result_code))
label,
wpa2.icon_geometry to_icon,
wpa2.instance_id to_instance,
wat.arrow_geometry,
wl.lookup_code visited /* transition status */
FROM wf_process_activities wpa,
wf_activities_vl wav,
wf_activities_vl wav2,
wf_activity_transitions wat,
wf_process_activities wpa2,
wf_item_activity_statuses wias,
wf_lookups wl
WHERE wpa.process_item_type = x_base_type /* check base activity */
AND wpa.process_name = x_base_name
AND wav.item_type = wpa.process_item_type
AND wav.name = wpa.process_name
AND wav.version = wpa.process_version
AND wav.begin_date <= x_start_date
AND (wav.end_date IS NULL
OR wav.end_date > x_start_date)
AND wav2.item_type = wpa.activity_item_type /* check activities */
AND wav2.name = wpa.activity_name
AND wav2.begin_date <= x_start_date
AND (wav2.end_date IS NULL
OR wav2.end_date > x_start_date)
AND wat.from_process_activity = wpa.instance_id
AND wpa2.instance_id = wat.to_process_activity
AND wias.item_type (+) = x_item_type /* find status */
AND wias.item_key (+) = x_item_key
AND wias.process_activity (+) = wpa.instance_id
AND wl.lookup_type = 'WFSTD_BOOLEAN'
AND ((wias.activity_status = 'COMPLETE'
AND (wat.result_code = wias.activity_result_code
OR wat.result_code = '*'
AND NOT EXISTS (SELECT NULL
FROM wf_activity_transitions
WHERE from_process_activity = wpa.instance_id
AND result_code = wias.activity_result_code))
AND wl.lookup_code = 'T')
OR (NOT (wias.activity_status = 'COMPLETE'
AND (wat.result_code = wias.activity_result_code
OR wat.result_code = '*'
AND NOT EXISTS (SELECT NULL
FROM wf_activity_transitions
WHERE from_process_activity = wpa.instance_id
AND result_code = wias.activity_result_code)))
OR wias.activity_status IS NULL) /* end of OR (NOT... */
AND wl.lookup_code = 'F');
c_update => FALSE);
SELECT LENGTH(x_name_list) INTO temp FROM DUAL;
SELECT INSTR(x_name_list, '^', total) INTO temp FROM DUAL;
SELECT SUBSTR(x_name_list, total, break_point - total) INTO token
FROM DUAL;