PACKAGE: APPS.CUG_ADDRESS_CREATION_PKG

Source

1 Package      CUG_ADDRESS_CREATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: CUGADRCS.pls 120.1 2006/03/27 14:36:21 appldev noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person      Date    Comments
11 -- ---------   ------  ------------------------------------------
12    -- Enter package declarations as shown below
13 
14    TYPE incident_address_rec_type IS RECORD(
15 	   location_id              NUMBER,
16         address1                VARCHAR2(240),
17         address2                VARCHAR2(240),
18         address3                VARCHAR2(240),
19         address4                VARCHAR2(240),
20         city                    VARCHAR2(60),
21         state                   VARCHAR2(60),
22         postal_code             VARCHAR2(60),
23         province                VARCHAR2(60),
24         county                  VARCHAR2(60),
25         country                 VARCHAR2(60),
26         street                  VARCHAR2(50),
27         house_number            VARCHAR2(50),
28         apartment_number        VARCHAR2(50),
29         building                VARCHAR2(50),
30         position                VARCHAR2(50),
31         po_box_number           VARCHAR2(50),
32         street_number           VARCHAR2(50),
33         room                    VARCHAR2(50),
34         floor                   VARCHAR2(50),
35         suite                   VARCHAR2(50),
36         jurisdiction_status     VARCHAR2(1) default null,
37         validation_status       VARCHAR2(1) default null) ;
38 
39    PROCEDURE Create_Incident_Address (
40     p_incident_id IN NUMBER,
41 	p_address_rec		IN	INCIDENT_ADDRESS_REC_TYPE,
42 	x_msg_count		OUT	NOCOPY NUMBER,
43      x_msg_data          OUT  NOCOPY VARCHAR2,
44 	x_return_status     OUT  NOCOPY VARCHAR2,
45 	x_location_id		OUT  NOCOPY NUMBER);
46 
47 
48 END CUG_ADDRESS_CREATION_PKG; -- Package spec