The following lines contain the word 'select', 'insert', 'update' or 'delete':
update bis_obj_properties prop
set implementation_flag = 'Y'
where OBJECT_type = 'PAGE'
and OBJECT_NAME = p_object_name;
update bis_obj_properties
set implementation_flag = 'Y'
where (object_type, OBJECT_NAME)
in( select distinct
depend_object_type,
depend_OBJECT_NAME
from bis_obj_dependency
where enabled_flag='Y'
start with object_type='PAGE'
and object_name = p_object_name
connect by prior DEPEND_OBJECT_NAME = object_name
AND PRIOR depend_object_type = object_type);
update BIS_OBJ_PROPERTIES
set implementation_flag = 'N'
where not exists (
-- back traverse and hit Pages that are implemented
(select distinct
dep.object_owner,
dep.object_type,
dep.OBJECT_NAME
from bis_obj_dependency dep
where dep.enabled_flag= 'Y'
and dep.object_type = 'PAGE'
and exists (
select 1
from BIS_OBJ_PROPERTIES tmp
where tmp.OBJECT_NAME = dep.OBJECT_NAME
and tmp.OBJECT_TYPE = dep.object_type
and tmp.implementation_flag = 'Y'
)
start with (
dep.depend_object_type = p_object_type and
dep.depend_object_name = p_object_name
)
connect by dep.DEPEND_OBJECT_NAME = prior dep.object_name
AND dep.depend_object_type = PRIOR dep.object_type
)
)
and BIS_OBJ_PROPERTIES.object_type = p_object_type
and BIS_OBJ_PROPERTIES.object_NAME = p_object_name;
select distinct
depend_object_type,
depend_OBJECT_NAME
from bis_obj_dependency
where enabled_flag='Y'
start with object_type='PAGE' and object_name = P_PGNAME
connect by prior DEPEND_OBJECT_NAME = object_name
AND PRIOR depend_object_type = object_type;
update bis_obj_properties prop
set implementation_flag = 'N'
where OBJECT_type = 'PAGE'
and OBJECT_NAME = p_object_name;
'update bis_obj_properties set IMPLEMENTATION_FLAG = :1
where OBJECT_NAME = :2 AND object_type = :3'
using p_impl_flag, p_object_name, 'PAGE';
select 'Y'
from dual
where not exists
(select 'Y'
from bis_obj_dependency
where depend_object_name=p_object_name
and depend_object_type=p_object_type);
update bis_obj_properties
set implementation_flag=''Y''
where object_type=''REPORT''
and object_name in (
select distinct object_name
from bis_request_set_objects
where object_type=''REPORT''
and REQUEST_SET_NAME=:1
and SET_APP_ID=:2 )';
select object_name
from bis_obj_properties
where object_type='REPORT'
and implementation_flag='Y';
select object_name
from bis_obj_properties
where object_type='REPORT'
and implementation_flag='N';
select distinct dep.depend_object_name, dep.depend_object_type
from
( select object_name,
object_type,
depend_object_name,
depend_object_type
from bis_obj_dependency
where enabled_flag='Y') dep
where dep.depend_object_type<>'REPORT'--bug 4609286
start with dep.object_type = 'REPORT'
and dep.object_name=p_report_name
connect by prior dep.depend_object_name = dep.object_name
and prior dep.depend_object_type = dep.object_type;
update bis_obj_properties
set IMPLEMENTATION_FLAG ='N'
where object_type=l_obj_under_report_rec.depend_object_type
and object_name=l_obj_under_report_rec.depend_object_name;
update bis_obj_properties
set IMPLEMENTATION_FLAG ='Y'
where object_type=l_obj_under_report_rec.depend_object_type
and object_name=l_obj_under_report_rec.depend_object_name;
select 'Y' from dual
where exists
(select 'Y'
from
(SELECT distinct object_name
FROM
( select object_name,
object_type,
object_owner,
depend_object_name,
depend_object_type,
depend_object_owner,
enabled_flag
from
bis_obj_dependency
where enabled_flag='Y' ) obj
where object_type='PAGE'
START WITH depend_object_name =p_report_name AND depend_object_type ='REPORT'
CONNECT BY PRIOR object_name = depend_object_name AND PRIOR object_type = depend_object_type) pages,
bis_obj_properties properties
where pages.object_name=properties.object_name
and properties.object_type='PAGE'
and properties.implementation_flag='Y');
select object_name
from bis_obj_properties
where object_type='REPORT'
and implementation_flag is null;
execute immediate 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''Y''
where object_type=''REPORT'' and object_name=:1' using l_reports_rec.object_name;
'update bis_obj_properties set IMPLEMENTATION_FLAG = ''N''
WHERE (object_type not in ( ''PAGE'',''REPORT''))
OR implementation_flag IS NULL';
'update bis_obj_properties set IMPLEMENTATION_FLAG = :1
where object_type<> ''REPORT''
and (object_name, object_type) in (
select distinct dep.depend_object_name, dep.depend_object_type
from bis_obj_dependency dep
where dep.enabled_flag = :2
start with dep.object_type = :3
and exists (select 1
from bis_obj_properties prop
where prop.object_type = dep.object_type
and prop.object_name = dep.object_name
and prop.implementation_flag = :4)
connect by prior dep.depend_object_name = dep.object_name
and prior dep.depend_object_type = dep.object_type
AND PRIOR dep.enabled_flag = :5
)'
using 'Y', 'Y', 'PAGE', 'Y', 'Y';
SELECT function_name
FROM fnd_form_functions
WHERE function_name = p_func_name
AND web_html_call LIKE 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE'||'&'||'akRegionApplicationId=191%';
SELECT object_name FROM bis_obj_dependency
WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA'
UNION ALL
SELECT object_name FROM bis_obj_properties
WHERE object_type = 'PAGE' AND object_name = p_func_name || '_OA';
select depend_objects.obj_name
from
( select distinct
obj.depend_OBJECT_NAME obj_name,
obj.depend_object_type obj_type,
obj.depend_object_owner obj_owner
from
( select object_name,
object_type,
object_owner,
depend_object_name,
depend_object_type,
depend_object_owner,
enabled_flag
from
bis_obj_dependency
where enabled_flag='Y' ) obj
start with obj.object_type ='PAGE'
and obj.object_name = p_page_name
connect by prior obj.DEPEND_OBJECT_NAME=obj.object_name
and prior depend_object_type=object_type
) depend_objects
where depend_objects.obj_type='REPORT';
execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'
using 'Y','REPORT',l_report_rec.obj_name;
execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:2 and object_name=:3'
using 'N','REPORT',l_report_rec.obj_name;
execute immediate 'update bis_obj_properties set implementation_flag=:1 where object_type=:1 and object_name=:2'
using p_impl_flag,'REPORT' ,p_report_name;
SElECT depend_object_name
FROM bis_obj_dependency objdep
WHERE objdep.object_name = p_page_obj_name
AND objdep.object_type = 'PAGE'
AND objdep.depend_object_type = 'PORTLET'
AND objdep.ENABLED_FLAG = 'Y';
SELECT Nvl (implementation_flag, 'N') implflag
FROM bis_obj_properties
WHERE object_type = 'PAGE' AND object_name = p_page_obj_name;
select 'Y'
from dual
where exists
(SElECT depend_object_name
FROM bis_obj_dependency objdep
WHERE objdep.object_name = p_report_name
AND objdep.object_type = 'REPORT'
AND objdep.ENABLED_FLAG = 'Y');
select 'Y'
from dual
where exists
(SElECT object_name
FROM bis_obj_prog_linkages
WHERE object_name = p_report_name
AND object_type = 'REPORT'
AND ENABLED_FLAG = 'Y');
SELECT object_name,implementation_flag implflag
FROM bis_obj_properties
WHERE object_type = 'REPORT' AND object_name = p_report_name;
execute immediate 'select nvl(implementation_flag, :1) implflag
FROM bis_obj_properties
WHERE object_type = :2 AND object_name = :3'
INTO v_ret_code
using 'N','PAGE', v_page_name;
select implementation_flag
into l_impl_flag
from bis_obj_properties where object_name=p_obj_name and object_type=p_obj_type;
select 'Y'
from dual
where exists
(select 'Y' from bis_obj_properties
where implementation_flag='Y'
and object_type in ('PAGE','REPORT')
) ;