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,