eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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: -- , county hz_locations.county%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: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE

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: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE
45: , territory_short_name fnd_territories_vl.territory_short_name%TYPE

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: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE
45: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
46: , geometry mdsys.sdo_geometry

Line 43: -- , county hz_locations.county%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: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE
45: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
46: , geometry mdsys.sdo_geometry
47: , start_date_active DATE

Line 44: -- , province hz_locations.province%TYPE

40: , city hz_locations.city%TYPE
41: , state hz_locations.state%TYPE
42: , country hz_locations.country%TYPE
43: -- , county hz_locations.county%TYPE
44: -- , province hz_locations.province%TYPE
45: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
46: , geometry mdsys.sdo_geometry
47: , start_date_active DATE
48: , end_date_active DATE

Line 59: , location_id hz_locations.location_id%TYPE

55:
56: TYPE address_rec_type1 IS RECORD(
57: party_id hz_parties.party_id%TYPE
58: , party_site_id hz_party_sites.party_site_id%TYPE
59: , location_id hz_locations.location_id%TYPE
60: , address_id per_addresses.address_id%TYPE
61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE

Line 61: , street hz_locations.address1%TYPE

57: party_id hz_parties.party_id%TYPE
58: , party_site_id hz_party_sites.party_site_id%TYPE
59: , location_id hz_locations.location_id%TYPE
60: , address_id per_addresses.address_id%TYPE
61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE

Line 62: , postal_code hz_locations.postal_code%TYPE

58: , party_site_id hz_party_sites.party_site_id%TYPE
59: , location_id hz_locations.location_id%TYPE
60: , address_id per_addresses.address_id%TYPE
61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE

Line 63: , city hz_locations.city%TYPE

59: , location_id hz_locations.location_id%TYPE
60: , address_id per_addresses.address_id%TYPE
61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE

Line 64: , state hz_locations.state%TYPE

60: , address_id per_addresses.address_id%TYPE
61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE
68: , territory_short_name fnd_territories_vl.territory_short_name%TYPE

Line 65: , country hz_locations.country%TYPE

61: , street hz_locations.address1%TYPE
62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE
68: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
69: , geometry mdsys.sdo_geometry

Line 66: , county hz_locations.county%TYPE

62: , postal_code hz_locations.postal_code%TYPE
63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE
68: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
69: , geometry mdsys.sdo_geometry
70: , start_date_active DATE

Line 67: , province hz_locations.province%TYPE

63: , city hz_locations.city%TYPE
64: , state hz_locations.state%TYPE
65: , country hz_locations.country%TYPE
66: , county hz_locations.county%TYPE
67: , province hz_locations.province%TYPE
68: , territory_short_name fnd_territories_vl.territory_short_name%TYPE
69: , geometry mdsys.sdo_geometry
70: , start_date_active DATE
71: , end_date_active DATE

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

93: *
94: * RS_EMPLOYEE
95: * Party is already created by HRMS whenever an Employee is created.
96: * This API will take care of inserting Party Sites and copying
97: * the address in PER_ADDRESS in HRMS Module to HZ_LOCATIONS in TCA.
98: * Before, party 'Dep/Arr Party' were created even for Employee
99: * Resources. Now this API will reuse the Party Created by HRMS itself.
100: *
101: * RS_PARTY

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

118: * requesting the address of the Resource.
119: *
120: * Automatic Geocoding of the Address
121: * If the Address corresponding to the determined Location is not yet Geocoded
122: * (GEOMETRY being NULL in HZ_LOCATIONS), the Address is Geocoded and stored
123: * in the table.
124: *
125: *
126: * @param p_api_version API Version (1.0)

Line 185: * HZ_LOCATIONS with the Geometry of the Address.

181: );
182:
183: /**
184: * Resolves the passed address and updates the corresponding address in
185: * HZ_LOCATIONS with the Geometry of the Address.
186: *
187: * The given address is resolved using Location Finder only when the
188: * profiles "CSR: Create Location" and "CSF: Location Finder Installed"
189: * are set to Yes. The geometry corresponding to the Location Specified