DBA Data[Home] [Help]

APPS.OKC_CHR_KEYWORD_PVT dependencies on DBA_OBJECTS

Line 80: apps sys.dba_objects.owner%TYPE;

76: return 0;
77: END;
78:
79: PROCEDURE create_ctx(x_return_status OUT NOCOPY VARCHAR2) IS
80: apps sys.dba_objects.owner%TYPE;
81: okc sys.dba_objects.owner%TYPE;
82: cmd VARCHAR2(4000);
83:
84: anyexp EXCEPTION;

Line 81: okc sys.dba_objects.owner%TYPE;

77: END;
78:
79: PROCEDURE create_ctx(x_return_status OUT NOCOPY VARCHAR2) IS
80: apps sys.dba_objects.owner%TYPE;
81: okc sys.dba_objects.owner%TYPE;
82: cmd VARCHAR2(4000);
83:
84: anyexp EXCEPTION;
85:

Line 97: FROM sys.dba_objects

93:
94: BEGIN
95: fnd_file.put_line(fnd_file.log,'Checking OKC_CHR_KEYWORD_PVT package exists or not...');
96: SELECT owner INTO apps
97: FROM sys.dba_objects
98: WHERE object_name = 'OKC_CHR_KEYWORD_PVT'
99: AND object_type = 'PACKAGE';
100: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package exists');
101: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package owner is '||apps);