DBA Data[Home] [Help]

APPS.WSH_DOC_SETS dependencies on SO_REPORT_PRINTERS

Line 222: FROM SO_REPORT_PRINTERS

218: save_output boolean;
219: printer_level number;
220: cursor report_level (X_concurrent_program_id NUMBER, X_application_id NUMBER) is
221: SELECT MAX(LEVEL_TYPE_ID)
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,

Line 234: FROM SO_REPORT_PRINTERS

230:
231: cursor report_printer (X_concurrent_program_id NUMBER,
232: X_application_id NUMBER, X_printer_level NUMBER) is
233: SELECT NVL(PRINTER_NAME, 'No Printer')
234: FROM SO_REPORT_PRINTERS
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,