222: FROM SO_REPORT_PRINTERS
223: WHERE REPORT_ID = X_concurrent_program_id
224: AND APPLICATION_id = x_application_id
225: AND LEVEL_VALUE_ID = DECODE(LEVEL_TYPE_ID,
226: 10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
227: 10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
228: AND ENABLE_FLAG = 'Y';
229:
230:
223: WHERE REPORT_ID = X_concurrent_program_id
224: AND APPLICATION_id = x_application_id
225: AND LEVEL_VALUE_ID = DECODE(LEVEL_TYPE_ID,
226: 10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
227: 10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
228: AND ENABLE_FLAG = 'Y';
229:
230:
231: cursor report_printer (X_concurrent_program_id NUMBER,
235: WHERE REPORT_ID = X_concurrent_program_id
236: AND APPLICATION_id = X_application_id
237: AND LEVEL_TYPE_ID = X_printer_level
238: AND LEVEL_VALUE_ID = DECODE(X_printer_level,
239: 10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
240: 10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
241: AND ENABLE_FLAG = 'Y';
242:
243: no_reportset_to_process EXCEPTION;
236: AND APPLICATION_id = X_application_id
237: AND LEVEL_TYPE_ID = X_printer_level
238: AND LEVEL_VALUE_ID = DECODE(X_printer_level,
239: 10001,0, 10002, FND_GLOBAL.RESP_APPL_ID,
240: 10003,FND_GLOBAL.RESP_ID, 10004, FND_GLOBAL.USER_ID)
241: AND ENABLE_FLAG = 'Y';
242:
243: no_reportset_to_process EXCEPTION;
244:
409: -- set up the printer
410:
411: if document.print_flag = 'Y' then
412:
413: -- dbms_output.put_line(' applid='||to_char(FND_GLOBAL.RESP_APPL_ID)||
414: -- ' resp_id='||to_char(FND_GLOBAL.RESP_ID) ||
415: -- ' user_id='||to_char(FND_GLOBAL.USER_ID));
416:
417: -- dbms_output.put_line(' prog_id='||(document.concurrent_program_id)||
410:
411: if document.print_flag = 'Y' then
412:
413: -- dbms_output.put_line(' applid='||to_char(FND_GLOBAL.RESP_APPL_ID)||
414: -- ' resp_id='||to_char(FND_GLOBAL.RESP_ID) ||
415: -- ' user_id='||to_char(FND_GLOBAL.USER_ID));
416:
417: -- dbms_output.put_line(' prog_id='||(document.concurrent_program_id)||
418: -- ' app='|| to_char(document.application_id));
411: if document.print_flag = 'Y' then
412:
413: -- dbms_output.put_line(' applid='||to_char(FND_GLOBAL.RESP_APPL_ID)||
414: -- ' resp_id='||to_char(FND_GLOBAL.RESP_ID) ||
415: -- ' user_id='||to_char(FND_GLOBAL.USER_ID));
416:
417: -- dbms_output.put_line(' prog_id='||(document.concurrent_program_id)||
418: -- ' app='|| to_char(document.application_id));
419: