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_LOCATION_OWNERS

Line 1928: FROM wsh_location_owners

1924: IS
1925:
1926: CURSOR c_check_duplicate(p_location_id IN NUMBER, p_owner_type IN NUMBER, p_party_id IN NUMBER) IS
1927: SELECT location_owner_id
1928: FROM wsh_location_owners
1929: WHERE wsh_location_id = p_location_id
1930: AND owner_type = p_owner_type
1931: AND owner_party_id = p_party_id;
1932:

Line 1958: FROM wsh_location_owners

1954:
1955: /*
1956: CURSOR get_location_info(c_location_id IN NUMBER) IS
1957: SELECT owner_party_id, location_owner_id
1958: FROM wsh_location_owners
1959: WHERE wsh_location_id = c_location_id;
1960: */
1961:
1962: CURSOR get_party_info(c_location_id IN NUMBER) IS

Line 2251: Insert into WSH_LOCATION_OWNERS

2247: LOOP
2248: BEGIN
2249: FORALL i in l_start..pLocLocationIdTbl.LAST
2250: --Primary key - location_owner_id
2251: Insert into WSH_LOCATION_OWNERS
2252: ( LOCATION_OWNER_ID,
2253: WSH_LOCATION_ID,
2254: OWNER_PARTY_ID,
2255: OWNER_TYPE,

Line 2262: wsh_location_owners_s.nextval,

2258: LAST_UPDATE_DATE,
2259: LAST_UPDATED_BY,
2260: LAST_UPDATE_LOGIN)
2261: Values (
2262: wsh_location_owners_s.nextval,
2263: pLocLocationIdTbl(i),
2264: pLocOwnerIdTbl(i),
2265: pLocOwnerTypeTbl(i),
2266: SYSDATE,