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.

APPS.CSF_TASK_ADDRESS_PVT dependencies on HZ_LOCATIONS

Line 24: UPDATE hz_locations

20: PROCEDURE update_geometry (p_location_id IN NUMBER)
21: IS
22: PRAGMA AUTONOMOUS_TRANSACTION;
23: BEGIN
24: UPDATE hz_locations
25: SET geometry = NULL
26: WHERE location_id = p_location_id;
27:
28: COMMIT;

Line 415: hz_locations l,

411: tl.territory_short_name country,
412: l.timezone_id
413: FROM jtf_tasks_b t,
414: jtf_task_types_b tt,
415: hz_locations l,
416: fnd_territories_tl tl,
417: jtf_task_statuses_vl jts
418: WHERE tt.task_type_id = t.task_type_id
419: AND t.location_id is not null

Line 450: hz_locations l,

446: l.timezone_id
447: FROM jtf_tasks_b t,
448: jtf_task_types_b tt,
449: hz_party_sites hps,
450: hz_locations l,
451: fnd_territories_tl tl,
452: jtf_task_statuses_vl jts
453: WHERE tt.task_type_id = t.task_type_id
454: AND t.address_id is not null

Line 487: hz_locations l,

483: tl.territory_short_name country,
484: l.timezone_id
485: FROM jtf_tasks_b t,
486: jtf_task_types_b tt,
487: hz_locations l,
488: fnd_territories_tl tl,
489: jtf_task_statuses_vl jts,
490: CSF_SPATIAL_CTRY_MAPPINGS sp
491: WHERE tt.task_type_id = t.task_type_id

Line 525: hz_locations l,

521: l.timezone_id
522: FROM jtf_tasks_b t,
523: jtf_task_types_b tt,
524: hz_party_sites hps,
525: hz_locations l,
526: fnd_territories_tl tl,
527: jtf_task_statuses_vl jts,
528: CSF_SPATIAL_CTRY_MAPPINGS sp
529: WHERE tt.task_type_id = t.task_type_id

Line 664: returns the locus given the location_id from the hz locations table

660: END retrieve_data;
661:
662: /*
663: Utility procedure to fetch the locus for a location id.
664: returns the locus given the location_id from the hz locations table
665: */
666: PROCEDURE get_geometry (
667: p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2,

Line 671: p_location_id IN hz_locations.location_id%TYPE,

667: p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2,
669: p_commit IN VARCHAR2,
670: p_validation_level IN NUMBER,
671: p_location_id IN hz_locations.location_id%TYPE,
672: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2

Line 672: x_locus OUT NOCOPY hz_locations.geometry%TYPE,

668: p_init_msg_list IN VARCHAR2,
669: p_commit IN VARCHAR2,
670: p_validation_level IN NUMBER,
671: p_location_id IN hz_locations.location_id%TYPE,
672: x_locus OUT NOCOPY hz_locations.geometry%TYPE,
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2
676: )

Line 681: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)

677: IS
678: l_api_name CONSTANT VARCHAR2 (30) := 'GET_GEOMETRY';
679: l_api_version CONSTANT NUMBER := 1.0;
680:
681: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)
682: IS
683: SELECT geometry
684: FROM hz_locations
685: WHERE location_id = l_location_id;

Line 684: FROM hz_locations

680:
681: CURSOR l_check_locus_csr (l_location_id hz_locations.location_id%TYPE)
682: IS
683: SELECT geometry
684: FROM hz_locations
685: WHERE location_id = l_location_id;
686: BEGIN
687: -- Standard check for call compatibility
688: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 786: p_locus IN hz_locations.geometry%TYPE,

782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2,
784: p_commit IN VARCHAR2,
785: p_validation_level IN NUMBER,
786: p_locus IN hz_locations.geometry%TYPE,
787: x_result OUT NOCOPY VARCHAR2,
788: x_return_status OUT NOCOPY VARCHAR2,
789: x_msg_count OUT NOCOPY NUMBER,
790: x_msg_data OUT NOCOPY VARCHAR2

Line 1308: l_location_id hz_locations.location_id%TYPE;

1304: SELECT task_id
1305: FROM csf_ext_locations
1306: WHERE task_id = l_task_id;
1307:
1308: l_location_id hz_locations.location_id%TYPE;
1309: l_task_id csf_ext_locations.task_id%TYPE;
1310: BEGIN
1311: -- Standard check for call compatibility
1312: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 1896: p_location_id IN hz_locations.location_id%TYPE,

1892: p_init_msg_list IN VARCHAR2,
1893: p_commit IN VARCHAR2,
1894: p_validation_level IN NUMBER,
1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,

Line 1897: p_address1 IN hz_locations.address1%TYPE,

1893: p_commit IN VARCHAR2,
1894: p_validation_level IN NUMBER,
1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,

Line 1898: p_address2 IN hz_locations.address2%TYPE,

1894: p_validation_level IN NUMBER,
1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,

Line 1899: p_address3 IN hz_locations.address3%TYPE,

1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,

Line 1900: p_address4 IN hz_locations.address4%TYPE,

1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,

Line 1901: p_city IN hz_locations.city%TYPE,

1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,

Line 1902: p_postal_code IN hz_locations.postal_code%TYPE,

1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,

Line 1903: p_state IN hz_locations.state%TYPE,

1899: p_address3 IN hz_locations.address3%TYPE,
1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,
1907: p_timezone_id IN hz_locations.timezone_id%TYPE,

Line 1904: p_province IN hz_locations.province%TYPE,

1900: p_address4 IN hz_locations.address4%TYPE,
1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,
1907: p_timezone_id IN hz_locations.timezone_id%TYPE,
1908: x_result OUT NOCOPY VARCHAR2,

Line 1905: p_county IN hz_locations.county%TYPE,

1901: p_city IN hz_locations.city%TYPE,
1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,
1907: p_timezone_id IN hz_locations.timezone_id%TYPE,
1908: x_result OUT NOCOPY VARCHAR2,
1909: x_return_status OUT NOCOPY VARCHAR2,

Line 1906: p_country IN hz_locations.country%TYPE,

1902: p_postal_code IN hz_locations.postal_code%TYPE,
1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,
1907: p_timezone_id IN hz_locations.timezone_id%TYPE,
1908: x_result OUT NOCOPY VARCHAR2,
1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,

Line 1907: p_timezone_id IN hz_locations.timezone_id%TYPE,

1903: p_state IN hz_locations.state%TYPE,
1904: p_province IN hz_locations.province%TYPE,
1905: p_county IN hz_locations.county%TYPE,
1906: p_country IN hz_locations.country%TYPE,
1907: p_timezone_id IN hz_locations.timezone_id%TYPE,
1908: x_result OUT NOCOPY VARCHAR2,
1909: x_return_status OUT NOCOPY VARCHAR2,
1910: x_msg_count OUT NOCOPY NUMBER,
1911: x_msg_data OUT NOCOPY VARCHAR2

Line 1916: l_locus hz_locations.geometry%TYPE;

1912: )
1913: IS
1914: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_TASK_DATA';
1915: l_api_version CONSTANT NUMBER := 1.0;
1916: l_locus hz_locations.geometry%TYPE;
1917: l_country_code hz_locations.country%TYPE;
1918: l_time_zone_check BOOLEAN;
1919: l_timezone_id VARCHAR2 (80);
1920:

Line 1917: l_country_code hz_locations.country%TYPE;

1913: IS
1914: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_TASK_DATA';
1915: l_api_version CONSTANT NUMBER := 1.0;
1916: l_locus hz_locations.geometry%TYPE;
1917: l_country_code hz_locations.country%TYPE;
1918: l_time_zone_check BOOLEAN;
1919: l_timezone_id VARCHAR2 (80);
1920:
1921: CURSOR c_timezone_check (p_timezone_id NUMBER)

Line 1927: CURSOR c_country_code (p_country hz_locations.country%TYPE)

1923: SELECT NAME
1924: FROM hz_timezones_vl
1925: WHERE timezone_id = p_timezone_id;
1926:
1927: CURSOR c_country_code (p_country hz_locations.country%TYPE)
1928: IS
1929: SELECT ftt.territory_code country_code
1930: FROM fnd_territories_tl ftt
1931: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)

Line 2135: p_location_id IN hz_locations.location_id%TYPE,

2131: p_api_version IN NUMBER,
2132: p_init_msg_list IN VARCHAR2,
2133: p_commit IN VARCHAR2,
2134: p_validation_level IN NUMBER,
2135: p_location_id IN hz_locations.location_id%TYPE,
2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,

Line 2136: p_address1 IN hz_locations.address1%TYPE,

2132: p_init_msg_list IN VARCHAR2,
2133: p_commit IN VARCHAR2,
2134: p_validation_level IN NUMBER,
2135: p_location_id IN hz_locations.location_id%TYPE,
2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,

Line 2137: p_address2 IN hz_locations.address2%TYPE,

2133: p_commit IN VARCHAR2,
2134: p_validation_level IN NUMBER,
2135: p_location_id IN hz_locations.location_id%TYPE,
2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,

Line 2138: p_address3 IN hz_locations.address3%TYPE,

2134: p_validation_level IN NUMBER,
2135: p_location_id IN hz_locations.location_id%TYPE,
2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,

Line 2139: p_address4 IN hz_locations.address4%TYPE,

2135: p_location_id IN hz_locations.location_id%TYPE,
2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,

Line 2140: p_city IN hz_locations.city%TYPE,

2136: p_address1 IN hz_locations.address1%TYPE,
2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,

Line 2141: p_postal_code IN hz_locations.postal_code%TYPE,

2137: p_address2 IN hz_locations.address2%TYPE,
2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,

Line 2142: p_state IN hz_locations.state%TYPE,

2138: p_address3 IN hz_locations.address3%TYPE,
2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,

Line 2143: p_province IN hz_locations.province%TYPE,

2139: p_address4 IN hz_locations.address4%TYPE,
2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,

Line 2144: p_county IN hz_locations.county%TYPE,

2140: p_city IN hz_locations.city%TYPE,
2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2148: p_timezone_id IN hz_locations.timezone_id%TYPE,

Line 2145: p_country IN hz_locations.country%TYPE,

2141: p_postal_code IN hz_locations.postal_code%TYPE,
2142: p_state IN hz_locations.state%TYPE,
2143: p_province IN hz_locations.province%TYPE,
2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2148: p_timezone_id IN hz_locations.timezone_id%TYPE,
2149: x_return_status OUT NOCOPY VARCHAR2,

Line 2148: p_timezone_id IN hz_locations.timezone_id%TYPE,

2144: p_county IN hz_locations.county%TYPE,
2145: p_country IN hz_locations.country%TYPE,
2146: p_validated_flag IN csf_ext_locations.validated_flag%TYPE,
2147: p_override_flag IN csf_ext_locations.override_flag%TYPE,
2148: p_timezone_id IN hz_locations.timezone_id%TYPE,
2149: x_return_status OUT NOCOPY VARCHAR2,
2150: x_msg_count OUT NOCOPY NUMBER,
2151: x_msg_data OUT NOCOPY VARCHAR2
2152: )

Line 2158: l_country_code hz_locations.country%TYPE;

2154: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_ADDRESS';
2155: l_api_version CONSTANT NUMBER := 1.0;
2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2158: l_country_code hz_locations.country%TYPE;
2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2161: IS
2162: SELECT ftt.territory_code country_code

Line 2159: l_country hz_locations.country%TYPE;

2155: l_api_version CONSTANT NUMBER := 1.0;
2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2158: l_country_code hz_locations.country%TYPE;
2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2161: IS
2162: SELECT ftt.territory_code country_code
2163: FROM fnd_territories_tl ftt

Line 2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)

2156: l_short_msg csf_ext_locations.log_detail_short%TYPE;
2157: l_long_msg csf_ext_locations.log_detail_long%TYPE;
2158: l_country_code hz_locations.country%TYPE;
2159: l_country hz_locations.country%TYPE;
2160: CURSOR c_country_code (p_country hz_locations.country%TYPE)
2161: IS
2162: SELECT ftt.territory_code country_code
2163: FROM fnd_territories_tl ftt
2164: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)