APPS.CSL_HZ_PARTY_SITES_ACC_PKG dependencies on CSL_HZ_LOCATIONS_ACC_PKG

Line 53: CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id

49: /*Insert the matching location*/
50: OPEN c_party_site( b_party_site_id => p_party_site_id );
51: FETCH c_party_site INTO r_party_site;
52: IF c_party_site%FOUND THEN
53: CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id
54: , p_resource_id => p_resource_id );
55: END IF;
56: CLOSE c_party_site;
57:

Line 154: CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id

150: /*Delete the matching location*/
151: OPEN c_party_site( b_party_site_id => p_party_site_id );
152: FETCH c_party_site INTO r_party_site;
153: IF c_party_site%FOUND THEN
154: CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id
155: , p_resource_id => p_resource_id );
156: END IF;
157: CLOSE c_party_site;
158:

Line 212: CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id

208: /*Delete the matching location*/
209: OPEN c_party_site( b_party_site_id => p_old_party_site_id );
210: FETCH c_party_site INTO r_party_site;
211: IF c_party_site%FOUND THEN
212: CSL_HZ_LOCATIONS_ACC_PKG.DELETE_LOCATION( p_location_id => r_party_site.location_id
213: , p_resource_id => p_resource_id );
214: END IF;
215: CLOSE c_party_site;
216: END IF;

Line 233: CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id

229: /*Insert the matching location*/
230: OPEN c_party_site( b_party_site_id => p_new_party_site_id );
231: FETCH c_party_site INTO r_party_site;
232: IF c_party_site%FOUND THEN
233: CSL_HZ_LOCATIONS_ACC_PKG.INSERT_LOCATION( p_location_id => r_party_site.location_id
234: , p_resource_id => p_resource_id );
235: END IF;
236: CLOSE c_party_site;
237: END IF;