DBA Data[Home] [Help]

PACKAGE: APPS.WSH_REPORT_PRINTERS_PVT

Source


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;