APPS.WSH_INTEGRATION dependencies on WSH_REPORT_PRINTERS

Line 604: l_enabled_flag WSH_REPORT_PRINTERS.enabled_flag%TYPE := null;

600: ) IS
601:
602: l_api_name CONSTANT VARCHAR2(100) := 'update_printer_assignment';
603:
604: l_enabled_flag WSH_REPORT_PRINTERS.enabled_flag%TYPE := null;
605: l_default_printer_flag WSH_REPORT_PRINTERS.default_printer_flag%TYPE := null;
606:
607: l_min_label_type_id NUMBER := 1;
608: l_max_label_type_id NUMBER := 0;

Line 605: l_default_printer_flag WSH_REPORT_PRINTERS.default_printer_flag%TYPE := null;

601:
602: l_api_name CONSTANT VARCHAR2(100) := 'update_printer_assignment';
603:
604: l_enabled_flag WSH_REPORT_PRINTERS.enabled_flag%TYPE := null;
605: l_default_printer_flag WSH_REPORT_PRINTERS.default_printer_flag%TYPE := null;
606:
607: l_min_label_type_id NUMBER := 1;
608: l_max_label_type_id NUMBER := 0;
609: loop_counter NUMBER := 0;

Line 618: FROM WSH_REPORT_PRINTERS

614: l_printer_signed_on NUMBER := 0;
615:
616: CURSOR c_printer_enabled(v_application_id NUMBER, v_label_type_id NUMBER) IS
617: SELECT enabled_flag, default_printer_flag
618: FROM WSH_REPORT_PRINTERS
619: WHERE application_id = v_application_id
620: AND concurrent_program_id = v_label_type_id
621: AND level_type_id = p_level_type_id
622: AND level_value_id = p_level_value_id

Line 702: FROM wsh_report_printers

698: BEGIN
699: SELECT 1 INTO l_printer_signed_on FROM dual
700: WHERE EXISTS
701: (SELECT 1
702: FROM wsh_report_printers
703: WHERE enabled_flag ='Y'
704: AND nvl(default_printer_flag,'N') ='Y'
705: AND concurrent_program_id = nvl(p_conc_program_id, concurrent_program_id)
706: AND level_type_id = p_level_type_id

Line 766: -- printer name in the WSH_REPORT_PRINTERS.

762:
763: IF (p_enabled_flag = 'Y') THEN
764: -- Trying to enable a printer/user/doc relationship
765: -- Check for existing records that match the App_id, conc_prog_id, level_type_id, level_value_id,
766: -- printer name in the WSH_REPORT_PRINTERS.
767:
768: trace('Inside p_enabled_flag = Y Enabling Printer ');
769:
770: OPEN c_printer_enabled(l_application_id, l_label_type_id);

Line 784: INSERT INTO WSH_REPORT_PRINTERS

780: trace('No Records exist for this combination');
781: trace('Inserting new record for the combination');
782:
783: -- Insert the new relation into the table.
784: INSERT INTO WSH_REPORT_PRINTERS
785: ( application_id
786: , concurrent_program_id
787: , level_type_id
788: , level_value_id

Line 872: UPDATE WSH_REPORT_PRINTERS

868: trace('Updating existing record for the combination');
869: -- Relationship exists already.
870: -- Now the printer is also marked as the default printer for the user.
871:
872: UPDATE WSH_REPORT_PRINTERS
873: SET enabled_flag = 'Y',
874: default_printer_flag = 'Y'
875: WHERE application_id = l_application_id
876: AND concurrent_program_id = l_label_type_id

Line 893: UPDATE WSH_REPORT_PRINTERS

889:
890: -- In this update, set the default_printer_flag to 'N' so that any printer
891: -- with the enabled_flag earlier is left untouched. The currently enabled printer
892: -- is a combination of the "enabled_flag" and the "default_printer_flag" set to 'Y'.
893: UPDATE WSH_REPORT_PRINTERS
894: SET enabled_flag = 'N',
895: default_printer_flag = null
896: WHERE application_id = l_application_id
897: AND concurrent_program_id = l_label_type_id

Line 917: UPDATE WSH_REPORT_PRINTERS

913: -- If yes, then check to see if a record exists for the printer for the user
914: -- and enable only if the printer has already been disabled.
915:
916: trace('Inside p_enabled_flag = N');
917: UPDATE WSH_REPORT_PRINTERS
918: SET enabled_flag = 'N',
919: default_printer_flag = null
920: WHERE application_id = l_application_id
921: AND concurrent_program_id = l_label_type_id