1 PACKAGE CS_AUTOCREATE_SYSTEMS_PKG AUTHID CURRENT_USER as
2 /* $Header: csxacsss.pls 115.6 2000/09/15 16:41:52 pkm ship $ */
3
4 TYPE Name_Rec_Type IS RECORD
5 (
6 system_id NUMBER,
7 name VARCHAR2(50)
8 );
9
10 TYPE Name_Tbl_Type IS TABLE OF Name_Rec_Type
11 INDEX BY BINARY_INTEGER;
12
13 PROCEDURE AUTOCREATE
14 (
15 p_customer_id IN NUMBER,
16 p_name IN VARCHAR2 DEFAULT NULL,
17 p_description IN VARCHAR2 DEFAULT NULL,
18 p_system_type_code IN VARCHAR2,
19 p_number_to_create IN NUMBER,
20 p_install_site_use_id IN NUMBER DEFAULT NULL,
21 p_technical_contact_id IN NUMBER DEFAULT NULL,
22 p_service_admin_contact_id IN NUMBER DEFAULT NULL,
23 p_ship_to_site_use_id IN NUMBER DEFAULT NULL,
24 p_ship_to_contact_id IN NUMBER DEFAULT NULL,
25 p_bill_to_site_use_id IN NUMBER DEFAULT NULL,
26 p_bill_to_contact_id IN NUMBER DEFAULT NULL,
27 p_config_system_type IN VARCHAR2 DEFAULT NULL,
28 p_start_date_active IN DATE DEFAULT NULL,
29 p_end_date_active IN DATE DEFAULT NULL,
30 p_attribute1 IN VARCHAR2 DEFAULT NULL,
31 p_attribute2 IN VARCHAR2 DEFAULT NULL,
32 p_attribute3 IN VARCHAR2 DEFAULT NULL,
33 p_attribute4 IN VARCHAR2 DEFAULT NULL,
34 p_attribute5 IN VARCHAR2 DEFAULT NULL,
35 p_attribute6 IN VARCHAR2 DEFAULT NULL,
36 p_attribute7 IN VARCHAR2 DEFAULT NULL,
37 p_attribute8 IN VARCHAR2 DEFAULT NULL,
38 p_attribute9 IN VARCHAR2 DEFAULT NULL,
39 p_attribute10 IN VARCHAR2 DEFAULT NULL,
40 p_attribute11 IN VARCHAR2 DEFAULT NULL,
41 p_attribute12 IN VARCHAR2 DEFAULT NULL,
42 p_attribute13 IN VARCHAR2 DEFAULT NULL,
43 p_attribute14 IN VARCHAR2 DEFAULT NULL,
44 p_attribute15 IN VARCHAR2 DEFAULT NULL,
45 p_context IN VARCHAR2 DEFAULT NULL,
46 x_name_tbl OUT Name_Tbl_Type
47 );
48
49 END CS_AUTOCREATE_SYSTEMS_PKG;
[Home] [Help]