APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on HZ_LOCATIONS

Line 10: * from HZ_LOCATIONS / PER_ADDRESSES tables.

6: g_st_party_fname CONSTANT VARCHAR2(30) := 'Dep/Arr Party';
7:
8: /**
9: * Address Record Structure to store the Address Information when retrieved
10: * from HZ_LOCATIONS / PER_ADDRESSES tables.
11: *
12: * *** Filled when address is retrieved from HZ_LOCATIONS Table ***
13: * *** Associated API that fills the records is GET_PARTY_ADDRESSES ***
14: * PARTY_ID Primary Key to HZ_PARTIES Table

Line 12: * *** Filled when address is retrieved from HZ_LOCATIONS Table ***

8: /**
9: * Address Record Structure to store the Address Information when retrieved
10: * from HZ_LOCATIONS / PER_ADDRESSES tables.
11: *
12: * *** Filled when address is retrieved from HZ_LOCATIONS Table ***
13: * *** Associated API that fills the records is GET_PARTY_ADDRESSES ***
14: * PARTY_ID Primary Key to HZ_PARTIES Table
15: * PARTY_SITE_ID Primary Key to HZ_PARTY_SITES Table
16: * LOCATION Primary Key to HZ_LOCATIONS Table

Line 16: * LOCATION Primary Key to HZ_LOCATIONS Table

12: * *** Filled when address is retrieved from HZ_LOCATIONS Table ***
13: * *** Associated API that fills the records is GET_PARTY_ADDRESSES ***
14: * PARTY_ID Primary Key to HZ_PARTIES Table
15: * PARTY_SITE_ID Primary Key to HZ_PARTY_SITES Table
16: * LOCATION Primary Key to HZ_LOCATIONS Table
17: * GEOMETRY Spatial Geometry of the Address
18:
19: * *** Filled when address is retrieved from PER_ADDRESSES Table ***
20: * *** Associated API that fills the records is GET_HOME_ADDRESSES ***

Line 23: * *** Common fields between HZ_LOCATIONS and PER_ADDRESSES Tables ***

19: * *** Filled when address is retrieved from PER_ADDRESSES Table ***
20: * *** Associated API that fills the records is GET_HOME_ADDRESSES ***
21: * ADDRESS_ID Primray Key to PER_ADDRESS Table
22: *
23: * *** Common fields between HZ_LOCATIONS and PER_ADDRESSES Tables ***
24: * STREET Address Line 1 Information
25: * CITY City Information
26: * STATE State Information
27: * POSTAL_CODE Postal Code Information

Line 36: , location_id hz_locations.location_id%TYPE

32: */
33: TYPE address_rec_type IS RECORD(
34: party_id hz_parties.party_id%TYPE
35: , party_site_id hz_party_sites.party_site_id%TYPE
36: , location_id hz_locations.location_id%TYPE
37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE

Line 38: , street hz_locations.address1%TYPE

34: party_id hz_parties.party_id%TYPE
35: , party_site_id hz_party_sites.party_site_id%TYPE
36: , location_id hz_locations.location_id%TYPE
37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE

Line 39: , postal_code hz_locations.postal_code%TYPE

35: , party_site_id hz_party_sites.party_site_id%TYPE
36: , location_id hz_locations.location_id%TYPE
37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE
43: , territory_short_name fnd_territories_vl.territory_short_name%TYPE

Line 40: , city hz_locations.city%TYPE

36: , location_id hz_locations.location_id%TYPE
37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE
43: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
44: , geometry mdsys.sdo_geometry

Line 41: , state hz_locations.state%TYPE

37: , address_id per_addresses.address_id%TYPE
38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE
43: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
44: , geometry mdsys.sdo_geometry
45: , start_date_active DATE

Line 42: , country hz_locations.country%TYPE

38: , street hz_locations.address1%TYPE
39: , postal_code hz_locations.postal_code%TYPE
40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE
43: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
44: , geometry mdsys.sdo_geometry
45: , start_date_active DATE
46: , end_date_active DATE

Line 72: * the address in PER_ADDRESS in HRMS Module to HZ_LOCATIONS in TCA.

68: *
69: * RS_EMPLOYEE
70: * Party is already created by HRMS whenever an Employee is created.
71: * This API will take care of inserting Party Sites and copying
72: * the address in PER_ADDRESS in HRMS Module to HZ_LOCATIONS in TCA.
73: * Before, party 'Dep/Arr Party' were created even for Employee
74: * Resources. Now this API will reuse the Party Created by HRMS itself.
75: *
76: * RS_PARTY

Line 97: * (GEOMETRY being NULL in HZ_LOCATIONS), the Address is Geocoded and stored

93: * requesting the address of the Resource.
94: *
95: * Automatic Geocoding of the Address
96: * If the Address corresponding to the determined Location is not yet Geocoded
97: * (GEOMETRY being NULL in HZ_LOCATIONS), the Address is Geocoded and stored
98: * in the table.
99: *
100: *
101: * @param p_api_version API Version (1.0)