APPS.ECX_DIAGNOSTICS_TEST SQL Statements

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

Line: 33

    select status,
      object_type
    from all_objects
    where object_type in ('PACKAGE', 'PACKAGE BODY')
    and object_name    = v_rec_package_details.package_name
    and owner          =v_rec_package_details.schema_name;

Line: 86

    select status
    from all_objects
    where object_type = 'PROCEDURE'
    and object_name   = v_rec_package_details.procedure_name
    and owner         =v_rec_package_details.schema_name;

Line: 98

    select count(1) count
    from all_procedures
    where object_name = v_rec_package_details.package_name
    and procedure_name= v_rec_package_details.procedure_name
    and owner         = v_rec_package_details.schema_name;

Line: 109

    select upper(epm.parameter_name) parameter_name,
      case epm.data_type
        when 1
        then 'VARCHAR2'
        when 2
        then 'NUMBER'
        when 12
        then 'DATE'
        when 96
        then 'CHAR'
        when 112
        then 'CLOB'
      end data_type,
      case epm.action_type
        when 1060
        then 'IN'
        when 1070
        then 'OUT'
        when 1080
        then 'IN/OUT'
      end direction
    from ecx_proc_mappings epm
    where epm.map_id     =v_rec_package_details.map_id
    and epm.transtage_id =
      (select transtage_id
      from ecx_tran_stage_data etsd
      where etsd.map_id                    = v_rec_package_details.map_id
      and upper(etsd.custom_procedure_name)= v_rec_package_details.full_name
      and rownum                           =1
      )
  order by epm.procmap_id;

Line: 150

    select aa.argument_name,
      aa.data_type,
      aa.in_out
    from all_arguments aa,
      all_objects ao
    where ao.object_id     = aa.object_id
    and aa.object_name     =v_rec_package_details.procedure_name
    and aa.owner           =v_rec_package_details.schema_name
    and nvl(aa.overload,1) =overloadnum
    and aa.argument_name  is not null
    and ao.object_name     = v_rec_package_details.package_name
    and ao.object_type     = 'PACKAGE'
	   and ao.owner           =v_rec_package_details.schema_name
    order by position;

Line: 170

    select distinct nvl(overload, 1) overloadnum
    from all_arguments aa,
      all_objects ao
    where ao.object_id = aa.object_id
    and aa.object_name =v_rec_package_details.procedure_name
    and aa.owner       =v_rec_package_details.schema_name
    and ao.object_name = v_rec_package_details.package_name
    and ao.object_type = 'PACKAGE'
	   and ao.owner       =v_rec_package_details.schema_name
    order by overloadnum;

Line: 190

    select aa.argument_name,
      aa.data_type,
      aa.in_out
    from all_arguments aa,
      all_objects ao
    where ao.object_id = aa.object_id
    and ao.object_name =v_rec_package_details.procedure_name
    and ao.owner       =v_rec_package_details.schema_name
    and ao.object_type = 'PROCEDURE'
	   and aa.owner       =v_rec_package_details.schema_name
    order by position;

Line: 369

  (select distinct etsd.map_id,
    em.map_code,
    upper(etsd.custom_procedure_name) full_name
  from ecx_tran_stage_data etsd,
    ecx_mappings em
  where etsd.map_id          = em.map_id
  and custom_procedure_name is not null
  order by full_name
  )
  loop
    v_tab_procedure_details.extend(1);

Line: 408

  select *
  from table(cast(v_tab_procedure_details as tab_procedure_details)) t1
  where t1.pkg_proc_notfoundorinvalid= 'TRUE';

Line: 453

  l_xsl       := l_xsl || '';

Line: 512

  (select 1 from ecx_outqueue where msgid= p_msgid
  )
  loop
    msgfoundinoutqueue:= 'TRUE';