[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
' and owner_id in(select group_id from jtf_rs_group_members where resource_id = ' || p_resource_id ||
' and nvl(delete_flag,'||''''||'N'||''''||') = '||''''||'N'||''''||') ' || ' ) OR ( '||
' distribution_status_id = 3 and assignee_type = ' || ''''|| 'RS_INDIVIDUAL'||''''||
' and assignee_id = '|| p_resource_id || ' ) ';
l_sql_stmt := 'SELECT /*+ FIRST_ROWS */ WORK_ITEM_ID, WORKITEM_OBJ_CODE, WORKITEM_PK_ID,' ||
'PRIORITY_LEVEL, DUE_DATE, OWNER_ID, OWNER_TYPE_ACTUAL OWNER_TYPE, ASSIGNEE_ID, ' ||
'ASSIGNEE_TYPE_ACTUAL ASSIGNEE_TYPE, SOURCE_OBJECT_TYPE_CODE, RESCHEDULE_TIME, WS_ID, ' ||
'DISTRIBUTION_STATUS_ID, WORK_ITEM_NUMBER FROM IEU_UWQM_ITEMS '||
' WHERE ( '|| l_extra_where_clause || ' ) '||
' AND WS_ID in ( ' || p_ws_id_str || ' ) ' ||
-- ' AND DISTRIBUTION_STATUS_ID in (1,3) ' ||
' AND STATUS_ID = 0 ' ||
' and reschedule_time <= sysdate ' ||
' order by priority_level, due_date ';
execute immediate 'select FND_PROFILE.VALUE_SPECIFIC(:1, :2, :3, :4) from dual' into l_enabled_flag
using IN p_name, IN p_user_id, IN p_responsibility_id, IN p_application_id;