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.HZ_POPULATE_TIMEZONE_PKG dependencies on HZ_LOCATIONS

Line 400: from hz_locations;

396: PROCEDURE LOCATION_TIMEZONE(errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY
397: VARCHAR2, p_overwrite_flag IN varchar2) is
398: cursor location_csr is
399: select location_id, country, state, city, postal_code
400: from hz_locations;
401:
402: cursor location_tz_csr is
403: select location_id, country, state, city, postal_code
404: from hz_locations

Line 404: from hz_locations

400: from hz_locations;
401:
402: cursor location_tz_csr is
403: select location_id, country, state, city, postal_code
404: from hz_locations
405: where timezone_id is null;
406:
407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;

Line 407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;

403: select location_id, country, state, city, postal_code
404: from hz_locations
405: where timezone_id is null;
406:
407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;

Line 408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;

404: from hz_locations
405: where timezone_id is null;
406:
407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
412:

Line 409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;

405: where timezone_id is null;
406:
407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
412:
413: I_COUNTRY COUNTRYList;

Line 410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;

406:
407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
412:
413: I_COUNTRY COUNTRYList;
414: I_CITY CITYList;

Line 411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;

407: TYPE COUNTRYList IS TABLE OF HZ_LOCATIONS.COUNTRY%TYPE;
408: TYPE CITYList IS TABLE OF HZ_LOCATIONS.CITY%TYPE;
409: TYPE POSTAL_CODEList IS TABLE OF HZ_LOCATIONS.POSTAL_CODE%TYPE;
410: TYPE STATEList IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
411: TYPE LOCATION_IDList IS TABLE OF HZ_LOCATIONS.LOCATION_ID%TYPE;
412:
413: I_COUNTRY COUNTRYList;
414: I_CITY CITYList;
415: I_POSTAL_CODE POSTAL_CODEList;

Line 471: UPDATE hz_locations

467: then -- we don't raise error
468: l_timezone_id := null;
469: end if;
470:
471: UPDATE hz_locations
472: SET timezone_id = l_timezone_id
473: WHERE location_id = I_LOCATION_ID(i);
474:
475: END LOOP;

Line 521: UPDATE hz_locations

517: then -- we don't raise error
518: l_timezone_id := null;
519: end if;
520:
521: UPDATE hz_locations
522: SET timezone_id = l_timezone_id
523: WHERE location_id = I_LOCATION_ID(i);
524:
525: END LOOP;