APPS.BIS_IMPL_OPT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

   update bis_obj_properties prop
   set implementation_flag = 'Y'
   where OBJECT_type = 'PAGE'
   and OBJECT_NAME = p_object_name;

Line: 25

   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);

Line: 46

          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;

Line: 85

      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;

Line: 109

   update bis_obj_properties prop
   set implementation_flag = 'N'
   where OBJECT_type = 'PAGE'
   and OBJECT_NAME = p_object_name;

Line: 136

    'update bis_obj_properties set IMPLEMENTATION_FLAG = :1
     where OBJECT_NAME = :2 AND object_type = :3'
    using p_impl_flag, p_object_name, 'PAGE';

Line: 189

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);

Line: 228

 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 )';

Line: 253

select object_name
from bis_obj_properties
where object_type='REPORT'
and implementation_flag='Y';

Line: 260

select object_name
from bis_obj_properties
where object_type='REPORT'
and implementation_flag='N';

Line: 266

 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;

Line: 290

	   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;

Line: 300

  	   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;

Line: 313

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');

Line: 356

  select object_name
  from bis_obj_properties
  where object_type='REPORT'
  and implementation_flag is null;

Line: 373

          execute immediate 'update bis_obj_properties set IMPLEMENTATION_FLAG = ''Y''
           where object_type=''REPORT'' and object_name=:1' using l_reports_rec.object_name;

Line: 382

        'update bis_obj_properties set IMPLEMENTATION_FLAG = ''N''
         WHERE (object_type not in ( ''PAGE'',''REPORT''))
         OR implementation_flag IS NULL';

Line: 390

        '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';

Line: 423

       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%';

Line: 455

       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';

Line: 486

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';

Line: 521

    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;

Line: 526

      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;

Line: 602

    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;

Line: 626

       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';

Line: 634

       SELECT Nvl (implementation_flag, 'N') implflag
	 FROM bis_obj_properties
	 WHERE object_type = 'PAGE' AND object_name = p_page_obj_name;

Line: 684

     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');

Line: 695

     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');

Line: 705

       SELECT  object_name,implementation_flag implflag
	 FROM bis_obj_properties
	 WHERE object_type = 'REPORT' AND object_name = p_report_name;

Line: 787

    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;

Line: 806

  select implementation_flag
  into l_impl_flag
  from bis_obj_properties where object_name=p_obj_name and object_type=p_obj_type;

Line: 821

select 'Y'
from dual
where exists
(select 'Y' from bis_obj_properties
 where implementation_flag='Y'
 and object_type in ('PAGE','REPORT')
) ;