[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tt.notification_flag
, ta.notification_flag
FROM jtf_task_types_b tt, jtf_tasks_b ta
WHERE ta.task_id = b_task_id AND ta.task_type_id = tt.task_type_id;
SELECT tt.workflow_type || ',' || tt.workflow workflow
FROM jtf_task_types_b tt, jtf_tasks_b ta
WHERE ta.task_id = b_task_id AND ta.task_type_id = tt.task_type_id;
SELECT where_clause
, 'SELECT ' || select_name || ' FROM ' || from_table || ' WHERE ' || select_id || ' = :RES'
FROM jtf_objects_vl
WHERE object_code = b_resource_type;
SELECT source_id,user_id
FROM jtf_rs_resource_extns
WHERE resource_id = b_resource_id;
SELECT resource_id
, 'RS_' || CATEGORY resource_type_code
FROM jtf_rs_resource_extns
WHERE resource_id IN(SELECT resource_id
FROM jtf_rs_group_members
WHERE GROUP_ID = b_group_id AND NVL(delete_flag, 'N') = 'N');
SELECT resource_id
, 'RS_' || CATEGORY resource_type_code
FROM jtf_rs_resource_extns
WHERE resource_id IN(SELECT team_resource_id
FROM jtf_rs_team_members
WHERE team_id = b_team_id AND NVL(delete_flag, 'N') = 'N');
SELECT name
FROM wf_local_roles
WHERE orig_system = b_orig_system
AND orig_system_id = b_orig_system_id
AND user_flag='N';
SELECT resource_id
, resource_type_code
FROM jtf_task_all_assignments
WHERE task_id = b_task_id AND assignee_role = 'ASSIGNEE';
IF p_event IN('DELETE_TASK', 'CHANGE_TASK_DETAILS', 'NO_UPDATE') THEN
FOR l_assignees IN c_assignees(p_task_id) LOOP
find_role(p_resource_id => l_assignees.resource_id, p_resource_type_code => l_assignees.resource_type_code);
IF p_event IN('CHANGE_ASSIGNEE', 'DELETE_ASSIGNEE') THEN
find_role(p_resource_id => p_old_assignee_id, p_resource_type_code => p_old_assignee_code);
SELECT end_date
FROM wf_items
WHERE item_type = b_itemtype AND item_key = b_itemkey;
SELECT t.task_number
, t.owner_id
, t.owner_type_code
, t.planned_start_date
, t.planned_end_date
, t.scheduled_start_date
, t.scheduled_end_date
, t.actual_start_date
, t.actual_end_date
, t.workflow_process_id
, tl.task_name
, tl.description
, t.task_type_id
, tt.name task_type_name
, t.task_priority_id
, tp.name task_priority_name
, t.task_status_id
, ts.name task_status_name
FROM jtf_tasks_b t
, jtf_tasks_tl tl
, jtf_task_statuses_tl ts
, jtf_task_types_tl tt
, jtf_task_priorities_tl tp
WHERE t.task_id = p_task_id
AND tl.language = userenv('LANG')
AND tl.task_id = t.task_id
AND ts.task_status_id(+) = t.task_status_id
AND ts.language(+) = userenv('LANG')
AND tt.task_type_id(+) = t.task_type_id
AND tt.language(+) = userenv('LANG')
AND tp.task_priority_id(+) = t.task_priority_id
AND tp.language(+) = userenv('LANG');
SELECT jtf_task_workflow_process_s.NEXTVAL
FROM DUAL;
SELECT NAME
FROM jtf_task_types_vl
WHERE task_type_id = b_type;
SELECT NAME
FROM jtf_task_priorities_vl
WHERE task_priority_id = b_priority;
SELECT NAME
FROM jtf_task_statuses_vl
WHERE task_status_id = b_status;
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = fnd_global.user_id;
IF l_backcomp_flag = 'Y' AND p_event IN('CREATE_TASK', 'DELETE_TASK') THEN
-- previous functionality did not have CREATE_TASK or DELETE_TASK events,
-- so we can bail out now
RETURN;
jtf_task_wf_util.notiflist.DELETE;
IF p_event IN('DELETE_TASK', 'CHANGE_OWNER') THEN
-- set the old owner
set_text_attr(
l_itemtype
, l_itemkey
, 'OLD_TASK_OWNER_NAME'
, get_resource_name(p_old_owner_code, p_old_owner_id)
);
IF p_event IN('DELETE_TASK', 'CHANGE_OWNER') THEN
-- set the old owner
IF p_event = 'DELETE_TASK' THEN
set_text_attr(
l_itemtype
, l_itemkey
, 'OLD_TASK_OWNER_NAME'
, get_resource_name(l_task_rec.owner_type_code, l_task_rec.owner_id)
);
IF p_event <> 'DELETE_TASK' THEN
-- set the new owner
set_text_attr(
l_itemtype
, l_itemkey
, 'NEW_TASK_OWNER_NAME'
, get_resource_name(l_task_rec.owner_type_code, l_task_rec.owner_id)
);
IF p_event IN('CHANGE_ASSIGNEE', 'DELETE_ASSIGNEE') THEN
-- set the old assignee
set_text_attr(
l_itemtype
, l_itemkey
, 'OLD_TASK_ASSIGNEE_NAME'
, get_resource_name(p_old_assignee_code, p_old_assignee_id)
);
IF p_event IN('DELETE_TASK', 'CHANGE_OWNER') AND p_old_owner_code = 'RS_EMPLOYEE' THEN
set_text_attr(
l_itemtype
, l_itemkey
, 'OLD_TASK_OWNER_ID'
, jtf_rs_resource_pub.get_wf_role(p_old_owner_id)
);
IF p_event <> 'DELETE_TASK' AND l_task_rec.owner_type_code = 'RS_EMPLOYEE' THEN
set_text_attr(
l_itemtype
, l_itemkey
, 'NEW_TASK_OWNER_ID'
, jtf_rs_resource_pub.get_wf_role(l_task_rec.owner_id)
);
IF p_event IN('CHANGE_ASSIGNEE', 'DELETE_ASSIGNEE') AND p_old_assignee_code = 'RS_EMPLOYEE' THEN
set_text_attr(
l_itemtype
, l_itemkey
, 'OLD_TASK_ASSIGNEE_ID'
, jtf_rs_resource_pub.get_wf_role(p_old_assignee_id)
);
ELSIF p_event = 'DELETE_ASSIGNEE' THEN
set_text_attr(
l_itemtype
, l_itemkey
, 'EVENT'
, 'ASSIGNEE_REMOVAL'
);
UPDATE jtf_tasks_b
SET workflow_process_id = l_wf_process_id
WHERE task_id = p_task_id;