APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on HZ_LOCATIONS

Line 2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'

2299: install_location_type_code location_type_code
2300: FROM csi_item_instances
2301: WHERE instance_id = p_instance_id;
2302:
2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'
2304: SELECT csi.install_location_id
2305: FROM csi_item_instances csi,
2306: hz_locations hl
2307: WHERE install_location_type_code = 'HZ_LOCATIONS'

Line 2306: hz_locations hl

2302:
2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'
2304: SELECT csi.install_location_id
2305: FROM csi_item_instances csi,
2306: hz_locations hl
2307: WHERE install_location_type_code = 'HZ_LOCATIONS'
2308: AND csi.owner_party_source_table = 'HZ_PARTIES'
2309: AND hl.location_id = csi.install_location_id
2310: AND NOT EXISTS (SELECT 1

Line 2307: WHERE install_location_type_code = 'HZ_LOCATIONS'

2303: CURSOR hz_loc_csr (p_instance_id NUMBER) IS -- for location type = 'HZ_LOCATIONS'
2304: SELECT csi.install_location_id
2305: FROM csi_item_instances csi,
2306: hz_locations hl
2307: WHERE install_location_type_code = 'HZ_LOCATIONS'
2308: AND csi.owner_party_source_table = 'HZ_PARTIES'
2309: AND hl.location_id = csi.install_location_id
2310: AND NOT EXISTS (SELECT 1
2311: FROM hz_party_sites hps,

Line 2342: FROM hz_locations hl

2338: SELECT
2339: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3,
2340: hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null,
2341: null,null,null,null,null,null,'n','n',80,1,1),1,80) loc_address
2342: FROM hz_locations hl
2343: WHERE hl.location_id = p_location_id;
2344:
2345: l_api_name VARCHAR2(35) := 'check_prod_instance';
2346: l_proc_name VARCHAR2(35) := 'CHECK_PROD_INSTANCE';

Line 2350: l_hz_Loc_id HZ_LOCATIONS.location_id%TYPE;

2346: l_proc_name VARCHAR2(35) := 'CHECK_PROD_INSTANCE';
2347:
2348: l_location_id CSI_ITEM_INSTANCES.LOCATION_ID%TYPE;
2349: l_location_type_code CSI_ITEM_INSTANCES.LOCATION_TYPE_CODE%TYPE;
2350: l_hz_Loc_id HZ_LOCATIONS.location_id%TYPE;
2351:
2352: instance_failed EXCEPTION;
2353:
2354: BEGIN

Line 2371: IF (l_location_type_code = 'HZ_LOCATIONS') THEN

2367: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2368: END IF;
2369: CLOSE csi_csr;
2370:
2371: IF (l_location_type_code = 'HZ_LOCATIONS') THEN
2372: OPEN hz_loc_csr (p_instance_id);
2373: FETCH hz_loc_csr INTO l_hz_loc_id;
2374: IF hz_loc_csr%FOUND THEN
2375: -- Raise Error