APPS.FND_PROGRAM dependencies on FND_PRINTER_STYLES

Line 617: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;

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;

Line 618: swidth fnd_printer_styles.width%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;

Line 619: slength fnd_printer_styles.length%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:

Line 733: FROM fnd_printer_styles

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

Line 740: FROM fnd_printer_styles_tl t,

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;

Line 741: fnd_printer_styles b

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

Line 780: fnd_printer_styles s

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

Line 787: fnd_printer_styles s

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