DBA Data[Home] [Help]

APPS.FND_PROGRAM dependencies on FND_PRINTER_STYLES

Line 620: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;

616: concurrent_class_id_i
617: fnd_concurrent_request_class.request_class_id%TYPE;
618: executable_application_id_i fnd_application.application_id%TYPE;
619: executable_id_i fnd_executables.executable_id%TYPE;
620: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
621: swidth fnd_printer_styles.width%TYPE;
622: slength fnd_printer_styles.length%TYPE;
623: appl_short_name fnd_application.application_short_name%TYPE;
624: mls_function_application_id_i fnd_application.application_id%TYPE;

Line 621: swidth fnd_printer_styles.width%TYPE;

617: fnd_concurrent_request_class.request_class_id%TYPE;
618: executable_application_id_i fnd_application.application_id%TYPE;
619: executable_id_i fnd_executables.executable_id%TYPE;
620: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
621: swidth fnd_printer_styles.width%TYPE;
622: slength fnd_printer_styles.length%TYPE;
623: appl_short_name fnd_application.application_short_name%TYPE;
624: mls_function_application_id_i fnd_application.application_id%TYPE;
625: mls_function_exe_id_i fnd_executables.executable_id%TYPE;

Line 622: slength fnd_printer_styles.length%TYPE;

618: executable_application_id_i fnd_application.application_id%TYPE;
619: executable_id_i fnd_executables.executable_id%TYPE;
620: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
621: swidth fnd_printer_styles.width%TYPE;
622: slength fnd_printer_styles.length%TYPE;
623: appl_short_name fnd_application.application_short_name%TYPE;
624: mls_function_application_id_i fnd_application.application_id%TYPE;
625: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
626:

Line 736: FROM fnd_printer_styles

732: IF(style IS NOT NULL) THEN
733: BEGIN /* First check developer key */
734: SELECT printer_style_name, width, length
735: INTO output_print_style_i, swidth, slength
736: FROM fnd_printer_styles
737: WHERE printer_style_name = style;
738: EXCEPTION
739: WHEN no_data_found THEN /* Check translated value */
740: BEGIN

Line 743: FROM fnd_printer_styles_tl t,

739: WHEN no_data_found THEN /* Check translated value */
740: BEGIN
741: SELECT b.printer_style_name, b.width, b.length
742: INTO output_print_style_i, swidth, slength
743: FROM fnd_printer_styles_tl t,
744: fnd_printer_styles b
745: WHERE t.user_printer_style_name = style
746: AND rownum = 1
747: AND b.printer_style_name = t.printer_style_name;

Line 744: fnd_printer_styles b

740: BEGIN
741: SELECT b.printer_style_name, b.width, b.length
742: INTO output_print_style_i, swidth, slength
743: FROM fnd_printer_styles_tl t,
744: fnd_printer_styles b
745: WHERE t.user_printer_style_name = style
746: AND rownum = 1
747: AND b.printer_style_name = t.printer_style_name;
748: EXCEPTION

Line 783: fnd_printer_styles s

779: where (output_print_style_i is not null
780: and p.printer_type in
781: (select i.printer_type
782: from fnd_printer_information i,
783: fnd_printer_styles s
784: where i.printer_style = output_print_style_i
785: and s.printer_style_name = i.printer_style))
786: or (output_print_style_i is null
787: and p.printer_type in

Line 790: fnd_printer_styles s

786: or (output_print_style_i is null
787: and p.printer_type in
788: (select i.printer_type
789: from fnd_printer_information i,
790: fnd_printer_styles s
791: where i.printer_style = s.printer_style_name
792: and s.width >= nvl(cols, s.width)
793: and s.length >= nvl(rows, s.length))));
794: EXCEPTION