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.WSH_LOCATIONS_PKG dependencies on WSH_LOCATIONS

Line 1: PACKAGE BODY WSH_LOCATIONS_PKG as

1: PACKAGE BODY WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMB.pls 120.12.12000000.2 2007/10/09 13:15:56 arimukhe ship $ */
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --

Line 4: -- Package: WSH_LOCATIONS_PKG

1: PACKAGE BODY WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMB.pls 120.12.12000000.2 2007/10/09 13:15:56 arimukhe ship $ */
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --
6: -- Purpose: To populate data in WSH_LOCATIONS with the data in
7: -- HZ_LOCATIONS, HR_LOCATIONS and PO_VENDOR_SITES.
8: --

Line 6: -- Purpose: To populate data in WSH_LOCATIONS with the data in

2: /* $Header: WSHLOCMB.pls 120.12.12000000.2 2007/10/09 13:15:56 arimukhe ship $ */
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --
6: -- Purpose: To populate data in WSH_LOCATIONS with the data in
7: -- HZ_LOCATIONS, HR_LOCATIONS and PO_VENDOR_SITES.
8: --
9: --
10:

Line 12: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_LOCATIONS_PKG';

8: --
9: --
10:
11: --
12: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_LOCATIONS_PKG';
13: --
14:
15: TYPE Generic_Cache_Rec_Typ IS RECORD(
16: INPUT_PARAM1 VARCHAR2(500),

Line 307: UPDATE wsh_locations

303: WSH_DEBUG_SV.LogMsg(l_module_name, 'Geometry Created Succesfully');
304: END IF;
305:
306: BEGIN
307: UPDATE wsh_locations
308: SET geometry = l_geometry
309: WHERE wsh_location_id = p_location_ids(k);
310: EXCEPTION
311: WHEN OTHERS THEN

Line 349: | This procedure will populate the WSH_LOCATIONS table |

345: | Process_Locations |
346: | |
347: | DESCRIPTION |
348: | |
349: | This procedure will populate the WSH_LOCATIONS table |
350: | with the locations in HZ_LOCATIONS (whose usage is deliver_to |
351: | or ship_to) and HR_LOCATIONS |
352: | |
353: +===========================================================================*/

Line 426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b

422: WSH.LATITUDE,
423: WSH.LONGITUDE,
424: NVL(TZ.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
425: SYSDATE
426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b
427: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
428: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
429: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
430: AND hz.location_id = wsh.source_location_id

Line 470: AND hz.location_id NOT IN ( select /+ INDEX (wl,WSH_LOCATIONS_N1) /

466: FROM HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_VL TZ
467: WHERE HZ.LOCATION_ID between p_from_location and p_to_location
468: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
469: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
470: AND hz.location_id NOT IN ( select /*+ INDEX (wl,WSH_LOCATIONS_N1) */
471: wl.source_location_id
472: from wsh_locations wl
473: where wl.location_source_code = 'HZ'
474: and wl.source_location_id = hz.location_id)

Line 472: from wsh_locations wl

468: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
469: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
470: AND hz.location_id NOT IN ( select /*+ INDEX (wl,WSH_LOCATIONS_N1) */
471: wl.source_location_id
472: from wsh_locations wl
473: where wl.location_source_code = 'HZ'
474: and wl.source_location_id = hz.location_id)
475: AND hps.location_id = hz.location_id
476: AND hp.party_id = hps.party_id

Line 511: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp

507: WSH.LATITUDE,
508: WSH.LONGITUDE,
509: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
510: SYSDATE
511: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
512: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
513: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
514: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
515: AND hr.location_id = wsh.source_location_id

Line 544: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,

540: WSH.LATITUDE,
541: WSH.LONGITUDE,
542: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
543: SYSDATE
544: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL,
545: PO_LOCATION_ASSOCIATIONS_ALL PLA
546: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
547: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
548: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)

Line 580: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL

576: WSH.LATITUDE,
577: WSH.LONGITUDE,
578: NVL(HR.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
579: SYSDATE
580: FROM WSH_LOCATIONS WSH, HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
581: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
582: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
583: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
584: AND hr.location_id = wsh.source_location_id

Line 622: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

618: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL, hr_organization_units ou, mtl_parameters mp
619: WHERE HR.LOCATION_ID between p_from_location and p_to_location
620: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
621: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
622: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl
623: where wl.location_source_code = 'HR'
624: and wl.source_location_id = hr.location_id)
625: AND HRTL.LOCATION_ID = HR.LOCATION_ID
626: AND HRTL.LANGUAGE = USERENV('LANG')

Line 656: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

652: PO_LOCATION_ASSOCIATIONS_ALL PLA
653: WHERE HR.LOCATION_ID between p_from_location and p_to_location
654: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
655: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
656: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl
657: where wl.location_source_code = 'HR'
658: and wl.source_location_id = hr.location_id)
659: AND HRTL.LOCATION_ID = HR.LOCATION_ID
660: AND HRTL.LANGUAGE = USERENV('LANG')

Line 691: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

687: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
688: WHERE HR.LOCATION_ID between p_from_location and p_to_location
689: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
690: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
691: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl
692: where wl.location_source_code = 'HR'
693: and wl.source_location_id = hr.location_id)
694: AND HRTL.LOCATION_ID = HR.LOCATION_ID
695: AND HRTL.LANGUAGE = USERENV('LANG')

Line 727: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl

723: FROM HR_LOCATIONS_ALL HR, HR_LOCATIONS_ALL_TL HRTL
724: WHERE HR.LOCATION_ID between p_from_location and p_to_location
725: AND nvl(hr.last_update_date,sysdate) >= nvl(l_start_date, nvl(hr.last_update_date,sysdate))
726: AND nvl(hr.last_update_date,sysdate) < nvl(l_end_date, nvl(hr.last_update_date,sysdate)+1)
727: AND hr.location_id NOT IN ( select wl.source_location_id from wsh_locations wl
728: where wl.location_source_code = 'HR'
729: and wl.source_location_id = hr.location_id)
730: AND HR.Ship_To_Site_Flag = 'Y'
731: AND HRTL.LOCATION_ID = HR.LOCATION_ID

Line 1719: Insert into WSH_LOCATIONS

1715:
1716: LOOP
1717: BEGIN
1718: forall i in l_start..pInsertLocationIdTbl.LAST
1719: Insert into WSH_LOCATIONS
1720: (WSH_LOCATION_ID,
1721: SOURCE_LOCATION_ID,
1722: LOCATION_SOURCE_CODE,
1723: LOCATION_CODE,

Line 1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);

1808: -- Bug 4775798
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);
1813: IF l_debug_on THEN
1814: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1815: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1816: ELSE

Line 1857: update WSH_LOCATIONS

1853: END IF;
1854: --
1855: BEGIN
1856: forall i in pUpdateLocationIdTbl.FIRST..pUpdateLocationIdTbl.LAST
1857: update WSH_LOCATIONS
1858: set location_code = pUpdateLocCodeTbl(i),
1859: address1 = pUpdateAddress1Tbl(i),
1860: address2 = pUpdateAddress2Tbl(i),
1861: address3 = pUpdateAddress3Tbl(i),

Line 1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);

1904: -- Bug 4775798
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1912: ELSE

Line 2477: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

2473: IF c_convert%ISOPEN THEN
2474: CLOSE c_convert;
2475: END IF;
2476: WSH_UTIL_CORE.DEFAULT_HANDLER(
2477: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2478: l_module_name);
2479:
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

2544:
2545: EXCEPTION
2546: WHEN OTHERS THEN
2547: WSH_UTIL_CORE.DEFAULT_HANDLER(
2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2549: l_module_name);
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2560: END WSH_LOCATIONS_PKG;

2556: END convert_internal_cust_location;
2557:
2558:
2559:
2560: END WSH_LOCATIONS_PKG;