PACKAGE: APPS.PON_ADD_UTIL_PKG

Source

1 PACKAGE PON_ADD_UTIL_PKG AUTHID CURRENT_USER as
2 /*$Header: PONADDUTS.pls 120.0 2005/06/01 13:55:39 appldev noship $ */
3 
4 --This ref cursor type is used for any cursors we need to pass out
5 --to Java.
6 
7 HZ_FAIL_EXCEPTION EXCEPTION;
8 
9 type hrAddrRecTyp IS RECORD (
10   address_name  	HR_LOCATIONS.location_code%TYPE
11 , address1      	HR_LOCATIONS.address_line_1%TYPE
12 , address2      	HR_LOCATIONS.address_line_2%TYPE
13 , city         		HR_LOCATIONS.town_or_city%TYPE
14 , state  		HR_LOCATIONS.region_2%TYPE
15 , province  		HR_LOCATIONS.region_3%TYPE
16 , zip  			HR_LOCATIONS.postal_code%TYPE
17 , postal_code  		HR_LOCATIONS.postal_code%TYPE
18 , country  		HR_LOCATIONS.country%TYPE
19 , county       		HR_LOCATIONS.region_1%TYPE
20 , bill_to_site_flag  	HR_LOCATIONS.bill_to_site_flag%TYPE
21 , ship_to_site_flag  	HR_LOCATIONS.ship_to_site_flag%TYPE
22 , mail_to_site_flag  	HR_LOCATIONS.receiving_site_flag%TYPE
23 );
24 
25 type tcaAddrRecTyp IS RECORD (
26   address_name  HZ_PARTY_SITES.party_site_name%TYPE
27 , address1      HZ_LOCATIONS.address1%TYPE
28 , address2      HZ_LOCATIONS.address2%TYPE
29 , city  HZ_LOCATIONS.city%TYPE
30 , state  HZ_LOCATIONS.state%TYPE
31 , province  HZ_LOCATIONS.province%TYPE
32 , zip  HZ_LOCATIONS.postal_plus4_code%TYPE
33 , postal_code  HZ_LOCATIONS.postal_code%TYPE
34 , country  HZ_LOCATIONS.country%TYPE
35 , county       HZ_LOCATIONS.county%TYPE
36 , over_sea_flag 	HZ_LOCATIONS.overseas_address_flag%TYPE
37 , bill_to_site_flag	VARCHAR2(1)
38 , ship_to_site_flag	VARCHAR2(1)
39 , mail_to_site_flag	VARCHAR2(1));
40 
41 type hrRefAddressCurTyp is Ref Cursor RETURN hrAddrRecTyp;
42 
43 type tcaRefAddressCurTyp is Ref Cursor RETURN tcaAddrRecTyp;
44 
45 
46 PROCEDURE retrieve_hr_address (
47   p_location_id 	IN NUMBER
48 , x_address 		OUT NOCOPY hrRefAddressCurTyp
49 , x_status		OUT NOCOPY VARCHAR2
50 , x_exception_msg	OUT NOCOPY VARCHAR2
51 );
52 
53 PROCEDURE retrieve_tca_address (
54   p_location_id 	IN NUMBER
55 , x_address 		OUT NOCOPY tcaRefAddressCurTyp
56 , x_status		OUT NOCOPY VARCHAR2
57 , x_exception_msg	OUT NOCOPY VARCHAR2
58 );
59 
60 PROCEDURE retrieve_hr_location_code (
61   p_location_id 	IN NUMBER
62 , p_language    	IN VARCHAR2
63 , x_address_name 	OUT NOCOPY VARCHAR2
64 );
65 
66 END PON_ADD_UTIL_PKG;