DBA Data[Home] [Help]

APPS.ONT_OEXORDTP_XMLP_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 23: FND_CONCURRENT_REQUESTS cr WHERE cr.request_id = P_CONC_REQUEST_ID AND cp.application_id = cr.program_application_id AND cp.concurrent_program_id = cr.concurrent_program_id ;

19: END;
20: DECLARE l_report_name VARCHAR2(240);
21: BEGIN SELECT cp.user_concurrent_program_name INTO l_report_name FROM
22: FND_CONCURRENT_PROGRAMS_VL cp,
23: FND_CONCURRENT_REQUESTS cr WHERE cr.request_id = P_CONC_REQUEST_ID AND cp.application_id = cr.program_application_id AND cp.concurrent_program_id = cr.concurrent_program_id ;
24: RP_Report_Name := l_report_name;
25: --EXCEPTION WHEN NO_DATA_FOUND THEN RP_REPORT_NAME := 'Transaction Types Listing';
26: EXCEPTION WHEN NO_DATA_FOUND THEN RP_REPORT_NAME := 'Transaction Types Listing Report';
27: END;