PACKAGE: APPS.IBY_ADDRESS_PKG

Source

1 package iby_address_pkg AUTHID CURRENT_USER as
2 /*$Header: ibyadrss.pls 115.3 2002/11/16 00:04:51 jleybovi ship $*/
3 /*
4 ** Name : iby_address_pkg.
5 ** Purpose : This package creates or deletes addresses that are part of
6 **           credit cards.
7 */
8 /*
9 ** Procedure Name : createAddress
10 ** Purpose : creates an entry in address table..
11 **           Returns the id created for the entry.
12 **
13 ** Parameters:
14 **
15 **    In  : i_address1, i_address2, i_address3, i_city, i_county,
16 **          i_state, i_country, i_postalcode.
17 **    Out : io_addressid.
18 **
19 */
20 procedure createAddress( i_address1 hz_locations.address1%type,
21                       i_address2 hz_locations.address2%type,
22                       i_address3 hz_locations.address3%type,
23                       i_city hz_locations.city%type,
24                       i_county hz_locations.county%type,
25                       i_state hz_locations.state%type,
26                       i_country hz_locations.country%type,
27                       i_postalcode hz_locations.postal_code%type,
28                       o_addressid  out nocopy hz_locations.location_id%type);
29 /*
30 ** Procedure Name : modAddress
31 ** Purpose : modifies an entry in Back end processor information table.
32 **
33 ** Parameters:
34 **
35 **    In  : i_addressid, i_address1, i_address2, i_address3, i_city,
36 **          i_county, i_state, i_country, i_postalcode.
37 **    Out : None.
38 **
39 */
40 procedure    modAddress(i_addressid hz_locations.location_id%type,
41                       i_address1 hz_locations.address1%type,
42                       i_address2 hz_locations.address2%type,
43                       i_address3 hz_locations.address3%type,
44                       i_city hz_locations.city%type,
45                       i_county hz_locations.county%type,
46                       i_state hz_locations.state%type,
47                       i_country hz_locations.country%type,
48                       i_postalcode hz_locations.postal_code%type);
49 end iby_address_pkg;