[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_msg_pub.delete_msg();
l_sql := ' select user_id from fnd_user
where upper(user_name) like upper( :p_user_name)';
l_sql := 'select resource_id
from jtf_rs_resource_extns where user_id = :l_user_id';
fnd_msg_pub.delete_msg();
l_sql := ' select user_id from fnd_user
where upper(user_name) like upper(:p_user_name)';
l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
/* l_sql := ' select responsibility_id, application_id //bug 6414726
from fnd_responsibility_tl where language = :l_language
and responsibility_name like :p_responsibility'; */
l_sql := ' select responsibility_id, application_id from fnd_responsibility where responsibility_id = :p_responsibility';
/* l_sql := ' select responsibility_id, application_id //bug6414726
from fnd_responsibility where responsibility_key like :p_responsibility'; */
l_sql := ' select application_id
from fnd_responsibility where responsibility_id = :p_responsibility';
fnd_msg_pub.delete_msg();
l_sql := ' select count(object_code) from jtf_objects_b
where upper(object_code) like upper(:p_object_code)';
l_sql := ' select responsibility_id, application_id
from fnd_responsibility_tl where language = :l_language
and responsibility_name like :p_responsibility';
l_sql := ' select responsibility_id, application_id
from fnd_responsibility where responsibility_key like :p_responsibility';
l_sql := ' select application_id
from fnd_responsibility where responsibility_id = :p_responsibility';
select media_type_id
from ieu_uwq_sel_enumerators
where ((not_valid_flag is null) or (not_valid_flag = 'N')) and
work_q_register_type = 'M' order by media_type_id;
fnd_msg_pub.delete_msg();
select work_q_enable_profile_option
into l_work_q_enable_profile_option
from ieu_uwq_sel_enumerators
where media_type_id = c_rec.media_type_id ;
select media_type_name INTO x_media_types(i)
from ieu_uwq_media_types_tl
where media_type_id = c_rec.MEDIA_TYPE_ID
and language = l_language order by media_type_name;
select count(s.SEL_ENUM_ID) into l_media_count
from
ieu_uwq_media_types_b b,
ieu_uwq_media_types_tl tl,
ieu_uwq_sel_enumerators s
where
b.media_type_id = tl.media_type_id and
tl.language = l_language and
s.media_type_id = b.media_type_id and
tl.media_type_name like x_media_types(v_count);
fnd_msg_pub.delete_msg();
l_sql := 'select server_group_id from jtf_rs_resource_extns where user_id = :l_user_id';
select mmptab.SVR_TYPE_ID into l_server_type_id from
IEO_SVR_SERVERS svrtab,
IEU_UWQ_SVR_MPS_MMAPS mmptab,
IEU_UWQ_MEDIA_TYPES_B mttab,
IEU_UWQ_MEDIA_TYPES_TL mtltab
where (mtltab.MEDIA_TYPE_NAME = l_media_types(i)) and
(mtltab.LANGUAGE = l_language) and
(mtltab.MEDIA_TYPE_ID = mttab.MEDIA_TYPE_ID) and
(mmptab.MEDIA_TYPE_ID = mttab.MEDIA_TYPE_ID) and
(svrtab.TYPE_ID = mmptab.SVR_TYPE_ID) and
(svrtab.MEMBER_SVR_GROUP_ID = l_server_group_id);
select GROUP_NAME into l_svr_group_name from IEO_SVR_GROUPS where SERVER_GROUP_ID = l_server_group_id;
SELECT
distinct l.meaning node_name,
e.SEL_ENUM_ID enum_id
FROM
IEU_UWQ_SEL_ENUMERATORS e,
fnd_lookup_values l
WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
(nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
AND l.language = l_language
AND l.lookup_code = e.work_q_label_lu_code
AND l.lookup_type = e.work_q_label_lu_type order by l.meaning;
fnd_msg_pub.delete_msg();
fnd_msg_pub.delete_msg();
select a.WORK_Q_ENABLE_PROFILE_OPTION into l_profle_name
from ieu_uwq_sel_enumerators a,
ieu_uwq_sel_enumerators b
where
a.sel_enum_id = b.sel_enum_id and
a.sel_enum_id = l_valid_nodes(v_count).enum_id and
(upper(a.WORK_Q_ENABLE_PROFILE_OPTION) <> b.WORK_Q_ENABLE_PROFILE_OPTION
or (a.WORK_Q_ENABLE_PROFILE_OPTION) not like ('IEU_QEN_%'));
SELECT
e.sel_enum_id,
e.enum_proc,
e.work_q_register_type,
e.media_type_id,
e.application_id,
e.work_q_label_lu_type,
e.work_q_label_lu_code
FROM
IEU_UWQ_SEL_ENUMERATORS e
WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
(nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
AND (e.work_q_register_type <> 'W' or e.work_q_register_type is null)
order by e.sel_enum_id;
select distinct v.meaning, s.sel_enum_id, s.enum_proc, tl.application_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl,
fnd_lookup_values v
where s.sel_enum_id = enum_id
and tl.application_id = app_id
and v.lookup_type = l_type
and v.lookup_code = l_code
and tl.language = l_language
and v.language = l_language;
fnd_msg_pub.delete_msg();
l_sql := 'select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';
UPDATE IEU_UWQ_SEL_RT_NODES
SET not_valid = 'Y'
WHERE resource_id = l_resource_id;
UPDATE IEU_UWQ_RTNODE_BIND_VALS
SET not_valid_flag = 'Y'
WHERE resource_id = l_resource_id;
/* SELECT lu.MEANING into l_vnode_label
from IEU_UWQ_SEL_ENUMERATORS u, FND_LOOKUP_VALUES lu
where
u.WORK_Q_LABEL_LU_TYPE = lu.LOOKUP_TYPE
and u.WORK_Q_LABEL_LU_CODE = lu.LOOKUP_CODE
and u.SEL_ENUM_ID =c_rec.SEL_ENUM_ID;*/
select distinct v.meaning into l_vnode_label
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl,
fnd_lookup_values v
where s.sel_enum_id = c_rec.SEL_ENUM_ID
and tl.application_id = s.APPLICATION_ID
and v.lookup_type = s.WORK_Q_LABEL_LU_TYPE
and v.lookup_code = s.WORK_Q_LABEL_LU_CODE
and tl.language = v.language
and v.language= l_language;
select count(sel_enum_id) into l_count from ieu_uwq_sel_enumerators
where enum_proc = c_rec.enum_proc;
select count(*) into l_temp_count from all_objects where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY') and status='VALID'and object_name = l_temp_pkg_name;
select
rownum
into
l_media_count
from
IEU_UWQ_SEL_RT_NODES
where
(resource_id = l_resource_id) and
(not_valid = 'N') and
(media_type_id IS NOT NULL) and
(rownum = 1);
Select
meaning
into
l_node_label
from
fnd_lookup_values_vl
where
(lookup_type = 'IEU_NODE_LABELS') and
(view_application_id = 696) and
(lookup_code = 'IEU_MEDIA_LBL');
SELECT
node_id, node_label, node_pid, node_weight
FROM ieu_uwq_sel_rt_nodes
WHERE
(resource_id = l_resource_id) and
((not_valid is null) or (not_valid <> 'Y'))order by node_pid, node_weight;
fnd_msg_pub.delete_msg();
l_sql := ' select resource_id
from jtf_rs_resource_extns
where user_id = :l_user_id';
SELECT
rt_nodes.sel_rt_node_id,
rt_nodes.node_id,
rt_nodes.node_pid,
rt_nodes.view_name,
rt_nodes.where_clause,
rt_nodes.media_type_id,
rt_nodes.sel_enum_id,
rt_nodes.refresh_view_name,
rt_nodes.refresh_view_sum_col,
rt_nodes.res_cat_enum_flag,
rt_nodes.node_label,
rt_nodes.node_weight
FROM
ieu_uwq_sel_rt_nodes rt_nodes
WHERE
(rt_nodes.resource_id = l_resource_id) AND
(rt_nodes.node_id <> 0) AND
(rt_nodes.node_id <> IEU_CONSTS_PUB.G_SNID_MEDIA) and
(rt_nodes.not_valid = 'N')
order by rt_nodes.node_pid, rt_nodes.node_weight;
SELECT
rt_nodes.sel_rt_node_id,
rt_nodes.node_id,
rt_nodes.node_pid,
rt_nodes.where_clause,
rt_nodes.sel_enum_id,
rt_nodes.refresh_view_name,
rt_nodes.refresh_view_sum_col,
rt_nodes.res_cat_enum_flag,
rt_nodes.view_name,
rt_nodes.node_label,
rt_nodes.node_weight
FROM
ieu_uwq_sel_rt_nodes rt_nodes
WHERE
(rt_nodes.resource_id = l_resource_id) AND
(rt_nodes.node_id = IEU_CONSTS_PUB.G_SNID_MEDIA) and
(rt_nodes.not_valid = 'N')
order by rt_nodes.node_pid, rt_nodes.node_weight;
SELECT
e.sel_enum_id,
e.refresh_proc,
e.work_q_register_type,
e.media_type_id,
e.application_id,
e.work_q_label_lu_type,
e.work_q_label_lu_code
FROM
IEU_UWQ_SEL_ENUMERATORS e
WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
(nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
order by e.sel_enum_id;
select distinct v.meaning, s.sel_enum_id, s.refresh_proc, tl.application_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl,
fnd_lookup_values v
where s.sel_enum_id = enum_id
and tl.application_id = app_id
and v.lookup_type = l_type
and v.lookup_code = l_code
and tl.language = l_language
and v.language = l_language;
select tl.application_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl
where s.sel_enum_id = enum_id
and tl.application_id = s.application_id
and tl.language = l_language;
fnd_msg_pub.delete_msg();
l_sql := ' select user_id from fnd_user
where upper(user_name) like upper(:p_user_name)';
l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
/* l_sql := ' select responsibility_id, application_id //bug6414726
from fnd_responsibility_tl where language = :l_language
and responsibility_name like :p_responsibility'; */
l_sql := 'select resource_id
from jtf_rs_resource_extns
where user_id = :l_user_id';
select count(*) into l_temp_count
from all_objects
where owner = 'APPS' and object_type in('PACKAGE', 'PACKAGE BODY')
and status='VALID'and object_name = l_temp_pkg_name;
select count(object_name) into l_temp_view_count from all_objects
where object_name = node.view_name and object_type = 'VIEW'
and status = 'VALID' and owner = 'APPS';
select tl.application_name into l_appli_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl
where s.sel_enum_id = node.sel_enum_id
and tl.application_id = s.application_id
and tl.language = l_language;
/* insert into g_temp (G) values (l_time_spent);
select count(object_name) into l_temp_view_count from all_objects
where object_name = l_view_name and object_type = 'VIEW'
and status = 'VALID' and owner = 'APPS';
select tl.application_name into l_appli_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl
where s.sel_enum_id = l_sel_enum_id
and tl.application_id = s.application_id
and tl.language = l_language;
/* insert into g_temp (G) values (l_time_spent);
SELECT
rt_nodes_bind_val.SEL_RT_NODE_ID,
rt_nodes_bind_val.node_id,
rt_nodes_bind_val.BIND_VAR_NAME,
rt_nodes_bind_val.bind_var_value
FROM
ieu_uwq_rtnode_bind_vals rt_nodes_bind_val
WHERE
(rt_nodes_bind_val.resource_id = p_resource_id) AND
(rt_nodes_bind_val.node_id <> 0) AND
(rt_nodes_bind_val.not_valid_flag = 'N');
select
where_clause
into
l_res_cat_where_clause
from
ieu_uwq_res_cats_b
where
res_cat_id = 10001;
select
decode(
(instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
into
l_enum_bind_var_flag
from
dual;
select
refresh_proc
into
l_refresh_proc
from
ieu_uwq_sel_enumerators
where
sel_enum_id = p_sel_enum_id;
select tl.application_name into l_appli_name
from ieu_uwq_sel_enumerators s,
fnd_application_tl tl
where s.sel_enum_id = p_sel_enum_id
and tl.application_id = s.application_id
and tl.language = l_language;
'Select sum(' || p_REFRESH_VIEW_SUM_COL || ') from ' ||
p_REFRESH_view_name || ' where ' || l_where_clause ||
' and ieu_param_pk_value is not null';
so, the above select would not work for 'ANY' */
if p_node_pid = 4000 then
l_media_sql_stmt :=
'begin select count(*) into :l_node_count from '||
p_refresh_view_name||' where resource_id = '||p_resource_id||'; end;';
'begin select ieu_param_pk_value into :l_param_pk_value from '||
p_refresh_view_name||' where resource_id = '||p_resource_id||'; end;';
'Select sum(' || p_REFRESH_VIEW_SUM_COL || ') from ' ||
p_REFRESH_view_name || ' where ' || l_where_clause;
'select count(resource_id) from ' || p_refresh_view_name ||
' where ' || l_where_clause;
'select count(resource_id) from ' || p_view_name ||
' where ' || l_where_clause;
select
decode((instr(l_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
into
l_resource_id_flag
from
dual;
UPDATE
IEU_UWQ_SEL_RT_NODES nodes
SET
nodes.count = l_count
WHERE
(nodes.sel_rt_node_id = p_sel_rt_node_id) AND
(nodes.resource_id = p_resource_id);
SELECT
node_id, view_name
FROM ieu_uwq_sel_rt_nodes
WHERE
(resource_id = l_resource_id) and
((not_valid is null) or (not_valid <> 'Y'))order by node_pid, node_weight;
fnd_msg_pub.delete_msg();
l_sql := ' select resource_id from jtf_rs_resource_extns where user_id = :l_user_id';
select count(object_name) into l_count from all_objects
where object_name = cur_rec.view_name and object_type = 'VIEW'
and status = 'VALID' and owner = 'APPS';
'SELECT unique object_function, name , APPLICATION_NAME
FROM jtf_objects_vl
WHERE lower(object_code) = lower(:action_code)',
DBMS_SQL.V7);
EXECUTE immediate ' select object_function '||
' from jtf_objects_vl '||
' where lower(OBJECT_CODE) = lower(:1) '
INTO l_object_function
USING 'TASK';
end LOOP; -- select object function from view
fnd_msg_pub.delete_msg();
'SELECT count(action_object_code)
FROM ieu_uwq_nonmedia_actions
WHERE lower(action_object_code) = lower(:action_code)
AND lower(source_for_task_flag) = lower(:flag)
AND nvl(responsibility_id, -1) IN (-1, :resp) ',
DBMS_SQL.V7);
EXECUTE immediate ' select NAME , application_name'||
' from jtf_objects_vl '||
' where lower(OBJECT_CODE) = lower(:1) '
INTO l_name,l_application_name
USING p_object_code;
EXECUTE immediate ' select action_proc'||
' from ieu_uwq_maction_defs_b a, ieu_uwq_nonmedia_actions b'||
' where a.maction_def_id = b.maction_def_id ' ||
' and lower(action_object_code) = lower(:1) ' ||
' and nvl(responsibility_id, -1) in (-1, :2) ' ||
' and lower(source_for_task_flag) = lower(:3) '
INTO l_object_function
USING p_object_code, l_responsibility_id, p_task_source;