APPS.CAC_TASK_PURGE_PVT dependencies on FND_CONCURRENT

Line 34: | fnd_concurrent_programs_U1,instead|

30: | Added code to delete record |
31: | record from JTF_TASK_PHONE table |
32: | for Bug # 5216358. |
33: | 30-May-2006 Swapan Barat For bug# 5213367. Using index |
34: | fnd_concurrent_programs_U1,instead|
35: | of fnd_concurrent_programs_U2 |
36: | 13-Jul-2006 Swapan Barat Checking template_flag <> 'Y' |
37: | before removing records from |
38: | JTF_TASK_DEPENDS for bug# 5388975 |

Line 35: | of fnd_concurrent_programs_U2 |

31: | record from JTF_TASK_PHONE table |
32: | for Bug # 5216358. |
33: | 30-May-2006 Swapan Barat For bug# 5213367. Using index |
34: | fnd_concurrent_programs_U1,instead|
35: | of fnd_concurrent_programs_U2 |
36: | 13-Jul-2006 Swapan Barat Checking template_flag <> 'Y' |
37: | before removing records from |
38: | JTF_TASK_DEPENDS for bug# 5388975 |
39: +======================================================================*/

Line 110: Select request_id From FND_CONCURRENT_REQUESTS

106: l_main_conc_req_message VARCHAR2(512);
107: l_child_message VARCHAR2(4000);
108:
109: Cursor C_Child_Request(p_request_id NUMBER) Is
110: Select request_id From FND_CONCURRENT_REQUESTS
111: Where parent_request_id = p_request_id;
112:
113: TYPE C_Cur_Type IS REF CURSOR;
114: C_Cur_Ref C_Cur_Type;

Line 229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id

225: -- Modified by SBARAT on 30/05/2006 for bug# 5213367
226:
227: Delete JTF_TASK_PURGE
228: Where concurrent_request_id In
229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id
230: From fnd_concurrent_requests r ,
231: fnd_concurrent_programs p
232: Where r.phase_code = 'C'
233: And p.concurrent_program_id = r.concurrent_program_id

Line 230: From fnd_concurrent_requests r ,

226:
227: Delete JTF_TASK_PURGE
228: Where concurrent_request_id In
229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id
230: From fnd_concurrent_requests r ,
231: fnd_concurrent_programs p
232: Where r.phase_code = 'C'
233: And p.concurrent_program_id = r.concurrent_program_id
234: And p.concurrent_program_name = 'CACTKPUR');

Line 231: fnd_concurrent_programs p

227: Delete JTF_TASK_PURGE
228: Where concurrent_request_id In
229: (Select /*+ INDEX(p fnd_concurrent_programs_U1) */ r.request_id
230: From fnd_concurrent_requests r ,
231: fnd_concurrent_programs p
232: Where r.phase_code = 'C'
233: And p.concurrent_program_id = r.concurrent_program_id
234: And p.concurrent_program_name = 'CACTKPUR');
235:

Line 643: IF fnd_concurrent.get_request_status(

639: -- completion status
640:
641: FOR r_child_request IN c_child_request(l_request_id) LOOP
642:
643: IF fnd_concurrent.get_request_status(
644: request_id => r_child_request.request_id ,
645: phase => l_worker_conc_req_phase ,
646: status => l_worker_conc_req_status ,
647: dev_phase => l_worker_conc_req_dev_phase ,