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_FACILITIES_INTEGRATION dependencies on WSH_LOCATIONS_PKG

Line 30: -- 1. p_location_ids WSH_LOCATIONS_PKG.ID_Tbl_Type (Required)

26: -- is used to make more efficient.
27: --
28: -- PARAMETERS :
29: -- IN Parameters:
30: -- 1. p_location_ids WSH_LOCATIONS_PKG.ID_Tbl_Type (Required)
31: -- The location ids for the facilities.
32: --
33: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
34: -- Corresponding company names for each

Line 33: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)

29: -- IN Parameters:
30: -- 1. p_location_ids WSH_LOCATIONS_PKG.ID_Tbl_Type (Required)
31: -- The location ids for the facilities.
32: --
33: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
34: -- Corresponding company names for each
35: -- location ID.
36: -- 3. p_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type (Not Required)
37: -- Corresponding site names for the

Line 36: -- 3. p_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type (Not Required)

32: --
33: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
34: -- Corresponding company names for each
35: -- location ID.
36: -- 3. p_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type (Not Required)
37: -- Corresponding site names for the
38: -- location ids, if applicable.
39: --
40: -- OUT Parameters : x_return_status VARCHAR2

Line 51: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,

47: -- Previous version 1.0
48: -- Initial version 1.0
49: -- End of comments
50: -----------------------------------------------------------------------------------
51: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
52: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
53: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 52: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

48: -- Initial version 1.0
49: -- End of comments
50: -----------------------------------------------------------------------------------
51: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
52: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
53: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_error_msg OUT NOCOPY VARCHAR2) IS
56:

Line 53: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

49: -- End of comments
50: -----------------------------------------------------------------------------------
51: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
52: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
53: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_error_msg OUT NOCOPY VARCHAR2) IS
56:
57: --