APPS.JA_CN_CFS_GENERATE_PKG dependencies on FND_CONCURRENT

Line 183: fnd_concurrent_requests

179: IS
180: SELECT
181: request_id
182: FROM
183: fnd_concurrent_requests
184: WHERE parent_request_id=l_reqid_fsg;
185:
186: --Cursor to get functional currency code of current set of book
187: --this cursor is updated by lyb, get functional currency code from gl_ledgers

Line 386: UPDATE FND_CONCURRENT_REQUESTS

382: '', '', '', '', '', '', '', '', '', ''
383: );
384:
385: IF (p_OUTPUT_OPTION = 'Y') THEN
386: UPDATE FND_CONCURRENT_REQUESTS
387: SET
388: OUTPUT_FILE_TYPE = 'XML'
389: WHERE
390: REQUEST_ID = l_reqid_fsg;

Line 395: --from the table 'fnd_concurrent_requests' for the FSG - CFS report.

391: END IF;
392: COMMIT;
393:
394: --Waiting for the 'Cash Flow Statement - FSG' completed, and then retrive the sub-request id
395: --from the table 'fnd_concurrent_requests' for the FSG - CFS report.
396: IF l_reqid_fsg<>0
397: THEN
398:
399:

Line 400: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_fsg

396: IF l_reqid_fsg<>0
397: THEN
398:
399:
400: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_fsg
401: ,interval => l_waiting_interval
402: ,phase => l_fsg_req_phase
403: ,status => l_fsg_req_status
404: ,dev_phase => l_dev_phase

Line 440: END IF; -- FND_CONCURRENT.Wait_For_Request ...

436: ELSIF l_fsg_req_status_code='E'
437: THEN
438: l_error_flag:='E';
439: END IF; --l_fsg_req_status_code='C'
440: END IF; -- FND_CONCURRENT.Wait_For_Request ...
441: ELSE
442: l_error_flag:='E';
443: END IF; --l_reqid_fsg<>0
444:

Line 470: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_cal

466: --Waiting for the 'Cash flow statement - Calculation' successfully completed and then submit
467: --'Cash Flow Statement - Combination' program
468: IF l_reqid_cal<>0
469: THEN
470: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_cal
471: ,interval => l_waiting_interval
472: ,phase => l_cal_req_phase
473: ,status => l_cal_req_status
474: ,dev_phase => l_dev_phase

Line 528: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb

524:
525: IF l_reqid_comb<>0
526: THEN
527:
528: IF FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb
529: ,interval => l_waiting_interval
530: ,phase => l_comb_req_phase
531: ,status => l_comb_req_status
532: ,dev_phase => l_dev_phase

Line 603: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb

599: ELSIF l_comb_req_status_code='E'
600: THEN
601: l_error_flag:='E';
602: END IF; --l_comb_req_status_code='C'
603: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_comb
604: ELSE
605: l_error_flag:='E';
606: END IF; --l_reqid_comb<>0
607:

Line 618: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_cal

614: THEN
615: l_error_flag:='E';
616: END IF; --l_cal_req_status_code='C'
617:
618: END IF; --FND_CONCURRENT.Wait_For_Request(request_id => l_reqid_cal
619:
620: ELSE
621: l_error_flag:='E';
622: END IF; --l_reqid_cal<>0

Line 634: l_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'WARNING'

630: --If any of above four concurrent porgrams is Warning/Failed, set current generation
631: --program to status 'Warning'/'Error' accordingly.
632: IF l_error_flag='W'
633: THEN
634: l_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'WARNING'
635: ,message => ''
636: );
637: ELSIF l_error_flag='E'
638: THEN

Line 639: l_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'ERROR'

635: ,message => ''
636: );
637: ELSIF l_error_flag='E'
638: THEN
639: l_error_status:=FND_CONCURRENT.Set_Completion_Status(status => 'ERROR'
640: ,message => ''
641: );
642: END IF; --l_error_flag='W'
643: