APPS.IBY_ADDRESS_PKG dependencies on HZ_LOCATIONS

Line 20: procedure createAddress( i_address1 hz_locations.address1%type,

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,

Line 21: i_address2 hz_locations.address2%type,

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,

Line 22: i_address3 hz_locations.address3%type,

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,

Line 23: i_city hz_locations.city%type,

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,

Line 24: i_county hz_locations.county%type,

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);

Line 25: i_state hz_locations.state%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: /*

Line 26: i_country hz_locations.country%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

Line 27: i_postalcode hz_locations.postal_code%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.

Line 28: o_addressid out nocopy hz_locations.location_id%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: **

Line 40: procedure modAddress(i_addressid hz_locations.location_id%type,

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,

Line 41: i_address1 hz_locations.address1%type,

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,

Line 42: i_address2 hz_locations.address2%type,

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,

Line 43: i_address3 hz_locations.address3%type,

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,

Line 44: i_city hz_locations.city%type,

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);

Line 45: i_county hz_locations.county%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;

Line 46: i_state hz_locations.state%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;

Line 47: i_country hz_locations.country%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;

Line 48: i_postalcode hz_locations.postal_code%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;