APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 28: return fnd_concurrent_requests.request_id%type

24: -- OKCARTSYNCCTX
25: -- OKCARTOPTCTX
26: --
27: function request_id(prog_name varchar2)
28: return fnd_concurrent_requests.request_id%type
29: is
30: result fnd_concurrent_requests.request_id%type;
31: begin
32: select request_id into result

Line 30: result fnd_concurrent_requests.request_id%type;

26: --
27: function request_id(prog_name varchar2)
28: return fnd_concurrent_requests.request_id%type
29: is
30: result fnd_concurrent_requests.request_id%type;
31: begin
32: select request_id into result
33: from fnd_concurrent_requests
34: where concurrent_program_id in (

Line 33: from fnd_concurrent_requests

29: is
30: result fnd_concurrent_requests.request_id%type;
31: begin
32: select request_id into result
33: from fnd_concurrent_requests
34: where concurrent_program_id in (
35: select concurrent_program_id
36: from fnd_concurrent_programs
37: where concurrent_program_name = prog_name

Line 128: request_id fnd_concurrent_requests.request_id%type;

124:
125: procedure sync_ctx(errbuf out nocopy varchar2, retcode out nocopy varchar2)
126: as
127: counter number;
128: request_id fnd_concurrent_requests.request_id%type;
129: begin
130: rindex := dbms_application_info.set_session_longops_nohint;
131: request_id := okc_article_keyword_pvt.request_id('OKCARTSYNCCTX');
132: dbms_application_info.set_session_longops(rindex, slno,

Line 169: request_id fnd_concurrent_requests.request_id%type;

165: end;
166:
167: procedure optimize_ctx(errbuf out nocopy varchar2, retcode out nocopy varchar2)
168: as
169: request_id fnd_concurrent_requests.request_id%type;
170: begin
171: rindex := dbms_application_info.set_session_longops_nohint;
172: request_id := okc_article_keyword_pvt.request_id('OKCARTOPTCTX');
173: dbms_application_info.set_session_longops(rindex, slno,

Line 209: request_id fnd_concurrent_requests.request_id%type;

205: end;
206:
207: procedure create_ctx(errbuf out nocopy varchar2, retcode out nocopy varchar2)
208: is
209: request_id fnd_concurrent_requests.request_id%type;
210: begin
211: rindex := dbms_application_info.set_session_longops_nohint;
212: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
213: dbms_application_info.set_session_longops(rindex, slno,

Line 232: request_id fnd_concurrent_requests.request_id%type;

228: cmd varchar2(4000);
229:
230: generic exception;
231:
232: request_id fnd_concurrent_requests.request_id%type;
233: begin
234: request_id := okc_article_keyword_pvt.request_id('OKCARTCRTCTX');
235: fnd_file.put_line(fnd_file.log,'OKC_ARTICLES_CTX text index creation started');
236: