APPS.CSL_CSP_LOCATIONS_ACC_PKG dependencies on HZ_LOCATIONS

Line 44: , HZ_LOCATIONS HZL

40: , HZ_CUST_SITE_USES_ALL CSU
41: , HZ_CUST_ACCT_SITES_ALL CAS
42: , CSP_RS_CUST_RELATIONS RCR
43: , HZ_PARTY_SITES HPS
44: , HZ_LOCATIONS HZL
45: WHERE PLA.location_id = b_location_id
46: AND CSU.site_use_id = PLA.site_use_id
47: AND CSU.site_use_code = 'SHIP_TO'
48: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )

201: , P_PK1_NUM_VALUE => p_location_id
202: , P_RESOURCE_ID => l_resource_id
203: );
204:
205: -- HZ_PARTY_SITES ( ALSO HZ_LOCATIONS IS FILLED BY THIS HOOK )
206: CSL_HZ_PARTY_SITES_ACC_PKG.INSERT_PARTY_SITE( r_location_ids.HPS_ID, l_resource_id );
207: END IF;
208: CLOSE c_location_ids;
209:

Line 236: , HZ_LOCATIONS HZL

232: , HZ_CUST_SITE_USES_ALL CSU
233: , HZ_CUST_ACCT_SITES_ALL CAS
234: , CSP_RS_CUST_RELATIONS RCR
235: , HZ_PARTY_SITES HPS
236: , HZ_LOCATIONS HZL
237: WHERE PLA.location_id = b_location_id
238: AND CSU.site_use_id = PLA.site_use_id
239: AND CSU.site_use_code = 'SHIP_TO'
240: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 338: -- HZ_LOCATIONS

334: );
335: -- HZ_PARTY_SITES
336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );
337:
338: -- HZ_LOCATIONS
339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );
340: END IF;
341:
342: CLOSE c_location_ids;

Line 339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );

335: -- HZ_PARTY_SITES
336: CSL_HZ_PARTY_SITES_ACC_PKG.UPDATE_PARTY_SITE( r_location_ids.HPS_ID );
337:
338: -- HZ_LOCATIONS
339: CSL_HZ_LOCATIONS_ACC_PKG.UPDATE_LOCATION( r_location_ids.HZL_ID );
340: END IF;
341:
342: CLOSE c_location_ids;
343: