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.FTE_REGION_ZONE_LOADER dependencies on WSH_REGIONS_INTERFACE

Line 25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;

21: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
22:
23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:

Line 26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;

22:
23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

Line 27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;

23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;

Line 28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;

24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;

Line 712: SELECT WSH_REGIONS_INTERFACE_S.NEXTVAL

708: L_POSTAL_CODE_FROM POSTAL_CODE_FROM_TAB;
709: L_POSTAL_CODE_TO POSTAL_CODE_TO_TAB;
710:
711: CURSOR GET_INTERFACE_REGION_ID IS
712: SELECT WSH_REGIONS_INTERFACE_S.NEXTVAL
713: FROM DUAL;
714:
715: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_REGION';
716:

Line 770: INSERT INTO WSH_REGIONS_INTERFACE(

766: END LOOP;
767:
768: FORALL i in L_REGION_ID.FIRST..L_REGION_ID.LAST
769:
770: INSERT INTO WSH_REGIONS_INTERFACE(
771: REGION_ID,
772: PARENT_REGION_ID,
773: COUNTRY_CODE,
774: STATE_CODE,