1 PACKAGE WSH_REPORT_PRINTERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: WSHRPRNS.pls 120.1.12010000.1 2008/07/29 06:18:14 appldev ship $ */
3
4 PROCEDURE Get_Printer (
5 p_concurrent_program_id IN NUMBER,
6 p_organization_id IN NUMBER default NULL,
7 p_equipment_type_id IN NUMBER default NULL,
8 p_equipment_instance IN VARCHAR2 default NULL,
9 p_label_id IN NUMBER default NULL,
10 p_user_id IN NUMBER default NULL,
11 p_zone IN VARCHAR2 default NULL,
12 p_department_id IN NUMBER default NULL,
13 p_responsibility_id IN NUMBER default NULL,
14 p_application_id IN NUMBER default NULL,
15 p_site_id IN NUMBER default NULL,
16 p_format_id IN NUMBER default NULL,
17 x_printer OUT NOCOPY VARCHAR2,
18 x_api_status OUT NOCOPY VARCHAR2,
19 x_error_message OUT NOCOPY VARCHAR2
20 );
21
22 TYPE LevelTyp IS RECORD (
23 priority_seq BINARY_INTEGER,
24 level_type_id BINARY_INTEGER,
25 level_value_id VARCHAR2(10));
26
27 TYPE LevelTabTyp IS TABLE OF LevelTyp INDEX BY BINARY_INTEGER;
28
29 level_table LevelTabTyp;
30
31
32 END WSH_REPORT_PRINTERS_PVT;