PACKAGE: APPS.OZF_LOCATION_PVT

Source

1 PACKAGE ozf_location_pvt AUTHID CURRENT_USER as
2 /* $Header: ozfvlocs.pls 115.1 2004/01/30 03:23:31 mkothari noship $ */
3 
4 
5   FUNCTION format_address( address_style IN VARCHAR2,
6   			   address1 IN VARCHAR2,
7 			   address2 IN VARCHAR2,
8 			   address3 IN VARCHAR2,
9 			   address4 IN VARCHAR2,
10 			   city IN VARCHAR2,
11 			   county IN VARCHAR2,
12 			   state IN VARCHAR2,
13 			   province IN VARCHAR2,
14 			   postal_code IN VARCHAR2,
15 			   territory_short_name IN VARCHAR2,
16   			   country_code IN VARCHAR2 default NULL,
17 			   customer_name IN VARCHAR2 default NULL,
18 			   first_name IN VARCHAR2 default NULL,
19 			   last_name IN VARCHAR2 default NULL,
20 			   mail_stop IN VARCHAR2 default NULL,
21 			   default_country_code IN VARCHAR2 default NULL,
22                            default_country_desc IN VARCHAR2 default NULL,
23                            print_home_country_flag IN VARCHAR2 default 'Y',
24   			   print_default_attn_flag IN VARCHAR2 default 'N',
25 			   width IN NUMBER default 1000,
26 			   height_min IN NUMBER default 1,
27 			   height_max IN NUMBER default 1
28 		        )return VARCHAR2;
29 
30 
31    FUNCTION get_location (p_location_id         IN NUMBER,
32                           p_cust_site_use_code  IN VARCHAR2 := NULL
33                          )return VARCHAR2;
34 
35    FUNCTION get_location_id (p_site_use_id      IN NUMBER
36                             )return NUMBER;
37 
38    FUNCTION get_party_name(p_party_id    IN NUMBER,
39                            p_site_use_id IN NUMBER) RETURN VARCHAR2;
40 
41 
42 END ozf_location_pvt;