The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE selector
(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
result IN OUT NOCOPY VARCHAR2
) IS
--
BEGIN
--
-- RUN mode - normal process execution
--
IF (funcmode = 'RUN') THEN
result := 'MONITOR_RULES';
wf_core.context('JTF_BRM_PVT', 'SELECTOR',
itemtype, itemkey, to_char(actid), funcmode);
END selector;
SELECT *
FROM jtf_brm_parameters
WHERE parameter_id = 1;
JTF_BRMParameter_PVT.Update_BRMParameter(
p_api_version => l_api_version,
p_init_msg_list => l_init_msg_list,
p_commit => l_commit,
p_validation_level => l_validation_level,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_bp_rec => l_bp_rec);
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = b_uom_type
AND lookup_code = b_uom_code
AND enabled_flag = 'Y'
AND start_date_active <= b_now
AND nvl(end_date_active, b_now) >= b_now;
SELECT jtf_brm_activities_s.nextval
FROM DUAL;
SELECT jbr.view_name,
jbr.rule_id,
jbp.rowid,
jbp.workflow_item_type,
jbp.workflow_process_name
FROM jtf_brm_processes jbp,
jtf_brm_rules_vl jbr
WHERE jbp.rule_id = jbr.rule_id
AND nvl(jbr.start_date_active, b_now + 1) <= b_now
AND nvl(jbr.end_date_active, b_now) >= b_now
AND nvl(jbp.brm_uom_type,'JTF_BRM_UOM_TYPE') = 'JTF_BRM_UOM_TYPE'
AND nvl(jbp.last_brm_check_date, b_now - 100) +
(jbp.brm_check_interval / decode(jbp.brm_check_uom_code,
'MINUTES', 1440,
'HOURS', 24)) <= b_now
AND jbr.view_name IS NOT NULL
and jbp.workflow_item_type is not null;
UPDATE jtf_brm_processes
SET last_brm_check_date = l_now
WHERE rowid = i.rowid;
l_query := 'SELECT object_type, object_id FROM ' || i.view_name;
SELECT brm_wf_command_type, brm_wf_command_code
FROM jtf_brm_parameters
WHERE workflow_process_id = itemkey;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = b_command_type
AND lookup_code = b_command_code
AND enabled_flag = 'Y'
AND start_date_active <= b_now
AND nvl(end_date_active, b_now) >= b_now;