1 PACKAGE AP_WEB_LOCATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: apwelocs.pls 115.1 2003/08/29 16:51:55 kmizuta noship $ */
3
4 --
5 -- The following record is used by routines in this package to represent
6 -- a location
7 type location_rec is record (
8 location_id number(15),
9 address1 varchar2(80),
10 address2 varchar2(80),
11 address3 varchar2(80),
12 address4 varchar2(80),
13 city varchar2(80),
14 province_state varchar2(80),
15 postal_code varchar2(80),
16 country varchar2(80),
17 geometry_status_code varchar2(30),
18 geometry mdsys.sdo_geometry,
19 org_id number(15),
20 address_key varchar2(660)
21 );
22
23 type loc_array is varray(20) of location_rec;
24 type cc_trx_array is varray(20) of ap_credit_card_trxns_all%rowtype;
25
26 --
27 -- get_location procedure checks to see if an identical address exists
28 -- in the AP_EXP_LOCATIONS table. If it exists, it does nothing.
29 -- If it doesn't exist, it will populate AP_EXP_LOCATIONS. It will
30 -- also call out to eLocations to populate the spatial coordinates
31 -- NOTE: AP_EXP_LOCATIONS will only be populated if
32 -- MERCHANT_COUNTRY_CODE is non-null.
33 procedure get_location(p_cc_trx in out nocopy ap_credit_card_trxns_all%rowtype,
34 x_return_status in out nocopy varchar2,
35 x_msg_count in out nocopy number,
36 x_msg_data in out nocopy varchar2);
37 procedure get_location(p_cc_trx in out nocopy cc_trx_array,
38 x_return_status in out nocopy varchar2,
39 x_msg_count in out nocopy number,
40 x_msg_data in out nocopy varchar2);
41
42 --
43 -- Uses various information about the card program to default a country.
44 -- This includes....
45 -- o Supplier Site
46 -- o Currency territories
47 -- o Organization
48 function default_country(p_card_program_id in number)
49 return varchar2;
50
51 end;