1 PACKAGE arp_addr_label_pkg AUTHID CURRENT_USER as
2 /* $Header: AROADDLS.pls 115.1 99/10/11 16:15:15 porting sh $ */
3
4
5 FUNCTION format_address_label( 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,
17 customer_name IN VARCHAR2,
18 bill_to_location IN VARCHAR2,
19 first_name IN VARCHAR2,
20 last_name IN VARCHAR2,
21 mail_stop IN VARCHAR2,
22 default_country_code IN VARCHAR2,
23 default_country_desc IN VARCHAR2,
24 print_home_country_flag IN VARCHAR2,
25 width IN NUMBER,
26 height_min IN NUMBER,
27 height_max IN NUMBER
28 )return VARCHAR2;
29
30
31 FUNCTION format_address( address_style IN VARCHAR2,
32 address1 IN VARCHAR2,
33 address2 IN VARCHAR2,
34 address3 IN VARCHAR2,
35 address4 IN VARCHAR2,
36 city IN VARCHAR2,
37 county IN VARCHAR2,
38 state IN VARCHAR2,
39 province IN VARCHAR2,
40 postal_code IN VARCHAR2,
41 territory_short_name IN VARCHAR2,
42 country_code IN VARCHAR2,
43 customer_name IN VARCHAR2,
44 bill_to_location IN VARCHAR2,
45 first_name IN VARCHAR2,
46 last_name IN VARCHAR2,
47 mail_stop IN VARCHAR2,
48 default_country_code IN VARCHAR2,
49 default_country_desc IN VARCHAR2,
50 print_home_country_flag IN VARCHAR2,
51 print_default_attn_flag IN VARCHAR2,
52 width IN NUMBER,
53 height_min IN NUMBER,
54 height_max IN NUMBER
55 )return VARCHAR2;
56
57
58 FUNCTION format_address( address_style IN VARCHAR2,
59 address1 IN VARCHAR2,
60 address2 IN VARCHAR2,
61 address3 IN VARCHAR2,
62 address4 IN VARCHAR2,
63 city IN VARCHAR2,
64 county IN VARCHAR2,
65 state IN VARCHAR2,
66 province IN VARCHAR2,
67 postal_code IN VARCHAR2,
68 territory_short_name IN VARCHAR2,
69 country_code IN VARCHAR2 default NULL,
70 customer_name IN VARCHAR2 default NULL,
71 first_name IN VARCHAR2 default NULL,
72 last_name IN VARCHAR2 default NULL,
73 mail_stop IN VARCHAR2 default NULL,
74 default_country_code IN VARCHAR2 default NULL,
75 default_country_desc IN VARCHAR2 default NULL,
76 print_home_country_flag IN VARCHAR2 default 'Y',
77 print_default_attn_flag IN VARCHAR2 default 'N',
78 width IN NUMBER default 1000,
79 height_min IN NUMBER default 1,
80 height_max IN NUMBER default 1
81 )return VARCHAR2;
82
83
84
85 END arp_addr_label_pkg;
[Home] [Help]