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_LOCATION_PARAMETERS_PKG dependencies on WSH_LOCATIONS

Line 11: -- i. Create_Facilities: Given location Id's from the WSH_LOCATIONS --

7: -- TYPE: PACKAGE BODY --
8: -- DESCRIPTION: Facility Creation Package. --
9: -- --
10: -- PROCEDURES: --
11: -- i. Create_Facilities: Given location Id's from the WSH_LOCATIONS --
12: -- table, it creates a facility for each --
13: -- location. --
14: -- ii. Create_Facility: Creates a single facility, given a location ID --
15: -- iii. Get_Facility_Info: Returns information about a facility, given --

Line 35: g_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;

31: g_nonindexed_Descriptions NoIndex_Varchar100_Tbl_Type := NoIndex_Varchar100_Tbl_Type();
32:
33: g_dup_locations STRINGARRAY;
34:
35: g_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;
36: g_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;
37: g_cur_index NUMBER;
38: g_names_exist BOOLEAN;
39:

Line 36: g_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;

32:
33: g_dup_locations STRINGARRAY;
34:
35: g_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;
36: g_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;
37: g_cur_index NUMBER;
38: g_names_exist BOOLEAN;
39:
40: -----------------------------------------------------------------------------

Line 211: FROM wsh_locations wl, hr_organization_units hou,

207: SELECT hou.name company_name,
208: hou.name site,
209: hou.creation_date cdate,
210: 'ORGANIZATION' company_type
211: FROM wsh_locations wl, hr_organization_units hou,
212: HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP
213: WHERE wl.source_location_id = p_location_id
214: AND wl.location_source_code = 'HR'
215: AND wl.source_location_id = hou.location_id

Line 230: FROM wsh_locations wl, hz_party_sites hps,

226: SELECT wc.carrier_name Company_Name,
227: wc.carrier_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
228: hps.creation_date Cdate,
229: 'CARRIER' Company_Type
230: FROM wsh_locations wl, hz_party_sites hps,
231: wsh_carriers_v wc
232: WHERE wl.source_location_id = p_location_id
233: AND wl.location_source_code = 'HZ'
234: AND wl.source_location_id = hps.location_id

Line 243: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,

239: SELECT hp.party_name Company_Name,
240: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
241: hps.creation_date Cdate,
242: 'CUSTOMER' Company_Type
243: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
244: hz_cust_acct_sites_all hcas
245: WHERE wl.source_location_id = p_location_id
246: AND wl.location_source_code = 'HZ'
247: AND wl.source_location_id = hps.location_id

Line 257: FROM wsh_locations wl, po_vendors po, hz_relationships rel,

253: SELECT hp.party_name Company_Name,
254: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
255: hps.creation_date Cdate,
256: 'SUPPLIER' Company_Type
257: FROM wsh_locations wl, po_vendors po, hz_relationships rel,
258: hz_party_sites hps, hz_parties hp
259: WHERE wl.source_location_id = p_location_id
260: AND wl.source_location_id = hps.location_id
261: AND hps.party_id = hp.party_id

Line 281: FROM WSH_LOCATIONS

277: x_description := NULL;
278:
279: BEGIN
280: SELECT location_source_code INTO l_hzr
281: FROM WSH_LOCATIONS
282: WHERE wsh_location_id = p_location_id;
283: EXCEPTION
284: WHEN OTHERS THEN
285: NULL;

Line 318: -- for all locations in WSH_LOCATIONS that are not already in

314: -----------------------------------------------------------------------------
315: -- PROCEDURE Fetch_Facility_Descriptions
316: --
317: -- Purpose Fetch company information and derive and cache the descriptions
318: -- for all locations in WSH_LOCATIONS that are not already in
319: -- FTE_LOCATION_PARAMETERS
320: -- Parameters None.
321: -----------------------------------------------------------------------------
322: PROCEDURE Fetch_Facility_Descriptions IS

Line 339: --Fetch company locations for all locations that exist in WSH_LOCATIONS

335: --counters
336: k NUMBER;
337: m NUMBER;
338:
339: --Fetch company locations for all locations that exist in WSH_LOCATIONS
340: --but NOT in FTE_LOCATION_PARAMETERS.
341: --Note that this query is the same as the one in fetch_single_facility_info,
342: --but without binding a location id. We order by date of creation, because
343: --in the case of multiple sites for an organization, we only pick the

Line 351: FROM wsh_locations wl, hr_organization_units hou,

347: wl.wsh_location_id LocId,
348: hou.name Site,
349: hou.creation_date Cdate,
350: 'ORGANIZATION' Company_Type
351: FROM wsh_locations wl, hr_organization_units hou,
352: HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,fte_location_parameters flp
353: WHERE wl.wsh_location_id = flp.location_id(+)
354: AND flp.location_id IS NULL
355: AND wl.location_source_code = 'HR'

Line 369: FROM wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc,

365: wl.wsh_location_id LocId,
366: wc.carrier_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
367: hps.creation_date cdate,
368: 'CARRIER' company_type
369: FROM wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc,
370: fte_location_parameters flp
371: WHERE wl.wsh_location_id = flp.location_id(+)
372: AND flp.location_id IS NULL
373: AND wl.location_source_code = 'HZ'

Line 384: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,

380: wl.wsh_location_id LocId,
381: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
382: hps.creation_date Cdate,
383: 'CUSTOMER' Company_Type
384: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
385: hz_cust_acct_sites_all hcas, fte_location_parameters flp,
386: wsh_location_owners wlo
387: WHERE wl.wsh_location_id = flp.location_id(+)
388: AND wl.wsh_location_id = wlo.wsh_location_id

Line 403: FROM wsh_locations wl, po_vendors po, hz_relationships rel,

399: SELECT hp.party_name Company_Name,
400: wl.wsh_location_id LocId,
401: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
402: hps.creation_date Cdate, 'SUPPLIER' Company_Type
403: FROM wsh_locations wl, po_vendors po, hz_relationships rel,
404: hz_party_sites hps, hz_parties hp, fte_location_parameters flp
405: WHERE wl.wsh_location_id = flp.location_id(+)
406: AND flp.location_id IS NULL
407: AND wl.source_location_id = hps.location_id

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

574: -- is used to make more efficient.
575: --
576: -- PARAMETERS :
577: -- IN Parameters:
578: -- 1. p_location_ids WSH_LOCATIONS_PKG.ID_Tbl_Type (Required)
579: -- The location ids for the facilities.
580: --
581: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
582: -- Corresponding company names for each

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

577: -- IN Parameters:
578: -- 1. p_location_ids WSH_LOCATIONS_PKG.ID_Tbl_Type (Required)
579: -- The location ids for the facilities.
580: --
581: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
582: -- Corresponding company names for each
583: -- location ID.
584: -- 3. p_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type (Not Required)
585: -- Corresponding site names for the

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

580: --
581: -- 2. p_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type (Not Required)
582: -- Corresponding company names for each
583: -- location ID.
584: -- 3. p_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type (Not Required)
585: -- Corresponding site names for the
586: -- location ids, if applicable.
587: --
588: -- OUT Parameters : x_return_status VARCHAR2

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

595: -- Previous version 1.0
596: -- Initial version 1.0
597: -- End of comments
598: -----------------------------------------------------------------------------------
599: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
600: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
601: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
602: x_return_status OUT NOCOPY VARCHAR2,
603: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 600: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,

596: -- Initial version 1.0
597: -- End of comments
598: -----------------------------------------------------------------------------------
599: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
600: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
601: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
602: x_return_status OUT NOCOPY VARCHAR2,
603: x_error_msg OUT NOCOPY VARCHAR2) IS
604:

Line 601: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,

597: -- End of comments
598: -----------------------------------------------------------------------------------
599: PROCEDURE Create_Facilities (p_location_ids IN WSH_LOCATIONS_PKG.ID_Tbl_Type,
600: p_company_names IN WSH_LOCATIONS_PKG.Address_Tbl_Type,
601: p_site_names IN WSH_LOCATIONS_PKG.LocationCode_Tbl_Type,
602: x_return_status OUT NOCOPY VARCHAR2,
603: x_error_msg OUT NOCOPY VARCHAR2) IS
604:
605: CURSOR get_location_owner(c_location_id IN NUMBER) IS

Line 950: wsh_locations wl

946: SELECT wl.wsh_location_id WSH_LOCATION_ID
947: FROM hz_party_sites hps,
948: hz_cust_acct_sites_all hcas,
949: hz_cust_site_uses_all hcsu, po_location_associations_all pla,
950: wsh_locations wl
951: WHERE pla.customer_id = hcas.cust_account_id
952: AND pla.site_use_id = hcsu.site_use_id
953: AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id
954: AND hcas.party_site_id = hps.party_site_id

Line 1083: l_location_id_tab WSH_LOCATIONS_PKG.ID_Tbl_Type;

1079: x_error_msg OUT NOCOPY VARCHAR2) IS
1080:
1081: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CREATE_FACILITY';
1082: l_debug_on BOOLEAN;
1083: l_location_id_tab WSH_LOCATIONS_PKG.ID_Tbl_Type;
1084: l_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;
1085: l_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;
1086:
1087: BEGIN

Line 1084: l_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;

1080:
1081: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CREATE_FACILITY';
1082: l_debug_on BOOLEAN;
1083: l_location_id_tab WSH_LOCATIONS_PKG.ID_Tbl_Type;
1084: l_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;
1085: l_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;
1086:
1087: BEGIN
1088: Init_Debug(l_module_name);

Line 1085: l_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;

1081: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CREATE_FACILITY';
1082: l_debug_on BOOLEAN;
1083: l_location_id_tab WSH_LOCATIONS_PKG.ID_Tbl_Type;
1084: l_site_names WSH_LOCATIONS_PKG.LocationCode_Tbl_Type;
1085: l_company_names WSH_LOCATIONS_PKG.Address_Tbl_Type;
1086:
1087: BEGIN
1088: Init_Debug(l_module_name);
1089:

Line 1293: l_location WSH_LOCATIONS_PKG.LOCATION_REC_TYPE;

1289: x_timezone OUT NOCOPY VARCHAR2,
1290: x_geometry OUT NOCOPY MDSYS.SDO_GEOMETRY
1291: ) is
1292:
1293: l_location WSH_LOCATIONS_PKG.LOCATION_REC_TYPE;
1294: x_error_msg VARCHAR2(100);
1295: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'Get_Fac_Lat_Long_and_TimeZone';
1296: BEGIN
1297: l_location.COUNTRY := p_country;