APPS.PO_EDA_IDX_FILE_GEN dependencies on FND_CONCURRENT_REQUESTS

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 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';