613: concurrent_class_id_i
614: fnd_concurrent_request_class.request_class_id%TYPE;
615: executable_application_id_i fnd_application.application_id%TYPE;
616: executable_id_i fnd_executables.executable_id%TYPE;
617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;
620: appl_short_name fnd_application.application_short_name%TYPE;
621: mls_function_application_id_i fnd_application.application_id%TYPE;
614: fnd_concurrent_request_class.request_class_id%TYPE;
615: executable_application_id_i fnd_application.application_id%TYPE;
616: executable_id_i fnd_executables.executable_id%TYPE;
617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;
620: appl_short_name fnd_application.application_short_name%TYPE;
621: mls_function_application_id_i fnd_application.application_id%TYPE;
622: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
615: executable_application_id_i fnd_application.application_id%TYPE;
616: executable_id_i fnd_executables.executable_id%TYPE;
617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
618: swidth fnd_printer_styles.width%TYPE;
619: slength fnd_printer_styles.length%TYPE;
620: appl_short_name fnd_application.application_short_name%TYPE;
621: mls_function_application_id_i fnd_application.application_id%TYPE;
622: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
623:
729: IF(style IS NOT NULL) THEN
730: BEGIN /* First check developer key */
731: SELECT printer_style_name, width, length
732: INTO output_print_style_i, swidth, slength
733: FROM fnd_printer_styles
734: WHERE printer_style_name = style;
735: EXCEPTION
736: WHEN no_data_found THEN /* Check translated value */
737: BEGIN
736: WHEN no_data_found THEN /* Check translated value */
737: BEGIN
738: SELECT b.printer_style_name, b.width, b.length
739: INTO output_print_style_i, swidth, slength
740: FROM fnd_printer_styles_tl t,
741: fnd_printer_styles b
742: WHERE t.user_printer_style_name = style
743: AND rownum = 1
744: AND b.printer_style_name = t.printer_style_name;
737: BEGIN
738: SELECT b.printer_style_name, b.width, b.length
739: INTO output_print_style_i, swidth, slength
740: FROM fnd_printer_styles_tl t,
741: fnd_printer_styles b
742: WHERE t.user_printer_style_name = style
743: AND rownum = 1
744: AND b.printer_style_name = t.printer_style_name;
745: EXCEPTION
771: select 'x' into dummy
772: from sys.dual
773: where printer in
774: (select distinct printer_name
775: from fnd_printer p
776: where (output_print_style_i is not null
777: and p.printer_type in
778: (select i.printer_type
779: from fnd_printer_information i,
775: from fnd_printer p
776: where (output_print_style_i is not null
777: and p.printer_type in
778: (select i.printer_type
779: from fnd_printer_information i,
780: fnd_printer_styles s
781: where i.printer_style = output_print_style_i
782: and s.printer_style_name = i.printer_style))
783: or (output_print_style_i is null
776: where (output_print_style_i is not null
777: and p.printer_type in
778: (select i.printer_type
779: from fnd_printer_information i,
780: fnd_printer_styles s
781: where i.printer_style = output_print_style_i
782: and s.printer_style_name = i.printer_style))
783: or (output_print_style_i is null
784: and p.printer_type in
782: and s.printer_style_name = i.printer_style))
783: or (output_print_style_i is null
784: and p.printer_type in
785: (select i.printer_type
786: from fnd_printer_information i,
787: fnd_printer_styles s
788: where i.printer_style = s.printer_style_name
789: and s.width >= nvl(cols, s.width)
790: and s.length >= nvl(rows, s.length))));
783: or (output_print_style_i is null
784: and p.printer_type in
785: (select i.printer_type
786: from fnd_printer_information i,
787: fnd_printer_styles s
788: where i.printer_style = s.printer_style_name
789: and s.width >= nvl(cols, s.width)
790: and s.length >= nvl(rows, s.length))));
791: EXCEPTION