APPS.OKC_ARTICLE_KEYWORD_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 30: return fnd_concurrent_requests.request_id%type

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

Line 32: result fnd_concurrent_requests.request_id%type;

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

Line 35: from fnd_concurrent_requests

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

Line 130: request_id fnd_concurrent_requests.request_id%type;

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

Line 171: request_id fnd_concurrent_requests.request_id%type;

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

Line 211: request_id fnd_concurrent_requests.request_id%type;

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

Line 236: request_id fnd_concurrent_requests.request_id%type;

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