APPS.PO_EDA_IDX_FILE_GEN dependencies on FND_CONCURRENT

Line 527: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =p_parent_id AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8

523: l_base_or_mod VARCHAR2(1);
524:
525: CURSOR csr_req_stats(p_parent_id VARCHAR2) IS
526: SELECT ARGUMENT1,ARGUMENT2,to_timestamp(ARGUMENT8,'YYYYMMDDHH24MISSSSS')
527: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =p_parent_id AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
528: AND 3 = (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
529: t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID);
530:
531: l_doc_type varchar2(10);

Line 528: AND 3 = (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND

524:
525: CURSOR csr_req_stats(p_parent_id VARCHAR2) IS
526: SELECT ARGUMENT1,ARGUMENT2,to_timestamp(ARGUMENT8,'YYYYMMDDHH24MISSSSS')
527: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =p_parent_id AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
528: AND 3 = (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
529: t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID);
530:
531: l_doc_type varchar2(10);
532: l_doc_number varchar2(100);

Line 715: v_finished := fnd_concurrent.get_request_status

711: l_req_id := SubStr(req_data,startpos);
712: END IF;
713: startpos := startpos+length(l_req_id)+1;
714:
715: v_finished := fnd_concurrent.get_request_status
716: (
717: request_id => l_req_id,
718: phase => v_phase,
719: status => v_status,

Line 844: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8

840: BEGIN
841: SELECT 'Y' into l_warning_flag
842: FROM dual where EXISTS(
843: SELECT 1
844: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
845: AND 3 > (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
846: t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID));
847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN

Line 845: AND 3 > (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND

841: SELECT 'Y' into l_warning_flag
842: FROM dual where EXISTS(
843: SELECT 1
844: FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
845: AND 3 > (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
846: t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID));
847: EXCEPTION
848: WHEN NO_DATA_FOUND THEN
849: l_warning_flag := 'N';