DBA Data[Home] [Help]

APPS.FND_OID_PLUG dependencies on DBA_OBJECTS

Line 568: o dba_objects.owner%type;

564: is
565: l_module_source VARCHAR2(1000) := G_MODULE_SOURCE || 'SetPlugin(package): ';
566: i pls_integer;
567: c pls_integer;
568: o dba_objects.owner%type;
569: n dba_objects.object_name%type;
570: errmsg varchar2(4000);
571: opt option_type_rec;
572: val varchar2(4000);

Line 569: n dba_objects.object_name%type;

565: l_module_source VARCHAR2(1000) := G_MODULE_SOURCE || 'SetPlugin(package): ';
566: i pls_integer;
567: c pls_integer;
568: o dba_objects.owner%type;
569: n dba_objects.object_name%type;
570: errmsg varchar2(4000);
571: opt option_type_rec;
572: val varchar2(4000);
573: realm varchar2(4000);

Line 619: select count(*) into c from dba_objects where

615: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Verify plugin package for owner is valid ' );
616: end if;
617: o:= substr(upper(plugin_name),0,i-1);
618: n:= substr(upper(plugin_name),i+1);
619: select count(*) into c from dba_objects where
620: owner=o and
621: object_name=n and
622: object_type in ('PACKAGE','PACKAGE BODY') and status='VALID';
623: