APPS.JTF_DIAGNOSTIC_ADAPTUTIL SQL Statements

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

Line: 26

  select nvl(TYPE_NAME,PLS_TYPE) into arg1
  from all_arguments z
  where UPPER(z.package_name) = UPPER(packageName)
  and upper(z.owner) in ('APPS', 'JTF', 'APPLSYS')
  and UPPER(z.object_name) = 'RUNTEST'
  and z.position = 1
  and z.IN_OUT = 'IN';

Line: 34

  select nvl(z.TYPE_NAME,z.PLS_TYPE)  into arg2
  from all_arguments z
  where UPPER(z.package_name) = UPPER(packageName)
  and upper(z.owner) in ('APPS', 'JTF', 'APPLSYS')
  and UPPER(z.object_name) = 'RUNTEST'
  and z.position = 2
  and z.IN_OUT = 'OUT';

Line: 42

  select nvl(z.TYPE_NAME,z.PLS_TYPE) into arg3
  from all_arguments z
  where UPPER(z.package_name) = UPPER(packageName)
  and upper(z.owner) in ('APPS', 'JTF', 'APPLSYS')
  and UPPER(z.object_name) = 'RUNTEST'
  and z.position = 3
  and z.IN_OUT = 'OUT';

Line: 51

  select max(z.position) into maxPos
  from all_arguments z
  where UPPER(z.package_name) = UPPER(packageName)
  and upper(z.owner) in ('APPS', 'JTF', 'APPLSYS')
  and UPPER(z.object_name) = 'RUNTEST';

Line: 91

  select y.status into s_status from all_objects y
  where y.object_name = UPPER(packageName)
  and y.object_type = 'PACKAGE'
  and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');

Line: 96

  select y.status into b_status from all_objects y
  where y.object_name = UPPER(packageName)
  and y.object_type = 'PACKAGE BODY'
  and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');

Line: 124

  select y.owner into v_pspec from all_objects y
  where y.object_name = UPPER(packageName)
  and y.object_type = 'PACKAGE'
  and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');

Line: 129

  select  y.owner into v_pbody from all_objects y
  where y.object_name = UPPER(packageName)
  and y.object_type = 'PACKAGE BODY'
  and upper(y.owner) in ('APPS', 'JTF', 'APPLSYS');

Line: 150

  select text into rcs_id from all_source
  where name like UPPER(packageName)
  and upper(owner) in ('APPS', 'JTF', 'APPLSYS')
  and text like '%$%Header%ship%' and
  type like 'PACKAGE BODY';

Line: 484

        select vsize(tempReportStr) into strSize from dual;

Line: 513

      select vsize(tmpReportStr) into strSize from dual;

Line: 538

    select distinct a.package_name, a.object_name
    from all_arguments a, all_objects b
    where
    -- a.owner like 'APPS' and b.owner like 'APPS'
    -- and a.object_id = b.object_id
    a.object_id = b.object_id
    and b.object_name like upper(pkgName)||'%'
    and b.object_name like upper('%DIAGUNITTEST%')
    and b.object_type like 'PACKAGE'
    and upper(b.owner) in ('APPS', 'JTF', 'APPLSYS')
    and upper(a.owner) in ('APPS', 'JTF', 'APPLSYS')
    and a.object_name like 'TEST%'
    and a.sequence = 0;

Line: 585

    select distinct package_name
    from all_arguments
    -- where owner like 'APPS'
    where -- owner like USER
    -- and upper(package_name) like  upper(pkgName)||'%'
    upper(package_name) like  upper(pkgName)||'%'
    and upper(owner) in ('APPS', 'JTF', 'APPLSYS')
    and upper(object_name) like upper('RUNTEST');

Line: 619

    select distinct package_name
    from all_arguments
    -- where owner like 'APPS'
    where -- owner like USER
    -- and upper(package_name) like  upper(pkgName)||'%'
    upper(package_name) like  upper(pkgName)||'%'
    and upper(package_name) like upper('%DIAGUNITTEST%')
    and upper(object_name) like 'TEST%'
    and upper(owner) in ('APPS', 'JTF', 'APPLSYS')
    and sequence = 0;

Line: 777

 select dbms_lob.getlength(arg1) into strSizeArg1 from dual;

Line: 778

 select dbms_lob.getlength(arg2) into strSizeArg2 from dual;

Line: 859

 select dbms_lob.getlength(arg1) into strSizeArg1 from dual;

Line: 860

 select dbms_lob.getlength(arg2) into strSizeArg2 from dual;