APPS.OKC_CHR_KEYWORD_PVT dependencies on OKC_CHR_KEYWORD_PVT

Line 1: PACKAGE BODY okc_chr_keyword_pvt AS

1: PACKAGE BODY okc_chr_keyword_pvt AS
2: /* $Header: OKCRCKWB.pls 120.6 2012/04/09 06:57:38 vechittu ship $ */
3:
4: retcode_success CONSTANT VARCHAR2(1) := '0';
5: retcode_warning CONSTANT VARCHAR2(1) := '1';

Line 95: fnd_file.put_line(fnd_file.log,'Checking OKC_CHR_KEYWORD_PVT package exists or not...');

91: request_id := get_request_id('OKCCHRCRCTX');
92: fnd_file.put_line(fnd_file.log,'OKC_K_HEADERS_TL_CTX text index creation started');
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';

Line 98: WHERE object_name = 'OKC_CHR_KEYWORD_PVT'

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

Line 100: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package exists');

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);
102:
103: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 13);
104: EXCEPTION WHEN OTHERS THEN

Line 101: fnd_file.put_line(fnd_file.log,'OKC_CHR_KEYWORD_PVT package owner is '||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);
102:
103: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 1, 13);
104: EXCEPTION WHEN OTHERS THEN
105: fnd_file.put_line(fnd_file.log,'ERROR: OKC_CHR__KEYWORD_PVT package doesn''t exist');

Line 125: EXECUTE IMMEDIATE 'GRANT EXECUTE ON '||apps||'.OKC_CHR_KEYWORD_PVT TO '||okc;

121: RAISE anyexp;
122: END;
123:
124: BEGIN
125: EXECUTE IMMEDIATE 'GRANT EXECUTE ON '||apps||'.OKC_CHR_KEYWORD_PVT TO '||okc;
126: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);
127:
128: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 13);
129:

Line 126: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);

122: END;
123:
124: BEGIN
125: EXECUTE IMMEDIATE 'GRANT EXECUTE ON '||apps||'.OKC_CHR_KEYWORD_PVT TO '||okc;
126: fnd_file.put_line(fnd_file.log,'Granted execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);
127:
128: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 13);
129:
130: EXCEPTION WHEN OTHERS THEN

Line 131: fnd_file.put_line(fnd_file.log,'ERROR: Couldn''t grant execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);

127:
128: dbms_application_info.set_session_longops( rindex, slno, null, request_id, request_id, 3, 13);
129:
130: EXCEPTION WHEN OTHERS THEN
131: fnd_file.put_line(fnd_file.log,'ERROR: Couldn''t grant execute on '||apps||'.OKC_CHR_KEYWORD_PVT to '||okc);
132: RAISE anyexp;
133: END;
134:
135: