34: CR.PRINTER
35: INTO L_REPORT_NAME,P_REQUEST_DATE,P_ACTUAL_START_DATE,P_PRINTER
36: FROM
37: FND_CONCURRENT_PROGRAMS_VL CP,
38: FND_CONCURRENT_REQUESTS CR
39: WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
40: AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
41: AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
42: l_report_name := substr(l_report_name,1,instr(l_report_name,' (XML)'));
52: SELECT
53: APPLICATION_NAME
54: INTO P_APPLICATION_NAME
55: FROM
56: FND_CONCURRENT_REQUESTS FCR,
57: FND_APPLICATION_VL FAV
58: WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
59: AND FAV.APPLICATION_ID = FCR.PROGRAM_APPLICATION_ID;
60: EXCEPTION
65: SELECT
66: RESPONSIBILITY_NAME
67: INTO P_RESPONSIBILITY_NAME
68: FROM
69: FND_CONCURRENT_REQUESTS FCR,
70: FND_RESPONSIBILITY_VL FRV
71: WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
72: AND FRV.RESPONSIBILITY_ID = FCR.RESPONSIBILITY_ID;
73: EXCEPTION