535: x_return_status := fnd_api.g_ret_sts_success;
536:
537: IF p_location_type_code = 'INVENTORY' THEN
538: l_location_table := 'HR_LOCATIONS';
539: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
540: BEGIN
541: SELECT 'Y' INTO l_hz_or_hr
542: FROM hz_locations
543: WHERE location_id = p_location_id;
538: l_location_table := 'HR_LOCATIONS';
539: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
540: BEGIN
541: SELECT 'Y' INTO l_hz_or_hr
542: FROM hz_locations
543: WHERE location_id = p_location_id;
544: l_location_table := 'HZ_LOCATIONS';
545: EXCEPTION
546: WHEN no_data_found THEN
540: BEGIN
541: SELECT 'Y' INTO l_hz_or_hr
542: FROM hz_locations
543: WHERE location_id = p_location_id;
544: l_location_table := 'HZ_LOCATIONS';
545: EXCEPTION
546: WHEN no_data_found THEN
547: l_location_table := 'HR_LOCATIONS';
548: END;
2569:
2570: ELSIF csi_txn_rec.transaction_type_id IN (132, 133, 105) OR
2571: (csi_txn_rec.transaction_type_id = 51 AND l_ship_create ='Y' ) THEN --Added for ER#16265912
2572:
2573: l_location_type_code := 'HZ_LOCATIONS';
2574:
2575: IF csi_txn_rec.transaction_type_id = 105 THEN
2576:
2577: SELECT deliver_to_location_id